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