public BankLoanDto GetBankLoanApplicationDetailsById(int bankLoanId)
{
BankLoanDto objLoanApplication = new BankLoanDto();
AdoHelper objAdo = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@BankLoanId", bankLoanId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader dr = objAdo.ExecDataReaderProc("uspBankLoanApplicationGetByBankLoanID", parms);
if (dr.Read())
{
objLoanApplication.BankLoanId = Convert.ToInt32(dr["BankLoanId"]);
objLoanApplication.GroupId = Convert.ToInt32(dr["GroupId"]);
objLoanApplication.LoanRequestDate = Convert.ToDateTime(dr["RequestDate"]);
objLoanApplication.LoanAmountRequested = Convert.ToInt32(dr["RequestedAmount"]);
objLoanApplication.NoofInstallments = Convert.ToByte(dr["NoOfInStallments"]);
objLoanApplication.LoanAmountApproved = Convert.ToDecimal(dr["ApprovedAmount"]);
objLoanApplication.LoanAmountApprovedDate = Convert.ToDateTime(dr["ApprovedDate"]);
objLoanApplication.DisbursedAmount = Convert.ToDecimal(dr["DisbursementAmount"]);
objLoanApplication.DisbursedDate = Convert.ToDateTime(dr["DisbursementDate"]);
objLoanApplication.InterestRate = Convert.ToInt32(dr["InterestRate"]);
objLoanApplication.BankEntryId = Convert.ToInt32(dr["BankEntryId"]);
objLoanApplication.SLAHId = Convert.ToInt32(dr["SLAHID"]);
objLoanApplication.ReferenceNumber = Convert.ToString(dr["ReferenceNumber"]);
objLoanApplication.DueDate = Convert.ToDateTime(dr["DueDate"]);
objLoanApplication.Status = Convert.ToString(dr["Status"]);
objLoanApplication.LoanNumber = Convert.ToString(dr["LinkageNumber"]);
objLoanApplication.Narration = Convert.ToString(dr["Narration"]);
objLoanApplication.EMI = Convert.ToInt32(dr["EMI"]);
}
return(objLoanApplication);
}
public ActionResult CreateBankLoan(BankLoanDto objLoan)
{
var resultDto = new ResultDto();
objLoan.GroupId = GroupInfo.GroupID;
objLoan.UserID = UserInfo.UserID;
resultDto = _bankLoanService.InsertUpdateBankLoanApplication(objLoan);
objLoan.LoanCode = resultDto.ObjectCode;
objLoan.BankLoanId = resultDto.ObjectId;
if (objLoan.BankLoanId > 0)
{
//_bankLoanService.SubmitLoanApplicationApproval((BankLoanDto)objLoan, UserInfo.UserID, objLoan.LoanMasterId, true);
objLoan = _bankLoanService.GetBankLoanApplicationDetailsById(objLoan.BankLoanId);
}
TempData["Result"] = resultDto;
LoadDropdowns();
ViewBag.isView = false;
return(View(objLoan));
}
public int SubmitLoanApplicationApproval(BankLoanDto objbankloan, int userId, int loanMasterId, bool isSave)
{
AdoHelper objAdo = new AdoHelper();
SqlParameter[] parms = new SqlParameter[9];
parms[0] = new SqlParameter("@BankLoanId", objbankloan.BankLoanId);
parms[0].SqlDbType = SqlDbType.Int;
parms[1] = new SqlParameter("@UserId", userId);
parms[1].SqlDbType = System.Data.SqlDbType.Int;
parms[8] = new SqlParameter("@isSave", isSave);
parms[8].SqlDbType = System.Data.SqlDbType.Bit;
objAdo.ExecNonQueryProc("uspApproveMemberLoan", parms);
int retVal = Convert.ToInt32(parms[7].Value);
return(retVal);
}
public ActionResult CreateBankLoan(string id)
{
int loanmasterId = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString());
int GroupId = GroupInfo.GroupID;
LoadDropdowns();
bool isView = false;
if (Request.QueryString["isView"] != null)
{
isView = Request.QueryString["isView"] == "1";
}
ViewBag.isView = isView;
BankLoanDto bankLoanDto = new BankLoanDto();
if (loanmasterId > 0)
{
bankLoanDto = _bankLoanService.GetBankLoanApplicationDetailsById(loanmasterId);
}
bankLoanDto.GroupId = GroupId;
return(View(bankLoanDto));
}
public ActionResult ConfirmBankLoanApplication(BankLoanDto objLoan)
{
int count = _bankLoanService.SubmitLoanApplicationApproval((BankLoanDto)objLoan, UserInfo.UserID, objLoan.LoanMasterId);
return(RedirectToAction("MemberLoanApplicationLookup"));
}
public ResultDto InsertUpdateBankLoanApplication(BankLoanDto objbankLoan)
{
BankLoanDataAccess objBankLoandataaccess = new BankLoanDataAccess();
return(objBankLoandataaccess.InsertUpdateBankLoanApplication(objbankLoan));
}
public int SubmitLoanApplicationApproval(BankLoanDto objSubmitLoan, int userId, int loanMasterId, bool isSave = false)
{
BankLoanDataAccess objbankLoan = new BankLoanDataAccess();
return(objbankLoan.SubmitLoanApplicationApproval(objSubmitLoan, userId, loanMasterId, isSave));
}
public ResultDto InsertUpdateBankLoanApplication(BankLoanDto obj)
{
ResultDto resultDto = new ResultDto();
string obectName = "Loan Application";
try
{
AdoHelper objAdo = new AdoHelper();
SqlParameter[] parms = new SqlParameter[20];
parms[0] = new SqlParameter("@BankLoanId", obj.BankLoanId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
parms[0].Direction = ParameterDirection.InputOutput;
parms[1] = new SqlParameter("@GroupId", obj.GroupId);
parms[1].SqlDbType = System.Data.SqlDbType.Int;
parms[2] = new SqlParameter("@BankEntryId", obj.BankEntryId);
parms[2].SqlDbType = System.Data.SqlDbType.Int;
parms[3] = new SqlParameter("@LoanApplicationDate", obj.LoanRequestDate);
parms[3].SqlDbType = System.Data.SqlDbType.Date;
parms[4] = new SqlParameter("@Narration", obj.Narration);
parms[4].SqlDbType = System.Data.SqlDbType.VarChar;
parms[5] = new SqlParameter("@SLAHId", obj.SLAHId);
parms[5].SqlDbType = System.Data.SqlDbType.Int;
parms[6] = new SqlParameter("@LoanAmountApplied", obj.LoanAmountRequested);
parms[6].SqlDbType = System.Data.SqlDbType.BigInt;
parms[7] = new SqlParameter("@NoofInstallmentsProposed", obj.NoofInstallments);
parms[7].SqlDbType = System.Data.SqlDbType.TinyInt;
parms[8] = new SqlParameter("@LoanNumber", obj.LoanNumber);
parms[8].SqlDbType = System.Data.SqlDbType.VarChar;
parms[9] = new SqlParameter("@UserId", obj.UserID);
parms[9].SqlDbType = System.Data.SqlDbType.Int;
parms[10] = new SqlParameter("@InterstRate", obj.InterestRate);
parms[10].SqlDbType = System.Data.SqlDbType.Int;
parms[11] = new SqlParameter("@RefNumber", obj.ReferenceNumber);
parms[11].SqlDbType = System.Data.SqlDbType.VarChar;
parms[12] = new SqlParameter("@LoanAmountApprovedDate", obj.LoanAmountApprovedDate);
parms[12].SqlDbType = System.Data.SqlDbType.DateTime;
parms[13] = new SqlParameter("@LoanAmountApprovedAmount", obj.LoanAmountApproved);
parms[13].SqlDbType = System.Data.SqlDbType.BigInt;
parms[14] = new SqlParameter("@DisbursedDate", obj.DisbursedDate);
parms[14].SqlDbType = System.Data.SqlDbType.DateTime;
parms[15] = new SqlParameter("@DisbursedAmount", obj.DisbursedAmount);
parms[15].SqlDbType = System.Data.SqlDbType.BigInt;
parms[16] = new SqlParameter("@Status", SqlDbType.VarChar, 50);
parms[16].Value = obj.Status;
parms[16].Direction = ParameterDirection.Output;
parms[17] = new SqlParameter("@EMI", SqlDbType.Int);
parms[17].Value = obj.EMI;
parms[18] = new SqlParameter("@DueDate", SqlDbType.Date);
parms[18].Value = obj.DueDate;
parms[19] = new SqlParameter("@GLAHID", SqlDbType.Int);
parms[19].Value = obj.GLAHId;
objAdo.ExecNonQueryProc("uspBankLoanInsertUpdate", parms);
resultDto.ObjectId = Convert.ToInt32(parms[0].Value);
//resultDto.ObjectCode = string.IsNullOrEmpty((string)parms[1].Value) ? obj.LoanCode : (string)parms[1].Value;
obj.Status = (string)parms[16].Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details saved successfully", obectName);
}
else if (resultDto.ObjectId == -1)
{
resultDto.Message = string.Format("Error occured while generating {0} code", obectName);
}
else
{
resultDto.Message = string.Format("Error occured while saving {0} details", obectName);
}
}
catch (Exception ex)
{
resultDto.Message = ex.Message; /*string.Format("Service layer error occured while saving the {0} details", obectName)*/;
resultDto.ObjectId = -98;
}
return(resultDto);
}
