internal DataTable LoadBankAccount(OpenBrsDiffModel objBrsOpenDiffEntery)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPOpenBrsDiffEntry";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBrsOpenDiffEntery.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBrsOpenDiffEntery.OrgID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtOpenBrsEntry = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtOpenBrsEntry);
dtOpenBrsEntry.TableName = "success";
}
catch (Exception)
{
dtOpenBrsEntry = new DataTable();
dtOpenBrsEntry.TableName = "error";
return(dtOpenBrsEntry);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtOpenBrsEntry);
}
internal DataTable SaveOpenBrs(OpenBrsDiffModel objBrsOpenDiffEntery)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPOpenBrsDiffEntry";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objBrsOpenDiffEntery.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objBrsOpenDiffEntery.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objBrsOpenDiffEntery.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objBrsOpenDiffEntery.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objBrsOpenDiffEntery.DocDate);
ClsCon.cmd.Parameters.AddWithValue("@Acccode", objBrsOpenDiffEntery.Acccode);
ClsCon.cmd.Parameters.AddWithValue("@Narration", objBrsOpenDiffEntery.Narration);
ClsCon.cmd.Parameters.AddWithValue("@ChequeNo", objBrsOpenDiffEntery.ChequeNo);
ClsCon.cmd.Parameters.AddWithValue("@ChequeDate", objBrsOpenDiffEntery.ChequeDate);
ClsCon.cmd.Parameters.AddWithValue("@BSCriteria", objBrsOpenDiffEntery.BSCriteria);
ClsCon.cmd.Parameters.AddWithValue("@UTRNo", objBrsOpenDiffEntery.UTRNo);
ClsCon.cmd.Parameters.AddWithValue("@DrAmount", objBrsOpenDiffEntery.DrAmount);
ClsCon.cmd.Parameters.AddWithValue("@CrAmount", objBrsOpenDiffEntery.CrAmount);
ClsCon.cmd.Parameters.AddWithValue("@BSDate", objBrsOpenDiffEntery.BSDate);
ClsCon.cmd.Parameters.AddWithValue("@BSAmount", objBrsOpenDiffEntery.BSAmount);
ClsCon.cmd.Parameters.AddWithValue("@VoucharDateFrom", objBrsOpenDiffEntery.VoucharDateFrom);
ClsCon.cmd.Parameters.AddWithValue("@VoucharDateto", objBrsOpenDiffEntery.VoucharDateto);
ClsCon.cmd.Parameters.AddWithValue("@OpeningDate", objBrsOpenDiffEntery.OpeningDate);
ClsCon.cmd.Parameters.AddWithValue("@OpeningBalance", objBrsOpenDiffEntery.OpeningBalance);
ClsCon.cmd.Parameters.AddWithValue("@ClosingDate", objBrsOpenDiffEntery.ClosingDate);
ClsCon.cmd.Parameters.AddWithValue("@ClosingBalance", objBrsOpenDiffEntery.ClosingBalance);
ClsCon.cmd.Parameters.AddWithValue("@BSInd", objBrsOpenDiffEntery.BSInd);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtOpenBrsEntry = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtOpenBrsEntry);
dtOpenBrsEntry.TableName = "success";
}
catch (Exception)
{
dtOpenBrsEntry = new DataTable();
dtOpenBrsEntry.TableName = "error";
return(dtOpenBrsEntry);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtOpenBrsEntry);
}
public DataTable SaveOpenBrs(OpenBrsDiffModel objBrsOpenDiffEntery)
{
DataTable SaveopenBrs = ObjbrsDiff.SaveOpenBrs(objBrsOpenDiffEntery);
return(SaveopenBrs);
}
public DataTable LoadBankAccount(OpenBrsDiffModel objBrsOpenDiffEntery)
{
DataTable lstBrsbnkpay = ObjbrsDiff.LoadBankAccount(objBrsOpenDiffEntery);
return(lstBrsbnkpay);
}