public List <StockItemDTO> GetStockItems() { var itemlist = dbcontext.Item_Stock.ToList(); List <StockItemDTO> stockItemDTOList = new List <StockItemDTO>(); if (itemlist != null && itemlist.Count > 0) { foreach (var item in itemlist) { StockItemDTO stockItemDTO = new StockItemDTO(); stockItemDTO.Item_ID = item.Item_ID; stockItemDTO.Item_Name = item.Item_Name; stockItemDTO.Item_Quantity = item.Item_Quantity; stockItemDTO.Item_Purchased_On = item.Item_Purchased_On; stockItemDTO.Item_Disposed_On = item.Item_Disposed_On; stockItemDTO.Item_Remarks = item.Item_Remarks; //stockItemDTO.Store_ID = item.Store_ID; //Only for Display Store Name stockItemDTO.Store_Name = dbcontext.Stores.Where(s => s.Store_ID == item.Store_ID).FirstOrDefault().Store_Name; stockItemDTOList.Add(stockItemDTO); } return(stockItemDTOList); } else { return(stockItemDTOList); } }
public AddUpdateItemResponse UpdatestockItem(StockItemDTO item) { try { using (WideWorldImportersEntities entities = new WideWorldImportersEntities()) { var originalItem = entities.StockItems.FirstOrDefault(s => s.StockItemID == item.StockItemID); originalItem.Barcode = item.Barcode; originalItem.Brand = item.Brand; originalItem.ColorID = item.ColorID; originalItem.CustomFields = item.CustomFields; originalItem.InternalComments = item.InternalComments; originalItem.IsChillerStock = item.IsChillerStock; originalItem.LastEditedBy = item.LastEditedBy; originalItem.LeadTimeDays = item.LeadTimeDays; originalItem.MarketingComments = item.MarketingComments; originalItem.OuterPackageID = item.OuterPackageID; originalItem.Photo = item.Photo; originalItem.QuantityPerOuter = item.QuantityPerOuter; originalItem.RecommendedRetailPrice = item.RecommendedRetailPrice; originalItem.SearchDetails = item.SearchDetails; originalItem.Size = item.Size; originalItem.StockItemName = item.StockItemName; originalItem.SupplierID = item.SupplierID; originalItem.Tags = item.Tags; originalItem.TaxRate = item.TaxRate; originalItem.TypicalWeightPerUnit = item.TypicalWeightPerUnit; originalItem.UnitPackageID = item.UnitPackageID; originalItem.UnitPrice = item.UnitPrice; originalItem.ValidFrom = item.ValidFrom; originalItem.ValidTo = item.ValidTo; //entities.Entry(originalItem).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); return(new AddUpdateItemResponse() { ItemId = originalItem.StockItemID, ErrorMessage = "", Success = true }); } } catch (Exception ex) { return(new AddUpdateItemResponse() { ItemId = item.StockItemID, ErrorMessage = ex.ToString(), Success = false }); } }
public void Create(StockItemDTO stockItemDTO) { Item_Stock item_Stock = new Item_Stock(); item_Stock.Item_Name = stockItemDTO.Item_Name; item_Stock.Item_Quantity = stockItemDTO.Item_Quantity; item_Stock.Item_Disposed_On = stockItemDTO.Item_Disposed_On; item_Stock.Item_Purchased_On = stockItemDTO.Item_Purchased_On; item_Stock.Item_Remarks = stockItemDTO.Item_Remarks; item_Stock.Store_ID = stockItemDTO.Store_ID; dbcontext.Item_Stock.Add(item_Stock); dbcontext.SaveChanges(); }
public void Edit(StockItemDTO stockItemDTO) { Item_Stock item_Stock = new Item_Stock(); item_Stock.Item_ID = stockItemDTO.Item_ID; item_Stock.Item_Name = stockItemDTO.Item_Name; item_Stock.Item_Quantity = stockItemDTO.Item_Quantity; item_Stock.Item_Purchased_On = stockItemDTO.Item_Purchased_On; item_Stock.Item_Disposed_On = stockItemDTO.Item_Disposed_On; item_Stock.Item_Remarks = stockItemDTO.Item_Remarks; item_Stock.Store_ID = stockItemDTO.Store_ID; dbcontext.Entry(item_Stock).State = EntityState.Modified; dbcontext.SaveChanges(); }
public StockItemDTO GetbyID(int id) { var Item = dbcontext.Item_Stock.Where(i => i.Item_ID == id).FirstOrDefault(); StockItemDTO stockItemDTO = new StockItemDTO(); if (Item != null) { stockItemDTO.Item_ID = Item.Item_ID; stockItemDTO.Item_Name = Item.Item_Name; stockItemDTO.Item_Quantity = Item.Item_Quantity; stockItemDTO.Item_Purchased_On = Item.Item_Purchased_On; stockItemDTO.Item_Disposed_On = Item.Item_Disposed_On; stockItemDTO.Item_Remarks = Item.Item_Remarks; stockItemDTO.Store_ID = Item.Store_ID; } return(stockItemDTO); }
public ActionResult Edit(StockItemDTO stockItemDTO) { _db.Edit(stockItemDTO); return(RedirectToAction("Index")); }
public ActionResult Create(StockItemDTO stockItemDTO) { _db.Create(stockItemDTO); return(RedirectToAction("Index")); }
public void Edit(StockItemDTO stockItemDTO) { _db.Edit(stockItemDTO); }
public void Create(StockItemDTO stockItemDTO) { _db.Create(stockItemDTO); }