internal DataTable LoadNarration(UpdateCashReceiptModel objUpdCashRec) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashRec.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashRec.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashRec.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashRec.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashRec.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdCashReceipt = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdCashReceipt); dtUpdCashReceipt.TableName = "success"; } catch (Exception) { dtUpdCashReceipt = new DataTable(); dtUpdCashReceipt.TableName = "error"; return(dtUpdCashReceipt); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdCashReceipt); }
internal DataTable UpdateCashReceipt(UpdateCashReceiptModel objUpdCashRec) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCashVoucher"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCashRec.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCashRec.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCashRec.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCashRec.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCashRec.VchType); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCashRec.DocNo); ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdCashRec.CCCode); ClsCon.cmd.Parameters.AddWithValue("@TblCash", JsonConvert.DeserializeObject <DataTable>(objUpdCashRec.Dt)); ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyName", objUpdCashRec.PartyName); ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyAddress", objUpdCashRec.PartyAddress); ClsCon.cmd.Parameters.AddWithValue("@RevenuePartyGSTIN", objUpdCashRec.PartyGstIN); ClsCon.cmd.Parameters.AddWithValue("@RevenueServiceNo", objUpdCashRec.ServiceNo); //ClsCon.cmd.Parameters.AddWithValue("@TblCash", objUpdCashRec.Dt); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdCashReceipt = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdCashReceipt); dtUpdCashReceipt.TableName = "success"; } catch (Exception) { dtUpdCashReceipt = new DataTable(); dtUpdCashReceipt.TableName = "error"; return(dtUpdCashReceipt); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdCashReceipt); }
public DataTable CancelVoucher(UpdateCashReceiptModel objUpdCashRec) { DataTable dtCancelVoucher = objUpdCashReceiptDA.CancelVoucher(objUpdCashRec); return(dtCancelVoucher); }
public DataTable CheckBudgetHead(UpdateCashReceiptModel objUpdCashRec) { DataTable lstcashrec = objUpdCashReceiptDA.CheckBudgetHead(objUpdCashRec); return(lstcashrec); }
public DataTable UpdateCashReceipt(UpdateCashReceiptModel objUpdCashRec) { DataTable UpdateCashReceiptList = objUpdCashReceiptDA.UpdateCashReceipt(objUpdCashRec); return(UpdateCashReceiptList); }
public DataSet BindAllUpdCashReceiptDDL(UpdateCashReceiptModel objUpdCashRec) { DataSet dsBindAllCRDDL = objUpdCashReceiptDA.BindAllUpdCashReceiptDDL(objUpdCashRec); return(dsBindAllCRDDL); }
public DataTable LoadNarration(UpdateCashReceiptModel objUpdCashRec) { DataTable NarrationList = objUpdCashReceiptDA.LoadNarration(objUpdCashRec); return(NarrationList); }
public DataTable AccountHead(UpdateCashReceiptModel objUpdCashRec) { DataTable AccHeadList = objUpdCashReceiptDA.AccountHead(objUpdCashRec); return(AccHeadList); }
public DataTable LoadCashAccount(UpdateCashReceiptModel objUpdCashRec) { DataTable lstcashrec = objUpdCashReceiptDA.LoadCashAccount(objUpdCashRec); return(lstcashrec); }