public ActionResult UpdateEngagement(string membernull, int engId, string engagementname, int activeid, string pic, string supervisor, string leader, string member) { EngagementActivity eng = db.EngagementActivities.Find(engId); eng.Name = engagementname; if (pic == null || supervisor == null || leader == null || member == null) { eng.MemberID = "0"; eng.PICID = "0"; eng.SupervisorID = "0"; eng.TeamLeaderID = "0"; } else if (member == "") { eng.MemberID = member; eng.SupervisorID = supervisor; eng.TeamLeaderID = leader; eng.PICID = pic; } else { eng.MemberID = member; eng.SupervisorID = supervisor; eng.TeamLeaderID = leader; eng.PICID = leader; } db.Entry(eng).State = EntityState.Modified; db.SaveChanges(); var obj = db.EngagementActivities.Where(m => m.ActivityID == activeid).Select(p => new { EngagementID = p.EngagementID, engName = p.Name }).ToList(); SelectList obg = new SelectList(obj, "EngagementID", "engName", 0); return(Json(obg)); }
public async Task <ActionResult> Edit([Bind(Include = "FeedbackID,FieldWorkID")] Feedback feedback) { if (ModelState.IsValid) { db.Entry(feedback).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } //ViewBag.AuditPlanningMemorandumID = new SelectList(db.AuditPlanningMemorandums, "AuditPlanningMemorandumID", "NomerAPM", feedback.AuditPlanningMemorandumID); return(View(feedback)); }
public ActionResult Edit([Bind(Include = "PermissionRoleID,permissionID,IsCreate,IsRead,IsUpdate,IsDelete,IsSubmit1,IsSubmit2,IsApprove,roleID")] PermissionRoles permissionRole) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; PermissionRoles oldData = db.PermissionRoles.AsNoTracking().Where(p => p.PermissionRoleID.Equals(permissionRole.PermissionRoleID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", permissionRole.PermissionRoleID, "Role Permission", oldData, permissionRole, username); db.Entry(permissionRole).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Role Permission successfully updated!"; return(RedirectToAction("Index")); } return(View(permissionRole)); }
public ActionResult EditProfile(int EmployeeID, string FirstName, string LastName, string Email, string UserName) { if (ModelState.IsValid) { var Mywho = Request.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(User.Identity.GetUserId()); var empl = db.Employees.Find(EmployeeID); empl.Name = FirstName + " " + LastName; empl.Email = Email; Mywho.Id = Mywho.Id; Mywho.UserName = UserName; Mywho.FirstName = FirstName; Mywho.LastName = LastName; Mywho.Email = Email; db.Entry(empl).State = EntityState.Modified; Request.GetOwinContext().GetUserManager <ApplicationUserManager>().Update(Mywho); db.SaveChanges(); string userId = User.Identity.GetUserId(); var currentUserLogin = db.UserLoginDetail.Where(p => p.UserID.Equals(userId)); if (currentUserLogin.Count() > 0) { db.UserLoginDetail.Remove(currentUserLogin.FirstOrDefault()); db.SaveChanges(); } AuthenticationManager.SignOut(); return(RedirectToAction("Login", "Account")); } return(View("EditProfile")); }
public ActionResult Edit([Bind(Include = "ConsultingFeedbackID,ConsultingSuratPerintahID")] ConsultingFeedback consultingFeedback) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; ConsultingFeedback oldData = db.ConsultingFeedbacks.AsNoTracking().Where(p => p.ConsultingFeedbackID.Equals(consultingFeedback.ConsultingFeedbackID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", consultingFeedback.ConsultingFeedbackID, "Consulting Feedback", oldData, consultingFeedback, username); db.Entry(consultingFeedback).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Consulting Feedback successfully updated!"; return(RedirectToAction("Index")); } ViewBag.ConsultingSuratPerintahID = new SelectList(db.ConsultingLetterOfCommands, "ConsultingSuratPerintahID", "NomorSP", consultingFeedback.ConsultingSuratPerintahID); return(View(consultingFeedback)); }
//public async Task<ActionResult> Edit([Bind(Include = "ReportingID,LetterOfCommandID,NomorLaporan,MemoDescription,SummaryDescription,Bab01Title,Bab01SubTitle,Bab01Description,Bab02Title,Bab02SubTitle,Bab02Description,Fact,Criteria,Impact,impactValue,Cause,Recommendation,FieldWorkID")] Reporting reporting, string submit) public async Task <ActionResult> Edit(Reporting reporting, string submit) { if (ModelState.IsValid) { if (submit == "Generate Summary") { return(RedirectToAction("Summary", new { id = reporting.ReportingID })); } else if (submit == "Generate Report") { return(RedirectToAction("Report", new { id = reporting.ReportingID })); } string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; Reporting oldData = db.Reportings.AsNoTracking().Where(p => p.ReportingID.Equals(reporting.ReportingID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", reporting.ReportingID, "Reporting", oldData, reporting, username); reporting.ReportingBabModel.Clear(); foreach (var item in reporting.ListBab) { reporting.ReportingBabModel.Add(item); } db.Entry(reporting).State = EntityState.Modified; await db.SaveChangesAsync(); TempData["message"] = "Report successfully updated!"; return(RedirectToAction("Index")); } return(View(reporting)); }
public ActionResult EditAuditUniverse(string submit, [Bind(Include = "ActivityID,ActivityParentID,Name,Status,Status_Active,Tahun,Description,DepartementID")] Activity activity) { if (ModelState.IsValid) { db.Entry(activity).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Audit Universe successfully updated!"; return(RedirectToAction("Index")); } return(View(activity)); }
public async Task <ActionResult> Edit([Bind(Include = "BusinessProcesID,BPMID,DocumentNo,DocumentName,FolderName")] BusinessProces businessProces) { if (ModelState.IsValid) { db.Entry(businessProces).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } //ViewBag.WalktroughID = new SelectList(db.Walktroughs, "WalktroughID", "Remarks", businessProces.WalktroughID); return(View(businessProces)); }
public async Task <ActionResult> EditBusiness(IEnumerable <HttpPostedFileBase> files, [Bind(Include = "BusinessProcesID,WalktroughID,DocumentNo,DocumentName,FolderName,BPMID")] BusinessProces businessProces) { 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()); } bool getFiles = filesTransact.getFiles(businessProces.DocumentNo, out newFilesName, out paths, url, server); List <string> deletedFiles = paths.Except(keepImages).ToList(); bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server); i = filesTransact.getLastNumberOfFiles(businessProces.DocumentNo, server); } foreach (var file in files) { if (file != null) { i = i + 1; bool addFile = filesTransact.addFile(businessProces.DocumentNo, i, file, server); } } Session.Remove("Images"); string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; BusinessProces oldData = db.BusinessProcess.AsNoTracking().Where(p => p.BusinessProcesID.Equals(businessProces.BusinessProcesID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", Convert.ToInt32(businessProces.WalktroughID), "BusinessProcessDetail", oldData, businessProces, username); db.Entry(businessProces).State = EntityState.Modified; await db.SaveChangesAsync(); db.SaveChanges(); TempData["message"] = "BPM detail successfully updated!"; return(RedirectToAction("CreateBusiness", new { id = businessProces.BPMID, walkid = businessProces.WalktroughID })); } return(View(businessProces)); }
public ActionResult Edit([Bind(Include = "ConsultingDraftAgreementID,NoRequest,NoSurat,RequesterID,Date_Start,ActivityStr,Tujuan,RuangLingkup,Peran,Status")] ConsultingDraftAgreement consultingDraftAgreement, string submit) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { consultingDraftAgreement.Status = "Draft"; } else if (submit == "Send Back") { consultingDraftAgreement.Status = HelperController.GetStatusSendback(db, "Consulting Draft Agreement", consultingDraftAgreement.Status); } else if (submit == "Approve") { consultingDraftAgreement.Status = "Approve"; } else if (submit == "Submit For Review By" + user) { consultingDraftAgreement.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { consultingDraftAgreement.Status = "Pending for Approve by" + user; string baseUrl = Request.Url.GetLeftPart(UriPartial.Authority); List <string> CIAUserIds = Request.GetOwinContext().GetUserManager <ApplicationRoleManager>().Roles.Where(p => p.Name.Equals(user.Trim())).FirstOrDefault().Users.Select(p => p.UserId).ToList(); List <Employee> CIAEmpList = new List <Employee>(); if (CIAUserIds.Count() > 0) { var CIAUsers = Request.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.Where(p => (CIAUserIds.Contains(p.Id))).ToList(); foreach (var CIAUser in CIAUsers) { Employee empl = db.Employees.Where(p => p.Email.Equals(CIAUser.Email)).FirstOrDefault(); string emailContent = "Dear {0}, <BR/><BR/>Consulting Draft Agreement : {1} need your approval. Please click on this <a href=\"{2}\" title=\"CDA\">link</a> to show the Consulting Draft Agreement.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team"; string urlRequest = baseUrl + "/ConsultingDraftAgreements/Details/" + consultingDraftAgreement.ConsultingDraftAgreementID; emailTransact.SentEmailApproval(empl.Email, empl.Name, consultingDraftAgreement.NoSurat, emailContent, urlRequest); } } } ConsultingDraftAgreement oldData = db.ConsultingDraftAgreements.AsNoTracking().Where(p => p.ConsultingDraftAgreementID.Equals(consultingDraftAgreement.ConsultingDraftAgreementID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", consultingDraftAgreement.ConsultingDraftAgreementID, "Consulting Draft Agreement", oldData, consultingDraftAgreement, username); db.Entry(consultingDraftAgreement).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Draft Agreement successfully updated!"; return(RedirectToAction("Index")); } //ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", consultingDraftAgreement.ActivityID); return(View(consultingDraftAgreement)); }
public ActionResult Edit([Bind(Include = "EmployeeID,Type,Name,NoPEK,Email,PhoneNumber,Status,OrganizationID,PositionID,UserName")] Employee employee, IEnumerable <HttpPostedFileBase> files) { if (ModelState.IsValid) { db.Configuration.ProxyCreationEnabled = false; Employee oldData = db.Employees.AsNoTracking().Where(p => p.EmployeeID.Equals(employee.EmployeeID)).FirstOrDefault(); string oldName = oldData.Name; bool nameExist = db.Employees.Any(p => p.Name == employee.Name); if (oldName != employee.Name) { if (!nameExist) { string username = User.Identity.Name; auditTransact.CreateAuditTrail("Update", employee.EmployeeID, "Employee", oldData, employee, username); db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Employee successfully updated!"; return(RedirectToAction("Index")); } else { ViewBag.NameExist = "Name already taken"; } } else { string username = User.Identity.Name; auditTransact.CreateAuditTrail("Update", employee.EmployeeID, "Employee", oldData, employee, username); db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Employee successfully updated!"; return(RedirectToAction("Index")); } } ViewBag.OrganizationID = new SelectList(db.Organizations, "OrganizationID", "Name", employee.OrganizationID); ViewBag.PositionID = new SelectList(db.Positions, "PositionID", "PositionName", employee.PositionID); return(View(employee)); }
public ActionResult Edit([Bind(Include = "PositionID,PositionName,JobDesc")] Position position) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; Position oldData = db.Positions.AsNoTracking().Where(p => p.PositionID.Equals(position.PositionID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", position.PositionID, "Position", oldData, position, username); db.Entry(position).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Position successfully updated!"; return(RedirectToAction("Index")); } return(View(position)); }
// PUT api/ReviewRelationDetail/5 public HttpResponseMessage PutReviewRelationDetail(int id, ReviewRelationDetail reviewrelationdetail) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != reviewrelationdetail.ReviewRelationDetailID) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(reviewrelationdetail).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
// PUT api/Comment/5 public HttpResponseMessage PutPostComment(int id, PostComment postcomment) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != postcomment.PostCommentId) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(postcomment).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public ActionResult Edit([Bind(Include = "ExitMeetingID,ActivityID,EngagementID,Date_Start,Date_End,Status,OrganizationID,LetterOfCommandID,Reviewer1,Reviewer2,StatusTanggapan")] ExitMeeting exitMeeting, string activname, string enggname, string submit, string organame, string nomersp, string period1, string period2) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; IQueryable <Activity> act = db.Activities.Where(p => p.Name.Equals(activname)); int actID = 0; if (act.Count() > 0 || act != null) { actID = act.Select(p => p.ActivityID).FirstOrDefault(); } exitMeeting.ActivityID = actID; IQueryable <EngagementActivity> eng = db.EngagementActivities.Where(p => p.Name.Equals(enggname)); int engID = 0; if (eng.Count() > 0 || eng != null) { engID = eng.Select(p => p.EngagementID).FirstOrDefault(); } exitMeeting.EngagementID = engID; exitMeeting.Date_Start = Convert.ToDateTime(period1); exitMeeting.Date_End = Convert.ToDateTime(period2); IQueryable <Organization> org = db.Organizations.Where(p => p.Name.Equals(organame)); int orgID = 0; if (act.Count() > 0 || act != null) { orgID = org.Select(p => p.OrganizationID).FirstOrDefault(); } exitMeeting.OrganizationID = orgID; IQueryable <LetterOfCommand> letter = db.LetterOfCommands.Where(p => p.NomorSP.Equals(nomersp)); int letterID = 0; if (letter.Count() > 0 || letter != null) { letterID = letter.Select(p => p.LetterOfCommandID).FirstOrDefault(); } exitMeeting.LetterOfCommandID = letterID; LetterOfCommand sp = db.LetterOfCommands.Find(exitMeeting.LetterOfCommandID); string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { exitMeeting.Status = "Draft"; } else if (submit == "Send Back") { exitMeeting.Status = HelperController.GetStatusSendback(db, "Exit Meeting", exitMeeting.Status); } else if (submit == "Approve") { exitMeeting.Status = "Approve"; exitMeeting.StatusTanggapan = "Closed"; } else if (submit == "Submit For Review By" + user) { exitMeeting.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { exitMeeting.Status = "Pending for Approve by" + user; string userToSentEmail = String.Empty; if (user.Trim() == "CIA") { userToSentEmail = sp.PICID; if (userToSentEmail != null) { sentSingleEmailEM(userToSentEmail, exitMeeting); } else { sentEmailEM(exitMeeting, user.Trim()); } } else if (user.Trim() == "Pengawas") { userToSentEmail = sp.SupervisorID; if (userToSentEmail != null) { sentSingleEmailEM(userToSentEmail, exitMeeting); } else { sentEmailEM(exitMeeting, user.Trim()); } } else if (user.Trim() == "Ketua Tim") { userToSentEmail = sp.TeamLeaderID; if (userToSentEmail != null) { sentSingleEmailEM(userToSentEmail, exitMeeting); } else { sentEmailEM(exitMeeting, user.Trim()); } } else if (user.Trim() == "Member") { userToSentEmail = sp.MemberID; if (userToSentEmail != null) { sentSingleEmailEM(userToSentEmail, exitMeeting); } else { sentEmailEM(exitMeeting, user.Trim()); } } } ExitMeeting oldData = db.ExitMeetings.AsNoTracking().Where(p => p.ExitMeetingID.Equals(exitMeeting.ExitMeetingID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", exitMeeting.ExitMeetingID, "Exit Meeting", oldData, exitMeeting, username); db.Entry(exitMeeting).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Exit Meeting successfully updated!"; return(RedirectToAction("Index")); } ViewBag.nomersp = db.LetterOfCommands.Where(p => p.LetterOfCommandID.Equals(exitMeeting.ExitMeetingID)).Select(p => p.NomorSP).FirstOrDefault(); 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(); return(View(exitMeeting)); }
public ActionResult Edit(string memberName, string enggname, string nomer, [Bind(Include = "AuditPlanningMemorandumID,NomerAPM,PreliminaryID,Date_Start,Date_End,Status,ActivityID,TujuanAudit,RuangLingkupAudit,MetodologiAudit,DataDanDokumen,AttachmentMasterID,EntryMeetingDateStart,EntryMeetingDateEnd,WalktroughDateStart,WalktroughDateEnd,FieldWorkDateStart,FieldWorkDateEnd,ExitMeetingDateStart,ExitMeetingDateEnd,LHADateStart,LHADateEnd,PICID,SupervisorID,TeamLeaderID,MemberID,ReviewMasterID,Kesimpulan,ActualEngagement")] AuditPlanningMemorandum auditPlanningMemorandum, IEnumerable <HttpPostedFileBase> files, string[] members, string pic, string supervisor, string leader, string submit, EngagementActivity engga, string activid) { 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()); } bool getFiles = filesTransact.getFiles(auditPlanningMemorandum.NomerAPM.Replace("/", ""), out newFilesName, out paths, url, server); List <string> deletedFiles = paths.Except(keepImages).ToList(); bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server); i = filesTransact.getLastNumberOfFiles(auditPlanningMemorandum.NomerAPM.Replace("/", ""), server); } foreach (var file in files) { if (file != null) { i = i + 1; bool addFile = filesTransact.addFile(auditPlanningMemorandum.NomerAPM.Replace("/", ""), i, file, server); } } Session.Remove("Images"); IQueryable <Preliminary> pre = db.Preliminaries.Where(p => p.NomorPreliminarySurvey.Equals(nomer)); int preId = 0; if (pre.Count() > 0 || pre != null) { preId = pre.Select(p => p.PreliminaryID).FirstOrDefault(); } auditPlanningMemorandum.PreliminaryID = preId; IQueryable <Activity> act = db.Activities.Where(p => p.Name.Equals(activid)); int actid = 0; if (act.Count() > 0 || act != null) { actid = act.Select(p => p.ActivityID).FirstOrDefault(); } auditPlanningMemorandum.ActivityID = actid; foreach (var mem in members) { auditPlanningMemorandum.MemberID += mem + ";"; } auditPlanningMemorandum.SupervisorID = supervisor; auditPlanningMemorandum.TeamLeaderID = leader; auditPlanningMemorandum.PICID = pic; string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { auditPlanningMemorandum.Status = "Draft"; } else if (submit == "Send Back") { HelperController.GetStatusSendback(db, "Audit Planning Memorandum", auditPlanningMemorandum.Status); } else if (submit == "Approve") { auditPlanningMemorandum.Status = "Approve"; } else if (submit == "Submit For Review By" + user) { auditPlanningMemorandum.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { auditPlanningMemorandum.Status = "Pending for Approve by" + user; string userToSentEmail = String.Empty; if (user.Trim() == "CIA") { userToSentEmail = auditPlanningMemorandum.PICID; if (userToSentEmail != null) { sentSingleEmailAPM(userToSentEmail, auditPlanningMemorandum); } else { sentEmailAPM(auditPlanningMemorandum, user.Trim()); } } else if (user.Trim() == "Pengawas") { userToSentEmail = auditPlanningMemorandum.SupervisorID; if (userToSentEmail != null) { sentSingleEmailAPM(userToSentEmail, auditPlanningMemorandum); } else { sentEmailAPM(auditPlanningMemorandum, user.Trim()); } } else if (user.Trim() == "Ketua Tim") { userToSentEmail = auditPlanningMemorandum.TeamLeaderID; if (userToSentEmail != null) { sentSingleEmailAPM(userToSentEmail, auditPlanningMemorandum); } else { sentEmailAPM(auditPlanningMemorandum, user.Trim()); } } else if (user.Trim() == "Member") { userToSentEmail = auditPlanningMemorandum.MemberID; if (userToSentEmail != null) { sentSingleEmailAPM(userToSentEmail, auditPlanningMemorandum); } else { sentEmailAPM(auditPlanningMemorandum, user.Trim()); } } } db.Entry(auditPlanningMemorandum).State = EntityState.Modified; string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; AuditPlanningMemorandum oldData = db.AuditPlanningMemorandums.AsNoTracking().Where(p => p.AuditPlanningMemorandumID.Equals(auditPlanningMemorandum.AuditPlanningMemorandumID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", auditPlanningMemorandum.AuditPlanningMemorandumID, "AuditPlanningMemorandum", oldData, auditPlanningMemorandum, username); db.SaveChanges(); TempData["message"] = "Audit Planning Memorandum successfully updated!"; return(RedirectToAction("Index")); } //ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", auditPlanningMemorandum.ActivityID); //ViewBag.PreliminaryID = new SelectList(db.Preliminaries, "PreliminaryID", "Type", auditPlanningMemorandum.PreliminaryID); return(View(auditPlanningMemorandum)); }
public ActionResult Edit(string period1, string period2, string empchair, string empmoderator, string empreporter, string empmember, string letterno, [Bind(Include = "NotulenEntryMeetingID,AuditPlanningMemorandumID,Tujuan,TimeConsumableStartDate,TimeConsumableEndDate,Place,EmployeeChairmanID,EmployeeModeratorID,EmployeeReporterID,EmployeeMemberID,Opening,ExposurePlan,LetterOfCommandID")] NotulenEntryMeeting notulenEntryMeeting, 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 notulen = "notulen"; var id = notulenEntryMeeting.NotulenEntryMeetingID; bool getFiles = filesTransact.getFiles(notulen + id, out newFilesName, out paths, url, server); List <string> deletedFiles = paths.Except(keepImages).ToList(); bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server); i = filesTransact.getLastNumberOfFiles(notulen + id, server); } foreach (var file in files) { if (file != null) { i = i + 1; var notulen = "notulen"; var id = notulenEntryMeeting.NotulenEntryMeetingID; bool addFile = filesTransact.addFile(notulen + id, i, file, server); } } Session.Remove("Images"); IQueryable <LetterOfCommand> loc = db.LetterOfCommands.Where(p => p.NomorSP.Equals(letterno)); int LetterOfCommandID = 0; if (loc.Count() > 0 || letterno != null) { LetterOfCommandID = loc.Select(p => p.LetterOfCommandID).FirstOrDefault(); } notulenEntryMeeting.LetterOfCommandID = LetterOfCommandID; notulenEntryMeeting.TimeConsumableStartDate = Convert.ToDateTime(period1); notulenEntryMeeting.TimeConsumableEndDate = Convert.ToDateTime(period2); IQueryable <Employee> emp = db.Employees.Where(p => p.Name.Equals(empchair)); int empId = 0; if (emp.Count() > 0 || emp != null) { empId = emp.Select(p => p.EmployeeID).FirstOrDefault(); } notulenEntryMeeting.EmployeeChairmanID = empId; IQueryable <Employee> emp2 = db.Employees.Where(p => p.Name.Equals(empmoderator)); int empId2 = 0; if (emp2.Count() > 0 || emp2 != null) { empId2 = emp2.Select(p => p.EmployeeID).FirstOrDefault(); } notulenEntryMeeting.EmployeeModeratorID = empId2; IQueryable <Employee> emp3 = db.Employees.Where(p => p.Name.Equals(empreporter)); int empId3 = 0; if (emp3.Count() > 0 || emp3 != null) { empId3 = emp3.Select(p => p.EmployeeID).FirstOrDefault(); } notulenEntryMeeting.EmployeeReporterID = empId3; IQueryable <Employee> emp4 = db.Employees.Where(p => p.Name.Equals(empmember)); int empId4 = 0; if (emp4.Count() > 0 || emp4 != null) { empId4 = emp4.Select(p => p.EmployeeID).FirstOrDefault(); } notulenEntryMeeting.EmployeeMemberID = empId4; string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; NotulenEntryMeeting oldData = db.NotulenEntryMeetings.AsNoTracking().Where(p => p.NotulenEntryMeetingID.Equals(notulenEntryMeeting.NotulenEntryMeetingID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", notulenEntryMeeting.NotulenEntryMeetingID, "NotulenEntryMeeting", oldData, notulenEntryMeeting, username); db.Entry(notulenEntryMeeting).State = EntityState.Modified; db.SaveChangesAsync(); TempData["message"] = "Notulen Entry Meeting successfully updated!"; return(RedirectToAction("Index")); } ViewBag.AuditPlanningMemorandumID = new SelectList(db.AuditPlanningMemorandums, "AuditPlanningMemorandumID", "NomerAPM", notulenEntryMeeting.AuditPlanningMemorandumID); return(View(notulenEntryMeeting)); }
public async Task <ActionResult> Edit([Bind(Include = "QuestionerID,Name,Type,Value,Status")] Questioner questioner, string Textarea, string Textbox, string Rating, string submit, string Rating1, string Rating2) { if (ModelState.IsValid) { if (questioner.Type == "Textbox") { questioner.Value = Textbox; } else if (questioner.Type == "Textarea") { questioner.Value = Textarea; } else { questioner.Value = Rating1 + ";" + Rating2; } string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save" || submit == "Send Back") { questioner.Status = "Draft"; } else if (submit == "Approve") { questioner.Status = "Approve"; } else if (submit == "Submit For Review By" + user) { questioner.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { questioner.Status = "Pending for Approve by" + user; string baseUrl = Request.Url.GetLeftPart(UriPartial.Authority); List <string> CIAUserIds = Request.GetOwinContext().GetUserManager <ApplicationRoleManager>().Roles.Where(p => p.Name.Equals(user.Trim())).FirstOrDefault().Users.Select(p => p.UserId).ToList(); List <Employee> CIAEmpList = new List <Employee>(); if (CIAUserIds.Count() > 0) { var CIAUsers = Request.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.Where(p => (CIAUserIds.Contains(p.Id))).ToList(); foreach (var CIAUser in CIAUsers) { Employee emp = db.Employees.Where(p => p.Email.Equals(CIAUser.Email)).FirstOrDefault(); string emailContent = "Dear {0}, <BR/><BR/>Questioner : {1} need your approval. Please click on this <a href=\"{2}\" title=\"Questioner\">link</a> to show the Questioner.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team"; string url = baseUrl + "/Questioners/Details/" + questioner.QuestionerID; //emailTransact.SentEmailApproval(emp.Email, emp.Name, questioner.Name, emailContent, url); } } } string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; Questioner oldData = db.Questioners.AsNoTracking().Where(p => p.QuestionerID.Equals(questioner.QuestionerID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", questioner.QuestionerID, "Questioner", oldData, questioner, username); db.Entry(questioner).State = EntityState.Modified; await db.SaveChangesAsync(); TempData["message"] = "Questioner successfully updated!"; return(RedirectToAction("Index")); } return(View(questioner)); }
public ActionResult Edit(int?ActivityID, int?EnggaID, EngagementActivity engagementNam, string EngagementName, int?UnActivityID, string submit, [Bind(Include = "PreliminaryID,Type,Status,NomorPreliminarySurvey,Date_Start,Date_End,ReviewMasterID,ActivityID,EmployeeID,EngagementID,PICID,SupervisorID,TeamLeaderID")] Preliminary preliminary, IEnumerable <HttpPostedFileBase> files, string[] member, string[] members) { 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"; } 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()); } } } if (preliminary.Type == "UnPlanned") { preliminary.ActivityID = UnActivityID.Value; preliminary.EngagementID = EnggaID; engagementNam.Name = EngagementName; engagementNam.ActivityID = UnActivityID.Value; engagementNam.EngagementID = EnggaID.Value; engagementNam.Date_Start = engagementNam.Date_Start; engagementNam.Date_End = engagementNam.Date_End; db.Entry(engagementNam).State = EntityState.Modified; } if (member != null) { foreach (var mem in member) { preliminary.EmployeeID += mem + ";"; } } if (members != null) { foreach (var memb in members) { preliminary.MemberID += memb + ";"; } } 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")); } return(View(preliminary)); }
public ActionResult Edit(string submit, string requester, [Bind(Include = "ConsultingRequestID,NoRequest,NoSurat,RequesterID,Date_Start,EvaluationResult,Status,ActivityStr")] ConsultingRequest consultingRequest, IEnumerable <HttpPostedFileBase> files) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; 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()); } bool getFiles = filesTransact.getFiles(consultingRequest.NoRequest.Replace("/", ""), out newFilesName, out paths, url, server); List <string> deletedFiles = paths.Except(keepImages).ToList(); bool deleteFiles = filesTransact.deleteFiles(deletedFiles, server); i = filesTransact.getLastNumberOfFiles(consultingRequest.NoRequest.Replace("/", ""), server); } foreach (var file in files) { if (file != null) { i = i + 1; bool addFile = filesTransact.addFile(consultingRequest.NoRequest.Replace("/", ""), i, file, server); } } Session.Remove("Images"); IQueryable <Employee> emp = db.Employees.Where(p => p.Name.Equals(requester)); int empId = 0; if (emp.Count() > 0 || emp != null) { empId = emp.Select(p => p.EmployeeID).FirstOrDefault(); } consultingRequest.RequesterID = empId; string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { consultingRequest.Status = "Draft"; } else if (submit == "Send Back") { consultingRequest.Status = HelperController.GetStatusSendback(db, "Consulting Request", consultingRequest.Status); } else if (submit == "Reject") { consultingRequest.Status = "Reject"; } else if (submit == "Approve") { consultingRequest.Status = "Approve"; ConsultingDraftAgreement consultingDraftAgreement = new ConsultingDraftAgreement(); consultingDraftAgreement.NoRequest = consultingRequest.NoRequest; consultingDraftAgreement.NoSurat = consultingRequest.NoSurat; consultingDraftAgreement.RequesterID = consultingRequest.RequesterID; consultingDraftAgreement.ActivityStr = consultingRequest.ActivityStr; //consultingDraftAgreement.ActivityID = consultingRequest.ActivityID; consultingDraftAgreement.Date_Start = consultingRequest.Date_Start; //consultingDraftAgreement.Date_End = consultingRequest.Date_End; consultingDraftAgreement.Status = "Draft"; db.ConsultingDraftAgreements.Add(consultingDraftAgreement); } else if (submit == "Submit For Review By" + user) { consultingRequest.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { consultingRequest.Status = "Pending for Approve by" + user; string baseUrl = Request.Url.GetLeftPart(UriPartial.Authority); List <string> CIAUserIds = Request.GetOwinContext().GetUserManager <ApplicationRoleManager>().Roles.Where(p => p.Name.Equals(user.Trim())).FirstOrDefault().Users.Select(p => p.UserId).ToList(); List <Employee> CIAEmpList = new List <Employee>(); if (CIAUserIds.Count() > 0) { var CIAUsers = Request.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.Where(p => (CIAUserIds.Contains(p.Id))).ToList(); foreach (var CIAUser in CIAUsers) { Employee empl = db.Employees.Where(p => p.Email.Equals(CIAUser.Email)).FirstOrDefault(); string emailContent = "Dear {0}, <BR/><BR/>Consulting Request : {1} need your approval. Please click on this <a href=\"{2}\" title=\"Consulting Request\">link</a> to show the Consulting Request.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team"; string urlRequest = baseUrl + "/ConsultingRequests/Details/" + consultingRequest.ConsultingRequestID; emailTransact.SentEmailApproval(empl.Email, empl.Name, consultingRequest.NoRequest, emailContent, urlRequest); } } } ConsultingRequest oldData = db.ConsultingRequests.AsNoTracking().Where(p => p.ConsultingRequestID.Equals(consultingRequest.ConsultingRequestID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", consultingRequest.ConsultingRequestID, "Consulting Request", oldData, consultingRequest, username); db.Entry(consultingRequest).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Request successfully updated!"; return(RedirectToAction("Index")); } //ViewBag.ActivityID = new SelectList(db.Activities, "ActivityID", "Name", consultingRequest.ActivityID); return(View(consultingRequest)); }
public ActionResult Create([Bind(Include = "ConsultingSuratPerintahID,NomorSP,ConsultingRequestID,EngagementName,EngagementID,StartDate,EndDate,PicID,SupervisorID,TeamLeaderID,Menimbang,Penutup,MemberID,Remarks")] ConsultingLetterOfCommand consultingletterofcommand, EngagementActivity engagementActivity, string ActivityName, string submit, string[] member, string ConsultingRequest, ConsultingLetterOfCommandDetailDasar Ldasar, ConsultingLetterOfCommandDetailTembusan Ltembusan, ConsultingLetterOfCommandDetailUntuk Luntuk, string[] dasar, string[] tembusan, string[] untuk) { if (ModelState.IsValid) { string username = User.Identity.Name; IQueryable <ConsultingRequest> cr = context.ConsultingRequests.Where(p => p.NoRequest.Equals(ConsultingRequest)); int ConsulId = 0; if (cr.Count() > 0 || cr != null) { ConsulId = cr.Select(p => p.ConsultingRequestID).FirstOrDefault(); } consultingletterofcommand.ConsultingRequestID = ConsulId; foreach (var mb in member) { consultingletterofcommand.MemberID += mb + ";"; } string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { consultingletterofcommand.Status = "Draft"; } else if (submit == "Send Back") { consultingletterofcommand.Status = HelperController.GetStatusSendback(context, "Consulting Surat Perintah", consultingletterofcommand.Status); } else if (submit == "Approve") { consultingletterofcommand.Status = "Approve"; } else if (submit == "Submit For Review By" + user) { consultingletterofcommand.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { consultingletterofcommand.Status = "Pending for Approve by" + user; } context.ConsultingLetterOfCommands.Add(consultingletterofcommand); //Engagement Activity //IQueryable<Activity> act = context.Activities.Where(p => p.Name.Equals(ActivityName)); //int ActivityID = 0; //if (act.Count() > 0 || act != null) // ActivityID = act.Select(p => p.ActivityID).FirstOrDefault(); engagementActivity.ActivityStr = ActivityName; engagementActivity.Name = consultingletterofcommand.EngagementName; engagementActivity.PICID = consultingletterofcommand.PicID; engagementActivity.TeamLeaderID = consultingletterofcommand.TeamLeaderID; engagementActivity.SupervisorID = consultingletterofcommand.SupervisorID; engagementActivity.MemberID = consultingletterofcommand.MemberID; context.EngagementActivities.Add(engagementActivity); //Letter of Command Dasar Ldasar.ConsultingSuratPerintahID = consultingletterofcommand.ConsultingSuratPerintahID; Ldasar.Dasar = null; foreach (var ds in dasar) { Ldasar.Dasar += ds + ";"; } context.ConsultingLetterOfCommandDetailDasars.Add(Ldasar); //Letter of Command Untuk Luntuk.ConsultingSuratPerintahID = consultingletterofcommand.ConsultingSuratPerintahID; Luntuk.Untuk = null; foreach (var utk in untuk) { Luntuk.Untuk += utk + ";"; } context.ConsultingLetterOfCommandDetailUntuks.Add(Luntuk); //Letter of Command Tembusan Ltembusan.ConsultingSuratPerintahID = consultingletterofcommand.ConsultingSuratPerintahID; Ltembusan.Tembusan = null; foreach (var tmb in tembusan) { Ltembusan.Tembusan += tmb + ";"; } context.ConsultingLetterOfCommandDetailTembusans.Add(Ltembusan); context.SaveChanges(); //assign engagementID in consulting SP consultingletterofcommand.EngagementID = engagementActivity.EngagementID; context.Entry(consultingletterofcommand).State = EntityState.Modified; //Review Relation Master ReviewRelationMaster rrm = new ReviewRelationMaster(); string page = "conleterdetail"; rrm.Description = page + consultingletterofcommand.ConsultingSuratPerintahID; context.ReviewRelationMasters.Add(rrm); context.SaveChanges(); ConsultingLetterOfCommand conletcom = new ConsultingLetterOfCommand(); ConsultingLetterOfCommandDetailDasar conletdasar = new ConsultingLetterOfCommandDetailDasar(); ConsultingLetterOfCommandDetailUntuk conletuntuk = new ConsultingLetterOfCommandDetailUntuk(); ConsultingLetterOfCommandDetailTembusan conlettembusan = new ConsultingLetterOfCommandDetailTembusan(); ConsultingLetterOfCommand conletnew = context.ConsultingLetterOfCommands.Find(consultingletterofcommand.ConsultingSuratPerintahID); auditTransact.CreateAuditTrail("Create", consultingletterofcommand.ConsultingSuratPerintahID, "Consulting Letter Of Command", conletcom, conletnew, username); auditTransact.CreateAuditTrail("Create", Ldasar.ConsultingLetterOfCommandDetailDasarID, "Consulting Letter Of Command Dasar", conletdasar, Ldasar, username); auditTransact.CreateAuditTrail("Create", Luntuk.ConsultingLetterOfCommandDetailUntukID, "Consulting Letter Of Command Untuk", conletuntuk, Luntuk, username); auditTransact.CreateAuditTrail("Create", Ltembusan.ConsultingLetterOfCommandDetailTembusanID, "Consulting Letter Of Command Tembusan", conlettembusan, Ltembusan, username); TempData["message"] = "Consulting Letter Of Command successfully created!"; return(RedirectToAction("Index")); } return(View(consultingletterofcommand)); }
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)); }
public ActionResult Create([Bind(Include = "LetterOfCommandID,NomorSP,Status,Remarks,AssuranceType,Date_Start,Date_End,Menimbang,Penutup,AuditPlanningMemorandumID,ActivityID,PICID,SupervisorID,TeamLeaderID,MemberID")] LetterOfCommand letterOfCommand, LetterOfCommandDetailDasar letterOfCommandDetailDasar, LetterOfCommandDetailUntuk letterOfCommandDetailUntuk, LetterOfCommandDetailTembusan letterOfCommandDetailTembusan, string letterno, string membernull, string activid, string[] members, string pic, string supervisor, string leader, string nomer, string submit, string[] dasar, string[] untuk, string[] tembusan) { if (ModelState.IsValid) { string username = User.Identity.Name; HttpServerUtilityBase server = Server; string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty; if (submit == "Save") { letterOfCommand.Status = "Draft"; } else if (submit == "Send Back") { letterOfCommand.Status = HelperController.GetStatusSendback(db, "Surat Perintah", letterOfCommand.Status); } else if (submit == "Approve") { letterOfCommand.Status = "Approve"; } else if (submit == "Submit For Review By" + user) { letterOfCommand.Status = "Pending for Review by" + user; } else if (submit == "Submit For Approve By" + user) { letterOfCommand.Status = "Pending for Approve by" + user; string userToSentEmail = String.Empty; if (user.Trim() == "CIA") { userToSentEmail = letterOfCommand.PICID; if (userToSentEmail != null) { sentSingleEmailSP(userToSentEmail, letterOfCommand); } else { sentEmailSP(letterOfCommand, user.Trim()); } } else if (user.Trim() == "Pengawas") { userToSentEmail = letterOfCommand.SupervisorID; if (userToSentEmail != null) { sentSingleEmailSP(userToSentEmail, letterOfCommand); } else { sentEmailSP(letterOfCommand, user.Trim()); } } else if (user.Trim() == "Ketua Tim") { userToSentEmail = letterOfCommand.TeamLeaderID; if (userToSentEmail != null) { sentSingleEmailSP(userToSentEmail, letterOfCommand); } else { sentEmailSP(letterOfCommand, user.Trim()); } } else if (user.Trim() == "Member") { userToSentEmail = letterOfCommand.MemberID; if (userToSentEmail != null) { sentSingleEmailSP(userToSentEmail, letterOfCommand); } else { sentEmailSP(letterOfCommand, user.Trim()); } } } IQueryable <AuditPlanningMemorandum> apm = db.AuditPlanningMemorandums.Where(p => p.NomerAPM.Equals(nomer)); int apmId = 0; if (apm.Count() > 0 || apm != null) { apmId = apm.Select(p => p.AuditPlanningMemorandumID).FirstOrDefault(); letterOfCommand.AuditPlanningMemorandumID = apmId; } letterOfCommand.SupervisorID = supervisor; letterOfCommand.TeamLeaderID = leader; letterOfCommand.PICID = pic; IQueryable <Activity> act = db.Activities.Where(p => p.Name.Equals(activid)); int activ = 0; if (act.Count() > 0 || act != null) { activ = act.Select(p => p.ActivityID).FirstOrDefault(); } letterOfCommand.ActivityID = activ; string tahun1 = letterOfCommand.Date_Start.ToShortDateString().Split('/')[2] + ";"; string tahun2 = letterOfCommand.Date_End.ToShortDateString().Split('/')[2] + ";"; Activity actLetter = db.Activities.Find(activ); if (actLetter.Tahun != null) { if (tahun1 != tahun2) { if (!actLetter.Tahun.Contains(tahun1)) { actLetter.Tahun += tahun1; } if (!actLetter.Tahun.Contains(tahun2)) { actLetter.Tahun += tahun2; } } else { if (!actLetter.Tahun.Contains(tahun1)) { actLetter.Tahun += tahun1; } } } else { if (tahun1 != tahun2) { actLetter.Tahun = tahun1 + tahun2; } else { actLetter.Tahun = tahun1; } } db.Entry(actLetter).State = EntityState.Modified; letterOfCommand.NomorSP = letterno; foreach (var mb in members) { letterOfCommand.MemberID += mb + ";"; } letterOfCommandDetailDasar.LetterOfCommandID = letterOfCommand.LetterOfCommandID; letterOfCommandDetailDasar.Dasar = null; foreach (var ds in dasar) { letterOfCommandDetailDasar.Dasar += ds + ";"; } letterOfCommandDetailUntuk.LetterOfCommandID = letterOfCommand.LetterOfCommandID; letterOfCommandDetailUntuk.Untuk = null; foreach (var utk in untuk) { letterOfCommandDetailUntuk.Untuk += utk + ";"; } letterOfCommandDetailTembusan.LetterOfCommandID = letterOfCommand.LetterOfCommandID; letterOfCommandDetailTembusan.Tembusan = null; foreach (var tmb in tembusan) { letterOfCommandDetailTembusan.Tembusan += tmb + ";"; } db.LetterOfCommandDetailDasars.Add(letterOfCommandDetailDasar); db.LetterOfCommandDetailTembusans.Add(letterOfCommandDetailTembusan); db.LetterOfCommandDetailUntuks.Add(letterOfCommandDetailUntuk); db.LetterOfCommands.Add(letterOfCommand); db.SaveChanges(); LetterOfCommand let = new LetterOfCommand(); LetterOfCommandDetailDasar letDasar = new LetterOfCommandDetailDasar(); LetterOfCommandDetailUntuk letUntuk = new LetterOfCommandDetailUntuk(); LetterOfCommandDetailTembusan letTembusan = new LetterOfCommandDetailTembusan(); auditTransact.CreateAuditTrail("Create", letterOfCommand.LetterOfCommandID, "LetterOfCommand", let, letterOfCommand, username); auditTransact.CreateAuditTrail("Create", letterOfCommandDetailDasar.ID, "LetterOfCommandDetailDasar", letDasar, letterOfCommandDetailDasar, username); auditTransact.CreateAuditTrail("Create", letterOfCommandDetailUntuk.ID, "LetterOfCommandDetailUntuk", letUntuk, letterOfCommandDetailUntuk, username); auditTransact.CreateAuditTrail("Create", letterOfCommandDetailTembusan.ID, "LetterOfCommandDetailTembusan", letTembusan, letterOfCommandDetailTembusan, username); ReviewRelationMaster rrm = new ReviewRelationMaster(); string page = "letter"; rrm.Description = page + letterOfCommand.LetterOfCommandID; db.ReviewRelationMasters.Add(rrm); db.SaveChanges(); TempData["message"] = "Letter Of Command successfully created!"; return(RedirectToAction("Index")); } ViewBag.PreliminaryID = new SelectList(db.Preliminaries, "PreliminaryID", "NomorPreliminarySurvey", letterOfCommand.PreliminaryID); return(View(letterOfCommand)); }