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