public ActionResult DeleteConfirmed(int id) { ConsultingReporting consultingReporting = db.ConsultingReportings.Find(id); db.ConsultingReportings.Remove(consultingReporting); db.SaveChanges(); TempData["message"] = "Consulting Report successfully deleted!"; return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "ConsultingReportingID,ConsultingSuratPerintahID,ActivityID,NoLaporan,Kepada,Dari,Lampiran,Perihal,Hasil")] ConsultingReporting consultingReporting) { if (ModelState.IsValid) { db.ConsultingReportings.Add(consultingReporting); db.SaveChanges(); TempData["message"] = "Consulting Report successfully created!"; return(RedirectToAction("Index")); } ViewBag.ConsultingSuratPerintahID = new SelectList(db.ConsultingLetterOfCommands, "ConsultingSuratPerintahID", "NomorSP", consultingReporting.ConsultingSuratPerintahID); return(View(consultingReporting)); }
// GET: ConsultingReportings/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ConsultingReporting consultingReporting = db.ConsultingReportings.Find(id); if (consultingReporting == null) { return(HttpNotFound()); } return(View(consultingReporting)); }
public ActionResult Edit([Bind(Include = "ConsultingReportingID,ConsultingSuratPerintahID,ActivityID,NoLaporan,Kepada,Dari,Lampiran,Perihal,Hasil")] ConsultingReporting consultingReporting) { if (ModelState.IsValid) { string username = User.Identity.Name; db.Configuration.ProxyCreationEnabled = false; ConsultingReporting oldData = db.ConsultingReportings.AsNoTracking().Where(p => p.ConsultingReportingID.Equals(consultingReporting.ConsultingReportingID)).FirstOrDefault(); auditTransact.CreateAuditTrail("Update", consultingReporting.ConsultingReportingID, "Consulting Reporting", oldData, consultingReporting, username); db.Entry(consultingReporting).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Consulting Report successfully updated!"; return(RedirectToAction("Index")); } ViewBag.ConsultingSuratPerintahID = new SelectList(db.ConsultingLetterOfCommands, "ConsultingSuratPerintahID", "NomorSP", consultingReporting.ConsultingSuratPerintahID); return(View(consultingReporting)); }
public string getNewNumber(string type) { ePatriaDefault db = new ePatriaDefault(); string result = String.Empty; int length = 4; int no = 1; string newNo = string.Empty; int year = DateTime.Now.Year; bool noExist = false; string formatNo = string.Empty; if (type == "SP") { LetterOfCommand sp = db.LetterOfCommands.OrderByDescending(p => p.LetterOfCommandID).FirstOrDefault(); if (sp != null) { noExist = db.LetterOfCommands.Any(p => p.NomorSP.Contains("/PPN030/Prin/")); if (noExist) { no = Convert.ToInt32(sp.NomorSP.Split('/')[0]) + 1; } } newNo = no.ToString().PadLeft(length, '0'); result = newNo + "/PPN030/Prin/" + year; } else if (type == "Reporting") { Reporting rep = db.Reportings.OrderByDescending(p => p.ReportingID).FirstOrDefault(); if (rep != null) { noExist = db.Reportings.Any(p => p.NomorLaporan.Contains("/PPN030/Lap/")); if (noExist) { no = Convert.ToInt32(rep.NomorLaporan.Split('/')[0]) + 1; } } newNo = no.ToString().PadLeft(length, '0'); result = newNo + "/PPN030/Lap/" + year; } else if (type == "CSP") { ConsultingLetterOfCommand csp = db.ConsultingLetterOfCommands.OrderByDescending(p => p.ConsultingSuratPerintahID).FirstOrDefault(); if (csp != null) { noExist = db.ConsultingLetterOfCommands.Any(p => p.NomorSP.Contains("/PPN030/CPrin/")); if (noExist) { no = Convert.ToInt32(csp.NomorSP.Split('/')[0]) + 1; } } newNo = no.ToString().PadLeft(length, '0'); result = newNo + "/PPN030/CPrin/" + year; } else if (type == "CReporting") { ConsultingReporting crep = db.ConsultingReportings.OrderByDescending(p => p.ConsultingReportingID).FirstOrDefault(); if (crep != null) { noExist = db.ConsultingReportings.Any(p => p.NoLaporan.Contains("/PPN030/CLap/")); if (noExist) { no = Convert.ToInt32(crep.NoLaporan.Split('/')[0]) + 1; } } newNo = no.ToString().PadLeft(length, '0'); result = newNo + "/PPN030/CLap/" + year; } else if (type == "CRequest") { ConsultingRequest creq = db.ConsultingRequests.OrderByDescending(p => p.ConsultingRequestID).FirstOrDefault(); if (creq != null) { noExist = db.ConsultingRequests.Any(p => p.NoRequest.Contains("/PPN030/")); if (noExist) { no = Convert.ToInt32(creq.NoRequest.Split('/')[0]) + 1; } } newNo = no.ToString().PadLeft(length, '0'); result = newNo + "/PPN030/" + year; } return(result); }