public string GetCustName(ClsRecoveryPosting RP)//amruta
{
try
{
RP.sql = "exec ISP_GetCustName @Custno='" + RP.CustNo + "', @BRCD='" + RP.BRCD + "'";
RP.sql = Conn.sExecuteScalar(RP.sql);
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
return(RP.sql);
}
public DataTable GetCustDeatails(ClsRecoveryPosting RP)//amruta
{
DataTable dt = new DataTable();
try
{
RP.sql = "select DIVNO,OFFNO from EMPDETAIL e inner join MASTER m on e.BRCD=m.BRCD and e.CUSTNO=m.CUSTNO and e.OFFNO=m.RECDEPT where e.STAGE<>1004 and e.CUSTNO='" + RP.CustNo + "' and e.brcd='" + RP.BRCD + "'";
dt = Conn.GetDatatable(RP.sql);
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
return(dt);
}
// For Report use only
public DataTable FnBl_RecoveryExReportSpecific(ClsRecoveryPosting Rp)
{
try
{
if (Rp.BANKCODE == "1009")
{
Rp.sql = "Exec Isp_Recovery_CustPosting_1009 @Flag='" + Rp.FL + "',@SFLAG='" + Rp.SFL + "',@Brcd='" + Rp.BRCD + "',@OnDate='" + Conn.ConvertDate(Rp.ASONDT) + "',@Mid='" + Rp.MID + "',@RecDiv='" + Rp.RECDIV + "',@RecCode='" + Rp.RECCODE + "',@DebitCode='" + Rp.DEBITCD + "',@CustNo='" + Rp.CustNo + "',@Identity='" + Rp.MERGEID + "'";
}
else
{
Rp.sql = "Exec Isp_Recovery_CustPosting @Flag='" + Rp.FL + "',@SFLAG='" + Rp.SFL + "',@Brcd='" + Rp.BRCD + "',@OnDate='" + Conn.ConvertDate(Rp.ASONDT) + "',@Mid='" + Rp.MID + "',@RecDiv='" + Rp.RECDIV + "',@RecCode='" + Rp.RECCODE + "',@DebitCode='" + Rp.DEBITCD + "',@CustNo='" + Rp.CustNo + "',@Identity='" + Rp.MERGEID + "'";
}
Rp.DT = Conn.GetDatatable(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Rp.DT);
}
// For Posting Recovery for specific customer wise (Single Customer)
public string FnBl_RecoveryCustPostSpecific(ClsRecoveryPosting Rp)
{
try
{
if (Rp.BANKCODE == "1009")
{
Rp.sql = "Exec Isp_Recovery_CustPosting_X_1009 @Flag='" + Rp.FL + "',@ChequeNo='" + Rp.ChequeNo + "',@ChequeDate='" + Conn.ConvertDate(Rp.ChequeDate) + "',@Brcd='" + Rp.BRCD + "',@OnDate='" + Conn.ConvertDate(Rp.ASONDT) + "',@Mid='" + Rp.MID + "',@RecDiv='" + Rp.RECDIV + "',@RecCode='" + Rp.RECCODE + "',@DebitCode='" + Rp.DEBITCD + "',@CustNo='" + Rp.CustNo + "',@MergeCustno='" + @MergeCustno + "',@MergeMM='" + @MergeMM + "',@MergeYY='" + @MergeYYYY + "'";
}
else
{
Rp.sql = "Exec Isp_Recovery_CustPosting_X @Flag='" + Rp.FL + "',@ChequeNo='" + Rp.ChequeNo + "',@ChequeDate='" + Conn.ConvertDate(Rp.ChequeDate) + "',@Brcd='" + Rp.BRCD + "',@OnDate='" + Conn.ConvertDate(Rp.ASONDT) + "',@Mid='" + Rp.MID + "',@RecDiv='" + Rp.RECDIV + "',@RecCode='" + Rp.RECCODE + "',@DebitCode='" + Rp.DEBITCD + "',@CustNo='" + Rp.CustNo + "',@MergeCustno='" + @MergeCustno + "',@MergeMM='" + @MergeMM + "',@MergeYY='" + @MergeYYYY + "'";
}
Rp.sql = Conn.sExecuteScalar(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Rp.sql);
}