public PurchaseOrderDetail PurchaseOrderDetail_GetByPoIdStockId(int purchaseOrderID, int stockID) { using (eToolContext context = new eToolContext()) { return context.PurchaseOrderDetails.Where(POD => POD.PurchaseOrderID == purchaseOrderID && POD.StockItemID == stockID).SingleOrDefault(); } }
public List<StockItem> Purchase(String vendorID) { using (eToolContext context = new eToolContext()) { return context.StockItems.Where(anItem => anItem.VendorID == anItem.VendorID).ToList(); } }
public List<Employee> Employee_List() { using (eToolContext context = new eToolContext()) { var results = from item in context.Employees orderby item.LastName select item; return results.ToList(); } }
public List<Vendor> Vendor_List() { using (eToolContext context = new eToolContext()) { var results = from item in context.Vendors orderby item.VendorName select item; return results.ToList(); } }
public List<OutstandingPurchaseOrderDetail> OutstandingPurchaseOrderDetail_List(int purchaseOrderID) { using (eToolContext context = new eToolContext()) { var results = from POD in context.PurchaseOrderDetails.ToList() where POD.PurchaseOrderID == purchaseOrderID select new OutstandingPurchaseOrderDetail { StockItemID = POD.StockItemID, Description = POD.StockItem.Description, Quantity = POD.Quantity }; return results.ToList(); } }
public List<OutstandingPurchaseOrder> OutstandingPurchaseOrder_List() { using (eToolContext context = new eToolContext()) { var results = from PO in context.PurchaseOrders.ToList() orderby PO.PurchaseOrderID where PO.Closed != true && PO.OrderDate != null select new OutstandingPurchaseOrder { PurchaseOrderID = PO.PurchaseOrderID, OrderDate = PO.OrderDate, Vendor = PO.Vendor.VendorName, ContactPhone = PO.Vendor.Phone }; return results.ToList(); } }
public OutstandingPurchaseOrder OutstandingPurchaseOrder_GetByID(int purchaseOrderID) { using (eToolContext context = new eToolContext()) { var results = from PO in context.PurchaseOrders orderby PO.PurchaseOrderID where PO.PurchaseOrderID == purchaseOrderID select new OutstandingPurchaseOrder { PurchaseOrderID = PO.PurchaseOrderID, OrderDate = PO.OrderDate, Vendor = PO.Vendor.VendorName, ContactPhone = PO.Vendor.Phone }; return results.SingleOrDefault(); } }
//[DataObjectMethod(DataObjectMethodType.Insert,false)] it is only for view, e.g: listview.... public void AddToCart(string currentUserName, int stockItemID, int quantity) { using (eToolContext context = new eToolContext()) { var currentCustomer = context.OnlineCustomers.FirstOrDefault( x => x.UserName == currentUserName); if (currentCustomer == null) { OnlineCustomer newCustomer = new OnlineCustomer(); newCustomer.UserName = currentUserName; newCustomer.CreatedOn = DateTime.Now; // Or //OnlineCustomer currentCustomer = new OnlineCustomer() //{ // UserName = user.Identity.Name, // CreatedOn = DateTime.Now //}; currentCustomer = context.OnlineCustomers.Add(newCustomer); context.SaveChanges(); } var currentShoppingCart = context.ShoppingCarts.FirstOrDefault( x => x.OnlineCustomer.UserName == currentUserName); if (currentShoppingCart == null) { ShoppingCart newShoppingCart = new ShoppingCart() { OnlineCustomerID = currentCustomer.OnlineCustomerID, CreatedOn = DateTime.Now }; currentShoppingCart = context.ShoppingCarts.Add(newShoppingCart); context.SaveChanges(); } ShoppingCartItem currentCartItem = new ShoppingCartItem() { ShoppingCartID = currentShoppingCart.ShoppingCartID, StockItemID = stockItemID, Quantity = quantity }; foreach (ShoppingCartItem cartItem in context.ShoppingCartItems) { if(cartItem.ShoppingCartID == currentShoppingCart.ShoppingCartID && cartItem.StockItemID == stockItemID) { context.Entry<ShoppingCartItem>(context.ShoppingCartItems.Attach(currentCartItem)).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } else if(cartItem.ShoppingCartID == currentShoppingCart.ShoppingCartID && cartItem.StockItemID != stockItemID) { //context.ShoppingCartItems.Add(currentCartItem); currentCartItem = context.ShoppingCartItems.Add(currentCartItem); } } //??? should be another way to update var currentStockItem = from skItem in context.StockItems where skItem.StockItemID == stockItemID select new StockItem { StockItemID = skItem.StockItemID, Description = skItem.Description, SellingPrice = skItem.PurchasePrice, PurchasePrice = skItem.PurchasePrice, QuantityOnHand = skItem.QuantityOnHand - quantity, QuantityOnOrder = skItem.QuantityOnOrder,//??? is this for customer or for vendor ReOrderLevel = skItem.ReOrderLevel, Discontinued = skItem.Discontinued, VendorID = skItem.VendorID, VendorStockNumber = skItem.VendorStockNumber, CategoryID = skItem.CategoryID }; context.Entry<StockItem>(context.StockItems.Attach((StockItem)currentStockItem)).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void StockItem_Update(StockItem selectedStockItem) { using (eToolContext context = new eToolContext()) { context.Entry<StockItem>(context.StockItems.Attach(selectedStockItem)).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void ShoppingCartItem_Add(ShoppingCartItem currentShoppingCartItem) { using (eToolContext context = new eToolContext()) { context.ShoppingCartItems.Add(currentShoppingCartItem); context.SaveChanges(); } }
public List<CategoryProduct> GetProductByCategory(int CategoryID) { using (eToolContext context = new eToolContext()) { var results = from pd in context.StockItems where pd.Category.CategoryID == CategoryID orderby pd.Description select new CategoryProduct() { CategoryID = CategoryID, StockItemID = pd.StockItemID, ProdcutCategoryDes = pd.Category.Description, ProductDes = pd.Description, SellingPrice = pd.SellingPrice, QOH = pd.QuantityOnHand, }; return results.ToList(); } }
public List<AllCategories> GetCategories() { using (eToolContext context = new eToolContext()) { var results = from cate in context.Categories orderby cate.Description select new AllCategories() { CategoryID = cate.CategoryID, CategoryDes = cate.Description, ProductCount = cate.StockItems.Count }; return results.ToList(); } }
public void PurchaseOrder_Update(PurchaseOrder item) { using (eToolContext context = new eToolContext()) { context.Entry<PurchaseOrder>(context.PurchaseOrders.Attach(item)).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public PurchaseOrder PurchaseOrder_GetByID(int purchaseOrderID) { using (eToolContext context = new eToolContext()) { return context.PurchaseOrders.Where(PO => PO.PurchaseOrderID == purchaseOrderID).SingleOrDefault(); } }
public int ReceivedOrder_Add(ReceiveOrder item) { using (eToolContext context = new eToolContext()) { ReceiveOrder added = null; added = context.ReceiveOrders.Add(item); context.SaveChanges(); return added.ReceiveOrderID; } }
public void ReturnOrderDetails_Add(ReturnedOrderDetail item) { using (eToolContext context = new eToolContext()) { ReturnedOrderDetail added = null; added = context.ReturnedOrderDetails.Add(item); context.SaveChanges(); //return added.ReturnedOrderDetailID; } }
public StockItem StockItemByID(int ItemID) { using (eToolContext context = new eToolContext()) { return context.StockItems.Where(anItem => anItem.StockItemID == ItemID).SingleOrDefault(); } }