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 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>"); } } }
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()); } }