public WhiskeyType CreateWhiskeyType(WhiskeyType whiskeyType) { var wt = _WSctx.WhiskeyTypes.Add(whiskeyType).Entity; _WSctx.SaveChanges(); return(wt); }
public ActionResult <WhiskeyType> Post([FromBody] WhiskeyType whiskeyType) { try { return(Ok(_wtService.CreateWhiskeyType(whiskeyType))); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public WhiskeyType CreateWhiskeyType(WhiskeyType whiskeyType) { if (string.IsNullOrEmpty(whiskeyType.TypeName)) { throw new Exception("The Whiskey type must be defined"); } else { return(_wTypeRepo.CreateWhiskeyType(whiskeyType)); } }
public ActionResult <WhiskeyType> Patch(int id, [FromBody] WhiskeyType whiskeyType) { try { whiskeyType.Id = id; return(Ok(_wtService.Update(whiskeyType))); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void CreateWhiskeyTypeWithTypeNameMissing() { var whiskeyTypeRepo = new Mock <IWhiskeyTypeRepository>(); IWhiskeyTypeService service = new WhiskeyTypeService(whiskeyTypeRepo.Object); var whiskeyType = new WhiskeyType() { // No WhiskeyType name }; Exception ex = Assert.Throws <Exception>(() => service.CreateWhiskeyType(whiskeyType)); Assert.Equal("The Whiskey type must be defined", ex.Message); }
/// <summary> /// Query for the advanced search. /// </summary> public async Task <IEnumerable <WhiskeyBase> > GetAllWhiskeysSearch(string searchName, string searchBrand, string searchCountry, bool searchForType, WhiskeyType searchType, bool searchRangeAge, int searchAge1, int searchAge2, bool searchRangePrice, decimal searchPrice1, decimal searchPrice2, bool searchRangePercent, decimal searchPercent1, decimal searchPercent2, bool includeSoftDelete) { var query = from w in db.Whiskeys where (includeSoftDelete || w.SoftDeleted == false) where (string.IsNullOrEmpty(searchName) || w.Name.Contains(searchName)) where (string.IsNullOrEmpty(searchBrand) || w.Brand.Contains(searchBrand)) where (string.IsNullOrEmpty(searchCountry) || w.CountryOfOrigin.Name.Contains(searchCountry)) where (!searchForType || w.Type == searchType) where (!searchRangeAge && (searchAge1 == 0 || w.AgeYears == searchAge1) || (w.AgeYears >= searchAge1 && w.AgeYears <= searchAge2)) where (!searchRangePrice && (searchPrice1 == 0 || w.Price == searchPrice1) || (w.Price >= searchPrice1 && w.Price <= searchPrice2)) where (!searchRangePercent && (searchPercent1 == 0 || w.Percentage == searchPercent1) || (w.Percentage >= searchPercent1 && w.Percentage <= searchPercent2)) orderby w.Name select w; return(await query.ToListAsync()); }
public async Task <IEnumerable <Whiskey> > GetByType(WhiskeyType whiskeyType) => await _db.Whiskeys .Where(w => w.WhiskeyType.Name == whiskeyType.Name) .Select(w => w).ToListAsync();
public WhiskeyType Update(WhiskeyType whiskeyType) { return(_wTypeRepo.Update(whiskeyType)); }
public WhiskeyType Update(WhiskeyType whiskeyType) { _WSctx.Attach(whiskeyType).State = EntityState.Modified; _WSctx.SaveChanges(); return(whiskeyType); }