public CitiesService(WideWorldImportersEntities context, IMapper mapper, ICache cache, ILog log) { _context = context; _mapper = mapper; _cache = cache; _log = log; }
public StockItemDTO GetStockItems(int id) { using (WideWorldImportersEntities entities = new WideWorldImportersEntities()) { var StockItemInDB = entities.StockItems.FirstOrDefault(e => e.StockItemID == id); return(new StockItemDTO() { ColorID = StockItemInDB.ColorID, Barcode = StockItemInDB.Barcode, Brand = StockItemInDB.Brand, CustomFields = StockItemInDB.CustomFields, InternalComments = StockItemInDB.InternalComments, IsChillerStock = StockItemInDB.IsChillerStock, LastEditedBy = StockItemInDB.LastEditedBy, LeadTimeDays = StockItemInDB.LeadTimeDays, MarketingComments = StockItemInDB.MarketingComments, OuterPackageID = StockItemInDB.OuterPackageID, Photo = StockItemInDB.Photo, QuantityPerOuter = StockItemInDB.QuantityPerOuter, RecommendedRetailPrice = StockItemInDB.RecommendedRetailPrice, SearchDetails = StockItemInDB.SearchDetails, Size = StockItemInDB.Size, StockItemID = StockItemInDB.StockItemID, StockItemName = StockItemInDB.StockItemName, SupplierID = StockItemInDB.SupplierID, Tags = StockItemInDB.Tags, TaxRate = StockItemInDB.TaxRate, TypicalWeightPerUnit = StockItemInDB.TypicalWeightPerUnit, UnitPackageID = StockItemInDB.UnitPackageID, UnitPrice = StockItemInDB.UnitPrice, ValidFrom = StockItemInDB.ValidFrom, ValidTo = StockItemInDB.ValidTo }); } }
// GET api/<controller>/5 public IEnumerable <StockItem> Get() { var context = new WideWorldImportersEntities(); var query = from s in context.StockItems select s; var stockItems = query.ToArray <StockItem>(); return(stockItems); }
public StockItem DeleteStockItem(int id) { using (WideWorldImportersEntities entities = new WideWorldImportersEntities()) { var StockItemInDB = entities.StockItems.FirstOrDefault(e => e.StockItemID == id); return(entities.StockItems.Remove(StockItemInDB)); } }
public OrderLinesBll(string @connectionString) { try { _DbModelEntities = new WideWorldImportersEntities(@connectionString); } catch (Exception err) { Console.Out.WriteLine(err); } }
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 AddItemResponse CreateStockItem(StockItem NewstockItem) { try { using (WideWorldImportersEntities entities = new WideWorldImportersEntities()) { var NewItem = new StockItem() { ColorID = NewstockItem.ColorID, Barcode = NewstockItem.Barcode, Brand = NewstockItem.Brand, CustomFields = NewstockItem.CustomFields, InternalComments = NewstockItem.InternalComments, IsChillerStock = NewstockItem.IsChillerStock, LastEditedBy = NewstockItem.LastEditedBy, LeadTimeDays = NewstockItem.LeadTimeDays, MarketingComments = NewstockItem.MarketingComments, OuterPackageID = NewstockItem.OuterPackageID, Photo = NewstockItem.Photo, QuantityPerOuter = NewstockItem.QuantityPerOuter, RecommendedRetailPrice = NewstockItem.RecommendedRetailPrice, SearchDetails = NewstockItem.SearchDetails, Size = NewstockItem.Size, StockItemID = NewstockItem.StockItemID, StockItemName = NewstockItem.StockItemName, SupplierID = NewstockItem.SupplierID, Tags = NewstockItem.Tags, TaxRate = NewstockItem.TaxRate, TypicalWeightPerUnit = NewstockItem.TypicalWeightPerUnit, UnitPackageID = NewstockItem.UnitPackageID, UnitPrice = NewstockItem.UnitPrice, ValidFrom = NewstockItem.ValidFrom, ValidTo = NewstockItem.ValidTo }; return(new AddItemResponse() { ItemId = NewstockItem.StockItemID, ErrorMessage = "", Success = true }); } } catch (Exception ex) { return(new AddItemResponse() { ItemId = NewstockItem.StockItemID, ErrorMessage = ex.ToString(), Success = false }); } }
public IEnumerable <StockItemDTO> GetStockItems() { using (WideWorldImportersEntities entities = new WideWorldImportersEntities()) { //Retrieving all items from the database var StockItemsFromDB = entities.StockItems.ToList(); //filling the retirieved item into a DTO list var ListOfStockItemsDTO = new List <StockItemDTO>(); foreach (var stockItem in StockItemsFromDB) { ListOfStockItemsDTO.Add(new StockItemDTO() { ColorID = stockItem.ColorID, Barcode = stockItem.Barcode, Brand = stockItem.Brand, CustomFields = stockItem.CustomFields, InternalComments = stockItem.InternalComments, IsChillerStock = stockItem.IsChillerStock, LastEditedBy = stockItem.LastEditedBy, LeadTimeDays = stockItem.LeadTimeDays, MarketingComments = stockItem.MarketingComments, OuterPackageID = stockItem.OuterPackageID, Photo = stockItem.Photo, QuantityPerOuter = stockItem.QuantityPerOuter, RecommendedRetailPrice = stockItem.RecommendedRetailPrice, SearchDetails = stockItem.SearchDetails, Size = stockItem.Size, StockItemID = stockItem.StockItemID, StockItemName = stockItem.StockItemName, SupplierID = stockItem.SupplierID, Tags = stockItem.Tags, TaxRate = stockItem.TaxRate, TypicalWeightPerUnit = stockItem.TypicalWeightPerUnit, UnitPackageID = stockItem.UnitPackageID, UnitPrice = stockItem.UnitPrice, ValidFrom = stockItem.ValidFrom, ValidTo = stockItem.ValidTo }); } return(ListOfStockItemsDTO); } }
public GetStateProvincesResponse GetStateProvinces(GetStateProvincesRequest request) { XmlConfigurator.Configure(); var log = LogManager.GetLogger(typeof(StateProvincesService)); log.Info("GetStateProvinces started"); var provinces = new List <entities.StateProvince>(); var useCache = bool.Parse(ConfigurationManager.AppSettings["UseCache"]); if (useCache == false || _StateProvinces == null) { var stopwatch = Stopwatch.StartNew(); var context = new WideWorldImportersEntities(); foreach (var province in context.StateProvinces) { provinces.Add(new entities.StateProvince { CountryIsoCode = province.Country.IsoAlpha3Code, StateProvinceCode = province.StateProvinceCode, StateProvinceName = province.StateProvinceName }); } log.Info("GetStateProvinces data load took: " + stopwatch.ElapsedMilliseconds + "ms"); if (useCache) { _StateProvinces = provinces; } } var response = new GetStateProvincesResponse { StateProvinces = useCache ? _StateProvinces : provinces }; log.Info("GetStateProvinces returning: " + response.StateProvinces.Count() + " provinces; using cache: " + useCache); return(response); }
public async Task <List <OrderLines> > GetOrderLinesAsync() { List <OrderLines> ordersLines = null; string SqlQuery = "EXEC Sales.SP_GetOrderLines"; try { using (_DbModelEntities = new WideWorldImportersEntities(_connectionString)) { using (var objectContext = ((IObjectContextAdapter)_DbModelEntities).ObjectContext) { var objectResult = await objectContext.ExecuteStoreQueryAsync <OrderLines>(SqlQuery); ordersLines = objectResult.Take(10).ToList(); } } return(ordersLines); } catch (Exception ex) { throw; } }
public CustomerService(WideWorldImportersEntities db) : base(db) { }
public CategoryService(WideWorldImportersEntities db) : base(db) { }
public ServiceBase(WideWorldImportersEntities db) { Context = db; }