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