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