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 SubmitAdslTunnel_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(IPAT.Text)) { Utilitaire.Utilites.MSG(msgboxpanel, "Donner une @ IP", ""); } else { using (Helpdesk.Entities.Agences.AgenceEntities db = new Entities.Agences.AgenceEntities()) { IQueryable <Helpdesk.Entities.Agences.Liaison> liaison = db.Liaison; var AdsTu = (Helpdesk.Entities.Agences.Adsl)liaison.OfType <Helpdesk.Entities.Agences.Adsl>().Where(ad => ad.Adresse_IP == IPAT.Text); if (AdsTu != null) { var req = from value in db.Agences where (value.ID == AdsTu.Agence_ID) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.ParentRed("../Historique/AfficheHistorique.aspx?IDAgence=" + res.ID); } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } } }
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 Link_Click(object sender, EventArgs e) { ActionUM.Visible = false; ActionUO.Visible = true; LinkButton b = (LinkButton)sender; Up1.Visible = true; List1.Visible = false; 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) { IDU.Value = res.ID.ToString(); TextBoxEmailU.Text = res.Email; TextBoxNomU.Text = res.Nom; TextBoxPasswordU.Text = Utilitaire.Encryption.AESEncryption.Decrypt(res.Password); TextBoxPrenomU.Text = res.Prenom; TextBoxUsernameU.Text = res.Username; } } }
protected void Page_Load(object sender, EventArgs e) { Session["Changed"] = null; Utilitaire.Databases.Scripts.CheckStatut(msgboxpanel); int id = Int32.Parse(Request.QueryString["IDAgence"]); IDagence.Value = id.ToString(); string date = Request.QueryString["Date"]; HDate.Value = date; using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Agences where ((value.ID == id)) select value; var res = req.FirstOrDefault(); HEquipement.Value = res.ID.ToString(); HLiaison.Value = res.ID.ToString(); IQueryable <Helpdesk.Entities.Agences.Equipement> Equipement = ag.Equipement.Where(eq => eq.Agence_ID == res.ID); var router = Equipement.OfType <Helpdesk.Entities.Agences.Routeurs>(); var switche = Equipement.OfType <Helpdesk.Entities.Agences.Switchers>(); var Mode = Equipement.OfType <Helpdesk.Entities.Agences.Modems>(); HRouteur.Value = router.FirstOrDefault().ID_Equipement.ToString(); HSwitcheur.Value = switche.FirstOrDefault().ID_Equipement.ToString(); HModem.Value = Mode.FirstOrDefault().ID_Equipement.ToString(); IQueryable <Helpdesk.Entities.Agences.Liaison> Liaison = ag.Liaison.Where(li => li.Agence_ID == res.ID); var Ad = Liaison.OfType <Helpdesk.Entities.Agences.Adsl>(); var Fr = Liaison.OfType <Helpdesk.Entities.Agences.Framerelay>(); HFramerelay.Value = Fr.FirstOrDefault().ID_Liaison.ToString(); HAdsl.Value = Ad.FirstOrDefault().ID_Liaison.ToString(); HResponsable.Value = res.Responsable.ToString(); } }
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 Submitframerelay_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(IPFramerelay.Text)) { Utilitaire.Utilites.MSG(msgboxpanel, "Donner une @ IP", ""); } else { using (Helpdesk.Entities.Agences.AgenceEntities db = new Entities.Agences.AgenceEntities()) { IQueryable <Helpdesk.Entities.Agences.Liaison> liaison = db.Liaison; var frame = (Helpdesk.Entities.Agences.Framerelay)liaison.OfType <Helpdesk.Entities.Agences.Framerelay>().Where(fr => fr.Adresse_IP == IPFramerelay.Text); if (frame != null) { var req = from value in db.Agences where (value.ID == frame.Agence_ID) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.redirect("../Historique/AfficheHistorique.aspx?IDAgence=" + res.ID); } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } } }
protected void Page_Load(object sender, EventArgs e) { int agence_ID = Int32.Parse(Request.QueryString["IDAgence"]); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from value in a.Agences where value.ID == agence_ID select value; var res = req.FirstOrDefault(); Del0.Text += " " + res.Nom; } }
protected void show_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(); NomResponsable.Text = res.Nom; PrenomResponsable.Text = res.Prenom; EmailResponsable.Text = res.Email; TelephoneResponsable.Text = res.Teléphone; } }
protected void DropDownListAgenceID_SelectedIndexChanged(object sender, EventArgs e) { int agence_ID = Int32.Parse(DropDownListAgenceID.SelectedValue); using (Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { var requete = from value in dba.Agences where (value.Agence_ID == agence_ID) select value; var result = requete.FirstOrDefault(); if (result != null) { DropDownListAgenceEmplacement.SelectedValue = result.Agence_Emplacement.ToString(); TextBoxAgenceZone.Text = result.Agence_Zone; TextBoxAgenceAdress.Text = result.Adress; TextBoxResponsableNom.Text = result.Respnosable_Agence.Nom; TextBoxResponsablePrenom.Text = result.Respnosable_Agence.Prenom; TextBoxResponsableEmail.Text = result.Respnosable_Agence.Email; TextBoxResponsableTelephone.Text = result.Respnosable_Agence.Teléphone; TextBoxAgenceDescription.Text = result.Agence_Descriptions; TextBoxEquipementDescription.Text = result.Equipements.Equipement_Description; DropDownListRouteurStatut.SelectedValue = result.Equipements.Routeurs.Routeur_Statut.ToString(); TextBoxRouteurType.Text = result.Equipements.Routeurs.Routeur_Type; TextBoxRouteurIP.Text = result.Equipements.Routeurs.Routeur_IPadress; TextBoxRouteurMac.Text = result.Equipements.Routeurs.Routeur_Macadress; TextBoxRouteurDescription.Text = result.Equipements.Routeurs.Routeur_Description; DropDownListSwitcheurStatut.SelectedValue = result.Equipements.Switcheurs.Switcheur_Statut.ToString(); TextBoxSwitcheurType.Text = result.Equipements.Switcheurs.Switcheur_Type; TextBoxSwitcheurIP.Text = result.Equipements.Switcheurs.Switcheur_IPadress; TextBoxSwitcheurMac.Text = result.Equipements.Switcheurs.Switcheur_Macadress; TextBoxSwitcheurDescription.Text = result.Equipements.Switcheurs.Switcheur_Description; DropDownListModemStatut.SelectedValue = result.Equipements.Modems.Modem_Statut.ToString(); TextBoxModemType.Text = result.Equipements.Modems.Modem_Type; TextBoxModemIP.Text = result.Equipements.Modems.Modem_IPadress; TextBoxModemMac.Text = result.Equipements.Modems.Modem_Macadress; TextBoxModemDescription.Text = result.Equipements.Modems.Modem_Description; TextBoxLiaisonDescription.Text = result.Liaisons.Liaison_Description; DropDownListAdslStatut.SelectedValue = result.Liaisons.Adsl.Adsl_Statut.ToString(); TextBoxAdslIdentificateur.Text = result.Liaisons.Adsl.Adsl_Identificateur; TextBoxAdslDescription.Text = result.Liaisons.Adsl.Adsl_Description; DropDownListFrarelayStatut.SelectedValue = result.Liaisons.Framerelay.Framerelay_Statut.ToString(); TextBoxFrameRelayIdentificateur.Text = result.Liaisons.Framerelay.Framerelay_Identificateur; TextBoxFramerelayDescription.Text = result.Liaisons.Framerelay.Framerelay_Description; } } }
protected void Oui_Click(object sender, EventArgs e) { int agence_ID = Int32.Parse(Request.QueryString["IDAgence"]); using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { var req = from value in a.Agences where value.ID == agence_ID select value; var res = req.FirstOrDefault(); Del.Text += " " + res.Nom; } Utilitaire.Databases.Scripts.supprimerAgence(msgboxpanel, agence_ID.ToString()); 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 EditMeU_Click(object sender, EventArgs e) { ModifUser.Visible = true; 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) { EmailU.Text = res.Email; NomU.Text = res.Nom; PrenomU.Text = res.Prenom; } } }
protected void Page_Load(object sender, EventArgs e) { int id = Int32.Parse(Request.QueryString["IDAgence"]); int E = 0; int L = 0; using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Agences where (value.Agence_ID == id) select value; var res = req.FirstOrDefault(); IDagence.Value = id.ToString(); E = res.Agence_Equipements; L = res.Agence_Liaisons; Equipement.Value = E.ToString(); Liaison.Value = L.ToString(); } }
public String Mission(int ID) { String Output = null; using (Helpdesk.Entities.Agences.AgenceEntities dbag = new Entities.Agences.AgenceEntities()) { var req = from value in dbag.Agences where value.Responsable == ID select value; var res = req.FirstOrDefault(); if (res != null) { Output = (res.Zones.Libelle + ", " + res.Nom); } else { Output = ("Free"); } } return(Output); }
protected void Page_Load(object sender, EventArgs e) { try { using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Responsables where value.Niveau == 3 && value.Role == 2 select value; var res = req.ToList(); if (res != null) { foreach (Helpdesk.Entities.Agences.Responsables r in res) { Response.Write(r.Nom); } } } } catch (System.Data.SqlClient.SqlException sql) { } }
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 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 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 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 Responsable(object sender, EventArgs e) { Assigned.DataSource = AssignedResponsable; Assigned.DataBind(); using (Helpdesk.Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { var req = from value in dba.Agences select value; var res = req.ToList(); if (res.Count == 0) { AutreResponsable.SelectCommand = "SELECT DISTINCT Responsables.ID, Responsables.Nom + ' ' + Responsables.Prenom AS Detaille FROM Responsables WHERE (Responsables.Niveau = 3) AND (Responsables.Role = 2)"; Autres.DataSource = AutreResponsable; Autres.DataBind(); } else { AutreResponsable.SelectCommand = "SELECT DISTINCT Responsables.ID, Responsables.Nom + ' ' + Responsables.Prenom AS Detaille FROM Responsables CROSS JOIN Agences WHERE (Responsables.Niveau = 3) AND (Responsables.Role = 2) AND (Responsables.ID NOT IN (SELECT Responsable FROM Agences AS Agences_1))"; Autres.DataSource = AutreResponsable; Autres.DataBind(); } } }
protected void EditMe_Click(object sender, EventArgs e) { Up1.Visible = true; List1.Visible = false; 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) { TextBoxEmailU.Text = res.Email; TextBoxNomU.Text = res.Nom; TextBoxPasswordU.Text = Utilitaire.Encryption.AESEncryption.Decrypt(res.Password); TextBoxPrenomU.Text = res.Prenom; TextBoxUsernameU.Text = res.Username; } } ActionUM.Visible = true; ActionUO.Visible = false; }
protected void SubmitResponsableTelephone_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(Telephone.Text)) { Utilitaire.Utilites.MSG(msgboxpanel, "Il faut remplire le Telephone du responsable", "Champs Vides"); } else { using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Agences where (value.Responsable_Agence.Teléphone == Telephone.Text) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.ParentRed("../Affichage/AfficheAgence.aspx?IDAgence=" + res.ID.ToString()); } else { Utilitaire.Utilites.MSG(msgboxpanel, "", "Agence Non Trouvée"); } } } }
protected void ButtontIP_Click(object sender, EventArgs e) { if ((String.IsNullOrEmpty(IP.Text))) { Utilitaire.Utilites.MSG(msgboxpanel, "Il faut Donnée l'adresse IP", "Champs Vides"); } else { using (Helpdesk.Entities.Agences.AgenceEntities ag = new Entities.Agences.AgenceEntities()) { var req = from value in ag.Agences where (value.Adresse_IP == IP.Text) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.ParentRed("../Affichage/AfficheAgence.aspx?IDAgence=" + res.ID.ToString()); } else { Utilitaire.Utilites.MSG(msgboxpanel, "", "Agence Non Trouvée"); } } } }
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 SubmitIP_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(IPAgence.Text)) { Utilitaire.Utilites.MSG(msgboxpanel, "Donner l'@ IP d'agence", ""); } else { using (Helpdesk.Entities.Agences.AgenceEntities db = new Entities.Agences.AgenceEntities()) { var req = from value in db.Agences where (value.Adresse_IP == IPAgence.Text) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.redirect("../Historique/AfficheHistorique.aspx?IDAgence=" + res.ID); } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } } }
protected void RechercheHNom_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(NomAgence.Text)) { Utilitaire.Utilites.MSG(msgboxpanel, "Donner le nom d'agence", ""); } else { using (Helpdesk.Entities.Agences.AgenceEntities db = new Entities.Agences.AgenceEntities()) { var req = from value in db.Agences where (value.Nom == NomAgence.Text) select value; var res = req.FirstOrDefault(); if (res != null) { Utilitaire.Utilites.ParentRed("../Historique/AfficheHistorique.aspx?IDAgence=" + res.ID); } else { Utilitaire.Utilites.MSG(msgboxpanel, " Agence Non Trouvéé !! ", " Agence Non Trouvéé !! "); } } } }
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 ComboBox1_TextChanged(object sender, EventArgs e) { if (ComboBox1.Text != null) { using (Helpdesk.Entities.Agences.AgenceEntities a = new Entities.Agences.AgenceEntities()) { int Found = 0; int Li = 0; var req = from value in a.Responsables where value.Niveau == 3 && value.Role == 2 select value; var res = req.ToList(); foreach (Helpdesk.Entities.Agences.Responsables r in res) { String Nom = r.Nom + " " + r.Prenom; if (Nom.Contains(ComboBox1.Text)) { ComboBox1.Text = Nom; Found = 1; foreach (EO.Web.ListBoxItem li in Assigned.Items) { if ((li.Text == Nom) && (li.Value == r.ID.ToString())) { if (Assigned.SelectedItem != null) { Assigned.SelectedItem.Selected = false; } if (Autres.SelectedItem != null) { Autres.SelectedItem.Selected = false; } Assigned.Items[li.ItemIndex].Selected = true; Li = 1; } } if (Li == 0) { foreach (EO.Web.ListBoxItem li in Autres.Items) { if ((li.Text == Nom) && (li.Value == r.ID.ToString())) { if (Assigned.SelectedItem != null) { Assigned.SelectedItem.Selected = false; } if (Autres.SelectedItem != null) { Autres.SelectedItem.Selected = false; } Autres.Items[li.ItemIndex].Selected = true; Li = 1; } } } break; } } if (Found == 0 || Li == 0) { ComboBox1.Text = ""; } } } else { ComboBox1.Text = ""; } }
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"); } } }