internal DataTable LoadIncomeHead(UpdateSalesReturnModel objUpdSRModel) //IncomeHeadFill { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdSRModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdSalesReturn = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdSalesReturn); dtUpdSalesReturn.TableName = "success"; } catch (Exception) { dtUpdSalesReturn = new DataTable(); dtUpdSalesReturn.TableName = "error"; return(dtUpdSalesReturn); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdSalesReturn); }
internal DataTable FillItemSellingRate(UpdateSalesReturnModel objUpdSRModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPItems"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID); //ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdSRModel.PartyCode); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdSRModel.GSTIN); ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUpdSRModel.ItemID); ClsCon.cmd.Parameters.AddWithValue("@ByCash", objUpdSRModel.ByCashSale); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdSalesReturn = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdSalesReturn); dtUpdSalesReturn.TableName = "success"; } catch (Exception) { dtUpdSalesReturn = new DataTable(); dtUpdSalesReturn.TableName = "error"; return(dtUpdSalesReturn); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdSalesReturn); }
internal DataTable FillShippingAddress(UpdateSalesReturnModel objUpdSRModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPSearchByAccount"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdSRModel.AccCode); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdSRModel.GSTIN); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdSalesReturn = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdSalesReturn); dtUpdSalesReturn.TableName = "success"; } catch (Exception) { dtUpdSalesReturn = new DataTable(); dtUpdSalesReturn.TableName = "error"; return(dtUpdSalesReturn); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdSalesReturn); }
internal DataSet LoadSRBasicDetails(UpdateSalesReturnModel objUpdSRModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPUpdateSalesReturnVoucher"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdSRModel.DocNo); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsUpdSalesReturn = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsUpdSalesReturn); dsUpdSalesReturn.DataSetName = "success"; } catch (Exception) { dsUpdSalesReturn = new DataSet(); dsUpdSalesReturn.DataSetName = "error"; return(dsUpdSalesReturn); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsUpdSalesReturn); }
public DataTable LastVoucherNo(UpdateSalesReturnModel objUpdSRModel) { DataTable AccHeadList = objUpdSRDA.LastVoucherNo(objUpdSRModel); return(AccHeadList); }
public DataTable FillShippingAddress(UpdateSalesReturnModel objUpdSRModel) { DataTable ItemList = objUpdSRDA.FillShippingAddress(objUpdSRModel); return(ItemList); }
public DataTable FillItemSellingRate(UpdateSalesReturnModel objUpdSRModel) { DataTable ItemList = objUpdSRDA.FillItemSellingRate(objUpdSRModel); return(ItemList); }
public DataTable FillItemName(UpdateSalesReturnModel objUpdSRModel) { DataTable dtFillItemName = objUpdSRDA.FillItemName(objUpdSRModel); return(dtFillItemName); }
public DataTable InvoiceSeries(UpdateSalesReturnModel objUpdSRModel) { DataTable dtLastVoucherNo = objUpdSRDA.InvoiceSeries(objUpdSRModel); return(dtLastVoucherNo); }
public DataTable SalesTo(UpdateSalesReturnModel objUpdSRModel) { DataTable dtSalesTo = objUpdSRDA.LoadSalesTo(objUpdSRModel); return(dtSalesTo); }
public DataTable IncomeHead(UpdateSalesReturnModel objUpdSRModel) { DataTable IncomeHeadList = objUpdSRDA.LoadIncomeHead(objUpdSRModel); return(IncomeHeadList); }
public DataTable LoadNarration(UpdateSalesReturnModel objUpdSRModel) { DataTable NarrationList = objUpdSRDA.LoadNarration(objUpdSRModel); return(NarrationList); }
public DataTable UpdateSalesReturnVoucher(UpdateSalesReturnModel objUpdSRModel) { DataTable AccHeadList = objUpdSRDA.UpdateSalesReturnVoucher(objUpdSRModel); return(AccHeadList); }
public DataSet LoadSRBasicDetails(UpdateSalesReturnModel objUpdSRModel) { DataSet dsSRBasicDetails = objUpdSRDA.LoadSRBasicDetails(objUpdSRModel); return(dsSRBasicDetails); }
public DataSet FillItemSellRate(UpdateSalesReturnModel objUpdSRModel) { DataSet ItemList = objUpdSRDA.FillItemSellRate(objUpdSRModel); return(ItemList); }
public DataSet BindAll(UpdateSalesReturnModel objUpdSRModel) { DataSet dsBindAll = objUpdSRDA.BindAll(objUpdSRModel); return(dsBindAll); }
public DataTable FillLocation(UpdateSalesReturnModel objUpdSRModel) { DataTable dtFillLocation = objUpdSRDA.Filllocation(objUpdSRModel); return(dtFillLocation); }
public DataTable FillGistnNo(UpdateSalesReturnModel objUpdSRModel) { DataTable IncomeHeadList = objUpdSRDA.FillGistnNo(objUpdSRModel); return(IncomeHeadList); }
internal DataTable UpdateSalesReturnVoucher(UpdateSalesReturnModel objUpdSRModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPUpdateSalesReturnVoucher"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdSRModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdSRModel.EntryType); ClsCon.cmd.Parameters.AddWithValue("@User", objUpdSRModel.User); ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdSRModel.IP); ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objUpdSRModel.ByCashSale); ClsCon.cmd.Parameters.AddWithValue("@PartyName", objUpdSRModel.PartyName); ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objUpdSRModel.PartyGSTIN); ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objUpdSRModel.PartyAddress); ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objUpdSRModel.WareHouseID); ClsCon.cmd.Parameters.AddWithValue("@TransName", objUpdSRModel.TransName); ClsCon.cmd.Parameters.AddWithValue("@PONo", objUpdSRModel.PONo); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdSRModel.DocNo); ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdSRModel.DocDate); ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objUpdSRModel.InvoiceSeries); ClsCon.cmd.Parameters.AddWithValue("@PurchaseSalesRecordID", objUpdSRModel.PurchaseSalesRecordID); ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherNo", objUpdSRModel.OrgVoucherNo); ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherDate", objUpdSRModel.OrgVoucherDate); ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdSRModel.CCCode); ClsCon.cmd.Parameters.AddWithValue("@TblSale", objUpdSRModel.DtSales); ClsCon.cmd.Parameters.AddWithValue("@TblItems", objUpdSRModel.DtItems); ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objUpdSRModel.DtSundries); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtUpdSalesReturn = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtUpdSalesReturn); dtUpdSalesReturn.TableName = "success"; } catch (Exception) { dtUpdSalesReturn = new DataTable(); dtUpdSalesReturn.TableName = "error"; return(dtUpdSalesReturn); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtUpdSalesReturn); }
public DataTable FillTransportation(UpdateSalesReturnModel objUpdSRModel) { DataTable dtLastVoucherNo = objUpdSRDA.FillTransportation(objUpdSRModel); return(dtLastVoucherNo); }