public DataSet GetDataSet(bool IsStoredProcedure, string sql) { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { if (IsStoredProcedure) { ds = dbm.GetDataSet(CommandType.StoredProcedure, sql); } else { ds = dbm.GetDataSet(CommandType.Text, sql); } } catch (Exception ex) { log.Write(ex.Message, "GetDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllSpecialOffersDynamicDataSet(string whereCondition, string orderBy) { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereCondition); dbm.AddParameters(1, "@OrderByExpression", orderBy); ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectSpecialOffersDynamic"); } catch (Exception ex) { log.Write(ex.Message, "GetAllSpecialOffersDynamicDataSet()"); throw (ex);; } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllLocationDataSet() { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectLocationsAll"); } catch (Exception ex) { log.Write(ex.Message, "GetAllLocationDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllSalesTerritoryHistorysViewDataSet() { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { ds = dbm.GetDataSet(CommandType.StoredProcedure, "ViewSalesTerritoryList"); } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritoryHistorysViewDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllVendorsByNameDataSet(string name) { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@Name", name); ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectVendorByName"); } catch (Exception ex) { log.Write(ex.Message, "GetAllVendorsDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllPaymentDataSet(int PaymentID) { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@PaymentID", PaymentID); ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectPaymentByOrderID"); } catch (Exception ex) { log.Write(ex.Message, "GetAllPaymentDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }
public DataSet GetAllProductAdjustmentHistoryDataSet(int purchaseAdjustedQuantity) { IDBManager dbm = new DBManager(); DataSet ds = new DataSet(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ProductID", purchaseAdjustedQuantity); ds = dbm.GetDataSet(CommandType.StoredProcedure, "SelectProductAdjustmentHistoryByAdjustedQuantity"); } catch (Exception ex) { log.Write(ex.Message, "GetAllProductAdjustmentHistoryDataSet()"); throw (ex); } finally { dbm.Dispose(); } return(ds); }