//-- Update public bool Update(int id, SpecificLiquorCreate updatedSpecificLiquor) { SpecificLiquor specificLiquor = _context.SpecificLiquors.Find(id); specificLiquor.Name = updatedSpecificLiquor.Name; specificLiquor.Liquor = ConvertFromStringToLiquor(updatedSpecificLiquor.Liquor); specificLiquor.Brand = updatedSpecificLiquor.Brand; specificLiquor.CountryOfOrigin = updatedSpecificLiquor.CountryOfOrigin; return(_context.SaveChanges() == 1); }
//-- Create public bool AddSpecificLiquor(SpecificLiquorCreate model) { var entity = new SpecificLiquor { Name = model.Name, Liquor = ConvertFromStringToLiquor(model.Liquor), Brand = model.Brand, CountryOfOrigin = model.CountryOfOrigin }; _context.SpecificLiquors.Add(entity); return(_context.SaveChanges() == 1); }
// helper public bool IsSpecificLiquorInDatabase(SpecificLiquorCreate model) { var liquor = ConvertFromStringToLiquor(model.Liquor); SpecificLiquor query = _context.SpecificLiquors.SingleOrDefault(q => q.Name == model.Name && q.Brand == model.Brand && q.CountryOfOrigin == model.CountryOfOrigin && q.Liquor.Type == liquor.Type && q.Liquor.Subtype == liquor.Subtype); if (query != null) { return(true); } return(false); }
//-- Get By ID public SpecificLiquorListItem GetById(int id) { SpecificLiquor entity = _context.SpecificLiquors.Find(id); if (entity is null) { return(null); } return(new SpecificLiquorListItem { Id = entity.Id, Name = entity.Name, Liquor = ConvertFromLiquorToString(entity.Liquor), Brand = entity.Brand, CountryOfOrigin = entity.CountryOfOrigin }); }
//-- Get All From Country public List <SpecificLiquorListItem> GetByCountry(string country) { List <SpecificLiquorListItem> specificLiquorList = _context.SpecificLiquors.Where(e => e.CountryOfOrigin.ToLower() == country.ToLower()).Select(s => new SpecificLiquorListItem { Id = s.Id, Name = s.Name, Brand = s.Brand, CountryOfOrigin = s.CountryOfOrigin }).ToList(); foreach (SpecificLiquorListItem item in specificLiquorList) { SpecificLiquor specificLiquor = _context.SpecificLiquors.Find(item.Id); item.Liquor = ConvertFromLiquorToString(specificLiquor.Liquor); } return(specificLiquorList); }
// helper public bool NoChangesWereMade(int id, SpecificLiquorCreate model) { SpecificLiquor liquor = _context.SpecificLiquors.Find(id); return(liquor.Name == model.Name && liquor.Brand == model.Brand && liquor.CountryOfOrigin == model.CountryOfOrigin && ConvertFromLiquorToString(liquor.Liquor) == model.Liquor); }