public static int UpdateInformation(A2ZLOANDTO dto) { int rowEffect = 0; string strQuery = "UPDATE A2ZLOAN set BranchNo='" + dto.BranchNo + "',LoanApplicationNo='" + dto.LoanApplicationNo + "',LoanApplicationDate='" + dto.LoanApplicationDate + "',MemNo='" + dto.LoanMemberNo + "',MemType='" + dto.MemType + "', AccType='" + dto.LoanAccountType + "', AccTypeMode='" + dto.AccTypeMode + "',LoanApplicationAmt='" + dto.LoanApplicationAmount + "',LoanIntRate='" + dto.LoanInterestRate + "',LoanInstlAmt='" + dto.LoanInstallmentAmount + "',LoanLastInstlAmt='" + dto.LoanLastInstallmentAmount + "',LoanNoInstl='" + dto.LoanNoInstallment + "',LoanExpiryDate='" + dto.LoanExpDate + "',LoanIntPeriod='" + dto.LoanInterestCalPeriod + "',LoanIntMethod='" + dto.LoanInterestCalMethod + "',LoanPurpose='" + dto.LoanPurpose + "',LoanCategory='" + dto.LoanCategory + "',LoanSuretyMemType='" + dto.LoanSuretyMemType + "',LoanSuretyMemNo='" + dto.LoanSuretyMemNo + "',LoanTotGuarantorAmt='" + dto.LoanTotGuarantorAmt + "',InputBy='" + dto.InputBy + "',InputByDate='" + dto.InputByDate + "',ApprovBy='" + dto.ApprovBy + "',ApprovByDate='" + dto.ApprovByDate + "',AccCorrAccType='" + dto.AccCorrAccType + "',AccCorrAccNo='" + dto.AccCorrAccNo + "',AccAutoTrfFlag='" + dto.AccAutoTrfFlag + "',AccDepositMode='" + dto.AccDepositMode + "',AccWeeklyDays='" + dto.AccWeeklyDays + "' where BranchNo='" + dto.BranchNo + "' AND LoanApplicationNo ='" + dto.LoanApplicationNo + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACGMS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int InsertInformation(A2ZLOANDTO dto) { int rowEffect = 0; string strQuery = @"INSERT into A2ZLOAN(BranchNo,LoanApplicationNo,LoanApplicationDate,AccType,MemType,MemNo,LoanApplicationAmt,LoanIntRate,LoanInstlAmt,LoanLastInstlAmt,LoanNoInstl,LoanExpiryDate,LoanIntPeriod,LoanIntMethod,LoanPurpose,LoanProcFlag,LoanCategory,LoanSuretyMemType,LoanSuretyMemNo,AccTypeMode,FromCashCode,LoanTotGuarantorAmt,InputBy,InputByDate,ApprovBy,ApprovByDate,AccCorrAccType,AccCorrAccNo,AccAutoTrfFlag,AccDepositMode,AccWeeklyDays)values('" + dto.BranchNo + "','" + dto.LoanApplicationNo + "','" + dto.LoanApplicationDate + "','" + dto.LoanAccountType + "','" + dto.MemType + "','" + dto.LoanMemberNo + "','" + dto.LoanApplicationAmount + "','" + dto.LoanInterestRate + "','" + dto.LoanInstallmentAmount + "','" + dto.LoanLastInstallmentAmount + "','" + dto.LoanNoInstallment + "','" + dto.LoanExpDate + "','" + dto.LoanInterestCalPeriod + "','" + dto.LoanInterestCalMethod + "','" + dto.LoanPurpose + "','" + dto.LoanProcFlag + "','" + dto.LoanCategory + "','" + dto.LoanSuretyMemType + "','" + dto.LoanSuretyMemNo + "','" + dto.AccTypeMode + "','" + dto.FromCashCode + "','" + dto.LoanTotGuarantorAmt + "','" + dto.InputBy + "','" + dto.InputByDate + "','" + dto.ApprovBy + "','" + dto.ApprovByDate + "','" + dto.AccCorrAccType + "','" + dto.AccCorrAccNo + "','" + dto.AccAutoTrfFlag + "','" + dto.AccDepositMode + "','" + dto.AccWeeklyDays + "')"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACGMS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int UpdateInformationBySP(A2ZLOANDTO dto) { int rowEffect = 0; var prm = new object[21]; prm[0] = dto.ID; prm[1] = dto.InputBy; prm[2] = dto.AccTypeMode; prm[3] = dto.LoanApplicationAmount; prm[4] = dto.LoanInterestRate; prm[5] = dto.LoanInstallmentAmount; prm[6] = dto.LoanLastInstallmentAmount; prm[7] = dto.LoanNoInstallment; prm[8] = dto.LoanExpDate; prm[9] = dto.LoanInterestCalPeriod; prm[10] = dto.LoanInterestCalMethod; prm[11] = dto.LoanPurpose; prm[12] = dto.LoanCategory; prm[13] = dto.LoanSuretyMemType; prm[14] = dto.LoanSuretyMemNo; prm[15] = dto.LoanTotGuarantorAmt; prm[16] = dto.AccCorrAccType; prm[17] = dto.AccCorrAccNo; prm[18] = dto.AccAutoTrfFlag; prm[19] = dto.AccDepositMode; prm[20] = dto.AccWeeklyDays; int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSLoanDataUpdate", prm, "A2ZACGMS")); if (result == 0) { rowEffect = 1; } else { rowEffect = 0; } //BLL.CommonManager.Instance.GetScalarValueBySp("Sp_CSLoanDataUpdate", prm, "A2ZACGMS"); return(rowEffect); }
public static A2ZLOANDTO GetInformation(int BranchNo, int AppNo) { var prm = new object[2]; prm[0] = BranchNo; prm[1] = AppNo; DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoLoan", prm, "A2ZACGMS"); //DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo, LoanApplicationNo, LoanApplicationDate, AccType, MemNo, LoanApplicationAmt, LoanIntRate, LoanGrace, LoanInstlAmt, LoanLastInstlAmt, LoanNoInstl, LoanFirstInstlDt, LoanExpiryDate,LoanIntPeriod, LoanIntMethod, LoanPurpose, LoanCategory, LoanSuretyMemNo, LoanStatDate, LoanProcFlag,LoanExpiryDate,InputBy,ApprovBy,InputByDate,ApprovByDate FROM dbo.A2ZLOAN WHERE LoanApplicationNo = " + AppNo, "A2ZCSMCUS"); var p = new A2ZLOANDTO(); if (dt.Rows.Count > 0) { p.ID = Converter.GetInteger(dt.Rows[0]["ID"]); p.BranchNo = Converter.GetInteger(dt.Rows[0]["BranchNo"]); p.LoanApplicationNo = Converter.GetInteger(dt.Rows[0]["LoanApplicationNo"]); p.LoanApplicationDate = Converter.GetDateTime(dt.Rows[0]["LoanApplicationDate"]); p.LoanAccountType = Converter.GetInteger(dt.Rows[0]["AccType"]); p.MemType = Converter.GetInteger(dt.Rows[0]["MemType"]); p.LoanMemberNo = Converter.GetInteger(dt.Rows[0]["MemNo"]); p.LoanApplicationAmount = Converter.GetDecimal(dt.Rows[0]["LoanApplicationAmt"]); p.LoanInterestRate = Converter.GetDecimal(dt.Rows[0]["LoanIntRate"]); //p.LoanGracePeriod = Converter.GetSmallInteger(dt.Rows[0]["LoanGrace"]); p.LoanInstallmentAmount = Converter.GetDecimal(dt.Rows[0]["LoanInstlAmt"]); p.LoanLastInstallmentAmount = Converter.GetDecimal(dt.Rows[0]["LoanLastInstlAmt"]); p.LoanNoInstallment = Converter.GetInteger(dt.Rows[0]["LoanNoInstl"]); //p.LoanFirstInstallmentdate = Converter.GetDateTime(dt.Rows[0]["LoanFirstInstlDt"]); p.LoanInterestCalPeriod = Converter.GetSmallInteger(dt.Rows[0]["LoanIntPeriod"]); p.LoanInterestCalMethod = Converter.GetSmallInteger(dt.Rows[0]["LoanIntMethod"]); p.LoanPurpose = Converter.GetSmallInteger(dt.Rows[0]["LoanPurpose"]); p.LoanCategory = Converter.GetSmallInteger(dt.Rows[0]["LoanCategory"]); p.LoanSuretyMemType = Converter.GetInteger(dt.Rows[0]["LoanSuretyMemType"]); p.LoanSuretyMemNo = Converter.GetInteger(dt.Rows[0]["LoanSuretyMemNo"]); p.LoanStatus = Converter.GetSmallInteger(dt.Rows[0]["LoanStatus"]); p.LoanStatDate = Converter.GetDateTime(dt.Rows[0]["LoanStatDate"]); p.LoanProcFlag = Converter.GetSmallInteger(dt.Rows[0]["LoanProcFlag"]); p.LoanExpDate = Converter.GetDateTime(dt.Rows[0]["LoanExpiryDate"]); p.FromCashCode = Converter.GetInteger(dt.Rows[0]["FromCashCode"]); p.LoanTotGuarantorAmt = Converter.GetDecimal(dt.Rows[0]["LoanTotGuarantorAmt"]); //p.AccTypeMode = Converter.GetSmallInteger(dt.Rows[0]["AccTypeMode"]); // p.LoanStatusNote = Converter.GetString(dt.Rows[0]["LoanStatNote"]); p.InputBy = Converter.GetSmallInteger(dt.Rows[0]["InputBy"]); p.ApprovBy = Converter.GetSmallInteger(dt.Rows[0]["ApprovBy"]); p.InputByDate = Converter.GetDateTime(dt.Rows[0]["InputByDate"]); p.ApprovByDate = Converter.GetDateTime(dt.Rows[0]["ApprovByDate"]); p.AccCorrAccType = Converter.GetInteger(dt.Rows[0]["AccCorrAccType"]); p.AccCorrAccNo = Converter.GetLong(dt.Rows[0]["AccCorrAccNo"]); p.AccAutoTrfFlag = Converter.GetSmallInteger(dt.Rows[0]["AccAutoTrfFlag"]); p.AccDepositMode = Converter.GetSmallInteger(dt.Rows[0]["AccDepositMode"]); p.AccWeeklyDays = Converter.GetSmallInteger(dt.Rows[0]["AccWeeklyDays"]); return(p); } p.LoanApplicationNo = 0; return(p); }