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