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)); }