// GET: Actifs/Edit/5
public ActionResult Edit(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.actif.Where(x => x.id_actif == id).FirstOrDefault()));
}
}
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 ImpactDatails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.impact.Where(x => x.id_impact == id).FirstOrDefault()));
}
}
public ActionResult INtegriteDetails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.integrite.Where(x => x.id_integ == id).FirstOrDefault()));
}
}
// GET: Activites/Details/5
public ActionResult Details(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.activite.Where(x => x.id_activite == id).FirstOrDefault()));
}
}
public ActionResult RiskDatails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.gestion_risque.Where(x => x.id_gestion_risk == id).FirstOrDefault()));
}
}
public ActionResult DispoDetails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.disponibilte.Where(x => x.id_dispo == id).FirstOrDefault()));
}
}
public ActionResult ActionEdit(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.action.Include(a => a.action_mesure).Where(x => x.id_action == id).FirstOrDefault()));
}
}
// GET: Actifs
public ActionResult Index(string search, int?i)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
//List<user_table> userNom = db.user_table.ToList();
List <collaborateur> collaborateurNom = db.collaborateur.ToList();
List <actif> actifNom = db.actif.ToList();
var query = from af in actifNom
join coll in collaborateurNom on af.matricule equals coll.matricule
into collTable
from coll in collTable.DefaultIfEmpty()
//join user in userNom on coll.matricule equals user.matricule
//into userTable
//from user in userTable.DefaultIfEmpty()
select new CIDActifVM
{
actifDetailles = af,
collaborateurDetailles = coll
//user_tableDetailles = user
};
var matricule = Session["UserMatricule"].ToString();
var fonction = Session["CollabFonction"].ToString();
if (fonction == "admin")
{
return(View(query.OrderBy(x => x.collaborateurDetailles.matricule).ToList().ToPagedList(i ?? 1, 7)));
}
return(View(query.Where(x => x.actifDetailles.matricule == matricule).ToPagedList(i ?? 1, 7)));
}
}
public ActionResult ConfidDetails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.confid.Where(x => x.id_confi == id).FirstOrDefault()));
}
}
public ActionResult OccuDatails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.prob_occurrence.Where(x => x.id_occur == id).FirstOrDefault()));
}
}
public ActionResult MenaceDatails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.menace.Where(x => x.id_menace == id).FirstOrDefault()));
}
}
public ActionResult VulneDatails(int id = 0)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.vulnerabilte.Where(x => x.id_vulne == id).FirstOrDefault()));
}
}
// GET: Collab
public ActionResult Index()
{
using (SMSIEntities1 db = new SMSIEntities1())
{
return(View(db.collaborateur.ToList()));
}
}
// GET: Menace
public ActionResult Index(string search, int?i, int id = 0)
{
SMSIEntities1 db = new SMSIEntities1();
List <actif> actifNom = db.actif.ToList();
List <vulnerabilte> vulneNom = db.vulnerabilte.ToList();
List <menace> menaceNom = db.menace.ToList();
List <prob_occurrence> occuraneNom = db.prob_occurrence.ToList();
List <impact> impactNom = db.impact.ToList();
var querry = from vul in vulneNom
join af in actifNom on vul.id_actif equals af.id_actif
into afTable
from af in afTable.DefaultIfEmpty()
join men in menaceNom on vul.id_vulne equals men.id_vulne
into menTable
from men in menTable.DefaultIfEmpty()
join occu in occuraneNom on men.id_menace equals occu.id_menace
into occuTable
from occu in occuTable.DefaultIfEmpty()
join imp in impactNom on men.id_menace equals imp.id_menace
into impTable
from imp in impTable.DefaultIfEmpty()
select new CIDActifVM
{
actifDetailles = af,
vulnerabilteDetailles = vul,
menaceDetailles = men,
probOccurrenceDetailles = occu,
impactDetailles = imp
};
var querryActif = from vul in vulneNom
join af in actifNom on vul.id_actif equals af.id_actif
into afTable
from af in afTable.DefaultIfEmpty()
select new CIDActifVM
{
vulnerabilteDetailles = vul,
actifDetailles = af
};
if (querryActif.Any(w => w.vulnerabilteDetailles.id_actif == id))
{
return(View(querry.Where(x => x.actifDetailles.id_actif == id).ToList().ToPagedList(i ?? 1, 7)));
}
else
{
//Actif DropDownList
List <actif> listActif = db.actif.ToList();
ViewBag.actifList = new SelectList(listActif, "id_actif", "nom_actif", id);
////return View("create");
return(RedirectToAction("create", "menace"));
}
}
// 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: Menace/Create
public ActionResult Create()
{
SMSIEntities1 db = new SMSIEntities1();
List <actif> listActif = db.actif.ToList();
ViewBag.actifList = new SelectList(listActif, "id_actif", "nom_actif");
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());
}
}
// 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 Authorize(user_table userModel)
{
using (SMSIEntities1 db = new SMSIEntities1())
{
var userDetailes = db.user_table.Where(x => x.username == userModel.username && x.passeword == userModel.passeword).FirstOrDefault();
if (userDetailes == null)
{
//userModel.errorMessage = "Matricule ou Mot De Passe Incorect !";
TempData["errorMessage"] = "Matricule ou Mot De Passe Incorect !";
return(RedirectToAction("Index", "Login"));
}
else
{
Session["UserID"] = userDetailes.username;
Session["UserMatricule"] = userDetailes.matricule;
Session["UserPass"] = userDetailes.passeword;
return(RedirectToAction("Index", "Collaborateur"));
}
}
}
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)
{
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(""));
}
}
// GET: CIDActif
//[HttpPost]
public ActionResult CID(string search, int?i, int id = 0)
{
SMSIEntities1 db = new SMSIEntities1();
List <user_table> userNom = db.user_table.ToList();
List <collaborateur> collaborateurNom = db.collaborateur.ToList();
List <CID_actif> cidNom = db.CID_actif.ToList();
List <actif> actifNom = db.actif.ToList();
List <activite> activiteNom = db.activite.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
{
CIDDetailles = cid,
actifDetailles = af,
activiteDetaillese = av,
confidDetailles = con,
integriteDetailles = inte,
disponibilteDetailles = disp,
user_tableDetailles = us,
collaborateurDetailles = col
};
var querryActif = from cid in cidNom
join af in actifNom on cid.id_actif equals af.id_actif
into afTable
from af in afTable.DefaultIfEmpty()
select new CIDActifVM
{
CIDDetailles = cid,
actifDetailles = af
};
if (querryActif.Any(w => w.actifDetailles.id_actif == id))
{
return(View(querry.Where(x => x.actifDetailles.id_actif == id).ToList().ToPagedList(i ?? 1, 7)));
}
else
{
//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);
//return View(querry.ToList().ToPagedList(i ?? 1, 7));
//return View("Create");
return(RedirectToAction("create", "CIDActif", id));
}
//return RedirectToAction("create", "Actifs");
}
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(""));
}
}
