<%@ Page Language="C#" Buffer="true" CodeFile="gestion_etat_civil.aspx.cs" Inherits="_gestion_etat_civil" CodePage="65001" UICulture="fr" Culture="fr-FR" ValidateRequest="false" %> <%@ Import Namespace="ItlRuntime" %> <%@ Import Namespace="System.Collections.Generic" %> <%@ Import Namespace="System.Linq" %> <% EC.linkableClassMap = (Map) EC.newMap(new Map() , "ocsNewsEvent:news", new ClassLink("./page00013329.aspx?card=object", "linkTable.aspx?GID=00013329&card=object", "Actualité")); %> " /> Actes d'état-civil

Téléservices

<% if (EC.currentUser != null) { EC.Page.Response.Write(EC.itl.login()); EC.Page.Response.Write(" "); } { DateTime date = DateTime.Now; EC.Page.Response.Write(EC.itl.formatTimestamp(date, "date")); EC.Page.Response.Write(" "); EC.Page.Response.Write(EC.itl.formatTimestamp(date, "hours")); } %>


 
<% EC.Request.dumpRepostForm(); int? currentStatus = (int?) ((int?)EC.itl.getParameterValue("integer", "currentStatus", 0)); SqlObject modifiedCard = (SqlObject) (new SqlObject("dm:form_etatcivil", @"SELECT this.`_oid` AS this FROM dm_form_etatcivil AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` = #V_0&;)", new Map("#V_0&;|integer", EC.itl.toInteger(EC.itl.getParameterValue("object:dm:form_etatcivil", "modifiedCard"))),true)); string mode = (string) ((string)EC.itl.getParameterValue("string", "mode")); string cmd = (string) ((string)EC.itl.getParameterValue("string", "cmd")); string oids = (string) ((string)EC.itl.getParameterValue("string", "oids")); int? newStatus = (int?) ((int?)EC.itl.getParameterValue("integer", "newStatus")); if(cmd == "newCardStatus") { ItlUpdateObject c1 = new ItlUpdateObject("dm:form_etatcivil", null, modifiedCard); ; c1.setField("sfStatus", newStatus, "integer", "sf:form"); c1.exec();; } else if(cmd == "deleteCard") { ItlDelete c2 = new ItlDelete("dm:form_etatcivil", modifiedCard); ; c2.exec();; } else if(cmd == "newStatus") { if(oids == "all") { %>- <% ItlUpdateCollection c4 = new ItlUpdateCollection("dm:form_etatcivil", new SqlCollection("dm:form_etatcivil", "SELECT \nthis.`_oid` AS this \nFROM dm_form_etatcivil AS this\nINNER JOIN sf_form AS this_z\nOn ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) \nWHERE \n(this.iso_sid <> '') \nAND (#V_0&; OR (this_z.sfStatus = #V_1&;))", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus), null), (List>) EC.newList(new List>(), (List) EC.newList(new List(), "UPDATE sf_form \nSET \nsfStatus = #V_2&;", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus, "#V_2&;|integer", newStatus)))); ; c4.exec();; } else { ItlEnumerator e6 = new ItlEnumerator("G00010e33_5", null, false); e6.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("dm:form_etatcivil", @"SELECT this.`_oid` AS this FROM dm_form_etatcivil AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_0&;))", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", ITL.S(oids), "oids")), new ItlRuntime.SQL.OrderAliases(), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this FROM dm_form_etatcivil AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), false, (List) EC.newList(new List()), null, null)); ItlEnumerator c = (ItlEnumerator) (e6); c.reset(); if(c.isNotEmpty()) { c.resetGroup(); for(c.start();c.test();c.fetch()) { ItlUpdateObject c7 = new ItlUpdateObject("dm:form_etatcivil", null, c); ; c7.setField("sfStatus", newStatus, "integer", "sf:form"); c7.exec();; } } c.finish(); } } SqlObject _t0 = new SqlObject("dm:form_etatcivil", @"SELECT this.`_oid` AS this FROM dm_form_etatcivil AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (#V_0&; OR (#V_1&; = this_z.sfStatus)) ORDER BY this_z.sfModificationDate ASC, this_z.sfCreationDate DESC", new Map("#V_0&;|boolean", (currentStatus == -1), "#V_1&;|integer", currentStatus),false); SqlObject card = (SqlObject) (new SqlObject("dm:form_etatcivil", @"SELECT this.`_oid` AS this, this.lastname AS this_p_lastname, this.firstname AS this_p_firstname, this.address AS this_p_address, this.zipCode AS this_p_zipCode, this.city AS this_p_city, this.phone AS this_p_phone, this.email AS this_p_email, this.precision_du_lien AS this_p_precision_du_lien, this.nombre AS this_p_nombre, this.date_evenement AS this_p_date_evenement, this.lieu AS this_p_lieu, this.nom_naissance AS this_p_nom_naissance, this.prenom_titulaire AS this_p_prenom_titulaire, this.nom_mere AS this_p_nom_mere, this.prenom_mere AS this_p_prenom_mere, this.prenom_pere AS this_p_prenom_pere, this.nom_pere AS this_p_nom_pere, this.nom_conjoint AS this_p_nom_conjoint, this.prenom_conjoint AS this_p_prenom_conjoint, this.nom_pere_conjoint AS this_p_nom_pere_conjoint, this.prenom_pere_conjoint AS this_p_prenom_pere_conjoint, this.nom_mere_conjoint AS this_p_nom_mere_conjoint, this.prenom_mere_conjoint AS this_p_prenom_mere_conjoint, this.precison_motif AS this_p_precison_motif, this_s_civility.label_fr AS this_s_civility_p_label_fr, this_s_civility.`_oid` AS this_s_civility, this_s_pays.label_fr AS this_s_pays_p_label_fr, this_s_pays.`_oid` AS this_s_pays, this_s_lien_avec_le_titulaire_de_l_acte.label_fr AS this_s_lien_avec_le_titulaire_de_l_acte_p_label_fr, this_s_lien_avec_le_titulaire_de_l_acte.`_oid` AS this_s_lien_avec_le_titulaire_de_l_acte, this_s_acte_demande.label_fr AS this_s_acte_demande_p_label_fr, this_s_acte_demande.`_oid` AS this_s_acte_demande, this_s_type_d_acte.label_fr AS this_s_type_d_acte_p_label_fr, this_s_type_d_acte.`_oid` AS this_s_type_d_acte, this_s_motif_de_la_demande.label_fr AS this_s_motif_de_la_demande_p_label_fr, this_s_motif_de_la_demande.`_oid` AS this_s_motif_de_la_demande, this_z.sfCreationDate AS this_z_p_sfCreationDate, this_z.sfModificationDate AS this_z_p_sfModificationDate, this_z.sfModifierLogin AS this_z_p_sfModifierLogin, this_z.sfStatus AS this_z_p_sfStatus FROM dm_form_etatcivil AS this INNER JOIN sf_form AS this_z On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_civility On ((this.civility = this_s_civility.`_oid`) AND (this_s_civility.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_pays On ((this.pays = this_s_pays.`_oid`) AND (this_s_pays.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_lien_avec_le_titulaire_de_l_acte On ((this.lien_avec_le_titulaire_de_l_acte = this_s_lien_avec_le_titulaire_de_l_acte.`_oid`) AND (this_s_lien_avec_le_titulaire_de_l_acte.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_acte_demande On ((this.acte_demande = this_s_acte_demande.`_oid`) AND (this_s_acte_demande.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_type_d_acte On ((this.type_d_acte = this_s_type_d_acte.`_oid`) AND (this_s_type_d_acte.iso_sid <> '')) LEFT JOIN omc_stringItem AS this_s_motif_de_la_demande On ((this.motif_de_la_demande = this_s_motif_de_la_demande.`_oid`) AND (this_s_motif_de_la_demande.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` = #V_0&;)", new Map("#V_0&;|integer", EC.itl.toInteger(EC.itl.getParameterValue("object:dm:form_etatcivil", "card", EC.itl.toInteger(_t0)))),true)); if(cmd == "editCard") { ItlUpdateObject c13 = new ItlUpdateObject("dm:form_etatcivil", "card", card); ; c13.setField("sfModifierLogin", EC.itl.login(), "string", "sf:form", 64); c13.setField("sfModificationDate", EC.itl.now(), "date", "sf:form"); c13.exec();; } %>

Actes d'état-civil (<% ITL.show(EC.itl.toInteger(new SqlCollection("dm:form_etatcivil", @"SELECT COUNT(DISTINCT this.data) AS result FROM (SELECT this.`_oid` AS this, this.`_oid` AS data FROM dm_form_etatcivil AS this INNER JOIN (sf_form AS this_z LEFT JOIN sf_catalog AS this_z_s_sfCatalog On ((this_z.sfCatalog = this_z_s_sfCatalog.`_oid`) AND (this_z_s_sfCatalog.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this_z_s_sfCatalog.name = 'etat_civil') AND (this_z.sfStatus = 0)) AS this", new Map(), (List) EC.newList(new List())).get("result")), "string", "html", "integer"); %>)