internal DataSet BindBRSDateAndBalance(BrsBankModel objBrsBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBRS";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBrsBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBrsBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBrsBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBrsBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@Acccode", objBrsBankPay.AccCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsBRS = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsBRS);
dsBRS.DataSetName = "success";
}
catch (Exception)
{
dsBRS = new DataSet();
dsBRS.DataSetName = "error";
return(dsBRS);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsBRS);
}
internal DataTable SaveBRS(BrsBankModel objBrsBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBRS";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBrsBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBrsBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBrsBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBrsBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@Acccode", objBrsBankPay.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@VoucharDateFrom", objBrsBankPay.VoucharDateFrom);
ClsCon.cmd.Parameters.AddWithValue("@VoucharDateto", objBrsBankPay.VoucharDateto);
ClsCon.cmd.Parameters.AddWithValue("@OpeningDate", objBrsBankPay.OpeningDate);
ClsCon.cmd.Parameters.AddWithValue("@OpeningBalance", objBrsBankPay.OpeningBalance);
ClsCon.cmd.Parameters.AddWithValue("@ClosingDate", objBrsBankPay.ClosingDate);
ClsCon.cmd.Parameters.AddWithValue("@ClosingBalance", objBrsBankPay.ClosingBalance);
ClsCon.cmd.Parameters.AddWithValue("@TblBRS", objBrsBankPay.DtBrs);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtBRS = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtBRS);
dtBRS.TableName = "success";
}
catch (Exception)
{
dtBRS = new DataTable();
dtBRS.TableName = "error";
return(dtBRS);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtBRS);
}
public DataSet BRSReconciliationSummary(BrsBankModel objBrsBankPay)
{
DataSet dsBRSReconciliationSummary = ObjBrsBankDA.BRSReconciliationSummary(objBrsBankPay);
return(dsBRSReconciliationSummary);
}
public DataTable SaveBRS(BrsBankModel objBrsBankPay)
{
DataTable lstBrsbnkpay = ObjBrsBankDA.SaveBRS(objBrsBankPay);
return(lstBrsbnkpay);
}
public DataSet BindBRSDateAndBalance(BrsBankModel objBrsBankPay)
{
DataSet dsDataAndBalance = ObjBrsBankDA.BindBRSDateAndBalance(objBrsBankPay);
return(dsDataAndBalance);
}
public DataSet LoadGridData(BrsBankModel objBrsBankPay)
{
DataSet dsGvData = ObjBrsBankDA.LoadGridData(objBrsBankPay);
return(dsGvData);
}
public DataSet BindAllBRSDDL(BrsBankModel objBrsBankPay)
{
DataSet lstBrsbnkpay = ObjBrsBankDA.BindAllBRSDDL(objBrsBankPay);
return(lstBrsbnkpay);
}
