public ActionResult Disbursement(int id) { char type = 'G'; GroupLoanDisbursementDto groupLoanDisbursementDto = GetLoanDisbursementDto(id, type); LoadLoanInterestDropDowns(); List <SelectListDto> fundSourceSelectList = _fundSourceService.GetFundSourceSelectList(); SelectList SlstfoundSource = new SelectList(fundSourceSelectList, "ID", "Text"); ViewBag.foundSource = SlstfoundSource; List <SelectListDto> projectSelectList = _projectService.GetProjectSelectList(); SelectList slProjectList = new SelectList(projectSelectList, "ID", "Text"); ViewBag.projects = slProjectList; BankMasterViewDto objBank = new BankMasterViewDto(); List <BankMasterViewDto> lstFedBanks = _groupReceiptService.GetFederationBanks(); SelectList lstFederationBanks = new SelectList(lstFedBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID); ViewBag.federationbanks = lstFederationBanks; TypeQueryResult lstBankAh = _masterService.GetTypeQueryResult("GROUP_OR_BANK_AH", groupLoanDisbursementDto.GroupID.ToString()); ViewBag.slBankAh = new SelectList(lstBankAh.OrderBy(a => a.Name), "Id", "Name"); return(View(groupLoanDisbursementDto)); }
public ActionResult CreateGroupLoanDisbursement(string Id) { int ID = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt32(Id.DecryptString()); char LoanType = 'G'; var groupLoanDisbursementDto = new GroupLoanDisbursementDto(); if (ID > 0) { Disbursement(ID); groupLoanDisbursementDto = GetLoanDisbursementDto(ID, LoanType); //Set interst ahnames while edit aftersaving, these are empty for 1st time if (groupLoanDisbursementDto.InterestMasterID > 0) { InterestMasterDto objInterestMasterDto = GetInterestDetailsDto(groupLoanDisbursementDto.InterestMasterID); groupLoanDisbursementDto.PrincipleAHName = objInterestMasterDto.AHName; groupLoanDisbursementDto.InterestAHName = objInterestMasterDto.InterestAHName; groupLoanDisbursementDto.PrincipleAHId = Convert.ToInt32(objInterestMasterDto.PrincipalAHID); groupLoanDisbursementDto.InterestRateID = objInterestMasterDto.InterestRateID; } List <SelectListDto> memberselectlist = _memberService.GetMemberCodeByGroupId(groupLoanDisbursementDto.GroupID); SelectList lstmembernames = new SelectList(memberselectlist, "id", "text"); ViewBag.membercodes = lstmembernames; TypeQueryResult lstBankAh = _masterService.GetTypeQueryResult("GROUP_OR_BANK_AH", groupLoanDisbursementDto.GroupID.ToString()); ViewBag.slBankAh = new SelectList(lstBankAh.OrderBy(a => a.Name), "Id", "Name"); } return(View(groupLoanDisbursementDto)); }
public ResultDto InsertDisbursement(GroupLoanDisbursementDto obj, int CurrentUserID) { ResultDto objResult = new ResultDto(); objResult = _LoanDisbursementDataAccess.InsertDisbursemnet(obj, CurrentUserID); return(objResult); }
public GroupLoanDisbursementDto GetByID(int id) { List <uspFederationLoanDisbursement_Result> lstuspFederationLoanDisbursement_Result = _dbContext.uspFederationLoanDisbursement(id).ToList(); GroupLoanDisbursementDto groupLoanDisbursementDto = Mapper.Map <uspFederationLoanDisbursement_Result, GroupLoanDisbursementDto>(lstuspFederationLoanDisbursement_Result.FirstOrDefault()); return(groupLoanDisbursementDto); }
public ActionResult CreateMemberLoanDisbursement(string Id) { int ID = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt32(Id.DecryptString()); char LoanType = 'M'; var groupLoanDisbursementDto = new GroupLoanDisbursementDto(); if (ID > 0) { LoadLoanInterestDropDowns(); groupLoanDisbursementDto = GetLoanDisbursementDto(ID, LoanType); if (groupLoanDisbursementDto.InterestMasterID > 0) { InterestMasterDto objInterestMasterDto = GetInterestDetailsDto(groupLoanDisbursementDto.InterestMasterID); groupLoanDisbursementDto.PrincipleAHName = objInterestMasterDto.PrincipalAHName; groupLoanDisbursementDto.InterestAHName = objInterestMasterDto.InterestName; groupLoanDisbursementDto.PrincipleAHId = Convert.ToInt32(objInterestMasterDto.PrincipalAHID); groupLoanDisbursementDto.InterestRateID = objInterestMasterDto.InterestRateID; groupLoanDisbursementDto.ROI = objInterestMasterDto.InterestRate; } List <SelectListDto> memberselectlist = _memberService.GetMemberCodeByGroupId(groupLoanDisbursementDto.GroupID); SelectList lstmembernames = new SelectList(memberselectlist, "id", "text"); ViewBag.membercodes = lstmembernames; } List <GroupMeetingDto> lstGroupMeetings = new GroupOtherReceiptService().GetGroupOpenMeetingDates(GroupInfo.GroupID); ViewBag.MonthMeetings = new SelectList(lstGroupMeetings, "DisplayMeetingDate", "DisplayMeetingDate"); TypeQueryResult lstBankAh = _masterService.GetTypeQueryResult("GROUP_OR_BANK_AH", GroupInfo.GroupID.ToString()); ViewBag.slBankAh = new SelectList(lstBankAh.OrderBy(a => a.Name), "Id", "Name"); return(View(groupLoanDisbursementDto)); }
public ResultDto InsertDisbursement(GroupLoanDisbursementDto obj, int CurrentUserID) { ResultDto objResult = new ResultDto(); //objResult = _MemberLoanDisbursementDataAccess.InsertDisbursemnet(obj, CurrentUserID); //ADDED NEW METHOD IN LOAN APPLICATION SERVICE SaveMemberLoanDisbursementDetails return(objResult); }
public ActionResult CreateDisbursement(FormCollection form) { GroupLoanDisbursementDto obj = new GroupLoanDisbursementDto(); obj.GroupInterstRateID = string.IsNullOrEmpty(form["hdninterestRateId"]) ? 0 : Convert.ToInt32(form["hdninterestRateId"]); obj.LoanMasterId = Convert.ToInt32(form["LoanMasterId"]); obj.DisbursedAmount = Convert.ToDecimal(form["txtDisBursedAmount"]); obj.NoOfInstallments = Convert.ToByte(form["noOfInstalments"]); obj.DisbursementDate = Convert.ToDateTime(form["txtDisbursementDate"]); obj.InstallmentStartFrom = Convert.ToDateTime(form["txtFirstInstallmentStartsFrom"]); obj.LoanClosingDate = Convert.ToDateTime(form["txtLastInstallmentDate"]); obj.InterestMasterID = string.IsNullOrEmpty(form["InterestMasterID"]) ? 0 : Convert.ToInt32(form["InterestMasterID"]); obj.InterestRateID = Convert.ToInt32(form["InterestRateID"]); obj.LoanRefNumber = Convert.ToString(form["RefNo"]); obj.MonthlyPrincipalDemand = Convert.ToDecimal(form["monthlyprincipaldemand"]); obj.ProjectID = Convert.ToInt32(form["ProjectID"]); obj.MeetingDay = Convert.ToInt32(form["txtDueDay"]); obj.GroupID = Convert.ToInt32(form["hdnGroupId"]); obj.PrincipleAHId = Convert.ToInt32(form["PrincipleAHId"]); obj.SLAccountName = Convert.ToString(form["SLAccountName"]); obj.TransactionMode = Convert.ToString(form["TransactionMode"]); obj.BankEntryId = Convert.ToInt32(form["BankEntryId"]); if (form["TransactionMode"] != "BD") { obj.ChequeNumber = Convert.ToString(form["ChequeNumber"]); obj.ChequeDate = Convert.ToDateTime(form["chequedate"]); } obj.GroupBankEntryId = Convert.ToInt32(form["GroupBankEntryId"]); ResultDto resultdto = _groupLoanDisbursementService.InsertDisbursement(obj, UserInfo.UserID); bool isConfirm = (Request.Form["hdnIsConfirm"] != null && Request.Form["hdnIsConfirm"] == "1"); if (isConfirm) { resultdto = _groupLoanDisbursementService.ConfirmAndDisburseGroupLoan(obj.LoanMasterId, UserInfo.UserID); if (resultdto.ObjectId > 0) { return(RedirectToAction("GroupLoanDisbursementLookup")); } } string encryptloanmasterId = obj.LoanMasterId.EncryptString(); //return RedirectToAction("CreateGroupLoanDisbursement", new { encryptloanmasterId }); return(Json(new { LoanMasterID = resultdto.ObjectId, Message = resultdto.Message, ObjectCode = resultdto.ObjectCode })); }
public ActionResult CreateDisbursement(FormCollection form) { GroupLoanDisbursementDto obj = new GroupLoanDisbursementDto(); obj.LoanMasterId = Convert.ToInt32(form["LoanMasterId"]); obj.DisbursedAmount = Convert.ToDecimal(form["txtDisBursedAmount"]); obj.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]); string strDisbusementDate = obj.TransactionMode == "C" ? Request.Form["DisbursementDate"] : Request.Form["txtDisbursementDate"]; DateTime dtDisbusementDate = strDisbusementDate.ConvertToDateTime(); obj.DisbursementDate = dtDisbusementDate; if (obj.TransactionMode != "C") { obj.BankEntryId = Convert.ToInt32(Request.Form["BankEntryId"]); } if (obj.TransactionMode == "BC") { obj.ChequeNumber = Convert.ToString(Request.Form["ChequeNumber"]); obj.chequedate = Request.Form["ChequeDate"].ConvertToDateTime(); } obj.NoOfInstallments = Convert.ToByte(form["NoOfInstallments"]); obj.LoanRefNumber = Convert.ToString(form["RefNo"]); obj.InstallmentStartFrom = Convert.ToDateTime(form["txtFirstInstallmentStartsFrom"]); obj.LoanClosingDate = Convert.ToDateTime(form["txtLastInstallmentDate"]); obj.MonthlyPrincipalDemand = Convert.ToDecimal(form["monthlyprincipaldemand"]); obj.GroupInterstRateID = Convert.ToInt32(form["hdninterestRateId"]); // obj.GroupInterstRateID = Convert.ToInt32(form["hdninterestRateId"]); //obj.FundSourceID = 0;// Convert.ToInt32(form["ddlfundSource"]); //obj.InterestRateID = Convert.ToInt32(form["hdninterestRateId"]); // obj.LoanAmountApplied = Convert.ToInt32(form[""]); //obj.GroupID = Convert.ToInt32(form["hdnMemberId"]); //obj.PrincipleAHId = Convert.ToInt32(form["hdnPrincipalAHID"]); //obj.SLAccountName = Convert.ToString(form["SLAccountName"]); //obj.OutStandingAmount = string.IsNullOrEmpty(form["OutStandingAmount"]) ? 0 : Convert.ToInt32(form["OutStandingAmount"]); //obj.InterestMasterID = string.IsNullOrEmpty(form["InterestMasterID"]) ? 0 : Convert.ToInt32(form["InterestMasterID"]); ResultDto resultdto = _memberLoanDisbursementService.InsertDisbursement(obj, UserInfo.UserID); return(Json(new { LoanMasterID = resultdto.ObjectId, Message = resultdto.Message, ObjectCode = resultdto.ObjectCode })); }
public GroupLoanDisbursementDto GetLoanDisbursementDto(int id, char type) { var groupLoanDisbursementDto = new GroupLoanDisbursementDto(); groupLoanDisbursementDto = _groupLoanDisbursementService.GetByIDCustom(id); if (groupLoanDisbursementDto.DisbursedAmount == 0) { groupLoanDisbursementDto.DisbursedAmount = groupLoanDisbursementDto.LoanAmountApplied; groupLoanDisbursementDto.NoOfInstallments = groupLoanDisbursementDto.NoofInstallmentsProposed; if (groupLoanDisbursementDto.NoOfInstallments > 0) { groupLoanDisbursementDto.MonthlyPrincipalDemand = groupLoanDisbursementDto.DisbursedAmount / groupLoanDisbursementDto.NoOfInstallments; } } else { groupLoanDisbursementDto.FinalInstallmentDate = groupLoanDisbursementDto.InstallmentStartFrom.AddMonths(groupLoanDisbursementDto.NoOfInstallments); } return(groupLoanDisbursementDto); }
public GroupLoanDisbursementDto GetDisbursement(int loanMasterID) { GroupLoanDisbursementDto groupLoanDisbursementDto = new GroupLoanDisbursementDto(); try { AdoHelper objAdo = new AdoHelper(); SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@LoanMasterID", loanMasterID); parms[0].SqlDbType = System.Data.SqlDbType.Int; SqlDataReader Dr = objAdo.ExecDataReaderProc("uspGetLoanDisbursement", parms); while (Dr.Read()) { if (DBNull.Value != Dr["DisbursedAmount"]) { groupLoanDisbursementDto.DisbursedAmount = Convert.ToInt32(Dr["DisbursedAmount"]); if (Convert.ToByte(Dr["NoOfInstallments"]) != 0) { groupLoanDisbursementDto.NoOfInstallments = Convert.ToByte(Dr["NoOfInstallments"]); } else { groupLoanDisbursementDto.NoOfInstallments = Convert.ToByte(Dr["NoofInstallmentsProposed"]); } groupLoanDisbursementDto.MonthlyPrincipalDemand = Convert.ToDecimal(Dr["MonthlyPrincipalDemand"]); groupLoanDisbursementDto.OutStandingAmount = Convert.ToDecimal(Dr["OutStandingAmount"]); if (!String.IsNullOrEmpty(Dr["PrincipalAHID"].ToString())) { groupLoanDisbursementDto.PrincipleAHId = Convert.ToInt32(Dr["PrincipalAHID"]); } if (!String.IsNullOrEmpty(Dr["InterestAHID"].ToString())) { groupLoanDisbursementDto.InterestAHID = Convert.ToInt32(Dr["InterestAHID"]); } // groupLoanDisbursementDto.SLAccountNumber = Convert.ToInt32(Dr["SLAccountNumber"]); groupLoanDisbursementDto.SLAccountName = Convert.ToString(Dr["SLAccountName"]); groupLoanDisbursementDto.InterestRateID = Convert.ToInt32(Dr["InterestRateID"] == DBNull.Value ? 0 : Convert.ToInt32(Dr["InterestRateID"])); groupLoanDisbursementDto.DisbursementDate = Convert.ToDateTime(Dr["DisbursementDate"]); groupLoanDisbursementDto.InstallmentStartFrom = Convert.ToDateTime(Dr["InstallmentStartFrom"]); groupLoanDisbursementDto.LoanClosingDate = Dr["LoanClosingDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(Dr["LoanClosingDate"]); groupLoanDisbursementDto.LoanRefNumber = Convert.ToString(Dr["LoanRefNumber"]); groupLoanDisbursementDto.ROI = DBNull.Value == Dr["ROI"] ? 0 : Convert.ToDecimal(Dr["ROI"]); // groupLoanDisbursementDto.InterestMasterID = Convert.ToInt32(Dr["InterestMasterID"]); if (DBNull.Value != Dr["BankEntryId"]) { groupLoanDisbursementDto.BankEntryId = Convert.ToInt32(Dr["BankEntryId"]); } groupLoanDisbursementDto.ChequeNumber = Convert.ToString(Dr["ChequeNumber"]); if (DBNull.Value != Dr["ChequeDate"]) { groupLoanDisbursementDto.chequedate = Convert.ToDateTime(Dr["ChequeDate"]); } groupLoanDisbursementDto.TransactionMode = (groupLoanDisbursementDto.BankEntryId == 0 ? "C" : groupLoanDisbursementDto.chequedate != DateTime.MinValue ? "BC" : "BD"); groupLoanDisbursementDto.InterestMasterID = Convert.ToInt32(Dr["MasterInterestId"]); } groupLoanDisbursementDto.MeetingDay = Convert.ToInt32(Dr["MeetingDay"]); groupLoanDisbursementDto.NoofInstallmentsProposed = Convert.ToByte(Dr["NoofInstallmentsProposed"]); groupLoanDisbursementDto.LoanAmountApplied = Convert.ToDecimal(Dr["LoanAmountApplied"]); groupLoanDisbursementDto.LoanMasterId = Convert.ToInt32(Dr["LoanMasterId"]); groupLoanDisbursementDto.GroupID = DBNull.Value == Dr["GroupID"] ? 0 : Convert.ToInt32(Dr["GroupID"]); groupLoanDisbursementDto.LoanCode = Convert.ToString(Dr["LoanCode"]); if (Convert.ToString(Dr["LoanType"]) == "G") { groupLoanDisbursementDto.Groupcode = Convert.ToString(Dr["GroupCode"]); groupLoanDisbursementDto.GroupName = Convert.ToString(Dr["GroupName"]); } groupLoanDisbursementDto.LoanApplicationDate = Convert.ToDateTime(Dr["LoanApplicationDate"]); groupLoanDisbursementDto.LoanPurpose = Convert.ToString(Dr["PurposeName"]); groupLoanDisbursementDto.Mode = Convert.ToString(Dr["ModeName"]); //groupLoanDisbursementDto.FundSourceID = Dr["FundSourceID"] == DBNull.Value ? 0 : Convert.ToInt32(Dr["FundSourceID"]); groupLoanDisbursementDto.ProjectName = Convert.ToString(Dr["ProjectName"]); groupLoanDisbursementDto.StatusCode = Convert.ToString(Dr["StatusCode"]); groupLoanDisbursementDto.Status = Convert.ToString(Dr["Status"]); if (Dr["GroupBankEntryId"] != DBNull.Value) { groupLoanDisbursementDto.GroupBankEntryId = Convert.ToInt32(Dr["GroupBankEntryId"]); } if (Dr["ProjectID"] != DBNull.Value) { groupLoanDisbursementDto.ProjectID = Convert.ToInt32(Dr["ProjectID"]); } if (Dr["GRAccountMasterId"] != DBNull.Value) { groupLoanDisbursementDto.GRAccountMasterId = Convert.ToInt32(Dr["GRAccountMasterId"]); groupLoanDisbursementDto.GRVoucherNumber = Convert.ToString(Dr["GRVoucherNumber"]); } if (Dr["FPAccountMasterId"] != DBNull.Value) { groupLoanDisbursementDto.FPAccountMasterId = Convert.ToInt32(Dr["FPAccountMasterId"]); groupLoanDisbursementDto.FPVoucherNumber = Convert.ToString(Dr["FPVoucherNumber"]); } } if (Dr.NextResult()) { groupLoanDisbursementDto.Schedule = new List <ScheduleDTO>(); ScheduleDTO objSchedule = null; while (Dr.Read()) { objSchedule = new ScheduleDTO(); objSchedule.PERIOD = Convert.ToInt64(Dr["PERIOD"]); objSchedule.Opening_Balance = Convert.ToDecimal(Dr["OPENING_BALANCE"]); objSchedule.PAYDATE = Convert.ToDateTime(Dr["PAYDATE"]); objSchedule.PAYMENT = Convert.ToDecimal(Dr["PAYMENT"]); objSchedule.PRINCIPAL = Convert.ToDecimal(Dr["PRINCIPAL"]); objSchedule.DAYS = Convert.ToInt32(Dr["DAYS"]); objSchedule.INTEREST = Convert.ToDecimal(Dr["INTEREST"]); objSchedule.CURRENT_BALANCE = Convert.ToDecimal(Dr["CURRENT_BALANCE"]); objSchedule.INTERESTRate = Convert.ToInt32(Dr["ROI"]); groupLoanDisbursementDto.Schedule.Add(objSchedule); } } } catch (Exception ex) { } return(groupLoanDisbursementDto); }
public ResultDto InsertDisbursemnet(GroupLoanDisbursementDto obj, int CurrentUserId) { ResultDto objresult = new ResultDto(); try { AdoHelper objAdo = new AdoHelper(); SqlParameter[] parms = new SqlParameter[23]; parms[0] = new SqlParameter("@InterstRateId", obj.InterestRateID); parms[0].SqlDbType = System.Data.SqlDbType.Int; parms[1] = new SqlParameter("@NoofInstallments", obj.NoOfInstallments); parms[1].SqlDbType = System.Data.SqlDbType.TinyInt; parms[2] = new SqlParameter("@DisbursedAmount", obj.DisbursedAmount); parms[2].SqlDbType = System.Data.SqlDbType.Decimal; parms[3] = new SqlParameter("@DisbursedDate", obj.DisbursementDate); parms[3].SqlDbType = System.Data.SqlDbType.DateTime; parms[4] = new SqlParameter("@DueDays", obj.MeetingDay); parms[4].SqlDbType = System.Data.SqlDbType.Int; parms[5] = new SqlParameter("@InstallmentStartDate", obj.InstallmentStartFrom); parms[5].SqlDbType = System.Data.SqlDbType.DateTime; parms[6] = new SqlParameter("@InstallmentEndDate", obj.LoanClosingDate); parms[6].SqlDbType = System.Data.SqlDbType.DateTime; parms[7] = new SqlParameter("@MonthlyPrincipalDemand", obj.MonthlyPrincipalDemand); parms[7].SqlDbType = System.Data.SqlDbType.Decimal; parms[8] = new SqlParameter("@ProjectId", obj.ProjectID); parms[8].SqlDbType = System.Data.SqlDbType.Int; parms[9] = new SqlParameter("@RefNo", obj.LoanRefNumber); parms[9].SqlDbType = System.Data.SqlDbType.VarChar; parms[10] = new SqlParameter("@LoanMasterId", obj.LoanMasterId); parms[10].SqlDbType = System.Data.SqlDbType.Int; parms[11] = new SqlParameter("@GroupId", obj.GroupID); parms[11].SqlDbType = System.Data.SqlDbType.Int; parms[12] = new SqlParameter("@PrincipalAHId", obj.PrincipleAHId); parms[12].SqlDbType = System.Data.SqlDbType.Int; parms[13] = new SqlParameter("@UserId", CurrentUserId); parms[13].SqlDbType = System.Data.SqlDbType.Int; parms[14] = new SqlParameter("@IsFederation", 1); parms[14].SqlDbType = System.Data.SqlDbType.Bit; //parms[15] = new SqlParameter("@FundSourceId", obj.FundSourceID); //parms[15].SqlDbType = System.Data.SqlDbType.Int; parms[15] = new SqlParameter("@SLAccountName", obj.SLAccountName); parms[15].SqlDbType = System.Data.SqlDbType.VarChar; parms[16] = new SqlParameter("@OutStandingAmount", obj.OutStandingAmount); parms[16].SqlDbType = System.Data.SqlDbType.Decimal; parms[17] = new SqlParameter("@InterestMasterID", obj.InterestMasterID); parms[17].SqlDbType = System.Data.SqlDbType.Int; parms[18] = new SqlParameter("@BankID", obj.BankEntryId); parms[18].SqlDbType = System.Data.SqlDbType.Int; parms[19] = new SqlParameter("@ChequeNumber", obj.ChequeNumber); parms[19].SqlDbType = System.Data.SqlDbType.VarChar; if (obj.ChequeDate.Ticks > 0) { parms[20] = new SqlParameter("@ChequeDate", obj.ChequeDate); } else { parms[20] = new SqlParameter("@ChequeDate", null); } parms[20].SqlDbType = System.Data.SqlDbType.DateTime; parms[21] = new SqlParameter("@TransactionMode", obj.TransactionMode); parms[21].SqlDbType = System.Data.SqlDbType.VarChar; parms[22] = new SqlParameter("@GroupBankEntryId", obj.GroupBankEntryId); parms[22].SqlDbType = System.Data.SqlDbType.Int; int updated = objAdo.ExecNonQueryProc("uspLoandDisbursementInsertDetails", parms); if (updated > 0) { objresult.Message = "Updated SuccessFully"; objresult.ObjectId = obj.LoanMasterId; objresult.ObjectCode = "TRUE"; } else { objresult.Message = "Failed To UpDate"; objresult.ObjectId = obj.LoanMasterId; objresult.ObjectCode = "FALSE"; } return(objresult); } catch (Exception ex) { throw ex; } }