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());
}
