private async Task <int> AddOrRemoveCart(Cosmetics cosmetics, int qty)
{
var shoppingCartItem = await _context.ShoppingCartItems
.SingleOrDefaultAsync(s => s.CosmeticsId == cosmetics.Id && s.ShoppingCartId == Id);
if (shoppingCartItem == null)
{
shoppingCartItem = new ShoppingCartItem
{
ShoppingCartId = Id,
Cosmetics = cosmetics,
Qty = 0
};
await _context.ShoppingCartItems.AddAsync(shoppingCartItem);
}
shoppingCartItem.Qty += qty;
if (shoppingCartItem.Qty <= 0)
{
shoppingCartItem.Qty = 0;
_context.ShoppingCartItems.Remove(shoppingCartItem);
}
await _context.SaveChangesAsync();
ShoppingCartItems = null; // Reset
return(await Task.FromResult(shoppingCartItem.Qty));
}
public void Delete(int id)
{
var cosmetics = new Cosmetics {
Id = id
};
_context.Entry(cosmetics).State = EntityState.Deleted;
}
/**
* Returns results of search the jobs data by key/value, using
* inclusion of the search term.
*/
public List <Cosmetic> FindByColumnAndValue(CosmeticFieldType column, string value)
{
IList <Cosmetic> cosmetics = Cosmetics
.Include(f => f.Finish)
.Include(c => c.Color)
.Include(c => c.Formulation)
.Include(r => r.Rating)
.Include(s => s.SkinType)
.ToList();
var results = from j in cosmetics
where GetFieldByType(j, column).Contains(value)
select j;
return(results.ToList());
}
public List <Cosmetic> FindByValue(string value)
{
var results = from j in Cosmetics.Include(c => c.Color)
.Include(c => c.Formulation)
.Include(c => c.SkinType)
.Include(c => c.Rating)
.Include(c => c.Finish)
.ToList()
where j.Color.Contains(value) ||
j.Finish.Contains(value) ||
j.Name.ToLower().Contains(value.ToLower()) ||
j.Formulation.Contains(value) ||
j.Rating.Contains(value) ||
j.SkinType.Contains(value)
select j;
return(results.ToList());
}
public async Task AddCosmeticsAsync(Cosmetics cosmetics)
{
await _context.cosmetics.AddAsync(cosmetics);
}
public void UpdateCosmetics(Cosmetics cosmetics)
{
_context.cosmetics.Update(cosmetics);
}
private void Cosmeticsbutton_Click(object sender, EventArgs e)
{
Cosmetics main = new Cosmetics();
main.Show();
}
public async Task <int> RemoveFromCartAsync(Cosmetics cosmetics)
{
return(await AddOrRemoveCart(cosmetics, -1));
}
public async Task <int> AddToCartAsync(Cosmetics cosmetics, int qty = 1)
{
return(await AddOrRemoveCart(cosmetics, qty));
}
