internal DataSet BindPendingTransaction(RPTPendingTransactionModel objRPTPTransModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPRPTPendingTransaction";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objRPTPTransModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objRPTPTransModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objRPTPTransModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@FromDate", objRPTPTransModel.FromDate);
ClsCon.cmd.Parameters.AddWithValue("@ToDate", objRPTPTransModel.ToDate);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsPendingTransaction = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsPendingTransaction);
dsPendingTransaction.DataSetName = "success";
}
catch (Exception)
{
dsPendingTransaction = new DataSet();
dsPendingTransaction.DataSetName = "error";
return(dsPendingTransaction);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsPendingTransaction);
}
public DataSet BindPendingTransaction(RPTPendingTransactionModel objRPTPTransModel)
{
DataSet dsPendingTransaction = objRPTPTransDA.BindPendingTransaction(objRPTPTransModel);
return(dsPendingTransaction);
}
