public int FnBl_ModifyCalc(ClsRecoveryOperation 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 GetRecDept(ClsRecoveryOperation RO)
 {
     try
     {
         RO.sql = "Select RECDEPT from Master where Custno='" + RO.CustNO + "'";
         RO.sql = Conn.sExecuteScalar(RO.sql);
     }
     catch (Exception ex)
     {
         ExceptionLogging.SendErrorToText(ex);
     }
     return(RO.sql);
 }
 public string GetCustName(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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 DataTable GetLableName1(ClsRecoveryOperation RO)
 {
     try
     {
         RO.sql = "SELECT DISTINCT COLUMNNO ,REC_PRD,SHORTNAME FROM AVS_RS WHERE STAGE<>1004 AND REC_PRD IN (SELECT REC_PRD FROM AVS_RS) AND BRCD='" + RO.BRCD + "'";
         //  RO.sql = "select subglcode REC_PRD, ShortGLName SHORTNAME  from GLMAST where subglcode in (201,202,44, 198, 1, 306, 176, 199, 425) and brcd='" + RO.BRCD + "'";
         RO.DT = Conn.GetDatatable(RO.sql);
     }
     catch (Exception ex)
     {
         ExceptionLogging.SendErrorToText(ex);
     }
     return(RO.DT);
 }
 public int FnBl_RecOperationsNew(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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 + "',@MWAmt='" + RO.MWAMT + "', @US='" + RO.US + "',@USAmt='" + RO.USAMT + "',@Custno='" + RO.CustNO + "'";
         }
         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 + "',@MWAmt='" + RO.MWAMT + "', @US='" + RO.US + "',@USAmt='" + RO.USAMT + "',@Custno='" + RO.CustNO + "'";
         }
         RO.Res = Conn.sExecuteQuery(RO.sql);
     }
     catch (Exception Ex)
     {
         ExceptionLogging.SendErrorToText(Ex);
     }
     return(RO.Res);
 }
 public string FnBL_CheckMaster(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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(ClsRecoveryOperation 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);
 }