public EXP_BankLoan SetToBankLoanModelObject(EXPBankLoan model, int _userid)//int _userid
{
EXP_BankLoan entity = new EXP_BankLoan();
//entity.BankLoanID = model.BankLoanID;
entity.BankLoanNo = model.BankLoanNo;
//entity.BankID = model.BankID;
//entity.BranchID = model.BranchID;
entity.LoanHead = model.LoanHead;
entity.RefACNo = model.RefACNo;
entity.RefACName = model.RefACName;
var GridloanRecieveDate = model.LoanReceiveDate.Contains("/") ? model.LoanReceiveDate : Convert.ToDateTime(model.LoanReceiveDate).ToString("dd/MM/yyyy");
entity.LoanReceiveDate = DalCommon.SetDate(GridloanRecieveDate);
entity.LoanAmt = model.LoanAmt;
entity.InterestPercent = model.InterestPercent;
entity.LoanLimit = model.LoanLimit;
entity.ReturnedAmt = model.ReturnedAmt;
entity.BalanceAmt = model.BalanceAmt;
entity.CIID = model.CIID;
entity.Remarks = model.Remarks;
entity.RecordStatus = "NCF";
entity.RunningStatus = "RNG";
entity.SetOn = DateTime.Now;
entity.SetBy = _userid;
entity.IPAddress = GetIPAddress.LocalIPAddress();
return(entity);
}
public ValidationMsg Save(EXPBankLoan model, int _userid, string pageUrl)//, string pageUrl
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
if (model.expBankLoanList.Count > 0)
{
foreach (var bankLoan in model.expBankLoanList)
{
EXP_BankLoan tblBankLoan = SetToBankLoanModelObject(bankLoan, _userid);
tblBankLoan.BankID = model.BankID;
tblBankLoan.BranchID = model.BranchID;
tblBankLoan.ApprovalNote = model.ApprovalNote;
_context.EXP_BankLoan.Add(tblBankLoan);
_context.SaveChanges();
}
}
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
}
}
catch (DbEntityValidationException e)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Save.";
}
return(_vmMsg);
}
public ActionResult SaveAndUpdate(EXPBankLoan model)
{
objValMssg = model.expBankLoanList[0].BankLoanID == 0 ? objDalEXPBankLoan.Save(model, Convert.ToInt32(Session["UserID"]), "EXPBankLoan/EXPBankLoan") :
objDalEXPBankLoan.Update(model, Convert.ToInt32(Session["UserID"]));
return(Json(new { msg = objValMssg }));
}
public ValidationMsg Update(EXPBankLoan model, int _userid)
{
_vmMsg = new ValidationMsg();
try
{
#region Update
using (var tx = new TransactionScope())
{
using (_context)
{
#region Save NEW Data & Update Existing Crust Leather Transfer Data
if (model.expBankLoanList != null)
{
foreach (EXPBankLoan bankLoan in model.expBankLoanList)
{
bankLoan.BankID = model.BankID;
bankLoan.BranchID = model.BranchID;
bankLoan.ApprovalNote = model.ApprovalNote;
if (bankLoan.BankLoanID == 0)
{
EXP_BankLoan tblBankLoan = SetToBankLoanModelObject(bankLoan, _userid);
tblBankLoan.BankID = bankLoan.BankID;
tblBankLoan.BranchID = bankLoan.BranchID;
tblBankLoan.ApprovalNote = bankLoan.ApprovalNote;
_context.EXP_BankLoan.Add(tblBankLoan);
}
else
{
EXP_BankLoan bankLoanEntity = SetToBankLoanModelObject(bankLoan, _userid);
model.BankID = bankLoanEntity.BankID;
model.BranchID = bankLoanEntity.BranchID;
model.ApprovalNote = bankLoanEntity.ApprovalNote;
var obBankLoan = _context.EXP_BankLoan.First(m => m.BankLoanID == bankLoan.BankLoanID);
//obBankLoan.BankLoanID = model.BankLoanID;
obBankLoan.BankLoanNo = bankLoanEntity.BankLoanNo;
obBankLoan.CIID = bankLoanEntity.CIID;
obBankLoan.LoanHead = bankLoanEntity.LoanHead;
obBankLoan.RefACNo = bankLoanEntity.RefACNo;
obBankLoan.RefACName = bankLoanEntity.RefACName;
//var GridloanRecieveDate = bankLoanEntity.LoanReceiveDate.Contains("/") ? bankLoanEntity.LoanReceiveDate : Convert.ToDateTime(bankLoanEntity.LoanReceiveDate).ToString("dd/MM/yyyy");
//obBankLoan.LoanReceiveDate = DalCommon.SetDate(GridloanRecieveDate);
obBankLoan.LoanAmt = bankLoanEntity.LoanAmt;
obBankLoan.InterestPercent = bankLoanEntity.InterestPercent;
obBankLoan.LoanLimit = bankLoanEntity.LoanLimit;
obBankLoan.ReturnedAmt = bankLoanEntity.ReturnedAmt;
obBankLoan.BalanceAmt = bankLoanEntity.BalanceAmt;
obBankLoan.Remarks = bankLoanEntity.Remarks;
obBankLoan.RunningStatus = bankLoanEntity.RunningStatus;
obBankLoan.RecordStatus = "NCF";
obBankLoan.ModifiedOn = DateTime.Now;
obBankLoan.ModifiedBy = _userid;
obBankLoan.IPAddress = GetIPAddress.LocalIPAddress();
}
}
}
#endregion
_context.SaveChanges();
tx.Complete();
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
}
#endregion
}
catch (DbEntityValidationException e)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Update.";
}
return(_vmMsg);
}
