internal DataTable LoadExpenseHead(CompositionPurchaseModel ObjPurchaseModel) //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", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPurchase = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPurchase); dtPurchase.TableName = "success"; } catch (Exception) { dtPurchase = new DataTable(); dtPurchase.TableName = "error"; return(dtPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPurchase); }
internal DataTable SavePurchase(CompositionPurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPurchaseVoucherChange"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjPurchaseModel.EntryType); ClsCon.cmd.Parameters.AddWithValue("@User", ObjPurchaseModel.User); ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPurchaseModel.IP); ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjPurchaseModel.ByCashSale); ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjPurchaseModel.PartyName); ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjPurchaseModel.PartyGSTIN); ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjPurchaseModel.PartyAddress); ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjPurchaseModel.WareHouseID); ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjPurchaseModel.PONo); ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", ObjPurchaseModel.PurchaseBillNo); ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", ObjPurchaseModel.PurchaseBillDate); ClsCon.cmd.Parameters.AddWithValue("@GRNNo", ObjPurchaseModel.GRNNo); ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjPurchaseModel.VoucherDate); ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", ObjPurchaseModel.DtPurchase); ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", ObjPurchaseModel.DtItems); ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", ObjPurchaseModel.DtSundries); ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjPurchaseModel.DtAdjAdvance); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPurchase = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPurchase); dtPurchase.TableName = "success"; } catch (Exception) { dtPurchase = new DataTable(); dtPurchase.TableName = "error"; return(dtPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPurchase); }
internal DataSet FillItemPurchaseRate(CompositionPurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPItems"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); //ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@PartyCode", ObjPurchaseModel.PartyCode); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjPurchaseModel.GSTIN); ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjPurchaseModel.ItemID); ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjPurchaseModel.ByCashSale); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsPurchase = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsPurchase); dsPurchase.DataSetName = "success"; } catch (Exception) { dsPurchase = new DataSet(); dsPurchase.DataSetName = "error"; return(dsPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsPurchase); }
internal DataTable FillShippingAddress(CompositionPurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPSearchByAccount"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjPurchaseModel.AccCode); ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjPurchaseModel.GSTIN); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtPurchase = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtPurchase); dtPurchase.TableName = "success"; } catch (Exception) { dtPurchase = new DataTable(); dtPurchase.TableName = "error"; return(dtPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtPurchase); }
internal DataSet FillGistnNoWithDetail(CompositionPurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPSearchByAccount"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjPurchaseModel.AccCode); ClsCon.cmd.Parameters.AddWithValue("@AdvRecPayID", ObjPurchaseModel.AdvRecPayID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsPurchase = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsPurchase); dsPurchase.DataSetName = "success"; } catch (Exception) { dsPurchase = new DataSet(); dsPurchase.DataSetName = "error"; return(dsPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsPurchase); }
internal DataSet BindAll(CompositionPurchaseModel ObjPurchaseModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPPurchaseVoucherChange"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsPurchase = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsPurchase); dsPurchase.DataSetName = "success"; } catch (Exception) { dsPurchase = new DataSet(); dsPurchase.DataSetName = "error"; return(dsPurchase); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsPurchase); }
public DataTable FillShippingAddress(CompositionPurchaseModel ObjPurchaseModel) { DataTable dtShippingAddress = objPurchaseDA.FillShippingAddress(ObjPurchaseModel); return(dtShippingAddress); }
public DataTable LoadNarration(CompositionPurchaseModel ObjPurchaseModel) { DataTable NarrationList = objPurchaseDA.LoadNarration(ObjPurchaseModel); return(NarrationList); }
public DataTable LastVoucherNo(CompositionPurchaseModel ObjPurchaseModel) { DataTable AccHeadList = objPurchaseDA.LastVoucherNo(ObjPurchaseModel); return(AccHeadList); }
public DataSet FillGistnNoWithDetail(CompositionPurchaseModel ObjPurchaseModel) { DataSet dsFillGistnNoWithDetail = objPurchaseDA.FillGistnNoWithDetail(ObjPurchaseModel); return(dsFillGistnNoWithDetail); }
public DataTable FillGistnNo(CompositionPurchaseModel ObjPurchaseModel) { DataTable IncomeHeadList = objPurchaseDA.FillGistnNo(ObjPurchaseModel); return(IncomeHeadList); }
public DataTable FillHeadName(CompositionPurchaseModel ObjPurchaseModel) { DataTable dtFillHeadName = objPurchaseDA.FillHeadName(ObjPurchaseModel); return(dtFillHeadName); }
public DataTable FillLocation(CompositionPurchaseModel ObjPurchaseModel) { DataTable dtFillLocation = objPurchaseDA.Filllocation(ObjPurchaseModel); return(dtFillLocation); }
public DataTable PurchaseFrom(CompositionPurchaseModel ObjPurchaseModel) { DataTable dtSalesTo = objPurchaseDA.PurchaseFrom(ObjPurchaseModel); return(dtSalesTo); }
public DataTable ExpenseHead(CompositionPurchaseModel ObjPurchaseModel) { DataTable IncomeHeadList = objPurchaseDA.LoadExpenseHead(ObjPurchaseModel); return(IncomeHeadList); }
public DataSet BindAll(CompositionPurchaseModel ObjPurchaseModel) { DataSet dsBindAll = objPurchaseDA.BindAll(ObjPurchaseModel); return(dsBindAll); }
public DataSet FillItemPurchaseRate(CompositionPurchaseModel ObjPurchaseModel) { DataSet ItemList = objPurchaseDA.FillItemPurchaseRate(ObjPurchaseModel); return(ItemList); }
public DataTable SavePurchase(CompositionPurchaseModel ObjPurchaseModel) { DataTable dtShippingAddress = objPurchaseDA.SavePurchase(ObjPurchaseModel); return(dtShippingAddress); }