// GET: Walktroughs/Create
public ActionResult Create(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(id);
BPM bpm = db.BPMs.Find(id);
//ViewBag.Name = db.BusinessProcess.Find(id);
if (walktrough == null)
{
return(HttpNotFound());
}
ViewBag.WalktroughID = walktrough.WalktroughID;
ViewBag.ActivityID = walktrough.ActivityID;
walktrough.BPM = (from b in db.BPMs
where b.WalktroughID == id
select b).ToList();
walktrough.RCM = (from b in db.RiskControlMatrixs
where b.WalktroughID == id
select b).ToList();
string message = TempData["message"] as string;
if (!string.IsNullOrEmpty(message))
{
ViewBag.message = message;
}
return(View(walktrough));
}
public ActionResult Preview(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(id);
BusinessProces business = db.BusinessProcess.Find(id);
List <RiskControlMatrix> rcmList = new List <RiskControlMatrix>();
//List<RCMDetailRisk> rcmDetailList = new List<RCMDetailRisk>();
List <RiskControlMatrix> rcms = db.RiskControlMatrixs.Where(p => p.WalktroughID.Equals(walktrough.WalktroughID)).ToList();
foreach (var busProses in rcms)
{
rcmList.Add(busProses);
}
//List<RiskControlMatrix> rcmList = new List<RiskControlMatrix>();
List <RCMDetailRiskControl> rcmDetailControlList = new List <RCMDetailRiskControl>();
List <RCMDetailControlAuditStep> rcmDetailControlAuditStepList = new List <RCMDetailControlAuditStep>();
List <RCMDetailRiskControlIssue> rcmDetailControlIssueList = new List <RCMDetailRiskControlIssue>();
//List<RiskControlMatrix> rcms = db.RiskControlMatrixs.Where(p => p.WalktroughID.Equals(walktrough.WalktroughID)).ToList();
/*foreach (var descProses in rcms)
* {
* rcmList.Add(descProses);
* List<RCMDetailRisk> rcmsss = db.RCMDetailRisks.Where(a => a.RiskControlMatrixID.Equals(descProses.RiskControlMatrixID)).ToList();
* foreach (var desc2 in rcmsss)
* {
* rcmDetailList.Add(desc2);
* List<RCMDetailRiskControl> rcmsssControl = db.RCMDetailRiskControls.Where(a => a.RCMDetailRiskID.Equals(desc2.RCMDetailRiskID)).ToList();
* foreach (var desc3 in rcmsssControl)
* {
* rcmDetailControlList.Add(desc3);
* List<RCMDetailControlAuditStep> rcmsssControlAudit = db.RCMDetailControlAuditSteps.Where(a => a.RCMDetailRiskControlID.Equals(desc3.RCMDetailRiskControlID)).ToList();
* foreach (var desc4 in rcmsssControlAudit)
* {
* rcmDetailControlAuditStepList.Add(desc4);
* }
* List<RCMDetailRiskControlIssue> rcmsssControlIssue = db.RCMDetailRiskControlIssue.Where(a => a.RCMDetailRiskControlID.Equals(desc3.RCMDetailRiskControlID)).ToList();
* foreach (var desc5 in rcmsssControlIssue)
* {
* rcmDetailControlIssueList.Add(desc5);
* }
* }
* }
* }*/
ViewBag.descControlIssue = rcmDetailControlIssueList;
ViewBag.descControlAuditStep = rcmDetailControlAuditStepList;
ViewBag.descControlRisks = rcmDetailControlList;
ViewBag.descRisk = rcmList;
//ViewBag.descProses = rcmList;
ViewBag.busProses = rcmList;
ViewBag.WordDocumentFilename = "RCM";
return(View(walktrough));
}
// GET: Walktroughs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(id);
BusinessProces business = db.BusinessProcess.Find(id);
List <string> newFilesName = new List <string>();
List <string> paths = new List <string>();
UrlHelper url = Url;
HttpServerUtilityBase server = Server;
bool getFiles = filesTransact.getFiles(business.DocumentNo, out newFilesName, out paths, url, server);
ViewBag.newFilesName = newFilesName;
ViewBag.paths = paths;
ViewBag.WalktroughID = business.WalktroughID;
ViewBag.BPMID = business.BPMID;
ViewBag.BusinessID = business.BusinessProcesID;
ViewBag.No = business.DocumentNo;
ViewBag.Name = business.DocumentName;
ViewBag.Mark = business.Walktrough.Remarks;
return(View(walktrough));
}
public ActionResult Create([Bind(Include = "WalktroughID,LetterOfCommandID,ActivityID,Date_Start,Date_End,Remarks,Status")] Walktrough walktrough)
{
if (ModelState.IsValid)
{
db.Walktroughs.Add(walktrough);
TempData["message"] = "Walktrough successfully created!";
return(RedirectToAction("Index"));
}
ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", walktrough.ActivityID);
return(View(walktrough));
}
public async Task <ActionResult> Edit([Bind(Include = "WalktroughID,LetterOfCommandID,ActivityID,Date_Start,Date_End,Remarks,Status")] Walktrough walktrough)
{
if (ModelState.IsValid)
{
db.Entry(walktrough).State = EntityState.Modified;
await db.SaveChangesAsync();
TempData["message"] = "Walktrough successfully updated!";
return(RedirectToAction("Index"));
}
ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", walktrough.ActivityID);
ViewBag.PreliminaryID = new SelectList(db.LetterOfCommands, "PreliminaryID", "NomorPreliminarySurvey", walktrough.PreliminaryID);
return(View(walktrough));
}
// GET: Walktroughs/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = await db.Walktroughs.FindAsync(id);
if (walktrough == null)
{
return(HttpNotFound());
}
ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", walktrough.ActivityID);
ViewBag.PreliminaryID = new SelectList(db.LetterOfCommands, "PreliminaryID", "NomorPreliminarySurvey", walktrough.PreliminaryID);
return(View(walktrough));
}
public string GetMember(string nopre)
{
Preliminary pre = db.Preliminaries.Where(p => p.NomorPreliminarySurvey.Equals(nopre)).FirstOrDefault();
if (pre != null)
{
var memberId = pre.MemberID;
var teamleaderId = pre.TeamLeaderID;
var supervisorId = pre.SupervisorID;
var picId = pre.PICID;
var activityid = pre.Activity.ActivityID;
var engagement = pre.EngagementActivity.Name;
string memberName = memberId;
string activity = db.Activities.Find(activityid).Name;
Walktrough wt = db.Walktroughs.Where(p => p.PreliminaryID == pre.PreliminaryID).FirstOrDefault();
string wlkStartDate = wt.Date_Start.ToShortDateString();
string wlkEndDate = wt.Date_End.ToShortDateString();
if (teamleaderId == "" || supervisorId == "" || picId == "")
{
//string memberName = "";
string teamleaderName = "Null";
string supervisorName = "Null";
string picName = "Null";
string memberName1 = "Null";
string names = teamleaderName + "," + supervisorName + "," + picName;
return(names + "," + memberName1 + "," + activity + "," + engagement + ',' + wlkStartDate + ',' + wlkEndDate);
}
else
{
//string memberName = db.Employees.Find(memberId).Name;
//string teamleaderName = db.Employees.Find(teamleaderId).Name;
//string supervisorName = db.Employees.Find(supervisorId).Name;
//string picName = db.Employees.Find(picId).Name;
string teamleaderName = teamleaderId;
string supervisorName = supervisorId;
string picName = picId;
string names = teamleaderName + "," + supervisorName + "," + picName;
return(names + "," + memberName + "," + activity + "," + engagement + ',' + wlkStartDate + ',' + wlkEndDate);
}
}
else
{
return(",,,,,,");
}
}
public ActionResult CreateBusiness(int?id, int?walkid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(walkid);
BusinessProces business = db.BusinessProcess.Find(id);
BPM bpm = db.BPMs.Find(id);
//ViewBag.Name = db.BusinessProcess.Find(id);
if (walktrough == null)
{
return(HttpNotFound());
}
//ViewBag.BusinessProcesID = business.BusinessProcesID;
ViewBag.WalktroughID = walktrough.WalktroughID;
ViewBag.ActivityID = walktrough.ActivityID;
ViewBag.BPMID = bpm.BPMID;
ViewBag.PrelimID = walktrough.PreliminaryID;
ViewBag.BPMStatus = bpm.Status;
ViewBag.WalktroughID = bpm.WalktroughID;
ViewBag.Name = bpm.Name;
walktrough.BusinessProces = (from b in db.BusinessProcess
where b.BPMID == id
select b).ToList();
walktrough.BPM = (from b in db.BPMs
where b.BPMID == id
select b).ToList();
string message = TempData["message"] as string;
if (!string.IsNullOrEmpty(message))
{
ViewBag.message = message;
}
return(View(walktrough));
//return View(walktrough);
}
// GET: Walktroughs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(id);
BusinessProces business = db.BusinessProcess.Find(id);
ViewBag.WalktroughID = business.WalktroughID;
ViewBag.BPMID = business.BPMID;
ViewBag.BusinessID = business.BusinessProcesID;
ViewBag.No = business.DocumentNo;
ViewBag.Name = business.DocumentName;
ViewBag.Mark = business.Walktrough.Remarks;
return(View(walktrough));
}
public ActionResult EditBusiness(int?id, int?walkid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Walktrough walktrough = db.Walktroughs.Find(walkid);
BusinessProces business = db.BusinessProcess.Find(id);
BPM bpm = db.BPMs.Find(id);
if (walktrough == null)
{
return(HttpNotFound());
}
List <string> newFilesName = new List <string>();
List <string> paths = new List <string>();
UrlHelper url = Url;
HttpServerUtilityBase server = Server;
var getFiles = filesTransact.getFiles(business.DocumentNo, out newFilesName, out paths, url, server);
ViewBag.newFilesName = newFilesName;
ViewBag.paths = paths;
ViewBag.WalktroughID = business.WalktroughID;
ViewBag.BPMID = business.BPMID;
ViewBag.BusinessProcesID = business.BusinessProcesID;
ViewBag.DocumentNo = business.DocumentNo;
ViewBag.DocumentName = business.DocumentName;
ViewBag.FolderName = business.FolderName;
walktrough.BusinessProces = (from b in db.BusinessProcess
where b.BPMID == id
select b).ToList();
return(View(walktrough));
}
public ActionResult Update(string submit, [Bind(Include = "PreliminaryID,Type,Status,NomorPreliminarySurvey,Date_Start,Date_End,ReviewMasterID,ActivityID,EmployeeID,EngagementID,PICID,SupervisorID,TeamLeaderID,MemberID")] Preliminary preliminary, IEnumerable <HttpPostedFileBase> files)
{
if (ModelState.IsValid)
{
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 pre = preliminary.NomorPreliminarySurvey.Split('/')[0];
var no = preliminary.NomorPreliminarySurvey.Split('/')[1];
bool getFiles = filesTransact.getFiles(pre + no, out newFilesName, out paths, url, server);
List <string> deletedFiles = paths.Except(keepImages).ToList();
bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server);
i = filesTransact.getLastNumberOfFiles(pre + no, server);
}
foreach (var file in files)
{
if (file != null)
{
i = i + 1;
var pre = preliminary.NomorPreliminarySurvey.Split('/')[0];
var no = preliminary.NomorPreliminarySurvey.Split('/')[1];
bool addFile = filesTransact.addFile(pre + no, i, file, server);
}
}
Session.Remove("Images");
string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty;
if (submit == "Save")
{
preliminary.Status = "Draft";
}
else if (submit == "Send Back")
{
preliminary.Status = HelperController.GetStatusSendback(db, "Preliminary Survey", preliminary.Status);
}
else if (submit == "Approve")
{
preliminary.Status = "Approve";
Walktrough walktrough = new Walktrough();
walktrough.PreliminaryID = preliminary.PreliminaryID;
walktrough.ActivityID = preliminary.ActivityID;
walktrough.Date_Start = preliminary.Date_Start;
walktrough.Date_End = preliminary.Date_End;
walktrough.Status = "Approve";
db.Walktroughs.Add(walktrough);
}
else if (submit == "Submit For Review By" + user)
{
preliminary.Status = "Pending for Review by" + user;
}
else if (submit == "Submit For Approve By" + user)
{
preliminary.Status = "Pending for Approve by" + user;
string userToSentEmail = String.Empty;
if (user.Trim() == "CIA")
{
userToSentEmail = preliminary.PICID;
if (userToSentEmail != null)
{
sentSingleEmailPrelim(userToSentEmail, preliminary);
}
else
{
sentEmailPrelim(preliminary, user.Trim());
}
}
else if (user.Trim() == "Pengawas")
{
userToSentEmail = preliminary.SupervisorID;
if (userToSentEmail != null)
{
sentSingleEmailPrelim(userToSentEmail, preliminary);
}
else
{
sentEmailPrelim(preliminary, user.Trim());
}
}
else if (user.Trim() == "Ketua Tim")
{
userToSentEmail = preliminary.TeamLeaderID;
if (userToSentEmail != null)
{
sentSingleEmailPrelim(userToSentEmail, preliminary);
}
else
{
sentEmailPrelim(preliminary, user.Trim());
}
}
else if (user.Trim() == "Member")
{
userToSentEmail = preliminary.MemberID;
if (userToSentEmail != null)
{
sentSingleEmailPrelim(userToSentEmail, preliminary);
}
else
{
sentEmailPrelim(preliminary, user.Trim());
}
}
}
string username = User.Identity.Name;
db.Configuration.ProxyCreationEnabled = false;
Preliminary oldData = db.Preliminaries.AsNoTracking().Where(p => p.PreliminaryID.Equals(preliminary.PreliminaryID)).FirstOrDefault();
auditTransact.CreateAuditTrail("Update", preliminary.PreliminaryID, "Preliminary", oldData, preliminary, username);
db.Entry(preliminary).State = EntityState.Modified;
db.SaveChanges();
TempData["message"] = "Preliminary successfully updated!";
return(RedirectToAction("Index"));
}
ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", preliminary.ActivityID);
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "Type", preliminary.EmployeeID);
return(View(preliminary));
}
