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