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