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