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