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); }