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);
}