public ActionResult DeleteConfirmed(int id)
{
context.Configuration.ProxyCreationEnabled = false;
string username = User.Identity.Name;
ConsultingLetterOfCommand consultingletterofcommand = context.ConsultingLetterOfCommands.Single(x => x.ConsultingSuratPerintahID == id);
ConsultingLetterOfCommand conletcom = new ConsultingLetterOfCommand();
ConsultingLetterOfCommandDetailDasar conletdas = new ConsultingLetterOfCommandDetailDasar();
ConsultingLetterOfCommandDetailUntuk conletunt = new ConsultingLetterOfCommandDetailUntuk();
ConsultingLetterOfCommandDetailTembusan conlettem = new ConsultingLetterOfCommandDetailTembusan();
context.ConsultingLetterOfCommands.Remove(consultingletterofcommand);
var iduntuk = context.ConsultingLetterOfCommandDetailUntuks.Where(p => p.ConsultingSuratPerintahID.Equals(id)).Select(p => p.ConsultingLetterOfCommandDetailUntukID).FirstOrDefault();
var idtembusan = context.ConsultingLetterOfCommandDetailTembusans.Where(p => p.ConsultingSuratPerintahID.Equals(id)).Select(p => p.ConsultingLetterOfCommandDetailTembusanID).FirstOrDefault();
var iddasar = context.ConsultingLetterOfCommandDetailDasars.Where(p => p.ConsultingSuratPerintahID.Equals(id)).Select(p => p.ConsultingLetterOfCommandDetailDasarID).FirstOrDefault();
var Ldasar = context.ConsultingLetterOfCommandDetailDasars.Find(iddasar);
var Ltembusan = context.ConsultingLetterOfCommandDetailTembusans.Find(idtembusan);
var Luntuk = context.ConsultingLetterOfCommandDetailUntuks.Find(iduntuk);
context.ConsultingLetterOfCommandDetailDasars.Remove(Ldasar);
context.ConsultingLetterOfCommandDetailTembusans.Remove(Ltembusan);
context.ConsultingLetterOfCommandDetailUntuks.Remove(Luntuk);
context.SaveChanges();
auditTransact.CreateAuditTrail("Delete", id, "Consulting Letter Of Command", consultingletterofcommand, conletcom, username);
auditTransact.CreateAuditTrail("Delete", id, "Consulting Letter Of Command Dasar", Ldasar, conletdas, username);
auditTransact.CreateAuditTrail("Delete", id, "Consulting Letter Of Command Untuk", Luntuk, conletunt, username);
auditTransact.CreateAuditTrail("Delete", id, "Consulting Letter Of Command Tembusan", Ltembusan, conlettem, username);
TempData["message"] = "Consulting Letter Of Command successfully deleted!";
return(RedirectToAction("Index"));
}
//
// GET: /ConsultingLetterOfCommandModels/Delete/5
public ActionResult Delete(int id)
{
ConsultingLetterOfCommand consultingletterofcommand = context.ConsultingLetterOfCommands.Single(x => x.ConsultingSuratPerintahID == id);
ViewBag.ActivityName = context.EngagementActivities.Where(p => p.Name.Equals(consultingletterofcommand.EngagementName)).Select(p => p.ActivityStr).FirstOrDefault();
ViewBag.Dasar = context.ConsultingLetterOfCommandDetailDasars.Where(p => p.ConsultingSuratPerintahID.Equals(consultingletterofcommand.ConsultingSuratPerintahID)).Select(p => p.Dasar).FirstOrDefault();
ViewBag.Untuk = context.ConsultingLetterOfCommandDetailUntuks.Where(p => p.ConsultingSuratPerintahID.Equals(consultingletterofcommand.ConsultingSuratPerintahID)).Select(p => p.Untuk).FirstOrDefault();
ViewBag.Tembusan = context.ConsultingLetterOfCommandDetailTembusans.Where(p => p.ConsultingSuratPerintahID.Equals(consultingletterofcommand.ConsultingSuratPerintahID)).Select(p => p.Tembusan).FirstOrDefault();
ViewBag.member = consultingletterofcommand.MemberID;
return(View(consultingletterofcommand));
}
private bool sentSingleEmailCSP(string userToSentEmail, ConsultingLetterOfCommand letter)
{
string baseUrl = Request.Url.GetLeftPart(UriPartial.Authority);
Employee emp = context.Employees.Where(p => p.Name.Equals(userToSentEmail)).FirstOrDefault();
if (emp != null)
{
string emailContent = "Dear {0}, <BR/><BR/>Consulting Letter of Command : {1} need your approval. Please click on this <a href=\"{2}\" title=\"Consulting Letter of Command\">link</a> to show the Consulting Letter of Command.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team";
string url = baseUrl + "/ConsultingLetterOfCommands/Details/" + letter.ConsultingSuratPerintahID;
emailTransact.SentEmailApproval(emp.Email, emp.Name, letter.NomorSP, emailContent, url);
}
return(true);
}
public async Task <ActionResult> Preview(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ConsultingLetterOfCommand consultingLetterOfCommand = await context.ConsultingLetterOfCommands.FindAsync(id);
string letterOfCommandDetailDasar = context.ConsultingLetterOfCommandDetailDasars.Find(id).Dasar;
string letterOfCommandDetailTembusan = context.ConsultingLetterOfCommandDetailTembusans.Find(id).Tembusan;
string letterOfCommandDetailUntuk = context.ConsultingLetterOfCommandDetailUntuks.Find(id).Untuk;
ViewBag.Dasar = letterOfCommandDetailDasar;
ViewBag.Untuk = letterOfCommandDetailUntuk;
ViewBag.Tembusan = letterOfCommandDetailTembusan;
ViewBag.MemberName = consultingLetterOfCommand.MemberID;
ViewBag.SupervisorName = consultingLetterOfCommand.SupervisorID;
ViewBag.TeamLeaderName = consultingLetterOfCommand.TeamLeaderID;
ViewBag.PICIDName = consultingLetterOfCommand.PicID;
List <ConsultingLetterOfCommandDetailUntuk> untukList = new List <ConsultingLetterOfCommandDetailUntuk>();
List <ConsultingLetterOfCommandDetailUntuk> Untuks = new List <ConsultingLetterOfCommandDetailUntuk>();
List <ConsultingLetterOfCommandDetailTembusan> tembusanList = new List <ConsultingLetterOfCommandDetailTembusan>();
List <ConsultingLetterOfCommandDetailTembusan> Tembusans = new List <ConsultingLetterOfCommandDetailTembusan>();
Untuks = context.ConsultingLetterOfCommandDetailUntuks.Where(p => p.ConsultingSuratPerintahID.Equals(consultingLetterOfCommand.ConsultingSuratPerintahID)).ToList();
foreach (var u in Untuks)
{
untukList.Add(u);
}
Tembusans = context.ConsultingLetterOfCommandDetailTembusans.Where(p => p.ConsultingSuratPerintahID.Equals(consultingLetterOfCommand.ConsultingSuratPerintahID)).ToList();
foreach (var u in Tembusans)
{
tembusanList.Add(u);
}
if (consultingLetterOfCommand == null)
{
return(HttpNotFound());
}
ViewBag.Untuks = untukList;
ViewBag.Tembusans = tembusanList;
ViewBag.WordDocumentFilename = "SuratPerintah";
return(View(consultingLetterOfCommand));
}
private bool sentEmailCSP(ConsultingLetterOfCommand letter, string 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 = context.Employees.Where(p => p.Email.Equals(CIAUser.Email)).FirstOrDefault();
if (emp != null)
{
string emailContent = "Dear {0}, <BR/><BR/>Consulting Letter of Command : {1} need your approval. Please click on this <a href=\"{2}\" title=\"Consulting Letter of Command\">link</a> to show the Consulting Letter of Command.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team";
string url = baseUrl + "/LetterOfCommands/Details/" + letter.ConsultingSuratPerintahID;
emailTransact.SentEmailApproval(emp.Email, emp.Name, letter.NomorSP, emailContent, url);
}
}
}
return(true);
}
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 UpdateStatus(int id, string submit)
{
if (ModelState.IsValid)
{
string username = User.Identity.Name;
context.Configuration.ProxyCreationEnabled = false;
var letter = context.ConsultingLetterOfCommands.Find(id);
string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty;
if (submit == "Save")
{
letter.Status = "Draft";
}
else if (submit == "Send Back")
{
letter.Status = HelperController.GetStatusSendback(context, "Consulting Surat Perintah", letter.Status);
}
else if (submit == "Approve")
{
letter.Status = "Approve";
ConsultingFieldWork cFw = new ConsultingFieldWork();
cFw.ConsultingSuratPerintahID = id;
cFw.Status = "Draft";
context.ConsultingFieldWork.Add(cFw);
}
else if (submit == "Submit For Review By" + user)
{
letter.Status = "Pending for Review by" + user;
}
else if (submit == "Submit For Approve By" + user)
{
letter.Status = "Pending for Approve by" + user;
string userToSentEmail = String.Empty;
if (user.Trim() == "CIA")
{
userToSentEmail = letter.PicID;
if (userToSentEmail != null)
{
sentSingleEmailCSP(userToSentEmail, letter);
}
else
{
sentEmailCSP(letter, user.Trim());
}
}
else if (user.Trim() == "Pengawas")
{
userToSentEmail = letter.SupervisorID;
if (userToSentEmail != null)
{
sentSingleEmailCSP(userToSentEmail, letter);
}
else
{
sentEmailCSP(letter, user.Trim());
}
}
else if (user.Trim() == "Ketua Tim")
{
userToSentEmail = letter.TeamLeaderID;
if (userToSentEmail != null)
{
sentSingleEmailCSP(userToSentEmail, letter);
}
else
{
sentEmailCSP(letter, user.Trim());
}
}
else if (user.Trim() == "Member")
{
userToSentEmail = letter.MemberID;
if (userToSentEmail != null)
{
sentSingleEmailCSP(userToSentEmail, letter);
}
else
{
sentEmailCSP(letter, user.Trim());
}
}
}
ConsultingLetterOfCommand oldData = context.ConsultingLetterOfCommands.AsNoTracking().Where(p => p.ConsultingSuratPerintahID.Equals(letter.ConsultingSuratPerintahID)).FirstOrDefault();
auditTransact.CreateAuditTrail("Update", letter.ConsultingSuratPerintahID, "Consulting Letter Of Command", oldData, letter, username);
context.Entry(letter).State = EntityState.Modified;
context.SaveChanges();
TempData["message"] = "Consulting Letter Of Command successfully updated!";
return(RedirectToAction("Index"));
}
TempData["message"] = "Consulting Letter Of Command successfully updated!";
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ConsultingSuratPerintahID,NomorSP,ConsultingRequestID,EngagementName,Status,StartDate,EndDate,PicID,SupervisorID,TeamLeaderID,Menimbang,Penutup,MemberID,Remarks,EngagementID")]
ConsultingLetterOfCommand consultingletterofcommand, string ConsultingRequest, string enggname, string submit, string ActivityName, string[] member, string[] Dasar, string[] Untuk, string[] Tembusan)
{
if (ModelState.IsValid)
{
string username = User.Identity.Name;
context.Configuration.ProxyCreationEnabled = false;
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;
if (member != null)
{
foreach (var mb in member)
{
consultingletterofcommand.MemberID += mb + ";";
}
}
else
{
consultingletterofcommand.MemberID += ";";
}
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;
}
ConsultingLetterOfCommand oldData = context.ConsultingLetterOfCommands.AsNoTracking().Where(p => p.ConsultingSuratPerintahID.Equals(consultingletterofcommand.ConsultingSuratPerintahID)).FirstOrDefault();
auditTransact.CreateAuditTrail("Update", consultingletterofcommand.ConsultingSuratPerintahID, "Consulting Letter Of Command", oldData, consultingletterofcommand, username);
context.Entry(consultingletterofcommand).State = EntityState.Modified;
context.SaveChanges();
ConsultingLetterOfCommandDetailDasar ConsultingletterOfCommandDetailDasar = context.ConsultingLetterOfCommandDetailDasars.Where(p => p.ConsultingSuratPerintahID == consultingletterofcommand.ConsultingSuratPerintahID).FirstOrDefault();
ConsultingletterOfCommandDetailDasar.Dasar = null;
if (Dasar != null)
{
foreach (var ab in Dasar)
{
ConsultingletterOfCommandDetailDasar.Dasar += ab + ";";
}
}
else
{
ConsultingletterOfCommandDetailDasar.Dasar = ";";
}
ConsultingLetterOfCommandDetailUntuk ConsultingletterOfCommandDetailUntuk = context.ConsultingLetterOfCommandDetailUntuks.Where(p => p.ConsultingSuratPerintahID == consultingletterofcommand.ConsultingSuratPerintahID).FirstOrDefault();
ConsultingletterOfCommandDetailUntuk.Untuk = null;
if (Untuk != null)
{
foreach (var cd in Untuk)
{
ConsultingletterOfCommandDetailUntuk.Untuk += cd + ";";
}
}
else
{
ConsultingletterOfCommandDetailUntuk.Untuk = ";";
}
ConsultingLetterOfCommandDetailTembusan ConsultingletterOfCommandDetailTembusan = context.ConsultingLetterOfCommandDetailTembusans.Where(p => p.ConsultingSuratPerintahID == consultingletterofcommand.ConsultingSuratPerintahID).FirstOrDefault();
ConsultingletterOfCommandDetailTembusan.Tembusan = null;
if (Tembusan != null)
{
foreach (var ef in Tembusan)
{
ConsultingletterOfCommandDetailTembusan.Tembusan += ef + ";";
}
}
else
{
ConsultingletterOfCommandDetailTembusan.Tembusan = ";";
}
var eng = context.EngagementActivities.Find(consultingletterofcommand.EngagementID);
eng.Name = consultingletterofcommand.EngagementName;
eng.PICID = consultingletterofcommand.PicID;
eng.TeamLeaderID = consultingletterofcommand.TeamLeaderID;
eng.SupervisorID = consultingletterofcommand.SupervisorID;
eng.MemberID = consultingletterofcommand.MemberID;
ConsultingLetterOfCommandDetailDasar oldDataDasar = context.ConsultingLetterOfCommandDetailDasars.AsNoTracking().Where(p => p.ConsultingLetterOfCommandDetailDasarID.Equals(ConsultingletterOfCommandDetailDasar.ConsultingLetterOfCommandDetailDasarID)).FirstOrDefault();
ConsultingLetterOfCommandDetailUntuk oldDataUntuk = context.ConsultingLetterOfCommandDetailUntuks.AsNoTracking().Where(p => p.ConsultingLetterOfCommandDetailUntukID.Equals(ConsultingletterOfCommandDetailUntuk.ConsultingLetterOfCommandDetailUntukID)).FirstOrDefault();
ConsultingLetterOfCommandDetailTembusan oldDataTembusan = context.ConsultingLetterOfCommandDetailTembusans.AsNoTracking().Where(p => p.ConsultingLetterOfCommandDetailTembusanID.Equals(ConsultingletterOfCommandDetailTembusan.ConsultingLetterOfCommandDetailTembusanID)).FirstOrDefault();
auditTransact.CreateAuditTrail("Update", ConsultingletterOfCommandDetailDasar.ConsultingLetterOfCommandDetailDasarID, "Consulting Letter Of Command Dasar", oldDataDasar, ConsultingletterOfCommandDetailDasar, username);
auditTransact.CreateAuditTrail("Update", ConsultingletterOfCommandDetailUntuk.ConsultingLetterOfCommandDetailUntukID, "Consulting Letter Of Command Untuk", oldDataUntuk, ConsultingletterOfCommandDetailUntuk, username);
auditTransact.CreateAuditTrail("Update", ConsultingletterOfCommandDetailTembusan.ConsultingLetterOfCommandDetailTembusanID, "Consulting Letter Of Command Tembusan", oldDataTembusan, ConsultingletterOfCommandDetailTembusan, username);
context.Entry(ConsultingletterOfCommandDetailDasar).State = EntityState.Modified;
context.Entry(ConsultingletterOfCommandDetailUntuk).State = EntityState.Modified;
context.Entry(ConsultingletterOfCommandDetailTembusan).State = EntityState.Modified;
context.Entry(eng).State = EntityState.Modified;
context.SaveChanges();
TempData["message"] = "Consulting Letter Of Command successfully updated!";
return(RedirectToAction("Index"));
}
return(View(consultingletterofcommand));
}
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);
}
