public string SaveIpFeedbackForm(IpFeedback ipFeedback)
{
int newFormNumber = 1;
IQueryable <SerialNumbertrackerRA> queryableSerialNumberTrackerRAData = this.unitOfWork.DbContext.SerialNumbertrackerRA
.Where(x => x.UserCode == ipFeedback.CreatedBy && x.FormType == "IPF");
if (queryableSerialNumberTrackerRAData.Any())
{
newFormNumber = queryableSerialNumberTrackerRAData.Max(y => y.SerialValue) + 1;;
}
string padding = "000";
string serialNumberComponent = padding.Remove(padding.Length - newFormNumber.ToString().Length) + (newFormNumber).ToString();
ipFeedback.IpFeedbackNumber = "IPF-" + ipFeedback.CreatedBy + "-" + serialNumberComponent;
/*Form entry*/
IpFeedback IpFeedbackObj = this.unitOfWork.DbContext.ipFeedback.Add(ipFeedback);
/*Serial Number updation*/
SerialNumbertrackerRA serialNumbertrackerRAObj = new SerialNumbertrackerRA
{
FormType = "IPF",
UserCode = ipFeedback.CreatedBy,
SerialValue = newFormNumber,
GeneratedDate = DateTime.UtcNow.AddHours(5.5)
};
serialNumbertrackerRAObj = this.unitOfWork.DbContext.SerialNumbertrackerRA.Add(serialNumbertrackerRAObj);
this.unitOfWork.DbContext.SaveChanges();
return(IpFeedbackObj.IpFeedbackNumber);
}
public string SaveProgrammePlanningForm(ProgrammePlanning programmePlanningForm)
{
int newFormNumber = 1;
IQueryable <SerialNumbertrackerRA> queryableSerialNumberTrackerRAData = this.unitOfWork.DbContext.SerialNumbertrackerRA
.Where(x => x.UserCode == programmePlanningForm.CreatedBy && x.FormType == "PL");
if (queryableSerialNumberTrackerRAData.Any())
{
newFormNumber = queryableSerialNumberTrackerRAData.Max(y => y.SerialValue) + 1;
}
string padding = "000";
string serialNumberComponent = padding.Remove(padding.Length - newFormNumber.ToString().Length) + (newFormNumber).ToString();
programmePlanningForm.PlanningNumber = "PL-" + programmePlanningForm.CreatedBy + "-" + serialNumberComponent;
/*Form entry */
ProgrammePlanning planningObj = this.unitOfWork.DbContext.ProgrammePlanning.Add(programmePlanningForm);
/*Serial Number updation*/
SerialNumbertrackerRA serialNumbertrackerRAObj = new SerialNumbertrackerRA
{
FormType = "PL",
UserCode = programmePlanningForm.CreatedBy,
SerialValue = newFormNumber,
GeneratedDate = DateTime.UtcNow.AddHours(5.5)
};
serialNumbertrackerRAObj = this.unitOfWork.DbContext.SerialNumbertrackerRA.Add(serialNumbertrackerRAObj);
this.unitOfWork.DbContext.SaveChanges();
return(planningObj.PlanningNumber);
}
public string SaveRakshakMonthlyReportForm(RakshakMonthlyReport rakshakMonthlyReportForm)
{
int newFormNumber = 1;
IQueryable <SerialNumbertrackerRA> queryableSerialNumberTrackerRAData = this.unitOfWork.DbContext.SerialNumbertrackerRA
.Where(x => x.UserCode == rakshakMonthlyReportForm.CreatedBy && x.FormType == "RM");
if (queryableSerialNumberTrackerRAData.Any())
{
newFormNumber = queryableSerialNumberTrackerRAData.Max(y => y.SerialValue) + 1;;
}
string padding = "000";
string serialNumberComponent = padding.Remove(padding.Length - newFormNumber.ToString().Length) + (newFormNumber).ToString();
rakshakMonthlyReportForm.RakshakMonthlyReportNumber = "RM-" + rakshakMonthlyReportForm.CreatedBy + "-" + serialNumberComponent;
/*Form entry*/
RakshakMonthlyReport RakshakMontlyReportObj = this.unitOfWork.DbContext.RakshakMonthlyReport.Add(rakshakMonthlyReportForm);
/*Serial Number updation*/
SerialNumbertrackerRA serialNumbertrackerRAObj = new SerialNumbertrackerRA
{
FormType = "RM",
UserCode = rakshakMonthlyReportForm.CreatedBy,
SerialValue = newFormNumber,
GeneratedDate = DateTime.UtcNow.AddHours(5.5)
};
serialNumbertrackerRAObj = this.unitOfWork.DbContext.SerialNumbertrackerRA.Add(serialNumbertrackerRAObj);
this.unitOfWork.DbContext.SaveChanges();
return(RakshakMontlyReportObj.RakshakMonthlyReportNumber);
}
