public static int InsertInformation(A2ZACCOUNTDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@Opendate", DBNull.Value); SqlParameter param2 = new SqlParameter("@MatruityDate", DBNull.Value); SqlParameter param3 = new SqlParameter("@AccBenefitDate", DBNull.Value); SqlParameter param4 = new SqlParameter("@InputByDate", DBNull.Value); if (dto.OpenNulldate == "") { param1 = new SqlParameter("@Opendate", DBNull.Value); } else { param1 = new SqlParameter("@Opendate", dto.Opendate); } if (dto.MatruityNullDate == "") { param2 = new SqlParameter("@MatruityDate", DBNull.Value); } else { param2 = new SqlParameter("@MatruityDate", dto.MatruityDate); } if (dto.AccBenefitNullDate == "") { param3 = new SqlParameter("@AccBenefitDate", DBNull.Value); } else { param3 = new SqlParameter("@AccBenefitDate", dto.AccBenefitDate); } param4 = new SqlParameter("@InputByDate", dto.InputByDate); int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZCSMCUS"), "Sp_CSAccountDataInsert", new object[] { dto.AccType, dto.AccNo, dto.CuType, dto.CuNo, dto.MemberNo, param1, dto.DepositAmount, dto.Period, dto.WithDrawalAC, dto.InterestCalculation, param2, dto.MatruityAmount, dto.InterestWithdrawal, dto.AutoRenewal, dto.LoanAmount, dto.NoInstallment, dto.MonthlyInstallment, dto.LastInstallment, dto.InterestRate, dto.ContractInt, dto.GracePeriod, dto.LoaneeACType, dto.LoaneeMemberNo, dto.SpInstruction, dto.CorrAccType, dto.CorrAccNo, dto.AutoTransferSavings, dto.OldAccountNo, dto.FixedDepositAmount, dto.FixedMthInt, dto.AccStatus, dto.AccAtyClass, param3, dto.InputBy, param4 }); if (result == 0) { return(0); } else { return(1); } }
public static int Update1(A2ZACCOUNTDTO dto) { int rowEffect = 0; string strQuery = "UPDATE A2ZACCOUNT SET AccAtyClass ='" + dto.AccAtyClass + "', MemType ='" + dto.MemType + "' where Id='" + dto.Id + "' "; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int UpdateAccStatus(A2ZACCOUNTDTO dto) { int rowEffect = 0; string strQuery = "UPDATE A2ZACCOUNT SET AccStatus ='" + dto.AccStatus + "' where AccNo='" + dto.AccNo + "' "; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static A2ZACCOUNTDTO GetInforbyAccType(int BrNo, Int16 MemType, int memNo, int AType) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE CuType = 0 AND CuNo = 0 AND MemNo = '" + memNo + "' AND AccType = '" + AType + "'", "A2ZCSCUBS"); var p = new A2ZACCOUNTDTO(); if (dt.Rows.Count > 0) { p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]); return(p); } p.AccNo = 0; return(p); }
public static int Insert(A2ZACCOUNTDTO dto) { int rowEffect = 0; string strQuery = @"INSERT into A2ZACCOUNT(AccType, AccNo,CuType,CuNo,MemNo,AccStatus,AccAtyClass,AccOpenDate) values('" + dto.AccType + "','" + dto.AccNo + "','" + dto.CuType + "','" + dto.CuNo + "','" + dto.MemberNo + "','" + dto.AccStatus + "','" + dto.AccAtyClass + "','" + dto.Opendate + "')"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int UpdateLoanInformation(A2ZACCOUNTDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@Opendate", DBNull.Value); SqlParameter param2 = new SqlParameter("@LoanSancDate", DBNull.Value); SqlParameter param3 = new SqlParameter("@AccDisbDate", DBNull.Value); SqlParameter param4 = new SqlParameter("@AccLoanExpiryDate", DBNull.Value); SqlParameter param5 = new SqlParameter("@LastTrnDate", DBNull.Value); if (dto.OpenNulldate == "") { param1 = new SqlParameter("@Opendate", DBNull.Value); } else { param1 = new SqlParameter("@Opendate", dto.Opendate); } if (dto.AccSancNullDate == "") { param2 = new SqlParameter("@LoanSancDate", DBNull.Value); } else { param2 = new SqlParameter("@LoanSancDate", dto.LoanSancDate); } if (dto.AccDisbNullDate == "") { param3 = new SqlParameter("@AccDisbDate", DBNull.Value); } else { param3 = new SqlParameter("@AccDisbDate", dto.AccDisbDate); } if (dto.AccExpiryNullDate == "") { param4 = new SqlParameter("@AccLoanExpiryDate", DBNull.Value); } else { param4 = new SqlParameter("@AccLoanExpiryDate", dto.AccLoanExpiryDate); } if (dto.LastTrnNullDate == "") { param5 = new SqlParameter("@LastTrnDate", DBNull.Value); } else { param5 = new SqlParameter("@LastTrnDate", dto.LastTrnDate); } int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZCSCUBS"), "Sp_CSLoanAccountDataUpdate", new object[] { dto.Id, dto.BranchNo, dto.AccType, dto.AccNo, dto.MemType, dto.MemberNo, param1, param2, param3, param4, param5, dto.LoanAmount, dto.AccDisbAmt, dto.InterestRate, dto.NoInstallment, dto.MonthlyInstallment, dto.LastInstallment, dto.CorrAccType, dto.CorrAccNo, dto.AccAutoTrfFlag, dto.OldAccountNo, dto.UserId, dto.AccSMSFlag }); if (result == 0) { return(0); } else { return(1); } }
public static int UpdateInformation(A2ZACCOUNTDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@Opendate", DBNull.Value); SqlParameter param2 = new SqlParameter("@MatruityDate", DBNull.Value); SqlParameter param3 = new SqlParameter("@AccBenefitDate", DBNull.Value); SqlParameter param4 = new SqlParameter("@AccAnniDate", DBNull.Value); SqlParameter param5 = new SqlParameter("@AccRenwlDate", DBNull.Value); if (dto.OpenNulldate == "") { param1 = new SqlParameter("@Opendate", DBNull.Value); } else { param1 = new SqlParameter("@Opendate", dto.Opendate); } if (dto.MatruityNullDate == "") { param2 = new SqlParameter("@MatruityDate", DBNull.Value); } else { param2 = new SqlParameter("@MatruityDate", dto.MatruityDate); } if (dto.AccBenefitNullDate == "") { param3 = new SqlParameter("@AccBenefitDate", DBNull.Value); } else { param3 = new SqlParameter("@AccBenefitDate", dto.AccBenefitDate); } if (dto.AccAnniNullDate == "") { param4 = new SqlParameter("@AccAnniDate", DBNull.Value); } else { param4 = new SqlParameter("@AccAnniDate", dto.AccAnniDate); } if (dto.AccRenwlNullDate == "") { param5 = new SqlParameter("@AccRenwlDate", DBNull.Value); } else { param5 = new SqlParameter("@AccRenwlDate", dto.AccRenwlDate); } int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZCSCUBS"), "Sp_CSAccountDataUpdate", new object[] { dto.UserId, dto.Id, dto.BranchNo, dto.AccType, dto.AccNo, dto.MemType, dto.MemberNo, param1, dto.DepositAmount, dto.Period, dto.WithDrawalAC, dto.InterestCalculation, param2, dto.MatruityAmount, dto.InterestWithdrawal, dto.AutoRenewal, dto.LoanAmount, dto.NoInstallment, dto.MonthlyInstallment, dto.LastInstallment, dto.InterestRate, dto.ContractInt, dto.GracePeriod, dto.LoaneeACType, dto.LoaneeMemberNo, dto.AccCertNo, dto.SpInstruction, dto.CorrAccType, dto.CorrAccNo, dto.AccAutoTrfFlag, dto.OldAccountNo, dto.FixedDepositAmount, dto.FixedMthInt, dto.AccAtyClass, param3, param4, param5, dto.AccOrgAmt, dto.AccPrincipal, dto.AccRenwlAmt, dto.AccNoBenefit, dto.TotDepositAmount, dto.AccSMSFlag }); if (result == 0) { return(0); } else { return(1); } }
public static A2ZACCOUNTDTO GetInfoAccNoByApplicationNo(int BranchNo, int AppNo) { //A2ZCSPARAMETERDTO dto2 = A2ZCSPARAMETERDTO.GetParameterValue(); //DateTime dt2 = Converter.GetDateTime(dto2.ProcessDate); //string date1 = dt2.ToString("dd/MM/yyyy"); //var prm1 = new object[3]; //prm1[0] = AccountNo; //prm1[1] = Converter.GetDateToYYYYMMDD(date1); //prm1[2] = 0; //DataTable dt3 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("SpM_CSGenerateSingleAccountBalance", prm1, "A2ZCSCUBS"); var prm = new object[2]; prm[0] = BranchNo; prm[1] = AppNo; DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoAccNoByApplicationNo", prm, "A2ZCSCUBS"); //DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE AccType = '" + AccType + "' and AccNo = '" + // AccountNo + "' and CuType='" + CuType + "' and CuNo='" + CreditNo + "' and MemNo='" + MemberNo + "'", "A2ZCSMCUS"); var p = new A2ZACCOUNTDTO(); if (dt.Rows.Count > 0) { p.Id = Converter.GetInteger(dt.Rows[0]["Id"]); p.BranchNo = Converter.GetInteger(dt.Rows[0]["BranchNo"]); p.AccType = Converter.GetInteger(dt.Rows[0]["AccType"]); p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]); p.MemType = Converter.GetSmallInteger(dt.Rows[0]["MemType"]); p.MemberNo = Converter.GetInteger(dt.Rows[0]["MemNo"]); p.Opendate = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]); p.DepositAmount = Converter.GetDecimal(dt.Rows[0]["AccMonthlyDeposit"]); p.FixedDepositAmount = Converter.GetDecimal(dt.Rows[0]["AccFixedAmt"]); p.FixedMthInt = Converter.GetDecimal(dt.Rows[0]["AccFixedMthInt"]); p.Period = Converter.GetSmallInteger(dt.Rows[0]["AccPeriod"]); p.WithDrawalAC = Converter.GetSmallInteger(dt.Rows[0]["AccDebitFlag"]); p.InterestCalculation = Converter.GetSmallInteger(dt.Rows[0]["AccIntFlag"]); p.MatruityDate = Converter.GetDateTime(dt.Rows[0]["AccMatureDate"]); p.MatruityAmount = Converter.GetDecimal(dt.Rows[0]["AccMatureAmt"]); p.InterestWithdrawal = Converter.GetSmallInteger(dt.Rows[0]["AccIntType"]); p.AutoRenewal = Converter.GetSmallInteger(dt.Rows[0]["AccAutoRenewFlag"]); p.AccLoanAppNo = Converter.GetInteger(dt.Rows[0]["AccLoanAppNo"]); p.AccLoanAppDate = Converter.GetDateTime(dt.Rows[0]["AccLoanAppDate"]); p.LoanSancDate = Converter.GetDateTime(dt.Rows[0]["AccLoanSancDate"]); p.LoanAmount = Converter.GetDecimal(dt.Rows[0]["AccLoanSancAmt"]); p.NoInstallment = Converter.GetSmallInteger(dt.Rows[0]["AccNoInstl"]); p.MonthlyInstallment = Converter.GetDecimal(dt.Rows[0]["AccLoanInstlAmt"]); p.LastInstallment = Converter.GetDecimal(dt.Rows[0]["AccLoanLastInstlAmt"]); p.InterestRate = Converter.GetDecimal(dt.Rows[0]["AccIntRate"]); p.ContractInt = Converter.GetSmallInteger(dt.Rows[0]["AccContractIntFlag"]); p.GracePeriod = Converter.GetSmallInteger(dt.Rows[0]["AccLoanGrace"]); p.LoaneeACType = Converter.GetInteger(dt.Rows[0]["AccLoaneeAccType"]); p.LoaneeMemberNo = Converter.GetInteger(dt.Rows[0]["AccLoaneeMemNo"]); p.SpInstruction = Converter.GetString(dt.Rows[0]["AccSpecialNote"]); p.CorrAccType = Converter.GetInteger(dt.Rows[0]["AccCorrAccType"]); p.CorrAccNo = Converter.GetLong(dt.Rows[0]["AccCorrAccNo"]); p.AccAutoTrfFlag = Converter.GetSmallInteger(dt.Rows[0]["AccAutoTrfFlag"]); p.OldAccountNo = Converter.GetString(dt.Rows[0]["AccOldNumber"]); p.AccBalance = Converter.GetDecimal(dt.Rows[0]["AccBalance"]); p.AccProvBalance = Converter.GetDecimal(dt.Rows[0]["AccProvBalance"]); p.AccPrincipal = Converter.GetDecimal(dt.Rows[0]["AccPrincipal"]); p.AccOrgAmt = Converter.GetDecimal(dt.Rows[0]["AccOrgAmt"]); p.AccLienAmt = Converter.GetDecimal(dt.Rows[0]["AccLienAmt"]); p.AccDisbDate = Converter.GetDateTime(dt.Rows[0]["AccDisbDate"]); p.AccDisbAmt = Converter.GetDecimal(dt.Rows[0]["AccDisbAmt"]); p.AccLoanExpiryDate = Converter.GetDateTime(dt.Rows[0]["AccLoanExpiryDate"]); p.LastTrnDate = Converter.GetDateTime(dt.Rows[0]["AccLastTrnDateU"]); p.TotDepositAmount = Converter.GetDecimal(dt.Rows[0]["AccTotalDep"]); p.AccAtyClass = Converter.GetSmallInteger(dt.Rows[0]["AccAtyClass"]); p.AccStatus = Converter.GetSmallInteger(dt.Rows[0]["AccStatus"]); p.AccStatusDate = Converter.GetDateTime(dt.Rows[0]["AccStatusDate"]); p.AccStatusNote = Converter.GetString(dt.Rows[0]["AccStatusNote"]); p.AccDueIntAmt = Converter.GetDecimal(dt.Rows[0]["AccDueIntAmt"]); p.AccRenwlDate = Converter.GetDateTime(dt.Rows[0]["AccRenwlDate"]); p.AccRenwlAmt = Converter.GetDecimal(dt.Rows[0]["AccRenwlAmt"]); p.AccCertNo = Converter.GetString(dt.Rows[0]["AccCertNo"]); p.AccBenefitDate = Converter.GetDateTime(dt.Rows[0]["AccBenefitDate"]); p.AccNoBenefit = Converter.GetSmallInteger(dt.Rows[0]["AccNoBenefit"]); p.AccOpBal = Converter.GetDecimal(dt.Rows[0]["AccOpBal"]); p.AccEffectDate = Converter.GetDateTime(dt.Rows[0]["AccEffectDate"]); p.AccBalance = p.AccOpBal; p.a = Converter.GetSmallInteger(1); return(p); } else { p.AccType = 0; p.AccNo = 0; p.MemberNo = 0; p.a = 0; } return(p); }
public static A2ZACCOUNTDTO GetInfo(int BranchNo, int AccType, Int16 MemType, int MemberNo) { var prm = new object[4]; prm[0] = BranchNo; prm[1] = AccType; prm[2] = MemType; prm[3] = MemberNo; DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoAcc", prm, "A2ZCSCUBS"); //DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZACCOUNT WHERE AccType = '" + AccType + "' and AccNo = '" + // AccountNo + "' and CuType='" + CuType + "' and CuNo='" + CreditNo + "' and MemNo='" + MemberNo + "'", "A2ZCSMCUS"); var p = new A2ZACCOUNTDTO(); if (dt.Rows.Count > 0) { p.BranchNo = Converter.GetInteger(dt.Rows[0]["BranchNo"]); p.AccType = Converter.GetInteger(dt.Rows[0]["AccType"]); p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]); p.MemType = Converter.GetSmallInteger(dt.Rows[0]["MemType"]); p.MemberNo = Converter.GetInteger(dt.Rows[0]["MemNo"]); p.Opendate = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]); p.DepositAmount = Converter.GetDecimal(dt.Rows[0]["AccMonthlyDeposit"]); p.FixedDepositAmount = Converter.GetDecimal(dt.Rows[0]["AccFixedAmt"]); p.FixedMthInt = Converter.GetDecimal(dt.Rows[0]["AccFixedMthInt"]); p.Period = Converter.GetSmallInteger(dt.Rows[0]["AccPeriod"]); p.WithDrawalAC = Converter.GetSmallInteger(dt.Rows[0]["AccDebitFlag"]); p.InterestCalculation = Converter.GetSmallInteger(dt.Rows[0]["AccIntFlag"]); p.MatruityDate = Converter.GetDateTime(dt.Rows[0]["AccMatureDate"]); p.MatruityAmount = Converter.GetDecimal(dt.Rows[0]["AccMatureAmt"]); p.InterestWithdrawal = Converter.GetSmallInteger(dt.Rows[0]["AccIntType"]); p.AutoRenewal = Converter.GetSmallInteger(dt.Rows[0]["AccAutoRenewFlag"]); p.LoanAmount = Converter.GetDecimal(dt.Rows[0]["AccLoanSancAmt"]); p.NoInstallment = Converter.GetSmallInteger(dt.Rows[0]["AccNoInstl"]); p.MonthlyInstallment = Converter.GetDecimal(dt.Rows[0]["AccLoanInstlAmt"]); p.LastInstallment = Converter.GetDecimal(dt.Rows[0]["AccLoanLastInstlAmt"]); p.InterestRate = Converter.GetDecimal(dt.Rows[0]["AccIntRate"]); p.ContractInt = Converter.GetSmallInteger(dt.Rows[0]["AccContractIntFlag"]); p.GracePeriod = Converter.GetSmallInteger(dt.Rows[0]["AccLoanGrace"]); p.LoaneeACType = Converter.GetInteger(dt.Rows[0]["AccLoaneeAccType"]); p.LoaneeMemberNo = Converter.GetInteger(dt.Rows[0]["AccLoaneeMemNo"]); p.SpInstruction = Converter.GetString(dt.Rows[0]["AccSpecialNote"]); p.CorrAccType = Converter.GetInteger(dt.Rows[0]["AccCorrAccType"]); p.CorrAccNo = Converter.GetLong(dt.Rows[0]["AccCorrAccNo"]); p.AccAutoTrfFlag = Converter.GetSmallInteger(dt.Rows[0]["AccAutoTrfFlag"]); p.OldAccountNo = Converter.GetString(dt.Rows[0]["AccOldNumber"]); p.AccBalance = Converter.GetDecimal(dt.Rows[0]["AccBalance"]); p.AccProvBalance = Converter.GetDecimal(dt.Rows[0]["AccProvBalance"]); p.AccPrincipal = Converter.GetDecimal(dt.Rows[0]["AccPrincipal"]); p.AccOrgAmt = Converter.GetDecimal(dt.Rows[0]["AccOrgAmt"]); p.AccLienAmt = Converter.GetDecimal(dt.Rows[0]["AccLienAmt"]); p.AccDisbAmt = Converter.GetDecimal(dt.Rows[0]["AccDisbAmt"]); p.LastTrnDate = Converter.GetDateTime(dt.Rows[0]["AccLastTrnDateU"]); p.TotDepositAmount = Converter.GetDecimal(dt.Rows[0]["AccTotalDep"]); p.AccAtyClass = Converter.GetSmallInteger(dt.Rows[0]["AccAtyClass"]); p.AccStatus = Converter.GetSmallInteger(dt.Rows[0]["AccStatus"]); p.AccStatusDate = Converter.GetDateTime(dt.Rows[0]["AccStatusDate"]); p.AccStatusNote = Converter.GetString(dt.Rows[0]["AccStatusNote"]); p.AccDueIntAmt = Converter.GetDecimal(dt.Rows[0]["AccDueIntAmt"]); p.AccRenwlDate = Converter.GetDateTime(dt.Rows[0]["AccRenwlDate"]); p.AccRenwlAmt = Converter.GetDecimal(dt.Rows[0]["AccRenwlAmt"]); p.AccCertNo = Converter.GetString(dt.Rows[0]["AccCertNo"]); p.AccBenefitDate = Converter.GetDateTime(dt.Rows[0]["AccBenefitDate"]); p.AccAnniDate = Converter.GetDateTime(dt.Rows[0]["AccAnniDate"]); p.AccNoBenefit = Converter.GetSmallInteger(dt.Rows[0]["AccNoBenefit"]); p.a = Converter.GetSmallInteger(1); return(p); } else { p.AccType = 0; p.AccNo = 0; p.MemberNo = 0; p.a = 0; } return(p); }
public static A2ZACCOUNTDTO GetInfoAccNo(Int64 AccountNo) { A2ZCSPARAMETERDTO dto2 = A2ZCSPARAMETERDTO.GetParameterValue(); DateTime dt2 = Converter.GetDateTime(dto2.ProcessDate); string date1 = dt2.ToString("dd/MM/yyyy"); var prm1 = new object[3]; prm1[0] = AccountNo; prm1[1] = Converter.GetDateToYYYYMMDD(date1); prm1[2] = 0; string input = Converter.GetString(AccountNo); string AccType = input.Substring(0, 2); DataTable dt3 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("SpM_GenerateSingleAccountBalance", prm1, "A2ZACGMS"); //} //else if (AccType == "16") //{ // DataTable dt3 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("SpM_GenerateSingleCashBalance", prm1, "A2ZACGMS"); //} //else //{ // DataTable dt3 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("SpM_GenerateSinglePartyBalance", prm1, "A2ZACGMS"); //} var prm = new object[1]; prm[0] = AccountNo; DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_GetInfoAccountNo", prm, "A2ZACGMS"); var p = new A2ZACCOUNTDTO(); if (dt.Rows.Count > 0) { p.Id = Converter.GetInteger(dt.Rows[0]["Id"]); p.AccType = Converter.GetInteger(dt.Rows[0]["AccType"]); p.AccNo = Converter.GetLong(dt.Rows[0]["AccNo"]); p.AccPartyNo = Converter.GetInteger(dt.Rows[0]["AccPartyNo"]); p.Opendate = Converter.GetDateTime(dt.Rows[0]["AccOpenDate"]); p.AccCurrency = Converter.GetInteger(dt.Rows[0]["AccCurrency"]); p.AccStatus = Converter.GetSmallInteger(dt.Rows[0]["AccStatus"]); p.AccBalance = Converter.GetDecimal(dt.Rows[0]["AccBalance"]); p.AccPrincipal = Converter.GetDecimal(dt.Rows[0]["AccPrincipal"]); p.AccInterest = Converter.GetDecimal(dt.Rows[0]["AccInterest"]); p.LastTrnDate = Converter.GetDateTime(dt.Rows[0]["AccLastTrnDateU"]); p.LoanAmount = Converter.GetDecimal(dt.Rows[0]["AccLoanAmt"]); p.AccLoanEffectingDate = Converter.GetDateTime(dt.Rows[0]["AccLoanEffectingDate"]); p.AccLoanExpiryDate = Converter.GetDateTime(dt.Rows[0]["AccLoanExpiryDate"]); p.AccCalculateDays = Converter.GetInteger(dt.Rows[0]["AccCalculateDays"]); p.AccIntRate = Converter.GetDecimal(dt.Rows[0]["AccIntRate"]); p.AccOpBal = Converter.GetDecimal(dt.Rows[0]["AccOpBal"]); p.a = Converter.GetSmallInteger(1); return(p); } else { p.AccType = 0; p.AccNo = 0; p.a = 0; } return(p); }