public ActionResult Create([Bind(Include = "id_action,nom_action,description_action,échéance,etat_avancement,commentaire,matricule_responable,id_gestion_risk,date_creation,id_mesure")] action action) { if (ModelState.IsValid) { db.action.Add(action); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.id_gestion_risk = new SelectList(db.gestion_risque, "id_gestion_risk", "nom_gesion_risk", action.id_gestion_risk); ViewBag.id_mesure = new SelectList(db.action_mesure, "id_mesure", "chapitre", action.id_mesure); return(View(action)); }
public ActionResult Create(actif Actif) { try { // TODO: Add insert logic here using (SMSIEntities1 db = new SMSIEntities1()) { actif Actifs = new actif(); Actifs.id_actif = Actif.id_actif; Actifs.nom_actif = Actif.nom_actif; Actifs.date_creation_actif = DateTime.Now; Actifs.descr_actif = Actif.descr_actif; Actifs.categ_actif = Actif.categ_actif; Actifs.matricule = Session["UserMatricule"].ToString(); db.actif.Add(Actifs); db.SaveChanges(); } return(RedirectToAction("Index", Actif)); } catch { return(View("")); } }
public ActionResult Edit(int id, activite Activite) { try { using (SMSIEntities1 db = new SMSIEntities1()) { db.Entry(Activite).State = EntityState.Modified; db.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(int id, activite Activite) { try { using (SMSIEntities1 db = new SMSIEntities1()) { Activite = db.activite.Where(x => x.id_activite == id).FirstOrDefault(); db.activite.Remove(Activite); db.SaveChanges(); } // TODO: Add delete logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(activite Activite) { // TODO: Add insert logic here using (SMSIEntities1 db = new SMSIEntities1()) { activite Activites = new activite(); Activites.nom_activite = Activite.nom_activite; Activites.date_creation = DateTime.Now; Activites.matricule = Session["UserMatricule"].ToString(); var exists = db.activite.Where(w => w.id_activite == Activite.id_activite).FirstOrDefault(); if (exists != null) { //Activite.errorMessage = "Activite Deja Existant"; TempData["errorMessage"] = "Activite Deja Existant"; //ViewBag.Message = "Activite Deja Existant"; return(View("create", Activite)); } db.activite.Add(Activites); db.SaveChanges(); return(RedirectToAction("Index")); } }
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("")); } }