// GET: CIDActif/Details/5 public ActionResult Actifs(string search, int?i, CIDActifVM model, int id = 0) { SMSIEntities1 db = new SMSIEntities1(); List <user_table> userNom = db.user_table.ToList(); List <collaborateur> collaborateurNom = db.collaborateur.ToList(); List <activite> activiteNom = db.activite.ToList(); List <CID_actif> cidNom = db.CID_actif.ToList(); List <actif> actifNom = db.actif.ToList(); List <confid> confidNom = db.confid.ToList(); List <integrite> integriteNom = db.integrite.ToList(); List <disponibilte> dispoNom = db.disponibilte.ToList(); var querry = from cid in cidNom join af in actifNom on cid.id_actif equals af.id_actif into afTable from af in afTable.DefaultIfEmpty() join av in activiteNom on cid.id_activite equals av.id_activite into avTable from av in avTable.DefaultIfEmpty() join con in confidNom on cid.id_confid equals con.id_confi into conTable from con in conTable.DefaultIfEmpty() join inte in integriteNom on cid.id_integ equals inte.id_integ into intTable from inte in intTable.DefaultIfEmpty() join disp in dispoNom on cid.id_dispo equals disp.id_dispo into dispTable from disp in dispTable.DefaultIfEmpty() join us in userNom on av.matricule equals us.matricule into usTable from us in usTable.DefaultIfEmpty() join col in collaborateurNom on us.matricule equals col.matricule into colTable from col in colTable.DefaultIfEmpty() select new CIDActifVM { user_tableDetailles = us, collaborateurDetailles = col, activiteDetaillese = av, CIDDetailles = cid, actifDetailles = af, confidDetailles = con, integriteDetailles = inte, disponibilteDetailles = disp, }; return(View(querry.Where(x => x.activiteDetaillese.id_activite == id).ToList().ToPagedList(i ?? 1, 7))); }
// GET: Collab/Details/5 public ActionResult Details(CIDActifVM CID, string id) { //using (SMSIEntities1 db = new SMSIEntities1()) //{ // return View(db.collaborateur.Where(x=> x.matricule == id).FirstOrDefault()); //} SMSIEntities1 db = new SMSIEntities1(); List <user_table> userNom = db.user_table.ToList(); List <collaborateur> collaborateurNom = db.collaborateur.ToList(); List <activite> activiteNom = db.activite.ToList(); List <CID_actif> cidNom = db.CID_actif.ToList(); List <actif> actifNom = db.actif.ToList(); var querry = from us in userNom join mt in collaborateurNom on us.matricule equals mt.matricule into mtTable from mt in mtTable.DefaultIfEmpty() join av in activiteNom on mt.matricule equals av.matricule into mtaTable from av in mtaTable.DefaultIfEmpty() join cid in cidNom on av.id_activite equals cid.id_activite into avTable from cid in avTable.DefaultIfEmpty() join af in actifNom on cid.id_actif equals af.id_actif into afTable from af in afTable.DefaultIfEmpty() select new CIDActifVM { user_tableDetailles = us, collaborateurDetailles = mt, activiteDetaillese = av, CIDDetailles = cid, actifDetailles = af }; return(View(querry.Where(x => x.collaborateurDetailles.matricule == id).FirstOrDefault())); }
public ActionResult Create(CIDActifVM model, int id = 0) { var ConfiderrorMessage = ""; var IntegriteerrorMessage = ""; var DisponibilteerrorMessage = ""; var CIDerrorMessage = ""; try { // TODO: Add insert logic here SMSIEntities1 db = new SMSIEntities1(); //Activite DropDownList List <activite> list = db.activite.ToList(); ViewBag.activiteList = new SelectList(list, "id_activite", "nom_activite"); //Actif DropDownList List <actif> listActif = db.actif.ToList(); ViewBag.actifList = new SelectList(listActif, "id_actif", "nom_actif", id); //if (ModelState.IsValid) //{ //Insert Into Confidentialite Table confid Confid = new confid(); Confid.id_confi = model.confidDetailles.id_confi; Confid.nom_confid = model.confidDetailles.nom_confid; Confid.date_creation_confid = DateTime.Now; /*model.confidDetailles.date_creation_confid;*/ Confid.descr_confid = model.confidDetailles.descr_confid; Confid.score_confid = model.confidDetailles.score_confid; //if (Confid.id_confi.Equals(null) || Confid.nom_confid.Equals(null) // || Confid.date_creation_confid.Equals(null) || Confid.descr_confid.Equals(null) // || Confid.score_confid.Equals(null) || ConfiderrorMessage != null) //{ // ConfiderrorMessage = "no"; //} db.confid.Add(Confid); db.SaveChanges(); //Last Insetrded ID int LastConfId = Confid.id_confi; //Insert Into Integrite Table integrite Integrite = new integrite(); Integrite.id_integ = model.integriteDetailles.id_integ; Integrite.nom_integ = model.integriteDetailles.nom_integ; Integrite.date_creation_integ = DateTime.Now; /*model.integriteDetailles.date_creation_integ;*/ Integrite.descr_integ = model.integriteDetailles.descr_integ; Integrite.score_integd = model.integriteDetailles.score_integd; //if (Integrite.id_integ.Equals(null) || Integrite.nom_integ.Equals(null) // || Integrite.date_creation_integ.Equals(null) || Integrite.descr_integ.Equals(null) // || Integrite.score_integd.Equals(null) || IntegriteerrorMessage != null) //{ // IntegriteerrorMessage = "no"; //} db.integrite.Add(Integrite); db.SaveChanges(); //Last Insetrded ID int LastIntegId = Integrite.id_integ; //Insert Into Disponibilte Table disponibilte Disponibilte = new disponibilte(); Disponibilte.id_dispo = model.disponibilteDetailles.id_dispo; Disponibilte.nom_dispo = model.disponibilteDetailles.nom_dispo; Disponibilte.date_creation_dispo = DateTime.Now; /*model.disponibilteDetailles.date_creation_dispo;*/ Disponibilte.descr_dispo = model.disponibilteDetailles.descr_dispo; Disponibilte.score_dispo = model.disponibilteDetailles.score_dispo; //if (Disponibilte.id_dispo.Equals(null) || Disponibilte.nom_dispo.Equals(null) // || Disponibilte.date_creation_dispo.Equals(null) || Disponibilte.descr_dispo.Equals(null) // || Disponibilte.score_dispo.Equals(null) || DisponibilteerrorMessage != null) //{ // DisponibilteerrorMessage = "no"; //} db.disponibilte.Add(Disponibilte); db.SaveChanges(); //Last Insetrded ID int LastDispogId = Disponibilte.id_dispo; //Insert Into CIDActif Table CID_actif CID = new CID_actif(); CID.id_actif = model.actifDetailles.id_actif; CID.id_activite = model.activiteDetaillese.id_activite; CID.id_confid = LastConfId; CID.id_integ = LastIntegId; CID.id_dispo = LastDispogId; //if (CID.id_actif.Equals(null) || CID.id_activite.Equals(null) // || CID.id_confid.Equals(null) || CID.id_integ.Equals(null) // || CID.id_dispo.Equals(null) || CIDerrorMessage != null) //{ // CIDerrorMessage = "no"; //} var exists = db.CID_actif.Where(x => x.id_actif == CID.id_actif && x.id_activite == CID.id_activite).FirstOrDefault(); //if (exists != null // && CIDerrorMessage != "no" && ConfiderrorMessage != "no" // && IntegriteerrorMessage != "no" && DisponibilteerrorMessage != "no" // ) //{ // //CID.errorMessage = "ok"; // TempData["SucccesMessage"] = "Nope"; // return View(model); //} //else if (exists == null // && CIDerrorMessage != "no" && ConfiderrorMessage != "no" // && IntegriteerrorMessage != "no" && DisponibilteerrorMessage != "no" // ) //{ // TempData["SucccesMessage"] = "Bien Ajouter"; // db.CID_actif.Add(CID); // db.SaveChanges(); // return View(model); //} if (exists != null) { //CID.errorMessage = "ok"; TempData["SucccesMessage"] = "Nope"; return(View(model)); } else { TempData["SucccesMessage"] = "Bien Ajouter"; db.CID_actif.Add(CID); db.SaveChanges(); model = null; return(RedirectToAction("CID")); } //return RedirectToAction("CID"); //} ModelState return(View(model)); } catch (Exception) { return(View("")); } }
public ActionResult Create(CIDActifVM model) { try { // TODO: Add insert logic here List <gestion_risque> risqueNom = db.gestion_risque.ToList(); //Vulnerabilite DropDownList List <vulnerabilte> listVuln = db.vulnerabilte.ToList(); ViewBag.vulnList = new SelectList(listVuln, "id_vulne", "nom_vulne"); //Insert Into Gestion Risque Table gestion_risque risk = new gestion_risque(); risk.id_gestion_risk = model.gestionDetailles.id_gestion_risk; risk.nom_gesion_risk = model.gestionDetailles.nom_gesion_risk; risk.description_gestion_risk = model.gestionDetailles.description_gestion_risk; risk.date_creation_g_risk = DateTime.Now; risk.risk_dicision = model.gestionDetailles.risk_dicision; risk.id_vulne = model.vulnerabilteDetailles.id_vulne; //risk.errorMessage = "Done"; db.gestion_risque.Add(risk); //db.SaveChanges(); int LastRiskID = risk.id_gestion_risk; //Insert Into Action Table action act = new action(); act.id_action = model.actionDetailles.id_action; act.nom_action = model.actionDetailles.nom_action; act.description_action = model.actionDetailles.description_action; act.échéance = model.actionDetailles.échéance; act.etat_avancement = model.actionDetailles.etat_avancement; act.commentaire = model.actionDetailles.commentaire; act.matricule_responable = Session["UserMatricule"].ToString(); act.id_gestion_risk = LastRiskID; act.date_creation = DateTime.Now; act.id_mesure = model.actionDetailles.id_mesure; //act.errorMessage = "Done"; db.action.Add(act); //db.SaveChanges(); //if (act.errorMessage == "Done" && risk.errorMessage == "Done") //{ var vulCount = risqueNom.Count(x => x.id_vulne == risk.id_vulne); if (vulCount >= 3) { TempData["SucccesMessage"] = "Plus"; ViewBag.chapitre = new SelectList(db.action_mesure.Select(a => a.chapitre).Distinct().ToList()); return(View(model)); } TempData["SucccesMessage"] = "Bien Ajouter"; db.SaveChanges(); ViewBag.chapitre = new SelectList(db.action_mesure.Select(a => a.chapitre).Distinct().ToList()); return(View()); //} //TempData["SucccesMessage"] = "Veuillez Remplisez Les Champs"; //return View(model); } catch (Exception) { ViewBag.chapitre = new SelectList(db.action_mesure.Select(a => a.chapitre).Distinct().ToList()); return(View("")); } ViewBag.chapitre = new SelectList(db.action_mesure.Select(a => a.chapitre).Distinct().ToList()); }
public ActionResult Create(CIDActifVM model) { try { // TODO: Add insert logic here SMSIEntities1 db = new SMSIEntities1(); //Actif DropDownList List <actif> listActif = db.actif.ToList(); ViewBag.actifList = new SelectList(listActif, "id_actif", "nom_actif"); //Insert Into Vulnerabilite Table vulnerabilte vuln = new vulnerabilte(); vuln.id_vulne = model.vulnerabilteDetailles.id_vulne; vuln.nom_vulne = model.vulnerabilteDetailles.nom_vulne; vuln.date_creation_vulne = DateTime.Now; vuln.desc_vulne = model.vulnerabilteDetailles.desc_vulne; vuln.id_actif = model.actifDetailles.id_actif; //if (vuln.id_vulne.Equals(null) || vuln.nom_vulne.Equals(null) // || vuln.desc_vulne.Equals(null) || vuln.id_actif.Equals(null)) //{ // vuln.errorMessage = null; //} TempData["errorMessage"] = "Bien Ajoute"; //Last Insetrded ID int LastVulnID = vuln.id_vulne; //Insert Into Menace Table menace men = new menace(); men.id_menace = model.menaceDetailles.id_menace; men.nom_menace = model.menaceDetailles.nom_menace; men.date_creation_menace = DateTime.Now; men.desc_menace = model.menaceDetailles.desc_menace; men.id_vulne = LastVulnID; //if (men.id_menace.Equals(null) || men.nom_menace.Equals(null) // || men.desc_menace.Equals(null) || men.id_vulne.Equals(null)) //{ // men.errorMessage = null; //} //men.errorMessage = "Bien Ajoute"; //Last Insetrded ID int LastMenaceId = men.id_menace; //Insert Into Impact Table impact imp = new impact(); imp.id_impact = model.impactDetailles.id_impact; imp.nom_impact = model.impactDetailles.nom_impact; imp.date_creation_impact = DateTime.Now; imp.descr_impact = model.impactDetailles.descr_impact; imp.score_impact = model.impactDetailles.score_impact; imp.id_menace = LastMenaceId; //if (imp.id_menace.Equals(null) || imp.id_impact.Equals(null) // || imp.nom_impact.Equals(null) || imp.descr_impact.Equals(null) // || imp.score_impact.Equals(null)) //{ // imp.errorMessage = null; //} TempData["errorMessage"] = "Bien Ajoute"; //Insert Into Probalite D'occurance Table prob_occurrence occu = new prob_occurrence(); occu.id_occur = model.probOccurrenceDetailles.id_occur; occu.nom_occur = model.probOccurrenceDetailles.nom_occur; occu.date_creation_occur = DateTime.Now; occu.desc_occur = model.probOccurrenceDetailles.desc_occur; occu.score_occur = model.probOccurrenceDetailles.score_occur; occu.id_menace = LastMenaceId; //if (occu.id_menace.Equals(null) || occu.id_occur.Equals(null) // || occu.nom_occur.Equals(null) || occu.desc_occur.Equals(null) // || occu.score_occur.Equals(null)) //{ // occu.errorMessage = null; //} TempData["errorMessage"] = "Bien Ajoute"; //if (vuln.errorMessage!=null && men.errorMessage!=null && imp.errorMessage // != null && occu.errorMessage != null) //{ db.vulnerabilte.Add(vuln); db.menace.Add(men); db.impact.Add(imp); db.prob_occurrence.Add(occu); db.SaveChanges(); //model.vulnerabilteDetailles.errorMessage = "Bien Ajoute"; TempData["errorMessage"] = "Bien Ajoute"; //return View(model); return(RedirectToAction("Index")); //return View("index"); //} //else //{ // model.vulnerabilteDetailles.errorMessage = "Nope"; // TempData["errorMessage"] = model.vulnerabilteDetailles.errorMessage; //} //return View(model); //return View("index"); } catch (Exception) { return(View("")); } }