public Recordset ReadSalesOrderDetails(int salesOrderID) { Recordset salesOrderDetails = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERDETAILS, TBL_SALESORDERDETAILS, new object[] { salesOrderID }); salesOrderDetails.Merge(ds); return(salesOrderDetails); }
public Recordset.SalesOrderTableRow ReadSalesOrder(int salesOrderID) { Recordset salesOrder = new Recordset(); DataSet ds = fillDataset(USP_SALESORDER_READ, TBL_SALESORDERS, new object[] { salesOrderID }); salesOrder.Merge(ds); return(salesOrder.SalesOrderTable[0]); }
public Recordset.SalesOrderDetailTableRow ReadSalesOrderDetail(int salesOrderDetailID) { Recordset salesOrderDetail = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERDETAIL_READ, TBL_SALESORDERDETAILS, new object[] { salesOrderDetailID }); salesOrderDetail.Merge(ds); return(salesOrderDetail.SalesOrderDetailTable[0]); }
public Recordset ReadSalesOrders() { Recordset salesOrders = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERS, TBL_SALESORDERS, new object[] { }); salesOrders.Merge(ds); return(salesOrders); }
public static SalesOrderRowGateway ReadSalesOrder(int salesOrderID) { Recordset salesOrder = new Recordset(); Database db = DatabaseFactory.CreateDatabase("SQLConnection"); DbCommand cmd = db.GetStoredProcCommand(USP_SALESORDER_READ, new object[] { salesOrderID }); DataSet ds = new DataSet(); db.LoadDataSet(cmd, ds, TBL_SALESORDERS); salesOrder.Merge(ds); return(new SalesOrderRowGateway(salesOrder.SalesOrderTable[0])); }
//Interface public static Recordset ReadSalesOrders() { Recordset salesOrders = new Recordset(); Database db = DatabaseFactory.CreateDatabase("SQLConnection"); DbCommand cmd = db.GetStoredProcCommand(USP_SALESORDERS, new object[] { }); DataSet ds = new DataSet(); db.LoadDataSet(cmd, ds, TBL_SALESORDERS); salesOrders.Merge(ds); return(salesOrders); }
public Recordset ReadSalesOrders() { Recordset salesOrders=null; //Caching: best to use with master tables not transactional tables ObjectCache cache = MemoryCache.Default; salesOrders = cache["salesorders"] as Recordset; if(salesOrders == null) { salesOrders = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERS,TBL_SALESORDERS,new object[] { }); salesOrders.Merge(ds); //CacheItemPolicy policy = new CacheItemPolicy(); //policy.ChangeMonitors.Add(new SqlChangeMonitor(new SqlDependency(new SqlCommand()))); DateTimeOffset policy = new DateTimeOffset(DateTime.Now.AddMinutes(5)); cache.Set("salesorders",salesOrders,policy); } return salesOrders; }
public Recordset ReadSalesOrders() { Recordset salesOrders = null; //Caching: best to use with master tables not transactional tables ObjectCache cache = MemoryCache.Default; salesOrders = cache["salesorders"] as Recordset; if (salesOrders == null) { salesOrders = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERS, TBL_SALESORDERS, new object[] { }); salesOrders.Merge(ds); //CacheItemPolicy policy = new CacheItemPolicy(); //policy.ChangeMonitors.Add(new SqlChangeMonitor(new SqlDependency(new SqlCommand()))); DateTimeOffset policy = new DateTimeOffset(DateTime.Now.AddMinutes(5)); cache.Set("salesorders", salesOrders, policy); } return(salesOrders); }
public Recordset.SalesOrderDetailTableRow ReadSalesOrderDetail(int salesOrderDetailID) { Recordset salesOrderDetail = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERDETAIL_READ,TBL_SALESORDERDETAILS,new object[] { salesOrderDetailID }); salesOrderDetail.Merge(ds); return salesOrderDetail.SalesOrderDetailTable[0]; }
public Recordset ReadSalesOrderDetails(int salesOrderID) { Recordset salesOrderDetails = new Recordset(); DataSet ds = fillDataset(USP_SALESORDERDETAILS,TBL_SALESORDERDETAILS,new object[] { salesOrderID }); salesOrderDetails.Merge(ds); return salesOrderDetails; }
public Recordset.SalesOrderTableRow ReadSalesOrder(int salesOrderID) { Recordset salesOrder = new Recordset(); DataSet ds = fillDataset(USP_SALESORDER_READ,TBL_SALESORDERS,new object[] { salesOrderID }); salesOrder.Merge(ds); return salesOrder.SalesOrderTable[0]; }