示例#1
0
        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));
        }
示例#2
0
        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);
        }
示例#7
0
        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 }));
        }
示例#9
0
        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);
        }
示例#10
0
        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);
        }
示例#11
0
        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; }
        }