protected void Link1_Click(object sender, EventArgs e) { LinkButton b = (LinkButton)sender; int ID = Int32.Parse(b.CommandArgument); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from val in a.Responsables where val.ID == ID select val; var res = req.FirstOrDefault(); if (res != null) { var req1 = from value in a.Historique_Login where value.ID_User == res.ID select value; var res1 = req1.ToList(); foreach (Helpdesk.Entities.Agences.Historique_Login h in res1) { a.DeleteObject(h); a.SaveChanges(); } a.DeleteObject(res); a.SaveChanges(); System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } } }
protected void Oui_Click(object sender, EventArgs e) { using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var request = from val in a.Agences where val.Zone == Zon select val; var result = request.ToList(); if (result == null || result.Count == 0) { var req = from value in a.Zones where value.ID == Zon select value; var res = req.FirstOrDefault(); a.DeleteObject(res); a.SaveChanges(); if (Request.QueryString["Page"] == "Update") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.document.getElementById('ButtonEditDone').click();"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } if (Request.QueryString["Page"] == "Affiche") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } } else { Response.Write("Cette Zone Contient " + result.Count + " Agences, Deplacer les puis supprimer la zonne"); } } }
protected void ActionU_Click(object sender, EventArgs e) { List1.Visible = false; Up1.Visible = true; if ((String.IsNullOrEmpty(TextBoxEmailU.Text) || String.IsNullOrWhiteSpace(TextBoxEmailU.Text)) || (String.IsNullOrEmpty(TextBoxNomU.Text) || String.IsNullOrWhiteSpace(TextBoxNomU.Text)) || (String.IsNullOrEmpty(TextBoxPasswordU.Text) || String.IsNullOrWhiteSpace(TextBoxPasswordU.Text)) || (String.IsNullOrEmpty(TextBoxPrenomU.Text) || String.IsNullOrWhiteSpace(TextBoxPrenomU.Text)) || (String.IsNullOrEmpty(TextBoxUsernameU.Text) || String.IsNullOrWhiteSpace(TextBoxUsernameU.Text))) { Utilitaire.Utilites.MSG(msgboxpanel, "Remplir les champs", "Champs Invalides"); } else { int ID = Int32.Parse(System.Web.HttpContext.Current.Request.Cookies["userInfo"]["ID"]); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from val in a.Responsables where val.ID == ID select val; var res = req.FirstOrDefault(); if (res != null) { res.Email = TextBoxEmailU.Text; res.Nom = TextBoxNomU.Text; res.Password = Utilitaire.Encryption.AESEncryption.Encrypt(TextBoxPasswordU.Text); res.Prenom = TextBoxPrenomU.Text; res.Username = TextBoxUsernameU.Text; a.SaveChanges(); } System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } } }
protected void SubmitResponsable_Click(object sender, EventArgs e) { Button b = (Button)sender; using (Helpdesk.Entities.Agences.AgenceEntities dbag = new Entities.Agences.AgenceEntities()) { if (b.Text == "Ajouter") { Helpdesk.Entities.Agences.Responsables respo = new Entities.Agences.Responsables() { Email = EmailResponsable.Text, Niveau = 3, Role = 2, Nom = NomResponsable.Text, Prenom = PrenomResponsable.Text, Teléphone = TelephoneResponsable.Text }; dbag.AddToResponsables(respo); dbag.SaveChanges(); } if (b.Text == "Modifier") { var req = from value in dbag.Responsables where value.ID == Resp select value; var res = req.FirstOrDefault(); res.Nom = NomResponsable.Text; res.Prenom = PrenomResponsable.Text; res.Email = EmailResponsable.Text; res.Teléphone = TelephoneResponsable.Text; dbag.SaveChanges(); } } if (Request.QueryString["Page"] == "Update") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.document.getElementById('ButtonEditDone').click();"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } if (Request.QueryString["Page"] == "Affiche") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } }
protected void Add_Click(object sender, EventArgs e) { Button b = (Button)sender; if (b.Text == "Ajouter") { using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { Helpdesk.Entities.Agences.Zones z = new Entities.Agences.Zones() { Libelle = TextLibelle.Text, Description = TextDescription.Text }; a.AddToZones(z); a.SaveChanges(); } } if (b.Text == "Modifier") { using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var requ = from val in ag.Zones where val.ID == Zon select val; var resu = requ.FirstOrDefault(); String lib = TextLibelle.Text; resu.Libelle = TextLibelle.Text; resu.Description = TextDescription.Text; ag.SaveChanges(); } } if (Request.QueryString["Page"] == "Update") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.document.getElementById('ButtonEditDone').click();"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } if (Request.QueryString["Page"] == "Affiche") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } }
protected void EditU_Click(object sender, EventArgs e) { int ID = Int32.Parse(System.Web.HttpContext.Current.Request.Cookies["userInfo"]["ID"]); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from val in a.Responsables where val.ID == ID select val; var res = req.FirstOrDefault(); if (res != null) { res.Email = EmailU.Text; res.Nom = NomU.Text; res.Prenom = PrenomU.Text; a.SaveChanges(); } System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } }
protected void ActionR_Click(object sender, EventArgs e) { if ((String.IsNullOrEmpty(TextBoxEmailR.Text) || String.IsNullOrWhiteSpace(TextBoxEmailR.Text)) || (String.IsNullOrEmpty(TextBoxNomR.Text) || String.IsNullOrWhiteSpace(TextBoxNomR.Text)) || (String.IsNullOrEmpty(TextBoxPasswordR.Text) || String.IsNullOrWhiteSpace(TextBoxPasswordR.Text)) || (String.IsNullOrEmpty(TextBoxPrenomR.Text) || String.IsNullOrWhiteSpace(TextBoxPrenomR.Text)) || (String.IsNullOrEmpty(TextBoxUsernameR.Text) || String.IsNullOrWhiteSpace(TextBoxUsernameR.Text))) { Utilitaire.Utilites.MSG(msgboxpanel, "Remplir les champs", "Champs Invalides"); } else { using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { Helpdesk.Entities.Agences.Responsables u = new Entities.Agences.Responsables() { Email = TextBoxEmailR.Text, Niveau = 2, Nom = TextBoxNomR.Text, Password = Utilitaire.Encryption.AESEncryption.Encrypt(TextBoxPasswordR.Text), Prenom = TextBoxPrenomR.Text, Username = TextBoxUsernameR.Text, Role = 1 }; a.AddToResponsables(u); a.SaveChanges(); System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } } }
protected void OuiResponsable_Click(object sender, EventArgs e) { using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from value in a.Responsables where value.ID == Resp select value; var res = req.FirstOrDefault(); a.DeleteObject(res); a.SaveChanges(); if (Request.QueryString["Page"] == "Update") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.document.getElementById('ButtonEditDone').click();"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } if (Request.QueryString["Page"] == "Affiche") { System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } } }
protected void ActionUO_Click(object sender, EventArgs e) { List1.Visible = false; Up1.Visible = true; int ID = Int32.Parse(IDU.Value); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from val in a.Responsables where val.ID == ID select val; var res = req.FirstOrDefault(); if (res != null) { res.Email = TextBoxEmailU.Text; res.Nom = TextBoxNomU.Text; res.Password = Utilitaire.Encryption.AESEncryption.Encrypt(TextBoxPasswordU.Text); res.Prenom = TextBoxPrenomU.Text; res.Username = TextBoxUsernameU.Text; a.SaveChanges(); } System.Web.HttpContext.Current.Response.Write("<script>"); System.Web.HttpContext.Current.Response.Write("parent.location.reload(true);"); System.Web.HttpContext.Current.Response.Write("<" + "/script>"); } }
protected void wzd_FinishButtonClick(object sender, WizardNavigationEventArgs e) { if ((ComboBox1.Text != null) && ((Assigned.SelectedItem != null) || (Autres.SelectedItem != null))) { int responsable = 0; if (Assigned.SelectedItem != null) { responsable = Int32.Parse(Assigned.SelectedItem.Value); } if (Autres.SelectedItem != null) { responsable = Int32.Parse(Autres.SelectedItem.Value); } int Found = 0; using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from value in a.Agences select value; var res = req.ToList(); foreach (Helpdesk.Entities.Agences.Agences ag in res) { if (ag.Responsable == responsable) { Found = 1; break; } } } if (Found == 0) { int Zoneagence = Int32.Parse(DropDownListAgenceZone.SelectedItem.Value); String Etatrouteur = DropDownListRouteurEtat.SelectedValue.ToString(); String Etatswitcheur = DropDownListSwitcheurEtat.SelectedValue.ToString(); String Etatmodem = DropDownListModemEtat.SelectedValue.ToString(); String EtatAdslTunnel = DropDownListAdslEtatTunnel.SelectedValue.ToString(); String EtatAdslCarte = DropDownListAdslEtatCarte.SelectedValue.ToString(); String EtatFramerelay = DropDownListFrarelayEtat.SelectedValue.ToString(); try { using (Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { Entities.Agences.Agences agence = new Entities.Agences.Agences() { Zone = Zoneagence, Adresse = TextBoxAgenceAdress.Text, Nom = TextBoxAgenceNom.Text, Adresse_IP = TextBoxAgenceAdressIP.Text, Code = TextBoxAgenceCode.Text, Responsable = responsable, Descriptions = TextBoxAgenceDescription.Text, Liaison_Description = TextBoxLiaisonDescription.Text, Equipement_Description = TextBoxEquipementDescription.Text }; Helpdesk.Entities.Agences.Responsabilité r = new Entities.Agences.Responsabilité() { Agence_ID = agence.ID, Responsable_ID = responsable, DateDebut = DateTime.Now.Date, TimeDebut = DateTime.Now.TimeOfDay }; Entities.Agences.Routeurs router = new Entities.Agences.Routeurs() { Agence_ID = agence.ID, Model = TextBoxRouteurModel.Text, Etat = Etatrouteur, Adresse_IP = TextBoxRouteurIP.Text, Adresse_MAC = TextBoxRouteurMac.Text, Type = TextBoxRouteurType.Text, Description = TextBoxRouteurDescription.Text }; Entities.Agences.Switchers switche = new Entities.Agences.Switchers() { Agence_ID = agence.ID, Model = TextBoxSwitcheurModel.Text, Etat = Etatswitcheur, Adresse_IP = TextBoxSwitcheurIP.Text, Adresse_MAC = TextBoxSwitcheurMac.Text, Type = TextBoxSwitcheurType.Text, Description = TextBoxSwitcheurDescription.Text }; Entities.Agences.Modems modem = new Entities.Agences.Modems() { Agence_ID = agence.ID, Etat = Etatmodem, Type = TextBoxModemType.Text, Model = TextBoxModemModel.Text, Description = TextBoxModemDescription.Text }; Entities.Agences.Framerelay framerelay = new Entities.Agences.Framerelay() { Agence_ID = agence.ID, Etat = EtatFramerelay, Adresse_IP = TextBoxFrameRelayAdresseIP.Text, Description = TextBoxFramerelayDescription.Text }; Entities.Agences.Adsl adsl = new Entities.Agences.Adsl() { Agence_ID = agence.ID, Etat = EtatAdslTunnel, Etat_Carte = EtatAdslCarte, Adresse_IP = TextBoxAdslAdresseTunnel.Text, Adresse_Carte = TextBoxAdslAdresseCarte.Text, Description = TextBoxAdslDescription.Text }; dba.AddToAgences(agence); dba.AddToEquipement(router); dba.AddToEquipement(switche); dba.AddToEquipement(modem); dba.AddToLiaison(framerelay); dba.AddToLiaison(adsl); dba.AddToResponsabilité(r); dba.SaveChanges(); Utilitaire.Utilites.MSG(msgboxpanel, "L'agence de : " + agence.Adresse + " a été ajoutée à la base avec succés", "Ajout Avec Succés"); } } catch (System.Data.SqlClient.SqlException sql) { Utilitaire.Utilites.MSG(msgboxpanel, sql.Message, "Sql Error"); } Response.Redirect(Request.RawUrl); } else { Utilitaire.Utilites.MSG(msgboxpanel, "Responsable Assigné a une autre mission ..", ""); } } else { Utilitaire.Utilites.MSG(msgboxpanel, "Responsable manquant ..", ""); } }
protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e) { int emplcamentagence = Int32.Parse(DropDownListAgenceEmplacement.SelectedValue.ToString()); String statutrouteur = DropDownListRouteurStatut.SelectedValue.ToString(); String statutswitcheur = DropDownListSwitcheurStatut.SelectedValue.ToString(); String statutmodem = DropDownListModemStatut.SelectedValue.ToString(); String statutAdsl = DropDownListAdslStatut.SelectedValue.ToString(); String statutFramerelay = DropDownListFrarelayStatut.SelectedValue.ToString(); int agence_ID = Int32.Parse(DropDownListAgenceID.SelectedValue); String CurrentUser = null; using (Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { if (System.Web.HttpContext.Current.Request.Cookies["userInfo"] != null) { CurrentUser = System.Web.HttpContext.Current.Request.Cookies["userInfo"]["Username"]; } var requete = from value in dba.Agences where (value.Agence_ID == agence_ID) select value; var result = requete.FirstOrDefault(); if (result != null) { Entities.Agences.Historique_Modem mo = new Entities.Agences.Historique_Modem() { Historique_Modem_Personnel = CurrentUser, Historique_Modem_ID = result.Equipements.Modems.Modem_ID, Historique_Modem_Date = DateTime.Now }; Entities.Agences.Historique_Routeur ro = new Entities.Agences.Historique_Routeur() { Historique_Routeur_Personnel = CurrentUser, Historique_Routeur_ID = result.Equipements.Routeurs.Routeur_ID, Historique_Routeur_Date = DateTime.Now }; Entities.Agences.Historique_Switcheur sw = new Entities.Agences.Historique_Switcheur() { Historique_Switcheur_Personnel = CurrentUser, Historique_Switcheur_ID = result.Equipements.Switcheurs.Switcheur_ID, Historique_Switcheur_Date = DateTime.Now }; Entities.Agences.Historique_Equipements eq = new Entities.Agences.Historique_Equipements() { Historique_Equipement_Date = DateTime.Now, Historique_Equipement_ID = result.Equipements.Equipement_ID, Historique_Equipement_Modem = mo.Historique_Modem1, Historique_Equipement_Routeur = ro.Historique_Routeur1, Historique_Equipement_Switcheur = sw.Historique_Switcheur1, Historique_Equipement_Personnel = CurrentUser, }; Entities.Agences.Historique_Adsl ad = new Entities.Agences.Historique_Adsl() { Historique_Adsl_Date = DateTime.Now, Historique_Adsl_Personnel = CurrentUser, Historique_Adsl_ID = result.Liaisons.Adsl.Adsl_ID }; Entities.Agences.Historique_FrameRelay fr = new Entities.Agences.Historique_FrameRelay() { Historique_Framerelay_Date = DateTime.Now, Historique_Framerelay_Personnel = CurrentUser, Historique_Framerelay_ID = result.Liaisons.Framerelay.Framerelay_ID }; Entities.Agences.Historique_Liaison li = new Entities.Agences.Historique_Liaison() { Historique_Liaison_Date = DateTime.Now, Historique_Liaison_ID = result.Liaisons.Liaison_ID, Historique_Liaison_Personnel = CurrentUser, Historique_Liaison_Adsl = ad.Historique_Adsl1, Historique_Liaison_Framerelay = fr.Historique_Framerelay1 }; Entities.Agences.Historique_Responsable re = new Entities.Agences.Historique_Responsable() { Historique_ID_Responsable = result.Respnosable_Agence.ID }; Entities.Agences.Historique_Agences ag = new Entities.Agences.Historique_Agences() { Historique_Coordonne_Responsable = re.Historique_Responsable1, Historique_Agence_Date = DateTime.Now, Historique_Agence_ID = agence_ID, Historique_Personnel = CurrentUser, Historique_Agence_Equipements = eq.Historique_Equipement, Historique_Agence_Liaisons = li.Historique_Liaison1 }; if (result.Agence_Descriptions != TextBoxAgenceDescription.Text) { ag.Historique_Agence_Description_Ancien = result.Agence_Descriptions; ag.Historique_Agence_Description_Nouveau = TextBoxAgenceDescription.Text; } if (result.Agence_Emplacement != emplcamentagence) { ag.Historique_Agence_Emplacement_ancien = result.Emplacement.Emplacement_Libelle; using (Entities.Agences.AgenceEntities emp = new Entities.Agences.AgenceEntities()) { var emreq = from val in emp.Emplacement where (val.Emplacement_ID == emplcamentagence) select val; var emres = emreq.FirstOrDefault(); ag.Historique_Agence_Emplacement_nouveau = emres.Emplacement_Libelle; } } if (result.Equipements.Equipement_Description != TextBoxEquipementDescription.Text) { eq.Historique_Equipement_Description_Ancien = result.Equipements.Equipement_Description; eq.Historique_Equipement_Description_Nouveau = TextBoxEquipementDescription.Text; } if (result.Liaisons.Liaison_Description != TextBoxLiaisonDescription.Text) { li.Historique_Liaison_Description_Ancien = result.Liaisons.Liaison_Description; li.Historique_Liaison_Description_Nouveau = TextBoxLiaisonDescription.Text; } if (result.Equipements.Modems.Modem_Description != TextBoxModemDescription.Text) { mo.Historique_Modem_Description_Ancien = result.Equipements.Modems.Modem_Description; mo.Historique_Modem_Description_Nouveau = TextBoxModemDescription.Text; } if (result.Equipements.Modems.Modem_IPadress != TextBoxModemIP.Text) { mo.Historique_Modem_Ip_Ancien = result.Equipements.Modems.Modem_IPadress; mo.Historique_Modem_Ip_Nouveau = TextBoxModemIP.Text; } if (result.Equipements.Modems.Modem_Macadress != TextBoxModemMac.Text) { mo.Historique_Modem_Mac_Ancien = result.Equipements.Modems.Modem_Macadress; mo.Historique_Modem_Mac_Nouveau = TextBoxModemMac.Text; } if (result.Equipements.Modems.Modem_Statut != statutmodem) { mo.Historique_Modem_Statut_ancien = result.Equipements.Modems.Modem_Statut; mo.Historique_Modem_Statut_Nouveau = statutmodem; } if (result.Equipements.Modems.Modem_Type != TextBoxModemType.Text) { mo.Historique_Modem_Type_Ancien = result.Equipements.Modems.Modem_Type; mo.Historique_Modem_Type_Nouveau = TextBoxModemType.Text; } if (result.Equipements.Routeurs.Routeur_Description != TextBoxRouteurDescription.Text) { ro.Historique_Routeur_Description_Ancien = result.Equipements.Routeurs.Routeur_Description; ro.Historique_Routeur_Description_Nouveau = TextBoxRouteurDescription.Text; } if (result.Equipements.Routeurs.Routeur_IPadress != TextBoxRouteurIP.Text) { ro.Historique_Routeur_Ip_Ancien = result.Equipements.Routeurs.Routeur_IPadress; ro.Historique_Routeur_Ip_Nouveau = TextBoxRouteurIP.Text; } if (result.Equipements.Routeurs.Routeur_Macadress != TextBoxRouteurMac.Text) { ro.Historique_Routeur_Mac_Ancien = result.Equipements.Routeurs.Routeur_Macadress; ro.Historique_Routeur_Mac_Nouveau = TextBoxRouteurMac.Text; } if (result.Equipements.Routeurs.Routeur_Statut != statutrouteur) { ro.Historique_Routeur_Statut_ancien = result.Equipements.Routeurs.Routeur_Statut; ro.Historique_Routeur_Statut_Nouveau = statutrouteur; } if (result.Equipements.Routeurs.Routeur_Type != TextBoxRouteurType.Text) { ro.Historique_Routeur_Type_Ancien = result.Equipements.Routeurs.Routeur_Type; ro.Historique_Routeur_Type_Nouveau = TextBoxRouteurType.Text; } if (result.Equipements.Switcheurs.Switcheur_Description != TextBoxSwitcheurDescription.Text) { sw.Historique_Switcheur_Description_Ancien = result.Equipements.Switcheurs.Switcheur_Description; sw.Historique_Switcheur_Description_Nouveau = TextBoxSwitcheurDescription.Text; } if (result.Equipements.Switcheurs.Switcheur_IPadress != TextBoxSwitcheurIP.Text) { sw.Historique_Switcheur_Ip_Ancien = result.Equipements.Switcheurs.Switcheur_IPadress; sw.Historique_Switcheur_Ip_Nouveau = TextBoxSwitcheurIP.Text; } if (result.Equipements.Switcheurs.Switcheur_Macadress != TextBoxSwitcheurMac.Text) { sw.Historique_Switcheur_Mac_Ancien = result.Equipements.Switcheurs.Switcheur_Macadress; sw.Historique_Switcheur_Mac_Nouveau = TextBoxSwitcheurMac.Text; } if (result.Equipements.Switcheurs.Switcheur_Statut != statutswitcheur) { sw.Historique_Switcheur_Statut_ancien = result.Equipements.Switcheurs.Switcheur_Statut; sw.Historique_Switcheur_Statut_Nouveau = statutswitcheur; } if (result.Equipements.Switcheurs.Switcheur_Type != TextBoxSwitcheurType.Text) { sw.Historique_Switcheur_Type_Ancien = result.Equipements.Switcheurs.Switcheur_Type; sw.Historique_Switcheur_Type_Nouveau = TextBoxSwitcheurType.Text; } if (result.Liaisons.Adsl.Adsl_Description != TextBoxAdslDescription.Text) { ad.Historique_Adsl_Description_Ancien = result.Liaisons.Adsl.Adsl_Description; ad.Historique_Adsl_Description_Nouveau = TextBoxAdslDescription.Text; } if (result.Liaisons.Adsl.Adsl_Identificateur != TextBoxAdslIdentificateur.Text) { ad.Historique_Adsl_Identificateur_Ancien = result.Liaisons.Adsl.Adsl_Identificateur; ad.Historique_Adsl_Identificateur_Nouveau = TextBoxAdslIdentificateur.Text; } if (result.Liaisons.Adsl.Adsl_Statut != statutAdsl) { ad.Historique_Adsl_Statut_Ancien = result.Liaisons.Adsl.Adsl_Statut; ad.Historique_Adsl_Statut_Nouveau = statutAdsl; } if (result.Liaisons.Framerelay.Framerelay_Description != TextBoxFramerelayDescription.Text) { fr.Historique_Framerelay_Description_Ancien = result.Liaisons.Framerelay.Framerelay_Description; fr.Historique_Framerelay_Description_Nouveau = TextBoxFramerelayDescription.Text; } if (result.Liaisons.Framerelay.Framerelay_Identificateur != TextBoxFrameRelayIdentificateur.Text) { fr.Historique_Framerelay_Identificateur_Ancien = result.Liaisons.Framerelay.Framerelay_Identificateur; fr.Historique_Framerelay_Identificateur_Nouveau = TextBoxFrameRelayIdentificateur.Text; } if (result.Liaisons.Framerelay.Framerelay_Statut != statutFramerelay) { fr.Historique_Framerelay_Statut_Ancien = result.Liaisons.Framerelay.Framerelay_Statut; fr.Historique_Framerelay_Statut_Nouveau = statutFramerelay; } if (result.Respnosable_Agence.Nom == TextBoxResponsableNom.Text) { re.Historique_Responsable_Nom_Ancien = result.Respnosable_Agence.Nom; re.Historique_Responsable_Nom_Nouveau = TextBoxResponsableNom.Text; } if (result.Respnosable_Agence.Prenom == TextBoxResponsablePrenom.Text) { re.Historique_Responsable_Prenom_Ancien = result.Respnosable_Agence.Prenom; re.Historique_Responsable_Prenom_Nouveau = TextBoxResponsablePrenom.Text; } if (result.Respnosable_Agence.Email == TextBoxResponsableEmail.Text) { re.Historique_Responsable_Email_ancien = result.Respnosable_Agence.Email; re.Historique_Responsable_Email_Nouveau = TextBoxResponsableEmail.Text; } if (result.Respnosable_Agence.Teléphone == TextBoxResponsableTelephone.Text) { re.Historique_Responsable_Telephone_Ancien = result.Respnosable_Agence.Teléphone; re.Historique_Responsable_Telephone_Nouveau = TextBoxResponsableTelephone.Text; } result.Agence_Descriptions = TextBoxAgenceDescription.Text; result.Agence_Emplacement = emplcamentagence; result.Equipements.Equipement_Description = TextBoxEquipementDescription.Text; result.Liaisons.Liaison_Description = TextBoxLiaisonDescription.Text; result.Equipements.Modems.Modem_Description = TextBoxModemDescription.Text; result.Equipements.Modems.Modem_IPadress = TextBoxModemIP.Text; result.Equipements.Modems.Modem_Macadress = TextBoxModemMac.Text; result.Equipements.Modems.Modem_Statut = statutmodem; result.Equipements.Modems.Modem_Type = TextBoxModemType.Text; result.Equipements.Routeurs.Routeur_Description = TextBoxModemDescription.Text; result.Equipements.Routeurs.Routeur_IPadress = TextBoxRouteurIP.Text; result.Equipements.Routeurs.Routeur_Macadress = TextBoxRouteurMac.Text; result.Equipements.Routeurs.Routeur_Statut = statutrouteur; result.Equipements.Routeurs.Routeur_Type = TextBoxRouteurType.Text; result.Equipements.Switcheurs.Switcheur_Description = TextBoxSwitcheurDescription.Text; result.Equipements.Switcheurs.Switcheur_IPadress = TextBoxSwitcheurIP.Text; result.Equipements.Switcheurs.Switcheur_Macadress = TextBoxSwitcheurMac.Text; result.Equipements.Switcheurs.Switcheur_Statut = statutswitcheur; result.Equipements.Switcheurs.Switcheur_Type = TextBoxSwitcheurType.Text; result.Liaisons.Adsl.Adsl_Description = TextBoxAdslDescription.Text; result.Liaisons.Adsl.Adsl_Identificateur = TextBoxAdslIdentificateur.Text; result.Liaisons.Adsl.Adsl_Statut = statutAdsl; result.Liaisons.Framerelay.Framerelay_Description = TextBoxFramerelayDescription.Text; result.Liaisons.Framerelay.Framerelay_Identificateur = TextBoxFrameRelayIdentificateur.Text; result.Liaisons.Framerelay.Framerelay_Statut = statutFramerelay; result.Adress = TextBoxAgenceAdress.Text; result.Agence_Zone = TextBoxAgenceZone.Text; result.Respnosable_Agence.Nom = TextBoxResponsableNom.Text; result.Respnosable_Agence.Prenom = TextBoxResponsablePrenom.Text; result.Respnosable_Agence.Email = TextBoxResponsableEmail.Text; result.Respnosable_Agence.Teléphone = TextBoxResponsableTelephone.Text; dba.AddToHistorique_Responsable(re); dba.AddToHistorique_Adsl(ad); dba.AddToHistorique_FrameRelay(fr); dba.AddToHistorique_Liaison(li); dba.AddToHistorique_Modem(mo); dba.AddToHistorique_Routeur(ro); dba.AddToHistorique_Switcheur(sw); dba.AddToHistorique_Equipements(eq); dba.AddToHistorique_Agences(ag); dba.SaveChanges(); Utilitaire.Utilites.MSG(msgboxpanel, "", "Mis Ajour Avec Succes"); } } }
public static void supprimerAgence(HtmlContainerControl div, String id) { try { int IDagence; IDagence = Int32.Parse(id); using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Agences where value.ID == IDagence select value; var res = req.FirstOrDefault(); if (res != null) { var HisA = from val in ag.Historiques_Agences where val.Agence_ID == IDagence select val; var ResHisA = HisA.ToList(); if (ResHisA != null) { foreach (Helpdesk.Entities.Agences.Historiques_Agences ha in ResHisA) { ag.DeleteObject(ha); } } String Adress = res.Nom + ", " + res.Adresse; var eqq = from equip in ag.Equipement where equip.Agence_ID == res.ID select equip; var eqqres = eqq.ToList(); foreach (Helpdesk.Entities.Agences.Equipement equ in eqqres) { Helpdesk.Entities.Agences.Routeurs r = eqqres.OfType <Helpdesk.Entities.Agences.Routeurs>().FirstOrDefault(); var HisR = from val in ag.Historiques_Routeurs where val.Routeur_ID == r.ID_Equipement select val; var resHisR = HisR.ToList(); if (resHisR != null) { foreach (Helpdesk.Entities.Agences.Historiques_Routeurs hr in resHisR) { ag.DeleteObject(hr); } } ag.DeleteObject(r); Helpdesk.Entities.Agences.Switchers s = eqqres.OfType <Helpdesk.Entities.Agences.Switchers>().FirstOrDefault(); var HisS = from val in ag.Historiques_Switcheurs where val.Switcheur_ID == s.ID_Equipement select val; var resHisS = HisS.ToList(); if (resHisS != null) { foreach (Helpdesk.Entities.Agences.Historiques_Switcheurs hs in resHisS) { ag.DeleteObject(hs); } } ag.DeleteObject(s); Helpdesk.Entities.Agences.Modems m = eqqres.OfType <Helpdesk.Entities.Agences.Modems>().FirstOrDefault(); var HisM = from val in ag.Historiques_Modems where val.Modem_ID == m.ID_Equipement select val; var resHisM = HisM.ToList(); if (resHisM != null) { foreach (Helpdesk.Entities.Agences.Historiques_Modems hm in resHisM) { ag.DeleteObject(hm); } } ag.DeleteObject(m); } var lii = from li in ag.Liaison where li.Agence_ID == res.ID select li; var liires = lii.ToList(); foreach (Helpdesk.Entities.Agences.Liaison li in liires) { Helpdesk.Entities.Agences.Adsl ads = liires.OfType <Helpdesk.Entities.Agences.Adsl>().FirstOrDefault(); var HisAd = from val in ag.Historiques_Adsls where val.Adsl_ID == ads.ID_Liaison select val; var resHisAd = HisAd.ToList(); if (resHisAd != null) { foreach (Helpdesk.Entities.Agences.Historiques_Adsls had in resHisAd) { ag.DeleteObject(had); } } ag.DeleteObject(ads); Helpdesk.Entities.Agences.Framerelay Fr = liires.OfType <Helpdesk.Entities.Agences.Framerelay>().FirstOrDefault(); var Hisfr = from val in ag.Historiques_Framerelays where val.Framerelay_ID == Fr.ID_Liaison select val; var resHisfr = Hisfr.ToList(); if (resHisfr != null) { foreach (Helpdesk.Entities.Agences.Historiques_Framerelays hfr in resHisfr) { ag.DeleteObject(hfr); } } ag.DeleteObject(Fr); } var HisRes = from val in ag.Responsabilité where val.Agence_ID == res.ID select val; var resHisRes = HisRes.ToList(); if (resHisRes != null) { foreach (Helpdesk.Entities.Agences.Responsabilité hres in resHisRes) { ag.DeleteObject(hres); } } ag.DeleteObject(res); ag.SaveChanges(); Utilitaire.Utilites.MSG(div, "Suppression de l'agence " + Adress, "Suppression"); } } } catch (System.Data.SqlClient.SqlException sql) { Utilitaire.Utilites.MSG(div, sql.Message, sql.ErrorCode.ToString()); } }
protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e) { int emplcamentagence = Int32.Parse(DropDownListAgenceEmplacement.SelectedValue.ToString()); String statutrouteur = DropDownListRouteurStatut.SelectedValue.ToString(); String statutswitcheur = DropDownListSwitcheurStatut.SelectedValue.ToString(); String statutmodem = DropDownListModemStatut.SelectedValue.ToString(); String statutAdsl = DropDownListAdslStatut.SelectedValue.ToString(); String statutFramerelay = DropDownListFrarelayStatut.SelectedValue.ToString(); try { using (Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { Entities.Agences.Routeurs router = new Entities.Agences.Routeurs() { Routeur_Statut = statutrouteur, Routeur_IPadress = TextBoxRouteurIP.Text, Routeur_Macadress = TextBoxRouteurMac.Text, Routeur_Type = TextBoxRouteurType.Text, Routeur_Description = TextBoxRouteurDescription.Text }; Entities.Agences.Switcheurs switche = new Entities.Agences.Switcheurs() { Switcheur_Statut = statutswitcheur, Switcheur_IPadress = TextBoxSwitcheurIP.Text, Switcheur_Macadress = TextBoxSwitcheurMac.Text, Switcheur_Type = TextBoxSwitcheurType.Text, Switcheur_Description = TextBoxSwitcheurDescription.Text }; Entities.Agences.Modems modem = new Entities.Agences.Modems() { Modem_Statut = statutmodem, Modem_IPadress = TextBoxModemIP.Text, Modem_Macadress = TextBoxModemMac.Text, Modem_Type = TextBoxModemType.Text, Modem_Description = TextBoxModemDescription.Text }; Entities.Agences.Equipements equipement = new Entities.Agences.Equipements() { Equipement_Modem = modem.Modem_ID, Equipement_Routeur = router.Routeur_ID, Equipement_Switcheur = switche.Switcheur_ID, Equipement_Description = TextBoxEquipementDescription.Text }; Entities.Agences.Framerelay framerelay = new Entities.Agences.Framerelay() { Framerelay_Statut = statutFramerelay, Framerelay_Identificateur = TextBoxFrameRelayIdentificateur.Text, Framerelay_Description = TextBoxFramerelayDescription.Text }; Entities.Agences.Adsl adsl = new Entities.Agences.Adsl() { Adsl_Statut = statutAdsl, Adsl_Identificateur = TextBoxAdslIdentificateur.Text, Adsl_Description = TextBoxAdslDescription.Text }; Entities.Agences.Liaisons liaison = new Entities.Agences.Liaisons() { Liaison_Adsl = adsl.Adsl_ID, Liaison_Framerelay = framerelay.Framerelay_ID, Liaison_Description = TextBoxLiaisonDescription.Text }; Entities.Agences.Respnosable_Agence responsable = new Entities.Agences.Respnosable_Agence() { Nom = TextBoxResponsableNom.Text, Prenom = TextBoxResponsablePrenom.Text, Email = TextBoxResponsableEmail.Text, Teléphone = TextBoxResponsableTelephone.Text }; Entities.Agences.Agences agence = new Entities.Agences.Agences() { Agence_Zone = TextBoxAgenceZone.Text, Adress = TextBoxAgenceAdress.Text, Agence_Coordonnee_Responsable = responsable.ID, Agence_Emplacement = emplcamentagence, Agence_Descriptions = TextBoxAgenceDescription.Text, Agence_Equipements = equipement.Equipement_ID, Agence_Liaisons = liaison.Liaison_ID }; dba.AddToRouteurs(router); dba.AddToSwitcheurs(switche); dba.AddToModems(modem); dba.AddToEquipements(equipement); dba.AddToFramerelay(framerelay); dba.AddToAdsl(adsl); dba.AddToLiaisons(liaison); dba.AddToRespnosable_Agence(responsable); dba.AddToAgences(agence); dba.SaveChanges(); Utilitaire.Utilites.MSG(msgboxpanel, "L'agence de : " + agence.Emplacement.Emplacement_Libelle + ", " + agence.Agence_Zone + ", " + agence.Adress + " a été ajoutée à la base avec succés", "Ajout Avec Succés"); } } catch (System.Data.SqlClient.SqlException sql) { Utilitaire.Utilites.MSG(msgboxpanel, sql.Message, "Sql Error"); } }