public void Insert(Favour model)
{
model.ID = new aers_sys_seedSqlMapDao().GetMaxID("Favor"); //2017.6.23 YM单词能不能统一起来 shi
String stmtId = "Favour_Insert"; // Message_Insert
ExecuteInsert(stmtId, model);
}
private async Task <int> AddOrRemoveCart(Favour favour, int qty)
{
var shoppingCartItem = await _context.ShoppingCartItems
.SingleOrDefaultAsync(s => s.FavourId == favour.Id && s.ShoppingCartId == Id);
if (shoppingCartItem == null)
{
shoppingCartItem = new ShoppingCartItem
{
ShoppingCartId = Id,
Favour = favour,
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));
}
private FavourModel GetModelByFavour(Favour favour)
{
return(new FavourModel
{
Id = favour.Id,
Name = favour.Name,
Cost = favour.Cost
});
}
public async Task Create(Favour favour)
{
using (var conn = Connection)
{
conn.Open();
await conn.ExecuteAsync($@"
insert favour (name, cost)
values (@{nameof(Favour.Name)}, @{nameof(Favour.Cost)})
", favour);
}
}
public async Task Update(Favour favour)
{
using (var conn = Connection)
{
conn.Open();
await conn.ExecuteAsync($@"
update favour
set name = @{nameof(Favour.Name)},
cost = @{nameof(Favour.Cost)}
where favour = @{nameof(Favour.Id)}
", favour);
}
}
public async Task <int> RemoveFromCartAsync(Favour favour)
{
return(await AddOrRemoveCart(favour, -1));
}
public async Task <int> AddToCartAsync(Favour favour, int qty = 1)
{
return(await AddOrRemoveCart(favour, qty));
}
public void Update(Favour model)
{
String stmtId = "Favour_Update";
ExecuteUpdate(stmtId, model);
}
public void Delete(int id)
{
var favour = new Favour { Id = id };
_context.Entry(favour).State = EntityState.Deleted;
}
public async Task AddFavourAsync(Favour favour)
{
await _context.Favours.AddAsync(favour);
}
public void UpdateFavour(Favour favour)
{
_context.Favours.Update(favour);
}
