internal DataTable LoadNarration(UpdateBankReceiptModel objUpdBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdBankRec.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdBankReceipt);
dtUpdBankReceipt.TableName = "success";
}
catch (Exception)
{
dtUpdBankReceipt = new DataTable();
dtUpdBankReceipt.TableName = "error";
return(dtUpdBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdBankReceipt);
}
internal DataSet BindAllUpdBankReceiptDDL(UpdateBankReceiptModel objupdBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objupdBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objupdBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objupdBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objupdBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objupdBankRec.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsUpdBankReceipt = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsUpdBankReceipt);
dsUpdBankReceipt.DataSetName = "success";
}
catch (Exception)
{
dsUpdBankReceipt = new DataSet();
dsUpdBankReceipt.DataSetName = "error";
return(dsUpdBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsUpdBankReceipt);
}
internal DataTable UpdateBankrec(UpdateBankReceiptModel objUpdBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdBankRec.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdBankRec.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdBankRec.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objUpdBankRec.IDARefNo);
ClsCon.cmd.Parameters.AddWithValue("@TblBank", JsonConvert.DeserializeObject <DataTable>(objUpdBankRec.Dt));
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyName", objUpdBankRec.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyAddress", objUpdBankRec.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyGSTIN", objUpdBankRec.PartyGstIN);
ClsCon.cmd.Parameters.AddWithValue("@RevenueServiceNo", objUpdBankRec.ServiceNo);
//ClsCon.cmd.Parameters.AddWithValue("@TblBank", objUpdBankRec.Dt);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdBankReceipt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdBankReceipt);
dtUpdBankReceipt.TableName = "success";
}
catch (Exception)
{
dtUpdBankReceipt = new DataTable();
dtUpdBankReceipt.TableName = "error";
return(dtUpdBankReceipt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdBankReceipt);
}
internal DataTable CancelVoucher(UpdateBankReceiptModel objupdBankRec)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objupdBankRec.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objupdBankRec.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objupdBankRec.BrID);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objupdBankRec.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", objupdBankRec.CancelReason);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objupdBankRec.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objupdBankRec.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtCancelVoucher = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCancelVoucher);
dtCancelVoucher.TableName = "success";
}
catch (Exception)
{
dtCancelVoucher = new DataTable();
dtCancelVoucher.TableName = "error";
return(dtCancelVoucher);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCancelVoucher);
}
public DataTable CheckBudgetHead(UpdateBankReceiptModel objupdBankRec)
{
DataTable updateBankPayList = dlUpdBankRec.CheckBudgetHead(objupdBankRec);
return(updateBankPayList);
}
public DataTable CancelVoucher(UpdateBankReceiptModel objupdBankRec)
{
DataTable dtCancelVoucher = dlUpdBankRec.CancelVoucher(objupdBankRec);
return(dtCancelVoucher);
}
public DataTable UpdateBankRec(UpdateBankReceiptModel objupdBankRec)
{
DataTable updateBankPayList = dlUpdBankRec.UpdateBankrec(objupdBankRec);
return(updateBankPayList);
}
public DataTable SearchBankRec(UpdateBankReceiptModel objupdBankRec)
{
DataTable SearchBankPayList = dlUpdBankRec.SearchBankrec(objupdBankRec);
return(SearchBankPayList);
}
public DataSet BindAllUpdBankReceiptDDL(UpdateBankReceiptModel objupdBankRec)
{
DataSet dsBindAllCRDDL = dlUpdBankRec.BindAllUpdBankReceiptDDL(objupdBankRec);
return(dsBindAllCRDDL);
}
public DataTable LoadBankAccount(UpdateBankReceiptModel objupdBankRec)
{
DataTable lstbnkpay = dlUpdBankRec.LoadBankAccount(objupdBankRec);
return(lstbnkpay);
}
public DataTable LoadNarration(UpdateBankReceiptModel objupdBankRec)
{
DataTable NarrationList = dlUpdBankRec.LoadNarration(objupdBankRec);
return(NarrationList);
}
public DataTable LastVoucherNo(UpdateBankReceiptModel objupdBankRec)
{
DataTable LastVoucherNo = dlUpdBankRec.LastVoucherNo(objupdBankRec);
return(LastVoucherNo);
}
public DataTable AccountHead(UpdateBankReceiptModel objupdBankRec)
{
DataTable AccHeadList = dlUpdBankRec.AccountHead(objupdBankRec);
return(AccHeadList);
}
