public bool UpdateCC(Model.CompletionCertificate entity) { using (var context = new SCMSEntities()) { ClearSessionData(); context.CompletionCertificates.Attach(entity); ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified); return(context.SaveChanges() > 0); } }
public ActionResult SubmitCC(Guid id) { Model.CompletionCertificate CC = ccService.GetCCById(id); CC.IsRejected = false; CC.IsSubmitted = true; CC.PreparedBy = currentStaff.Id; CC.PreparedOn = DateTime.Now; CC.RefNumber = ccService.GenerateUniquNumber(countryProg); ccService.UpdateCC(CC); notificationService.SendToAppropriateApprover(NotificationHelper.ccCode, NotificationHelper.approvalCode, CC.Id); return(ViewCC()); }
public bool SaveCompletionC(Model.CompletionCertificate entity) { using (var db = new SCMSEntities()) { try { ClearSessionData(); entity.IsRejected = false; db.CompletionCertificates.Add(entity); return((db.SaveChanges() > 0) ? true : false); } catch (Exception ex) { return(false); } } }
private string GetStatus(Model.CompletionCertificate model) { string status; if ((bool)model.IsRejected) { status = Resources.Global_String_StatusRJ; } else if (model.ApprovedBy != null) { status = Resources.Global_String_StatusAP; } else if (model.IsSubmitted) { status = Resources.Global_String_StatusCR; } else { status = Resources.Global_String_StatusNEW; } return(status); }
public string GenerateUniquNumber(CountryProgramme cp) { string code = "CC/DRC/" + cp.Country.ShortName + "/"; string refNumber = ""; long count = 1; using (var dbContext = new SCMSEntities()) { var total = dbContext.CompletionCertificates.Where(p => p.CountryProgrammeId == cp.Id && p.IsSubmitted == true).Count(); count = total; Model.CompletionCertificate m = null; do { count++; if (count < 10000) { if (count < 10) { refNumber = code + "0000" + count; } if (count < 100 & count >= 10) { refNumber = code + "000" + count; } if (count < 1000 & count >= 100) { refNumber = code + "00" + count; } if (count < 10000 & count >= 1000) { refNumber = code + "0" + count; } } m = dbContext.CompletionCertificates.FirstOrDefault(p => p.RefNumber == refNumber); } while (m != null); return(refNumber); } }