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