public ActionResult UpdateRisk(int rcmId, int riskId, string riskName)
{
string username = User.Identity.Name;
int wallid = db.RiskControlMatrixs.Where(p => p.RiskControlMatrixID.Equals(rcmId)).Select(p => p.WalktroughID).FirstOrDefault();
db.Configuration.ProxyCreationEnabled = false;
RCMDetailRisk oldData = db.RCMDetailRisks.AsNoTracking().Where(p => p.RCMDetailRiskID.Equals(riskId)).FirstOrDefault();
RCMDetailRisk Rdr = db.RCMDetailRisks.Find(riskId);
Rdr.RiskName = riskName;
db.Entry(Rdr).State = EntityState.Modified;
db.SaveChanges();
auditTransact.CreateAuditTrail("Update", wallid, "RCMDetailRisk", oldData, Rdr, username);
var rdr = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID == rcmId).Select(p => new { riskId = p.RCMDetailRiskID, riskName = p.RiskName }).ToList();
SelectList riskSelectList = new SelectList(rdr, "riskId", "riskName");;
return(Json(riskSelectList));
}
public ActionResult DeleteRisk(int rcmId, int riskId)
{
int wallid = db.RiskControlMatrixs.Where(p => p.RiskControlMatrixID.Equals(rcmId)).Select(p => p.WalktroughID).FirstOrDefault();
db.Configuration.ProxyCreationEnabled = false;
string username = User.Identity.Name;
RCMDetailRisk Rdr = db.RCMDetailRisks.Find(riskId);
db.RCMDetailRisks.Remove(Rdr);
db.SaveChanges();
RCMDetailRisk rc = new RCMDetailRisk();
auditTransact.CreateAuditTrail("Delete", wallid, "RCMDetailRisk", Rdr, rc, username);
var rdr = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID == rcmId).Select(p => new { riskId = p.RCMDetailRiskID, riskName = p.RiskName }).ToList();
SelectList riskSelectList = new SelectList(rdr, "riskId", "riskName");;
return(Json(riskSelectList));
}
public ActionResult SaveRisk(int rcmId, string riskName)
{
RCMDetailRisk newRdr = new RCMDetailRisk();
newRdr.RiskControlMatrixID = rcmId;
newRdr.RiskName = riskName;
newRdr.Status = "Pending";
db.RCMDetailRisks.Add(newRdr);
db.SaveChanges();
string username = User.Identity.Name;
int wallid = db.RiskControlMatrixs.Where(p => p.RiskControlMatrixID.Equals(rcmId)).Select(p => p.WalktroughID).FirstOrDefault();
RCMDetailRisk ri = new RCMDetailRisk();
auditTransact.CreateAuditTrail("Create", wallid, "RCMDetailRisk", ri, newRdr, username);
var rdr = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID == rcmId).Select(p => new { riskId = p.RCMDetailRiskID, riskName = p.RiskName }).ToList();
SelectList riskSelectList = new SelectList(rdr, "riskId", "riskName");;
return(Json(riskSelectList));
}
