internal DataTable LoadNarration(UpdBankPaymentModel objUpdBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdBankPay.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdBankPayment = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdBankPayment);
dtUpdBankPayment.TableName = "success";
}
catch (Exception)
{
dtUpdBankPayment = new DataTable();
dtUpdBankPayment.TableName = "error";
return(dtUpdBankPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdBankPayment);
}
internal DataTable UpdateBankPay(UpdBankPaymentModel objUpdBankPay)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBankVoucher";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdBankPay.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdBankPay.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdBankPay.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdBankPay.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdBankPay.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdBankPay.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdBankPay.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@IDARefNo", objUpdBankPay.IDARefNo);
ClsCon.cmd.Parameters.AddWithValue("@DeptID", objUpdBankPay.DeptID);
ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", objUpdBankPay.SubDeptID);
ClsCon.cmd.Parameters.AddWithValue("@IsFinal", objUpdBankPay.IsFinal);
ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objUpdBankPay.IsAudit);
ClsCon.cmd.Parameters.AddWithValue("@IsSendToAudit", objUpdBankPay.IsSendToAudit);
ClsCon.cmd.Parameters.AddWithValue("@BankPayVoucherInd", objUpdBankPay.BankPayVoucherInd);
ClsCon.cmd.Parameters.AddWithValue("@ChequeDrawn", objUpdBankPay.ChequeDrawn);
ClsCon.cmd.Parameters.AddWithValue("@TblBank", JsonConvert.DeserializeObject <DataTable>(objUpdBankPay.Dt));
ClsCon.cmd.Parameters.AddWithValue("@User", objUpdBankPay.User);
//ClsCon.cmd.Parameters.AddWithValue("@TblBank", objUpdBankPay.Dt);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdBankPayment = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdBankPayment);
dtUpdBankPayment.TableName = "success";
}
catch (Exception)
{
dtUpdBankPayment = new DataTable();
dtUpdBankPayment.TableName = "error";
return(dtUpdBankPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdBankPayment);
}
public DataTable CheckBudgetHead(UpdBankPaymentModel objUpdBankPay)
{
DataTable updateBankPayList = dlUpdBankPay.CheckBudgetHead(objUpdBankPay);
return(updateBankPayList);
}
public DataTable CancelVoucher(UpdBankPaymentModel objUpdBankPay)
{
DataTable dtCancelVoucher = dlUpdBankPay.CancelVoucher(objUpdBankPay);
return(dtCancelVoucher);
}
public DataTable UpdateBankPay(UpdBankPaymentModel objUpdBankPay)
{
DataTable updateBankPayList = dlUpdBankPay.UpdateBankPay(objUpdBankPay);
return(updateBankPayList);
}
public DataTable SearchBankPay(UpdBankPaymentModel objUpdBankPay)
{
DataTable SearchBankPayList = dlUpdBankPay.SearchBankPay(objUpdBankPay);
return(SearchBankPayList);
}
public DataSet BindAllUpdBankPaymentDDL(UpdBankPaymentModel objUpdBankPay)
{
DataSet dsBindAllCRDDL = dlUpdBankPay.BindAllUpdBankPaymentDDL(objUpdBankPay);
return(dsBindAllCRDDL);
}
public DataTable LoadBankAccount(UpdBankPaymentModel objUpdBankPay)
{
DataTable lstbnkpay = dlUpdBankPay.LoadBankAccount(objUpdBankPay);
return(lstbnkpay);
}
public DataTable LoadNarration(UpdBankPaymentModel objUpdBankPay)
{
DataTable NarrationList = dlUpdBankPay.LoadNarration(objUpdBankPay);
return(NarrationList);
}
public DataTable LastVoucherNo(UpdBankPaymentModel objUpdBankPay)
{
DataTable LastVoucherNo = dlUpdBankPay.LastVoucherNo(objUpdBankPay);
return(LastVoucherNo);
}
public DataTable AccountHead(UpdBankPaymentModel objUpdBankPay)
{
DataTable AccHeadList = dlUpdBankPay.AccountHead(objUpdBankPay);
return(AccHeadList);
}
