internal void DeleteWarehouseItem(int itemId) { try { using (WarehouseDataBaseEntities context = new WarehouseDataBaseEntities()) { tblProduct itemToDelete = (from i in context.tblProducts where i.ID == itemId select i).First(); context.tblProducts.Remove(itemToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
internal List <vwProduct> GetAllWarehouseItems() { try { using (WarehouseDataBaseEntities context = new WarehouseDataBaseEntities()) { List <vwProduct> list = new List <vwProduct>(); list = (from x in context.vwProducts select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwProduct ChangeStoredStatus(vwProduct item) { try { using (WarehouseDataBaseEntities context = new WarehouseDataBaseEntities()) { tblProduct itemToEditStoredStatus = (from i in context.tblProducts where i.ID == item.ID select i).First(); itemToEditStoredStatus.InStock = item.InStock; context.SaveChanges(); return(item); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwProduct EditWarehouseItem(vwProduct item) { try { using (WarehouseDataBaseEntities context = new WarehouseDataBaseEntities()) { tblProduct itemToEdit = (from i in context.tblProducts where i.ID == item.ID select i).First(); itemToEdit.ProductName = item.ProductName; itemToEdit.ProductNumber = item.ProductNumber; itemToEdit.Amount = item.Amount; itemToEdit.Price = item.Price; context.SaveChanges(); return(item); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwProduct AddWarehouseItem(vwProduct item) { try { using (WarehouseDataBaseEntities context = new WarehouseDataBaseEntities()) { tblProduct newProduct = new tblProduct(); newProduct.ProductName = item.ProductName; newProduct.ProductNumber = item.ProductNumber; newProduct.Amount = item.Amount; newProduct.Price = item.Price; newProduct.InStock = item.InStock; context.tblProducts.Add(newProduct); context.SaveChanges(); item.ID = newProduct.ID; return(item); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }