public int FnBl_ModifyCalc(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = "Exec Isp_Recovery_Statement_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "', " + " @PS1Bal='" + RO.S1Bal + "',@PS1Inst='" + RO.S1Inst + "',@PS1Intr='" + RO.S1Intr + "'," + " @PS2Bal='" + RO.S2Bal + "',@PS2Inst='" + RO.S2Inst + "',@PS2Intr='" + RO.S2Intr + "'," + " @PS10Bal='" + RO.S10Bal + "',@PS10Inst='" + RO.S10Inst + "',@PS10Intr='" + RO.S10Intr + "'," + " @PS3Bal='" + RO.S3Bal + "',@PS4Bal='" + RO.S4Bal + "',@PS5Bal='" + RO.S5Bal + "',@PS6Bal='" + RO.S6Bal + "'," + "@PS7Bal='" + RO.S7Bal + "',@PS8Bal='" + RO.S8Bal + "',@PS9Bal='" + RO.S9Bal + "'," + " @Id='" + RO.ID + "'"; } else { RO.sql = "Exec Isp_Recovery_Statement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "', " + " @PS1Bal='" + RO.S1Bal + "',@PS1Inst='" + RO.S1Inst + "',@PS1Intr='" + RO.S1Intr + "'," + " @PS2Bal='" + RO.S2Bal + "',@PS2Inst='" + RO.S2Inst + "',@PS2Intr='" + RO.S2Intr + "'," + " @PS3Bal='" + RO.S3Bal + "',@PS4Bal='" + RO.S4Bal + "',@PS5Bal='" + RO.S5Bal + "',@PS6Bal='" + RO.S6Bal + "'," + "@PS7Bal='" + RO.S7Bal + "',@PS8Bal='" + RO.S8Bal + "',@PS9Bal='" + RO.S9Bal + "'," + " @Id='" + RO.ID + "'"; } RO.Res = Conn.sExecuteQuery(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public string GetCustName(ClsAVS5171 RO) { try { RO.sql = "exec ISP_GetCustName @Custno='" + RO.CustNO + "', @BRCD='" + RO.BRCD + "'"; RO.sql = Conn.sExecuteScalar(RO.sql); } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } return(RO.sql); }
public string FnBL_CheckCustMaster(ClsAVS5171 RO)//amruta { try { RO.sql = "Exec Isp_Recovery_CustStatement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "',@CustNo='" + RO.CustNO + "'"; RO.sql = Conn.sExecuteScalar(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.sql); }
public DataTable GetLableName(ClsAVS5171 RO) { try { RO.sql = "Exec Isp_LabelName @brcd='" + RO.BRCD + "',@BKCODE='" + RO.BANKCODE + "'"; RO.DT = Conn.GetDatatable(RO.sql); } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } return(RO.DT); }
public string FnBL_GetCustExistsRecovery(ClsAVS5171 RO) { try { RO.sql = "Exec Isp_Recovery_CustStatement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "',@CustNo='" + RO.CustNO + "'"; RO.sql = Conn.sExecuteScalar(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.sql); }
public int FnBl_CreateCustCalc(ClsAVS5171 RO)//amruta { try { RO.sql = " Exec Isp_Recovery_CustStatement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "',@DeathFund='" + RO.DeathFund + "',@CustNo='" + RO.CustNO + "'"; RO.Res = Conn.sExecuteQuery(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public int FnBl_RecOperationsNew(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = " Exec Isp_Recovery_Create_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "',@ForYY='" + RO.YY + "',@ForMM='" + RO.MM + "'"; } else { RO.sql = " Exec Isp_Recovery_Create @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "',@ForYY='" + RO.YY + "',@ForMM='" + RO.MM + "'"; } RO.Res = Conn.sBindGrid(RO.GRD, RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public int FnBl_ModifyX(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = "Exec Isp_Recovery_Create_1009 @Flag='" + RO.FL + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@PSBal='" + RO.SBAL + "',@PSInst='" + RO.SINST + "',@PSIntr='" + RO.SINTR + "',@Id='" + RO.ID + "'"; } else { RO.sql = "Exec Isp_Recovery_Create @Flag='" + RO.FL + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@PSBal='" + RO.SBAL + "',@PSInst='" + RO.SINST + "',@PSIntr='" + RO.SINTR + "',@Id='" + RO.ID + "'"; } RO.Res = Conn.sExecuteQuery(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public int FnBl_CreateCalcAcc(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = " Exec Isp_Recovery_Create_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecDiv='" + RO.RECDIV + "',@RecCode='" + RO.RECCODE + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "',@DeathFund='" + RO.DeathFund + "',@Narration='" + RO.Narration + "',@MW='" + RO.MW + "',@US='" + RO.US + "'"; } else { RO.sql = " Exec Isp_Recovery_Create @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@RecDiv='" + RO.RECDIV + "',@RecCode='" + RO.RECCODE + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "',@DeathFund='" + RO.DeathFund + "',@Narration='" + RO.Narration + "',@MW='" + RO.MW + "',@US='" + RO.US + "'"; } RO.Res = Conn.sExecuteQuery(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public string FnBL_CheckMaster(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = "Exec Isp_Recovery_Statement_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "'"; } else { RO.sql = "Exec Isp_Recovery_Statement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "'"; } RO.sql = Conn.sExecuteScalar(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.sql); }
public string FnBl_CheckMid(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = "Exec Isp_Recovery_Create_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@ForMM='" + RO.MM + "', " + " @ForYY='" + RO.YY + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "'"; } else { RO.sql = "Exec Isp_Recovery_Create @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "',@ForMM='" + RO.MM + "', " + " @ForYY='" + RO.YY + "',@RecCode='" + RO.RECCODE + "',@RecDiv='" + RO.RECDIV + "'"; } RO.sql = Conn.sExecuteScalar(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.sql); }
public int FnBL_GetSumGrid(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { // RO.sql = "Exec Isp_Recovery_Statement_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "'"; RO.sql = "Exec Isp_Recovery_Create_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "'"; } else { // RO.sql = "Exec Isp_Recovery_Statement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "'"; RO.sql = "Exec Isp_Recovery_Create @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@ForMM='" + RO.MM + "',@ForYY='" + RO.YY + "'"; } RO.Res = Conn.sBindGrid(RO.GRD, RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }
public int FnBl_AuthoCalc(ClsAVS5171 RO) { try { if (RO.BANKCODE == "1009") { RO.sql = "Exec Isp_Recovery_Statement_1009 @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "', " + " @Id='" + RO.ID + "'"; } else { RO.sql = "Exec Isp_Recovery_Statement @Flag='" + RO.FL + "',@Brcd='" + RO.BRCD + "',@OnDate='" + Conn.ConvertDate(RO.ASONDT) + "',@Mid='" + RO.MID + "', " + " @Id='" + RO.ID + "'"; } Res = Conn.sExecuteQuery(RO.sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RO.Res); }