internal DataTable LoadNarration(UpdCashPaymentModel objUpdCashPay) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashPay.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashPay.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashPay.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashPay.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashPay.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdCashPay = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdCashPay); dtUpdCashPay.TableName = "success"; } catch (Exception) { dtUpdCashPay = new DataTable(); dtUpdCashPay.TableName = "error"; return(dtUpdCashPay); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdCashPay); }
internal DataTable UpdateCashPay(UpdCashPaymentModel objUpdCashPay) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCashVoucher"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashPay.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashPay.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashPay.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashPay.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashPay.VchType); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCashPay.DocNo); ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdCashPay.CCCode); ClsCon.cmd.Parameters.AddWithValue("@DeptID", objUpdCashPay.DeptID); ClsCon.cmd.Parameters.AddWithValue("@SubDeptID", objUpdCashPay.SubDeptID); ClsCon.cmd.Parameters.AddWithValue("@IsAudit", objUpdCashPay.IsAudit); ClsCon.cmd.Parameters.AddWithValue("@IsSendToAudit", objUpdCashPay.IsSendToAudit); ClsCon.cmd.Parameters.AddWithValue("@TblCash", JsonConvert.DeserializeObject <DataTable>(objUpdCashPay.Dt)); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdCashPay = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdCashPay); dtUpdCashPay.TableName = "success"; } catch (Exception) { dtUpdCashPay = new DataTable(); dtUpdCashPay.TableName = "error"; return(dtUpdCashPay); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdCashPay); }
public DataTable CheckBudgetHead(UpdCashPaymentModel objUpdCashPay) { DataTable UpdateCashPayList = UpdCashPaymentDA.CheckBudgetHead(objUpdCashPay); return(UpdateCashPayList); }
public DataTable UpdateCashPay(UpdCashPaymentModel objUpdCashPay) { DataTable UpdateCashPayList = UpdCashPaymentDA.UpdateCashPay(objUpdCashPay); return(UpdateCashPayList); }
public DataTable CancelVoucher(UpdCashPaymentModel objUpdCashPay) { DataTable dtCancelVoucher = UpdCashPaymentDA.CancelVoucher(objUpdCashPay); return(dtCancelVoucher); }
public DataTable SearchCashPay(UpdCashPaymentModel objUpdCashPay) { DataTable SearchCashpayList = UpdCashPaymentDA.SearchCashPay(objUpdCashPay); return(SearchCashpayList); }
public DataSet BindAllUpdCashPaymentDDL(UpdCashPaymentModel objUpdCashPay) { DataSet dsBindAllCPDDL = UpdCashPaymentDA.BindAllUpdCashPaymentDDL(objUpdCashPay); return(dsBindAllCPDDL); }
public DataTable LoadCashAccount(UpdCashPaymentModel objUpdCashPay) { DataTable lstcashpay = UpdCashPaymentDA.LoadCashAccount(objUpdCashPay); return(lstcashpay); }
public DataTable LoadNarration(UpdCashPaymentModel objUpdCashPay) { DataTable NarrationList = UpdCashPaymentDA.LoadNarration(objUpdCashPay); return(NarrationList); }
public DataTable AccountHead(UpdCashPaymentModel objUpdCashPay) { DataTable AccHeadList = UpdCashPaymentDA.AccountHead(objUpdCashPay); return(AccHeadList); }