public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RCMDetailRiskControlIssue issue = db.RCMDetailRiskControlIssue.Find(id); List <string> newFilesName = new List <string>(); List <string> paths = new List <string>(); UrlHelper url = Url; HttpServerUtilityBase server = Server; var iss = issue.NoRef.Split('/')[0] + issue.NoRef.Split('/')[1]; var no = issue.NoRef.Split('/')[2]; var getFiles = filesTransact.getFiles(iss + no, out newFilesName, out paths, url, server); ViewBag.newFilesName = newFilesName; ViewBag.paths = paths; if (issue.PICID != null) { ViewBag.PICID = db.Employees.Where(p => p.Name.Equals(issue.PICID)).FirstOrDefault().Name; } if (issue == null) { return(HttpNotFound()); } return(View(issue)); }
public ActionResult GetIssue(string nomer) { List <FieldWork> fieldWorks = db.FieldWorks.Where(p => p.LetterOfCommand.NomorSP.Equals(nomer)).ToList(); List <RCMDetailRisk> risks = new List <RCMDetailRisk>(); List <RCMDetailRiskControl> controls = new List <RCMDetailRiskControl>(); List <RCMDetailRiskControlIssue> issueList = new List <RCMDetailRiskControlIssue>(); RCMDetailRiskControlIssue issue = new RCMDetailRiskControlIssue(); foreach (var fieldwork in fieldWorks) { risks = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID.Equals(fieldwork.RiskControlMatrixID)).ToList(); foreach (var risk in risks) { controls = db.RCMDetailRiskControls.Where(p => p.RCMDetailRiskID.Equals(risk.RCMDetailRiskID)).ToList(); List <RCMDetailRiskControlIssue> Issues = new List <RCMDetailRiskControlIssue>(); foreach (var control in controls) { //var singleIssues = db.RCMDetailRiskControlIssue.Where(p => p.RCMDetailRiskControlID.Equals(control.RCMDetailRiskControlID)).OrderByDescending(d=>d.RCMDetailRiskControlIssueID).FirstOrDefault(); //issueList.Add(singleIssues); Issues = db.RCMDetailRiskControlIssue.Where(p => p.RCMDetailRiskControlID.Equals(control.RCMDetailRiskControlID)).ToList(); foreach (var iss in Issues) { issueList.Add(iss); } } } } db.Configuration.ProxyCreationEnabled = false; return(Json(new { issueList = issueList }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Preview(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExitMeeting exitMeeting = await db.ExitMeetings.FindAsync(id); if (exitMeeting == null) { return(HttpNotFound()); } var nomorSP = db.LetterOfCommands.Where(p => p.LetterOfCommandID.Equals(exitMeeting.LetterOfCommandID)).Select(p => p.NomorSP).FirstOrDefault(); ViewBag.nomersp = nomorSP; List <FieldWork> fieldWorks = db.FieldWorks.Where(p => p.LetterOfCommand.NomorSP.Equals(nomorSP)).ToList(); List <RCMDetailRisk> risks = new List <RCMDetailRisk>(); List <RCMDetailRiskControl> controls = new List <RCMDetailRiskControl>(); List <RCMDetailRiskControlIssue> issueList = new List <RCMDetailRiskControlIssue>(); RCMDetailRiskControlIssue issue = new RCMDetailRiskControlIssue(); //List<Employee> memberList = new List<Employee>(); foreach (var fieldwork in fieldWorks) { risks = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID.Equals(fieldwork.RiskControlMatrixID)).ToList(); foreach (var risk in risks) { controls = db.RCMDetailRiskControls.Where(p => p.RCMDetailRiskID.Equals(risk.RCMDetailRiskID)).ToList(); List <RCMDetailRiskControlIssue> Issues = new List <RCMDetailRiskControlIssue>(); foreach (var control in controls) { Issues = db.RCMDetailRiskControlIssue.Where(p => p.RCMDetailRiskControlID.Equals(control.RCMDetailRiskControlID)).ToList(); foreach (var iss in Issues) { issueList.Add(iss); } } } } ViewBag.Issues = issueList; ViewBag.CountAllIssues = issueList.Count(); ViewBag.CountIssueDone = issueList.Where(c => c.Status == "Done").Count(); ViewBag.CountIssueNotDone = issueList.Where(c => c.Status != "Done").Count(); //List<Employee> MemberExitMeetings = new List<Employee>(); //MemberExitMeetings = db.Employees.Where(p => p.OrganizationID.Equals(exitMeeting.OrganizationID)).ToList(); //foreach (var member in MemberExitMeetings) //{ // memberList.Add(member); //} ViewBag.WordDocumentFilename = "ExitMeetings"; return(View(exitMeeting)); }
public bool UpdateIssueSign(string issueNo, string signification) { RCMDetailRiskControlIssue issue = db.RCMDetailRiskControlIssue.Where(p => p.NoRef.Equals(issueNo)).FirstOrDefault(); issue.Signification = signification; db.Entry(issue).State = EntityState.Modified; db.SaveChanges(); return(true); }
public ActionResult EditManagementResponse(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RCMDetailRiskControlIssue issue = db.RCMDetailRiskControlIssue.Find(id); ViewBag.picName = issue.PICID != null ? issue.PICID : null; return(View(issue)); }
// GET: ExitMeetings/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExitMeeting exitMeeting = db.ExitMeetings.Find(id); if (exitMeeting == null) { return(HttpNotFound()); } var nomorSP = db.LetterOfCommands.Where(p => p.LetterOfCommandID.Equals(exitMeeting.LetterOfCommandID)).Select(p => p.NomorSP).FirstOrDefault(); ViewBag.nomersp = nomorSP; ViewBag.activname = db.Activities.Where(p => p.ActivityID.Equals(exitMeeting.ActivityID)).Select(p => p.Name).FirstOrDefault(); ViewBag.enggname = db.EngagementActivities.Where(p => p.EngagementID.Equals(exitMeeting.EngagementID)).Select(p => p.Name).FirstOrDefault(); ViewBag.organame = db.Organizations.Where(p => p.OrganizationID.Equals(exitMeeting.OrganizationID)).Select(p => p.Name).FirstOrDefault(); ViewBag.datestart = exitMeeting.Date_Start.Value.ToString("dd/MM/yyyy HH:mm"); ViewBag.dateend = exitMeeting.Date_End.Value.ToString("dd/MM/yyyy HH:mm"); List <FieldWork> fieldWorks = db.FieldWorks.Where(p => p.LetterOfCommand.NomorSP.Equals(nomorSP)).ToList(); List <RCMDetailRisk> risks = new List <RCMDetailRisk>(); List <RCMDetailRiskControl> controls = new List <RCMDetailRiskControl>(); List <RCMDetailRiskControlIssue> issueList = new List <RCMDetailRiskControlIssue>(); RCMDetailRiskControlIssue issue = new RCMDetailRiskControlIssue(); foreach (var fieldwork in fieldWorks) { risks = db.RCMDetailRisks.Where(p => p.RiskControlMatrixID.Equals(fieldwork.RiskControlMatrixID)).ToList(); foreach (var risk in risks) { controls = db.RCMDetailRiskControls.Where(p => p.RCMDetailRiskID.Equals(risk.RCMDetailRiskID)).ToList(); List <RCMDetailRiskControlIssue> Issues = new List <RCMDetailRiskControlIssue>(); foreach (var control in controls) { //var singleIssues = db.RCMDetailRiskControlIssue.Where(p => p.RCMDetailRiskControlID.Equals(control.RCMDetailRiskControlID)).OrderByDescending(d => d.RCMDetailRiskControlIssueID).FirstOrDefault(); //issueList.Add(singleIssues); Issues = db.RCMDetailRiskControlIssue.Where(p => p.RCMDetailRiskControlID.Equals(control.RCMDetailRiskControlID)).ToList(); foreach (var iss in Issues) { issueList.Add(iss); } } } } ViewBag.Issues = issueList; return(View(exitMeeting)); }
public string GetDetailIssue(string issueTitle) { RCMDetailRiskControlIssue issue = db.RCMDetailRiskControlIssue.Where(p => p.Title.Equals(issueTitle)).FirstOrDefault(); string result = String.Empty; if (issue != null) { result = issue.Fact + ";" + issue.Criteria + ";" + issue.Impact + ";" + issue.ImpactValue + ";" + issue.Cause + ";" + issue.Recommendation; } else { result = ";;;;;"; } return(result); }
public bool UpdateManagementResponse(int issueID, string managementResponse, string issueStatus, string dueDate, string picName, int emId) { RCMDetailRiskControlIssue issue = db.RCMDetailRiskControlIssue.Find(issueID); issue.ManagementResponse = managementResponse; issue.Status = issueStatus; issue.Due_Date = dueDate; issue.PICID = picName != String.Empty ? db.Employees.Where(p => p.Name.Equals(picName)).FirstOrDefault().Name : null; db.Entry(issue).State = EntityState.Modified; if (issueStatus == "Agree") { FieldWork fw = db.FieldWorks.Where(p => p.RiskControlMatrixID.Equals(issue.RCMDetailRiskControl.RCMDetailRisk.RiskControlMatrixID)).FirstOrDefault(); MonitoringTindakLanjut mon1 = db.MonitoringTindakLanjut.Where(d => d.RCMDetailRiskControlIssueID == issue.RCMDetailRiskControlIssueID && d.LetterOfCommandID == fw.LetterOfCommandID).FirstOrDefault(); if (mon1 != null) { db.MonitoringTindakLanjut.Remove(mon1); } MonitoringTindakLanjut mon = new MonitoringTindakLanjut(); mon.RCMDetailRiskControlIssueID = issue.RCMDetailRiskControlIssueID; mon.Status = "Open"; mon.LetterOfCommandID = fw.LetterOfCommandID; db.MonitoringTindakLanjut.Add(mon); } else { FieldWork fw = db.FieldWorks.Where(p => p.RiskControlMatrixID.Equals(issue.RCMDetailRiskControl.RCMDetailRisk.RiskControlMatrixID)).FirstOrDefault(); MonitoringTindakLanjut mon = db.MonitoringTindakLanjut.Where(d => d.RCMDetailRiskControlIssueID == issue.RCMDetailRiskControlIssueID && d.LetterOfCommandID == fw.LetterOfCommandID).FirstOrDefault(); if (mon != null) { db.MonitoringTindakLanjut.Remove(mon); } } ExitMeeting em = db.ExitMeetings.Find(emId); //em.StatusTanggapan = "Closed"; db.Entry(em).State = EntityState.Modified; db.SaveChanges(); return(true); }
public ActionResult Edit([Bind(Include = "RCMDetailRiskControlIssueID,RCMDetailRiskControlID,NoRef,Title,Fact,Criteria,Impact,ImpactValue,Cause,Recommendation,ManagementResponse,FindingType,Status,Status_Approval,Status_App,Signification,Due_Date,Close_Date,CaseClose")] RCMDetailRiskControlIssue issue, IEnumerable <HttpPostedFileBase> files, string PICID) { if (ModelState.IsValid) { MonitoringTindakLanjut dbitem = db.MonitoringTindakLanjut.Where(d => d.RCMDetailRiskControlIssueID == issue.RCMDetailRiskControlIssueID).FirstOrDefault(); if (dbitem != null) { if (issue.CaseClose == "true") { dbitem.Status = "Close"; } else { dbitem.Status = "Open"; } db.Configuration.ProxyCreationEnabled = false; db.Entry(dbitem).State = EntityState.Modified; db.SaveChanges(); } string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; RCMDetailRiskControlIssue oldData = db.RCMDetailRiskControlIssue.AsNoTracking().Where(p => p.RCMDetailRiskControlIssueID.Equals(issue.RCMDetailRiskControlIssueID)).FirstOrDefault(); //auditTransact.CreateAuditTrail("Update", issue.RCMDetailRiskControlIssueID, "RCM Control Issue", oldData, issue, username); issue.PICID = PICID; db.Entry(issue).State = EntityState.Modified; db.SaveChanges(); int i = 0; HttpServerUtilityBase server = Server; List <string> newFilesName = new List <string>(); List <string> paths = new List <string>(); UrlHelper url = Url; List <string> keepImages = new List <string>(); //object imagesTemp = Session["Images"]; var sessionImages = Session["Images"]; if (sessionImages != null) { Array arrKeepImages = (Array)sessionImages; foreach (var arrKeepImage in arrKeepImages) { keepImages.Add(arrKeepImage.ToString()); } var iss = issue.NoRef.Split('/')[0] + issue.NoRef.Split('/')[1]; var no = issue.NoRef.Split('/')[2]; bool getFiles = filesTransact.getFiles(iss + no, out newFilesName, out paths, url, server); List <string> deletedFiles = paths.Except(keepImages).ToList(); bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server); i = filesTransact.getLastNumberOfFiles(iss + no, server); } foreach (var file in files) { if (file != null) { i = i + 1; var iss = issue.NoRef.Split('/')[0] + issue.NoRef.Split('/')[1]; var no = issue.NoRef.Split('/')[2]; bool addFile = filesTransact.addFile(iss + no, i, file, server); } } Session.Remove("Images"); return(RedirectToAction("Index")); } return(View(issue)); }