public static List <BinModel> LoadBins() { string sql = @"select BinID, BinName from dbo.bins;"; return(SqlDataAccess.Query <BinModel>(sql)); }
public static List <ProductModel> LoadProducts() { string sql = @"select ProductID, SKU, ProductDescription from dbo.product;"; return(SqlDataAccess.Query <ProductModel>(sql)); }
public static List <OrderModel> LoadOrders() { string sql = @"select OrderID, OrderNumber, DateOrdered, CustomerName, CustomerAddress from dbo.orders;"; return(SqlDataAccess.Query <OrderModel>(sql)); }
public static List <InventoryModel> LoadInventory(int productID) { string sql = @"select InventoryID, ProductID, BinID, QTY from dbo.inventory WHERE ProductID = @ProductID;"; return(SqlDataAccess.Query <InventoryModel>(sql, new { ProductID = productID })); }
public static List <InventoryModel> LoadInventory() { string sql = @"select InventoryID, ProductID, BinID, QTY from dbo.inventory;"; return(SqlDataAccess.Query <InventoryModel>(sql)); }
public static OrderLinesModel LoadOrderLine(int orderLineID) { string sql = @"select OrderLineID, OrderID, ProductID, QTY from dbo.orderlines WHERE OrderLineID = @orderLineID ;"; return(SqlDataAccess.Query <OrderLinesModel>(sql, new { orderLineID = orderLineID }).FirstOrDefault()); }
public static int CreateOrder(string orderNumber, DateTime dateordered, string customerName, string customerAddress) { OrderModel data = new OrderModel { OrderNumber = orderNumber, DateOrdered = dateordered, CustomerName = customerName, CustomerAddress = customerAddress }; string sql = @"insert into dbo.orders (OrderNumber, DateOrdered, CustomerName, CustomerAddress) values (@OrderNumber, @DateOrdered, @CustomerName, @CustomerAddress); SELECT CAST(SCOPE_IDENTITY() as int)"; return(SqlDataAccess.Query <int>(sql, data).Single()); }