private TGLPreSanctionVM CreateTGLPreSanctionVM(TGLPreSanction model)
{
return(new TGLPreSanctionVM
{
PreSanctionID = model.PreSanctionID,
KYCID = model.KYCID,
LoanType = model.LoanType,
LoanPurposeID = model.LoanPurposeID,
Comments = model.Comments,
CreatedBy = model.CreatedBy,
LTV = model.LTV,
ProductID = model.ProductID,
ReqLoanAmount = model.ReqLoanAmount,
RMID = model.RMID,
ROI = model.ROI,
SchemeID = model.SchemeID,
Tenure = model.Tenure,
ResidenceVerification = model.ResidenceVerification,
CustomerID = model.TGLKYC_BasicDetails.CustomerID,
ApplicationNo = model.TGLKYC_BasicDetails.ApplicationNo,
AppliedDate = model.TGLKYC_BasicDetails.AppliedDate.ToString("dd/MM/yyyy"),
TransactionID = model.TransactionID,
ApproverComment = model.ApproverComments,
DeviationApprove = model.Status
});
}
public TGLPreSanction UpdatePreSanction(TGLPreSanction model, out Dictionary <string, string> errors)
{
errors = new Dictionary <string, string>();
var dbRecord = _context.TGLPreSanctions.Where(ps => ps.PreSanctionID == model.PreSanctionID).FirstOrDefault();
if (dbRecord == null)
{
errors.Add("NoRecordFound", "No Record Found.");
return(new TGLPreSanction());
}
ValidateRecord(model, errors);
if (errors.Count > 0)
{
return(new TGLPreSanction());
}
UpdatePreSanction(dbRecord, model);
try
{
_context.SaveChanges();
}
catch (Exception ex)
{
errors.Add("PreSanctionError", "Error updating record.");
}
return(dbRecord);
}
private void ValidateRecord(TGLPreSanction model, Dictionary <string, string> errors)
{
if (_context.TGLSanctionDisburse_BasicDetails.Any(sd => sd.KYCID == model.KYCID))
{
errors.Add("InUse", "Record can not be updated,since it is in use.");
}
}
public TGLPreSanction AddPreSanction(TGLPreSanction model, out Dictionary <string, string> errors)
{
errors = new Dictionary <string, string>();
var dbRecord = _context.TGLPreSanctions.Add(model);
try
{
_context.SaveChanges();
}
catch (Exception ex)
{
errors.Add("PreSanctionError", "Error adding record.");
}
return(dbRecord);
}
private void UpdatePreSanction(TGLPreSanction dbRecord, TGLPreSanction model)
{
dbRecord.Comments = model.Comments;
dbRecord.KYCID = model.KYCID;
dbRecord.LastUpdatedBy = model.CreatedBy;
dbRecord.LastUpdatedDate = DateTime.Now;
dbRecord.LoanPurposeID = model.LoanPurposeID;
dbRecord.LoanType = model.LoanType;
dbRecord.LTV = model.LTV;
dbRecord.ProductID = model.ProductID;
dbRecord.RMID = model.RMID;
dbRecord.ROI = model.ROI;
dbRecord.SchemeID = model.SchemeID;
dbRecord.Tenure = model.Tenure;
dbRecord.TransactionID = model.TransactionID;
dbRecord.ReqLoanAmount = model.ReqLoanAmount;
dbRecord.ResidenceVerification = model.ResidenceVerification;
}
public TGLPreSanction UpdatePreSanctionApprove(TGLPreSanction model, out Dictionary <string, string> errors)
{
errors = new Dictionary <string, string>();
var dbRecord = _context.TGLPreSanctions.Where(ps => ps.PreSanctionID == model.PreSanctionID).FirstOrDefault();
if (dbRecord == null)
{
errors.Add("NoRecordFound", "No Record Found.");
return(new TGLPreSanction());
}
var messageRecords = _context.MessageActionUsers.Where(mes => mes.MessageActionID == dbRecord.MessageActionID).ToList();
if (messageRecords.Count <= 0)
{
errors.Add("NoRecordFound", "No Record Found.");
return(new TGLPreSanction());
}
messageRecords.ForEach(e => e.IsRead = true);
dbRecord.ApproverComments = model.ApproverComments;
dbRecord.Status = model.Status;
dbRecord.LastUpdatedDate = DateTime.Now;
try
{
_context.SaveChanges();
}
catch (Exception ex)
{
errors.Add("PreSanctionError", "Error updating record.");
}
return(dbRecord);
}
