public List <StockElementDTO> GetAll() { using (var dbContext = new DatabaseContext()) { var stockElements = dbContext.StockElements.ToList(); var stockElementDtos = StockElementFactory.ConvertToDtos(stockElements); return(stockElementDtos); } }
public List <StockElementDTO> GetByFilter(string elementName) { using (var dbContext = new DatabaseContext()) { var stockElements = dbContext.StockElements.Where(x => x.Name == elementName).ToList(); var stockElementDtos = StockElementFactory.ConvertToDtos(stockElements); return(stockElementDtos); } }
public void CreateNew(StockElementDTO newStockElements) { using (var dbContext = new DatabaseContext()) { var stockElements = StockElementFactory.ConvertToEntity(newStockElements); stockElements.Select(x => { x.PurchaseDate = DateTime.Now; return(x); }).ToList(); dbContext.AddRange(stockElements); dbContext.SaveChanges(); } }
public void UpdateStockElement(OpeningStockElementDTO updatedStockElements) { using (var dbContext = new DatabaseContext()) { var stockElement = dbContext.StockElements.Where(x => x.Name == updatedStockElements.Name && x.OpeningDate == null).FirstOrDefault(); if (stockElement != null) { var updatedStockElement = StockElementFactory.UpdateEntity(stockElement, updatedStockElements); dbContext.Update(updatedStockElement); dbContext.SaveChanges(); } } }