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