public async Task AddAsync_Gets_Added() { var newGlass = new Glass { Name = "newGlass" + DateTime.Now.Ticks}; await _glassRepository.AddAsync(newGlass); var glasses = await _glassRepository.GetAllAsync(); Assert.True(glasses.Any(o => o.Name == newGlass.Name)); }
public void Add_Hop_Id_Gets_Set() { var newGlass = new Glass { Name = "newGlass" + DateTime.Now.Ticks}; _glassRepository.Add(newGlass); var other = _glassRepository.GetSingle(newGlass.GlassId); Assert.NotNull(other); }
public void Add_Gets_Added() { var newGlass = new Glass {Name = "newGlass" + DateTime.Now.Ticks}; _glassRepository.Add(newGlass); var glasses = _glassRepository.GetAll(); Assert.True(glasses.Any(o => o.Name == newGlass.Name)); }
public virtual void Remove(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Deleted; context.SaveChanges(); } }
public virtual void Update(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Modified; context.SaveChanges(); } }
public void Update(Glass glass) { using (var context = DapperHelper.GetConnection()) { context.Open(); using (var transaction = context.BeginTransaction()) { context.Execute(@"UPDATE Glasses set Name = @Name WHERE GlassId = @GlassId", new { glass.Name, glass.GlassId }, transaction); transaction.Commit(); } } }
public void Remove(Glass glass) { using (var context = DapperHelper.GetConnection()) { context.Open(); using (var transaction = context.BeginTransaction()) { context.Execute(@"DELETE FROM Glasses WHERE GlassId = @GlassId;", new { glass.GlassId }, transaction); transaction.Commit(); } } }
public void Add(Glass glass) { using (var context = DapperHelper.GetConnection()) { context.Open(); using (var transaction = context.BeginTransaction()) { var glassId = context.Query<int>("SELECT MAX(GlassId) FROM Glasses",transaction: transaction); glass.GlassId = glassId.SingleOrDefault() + 1; context.Query<int>(@"INSERT Glasses(GlassId,Name) VALUES(@GlassId,@Name);", new { glass.Name, glass.GlassId }, transaction); transaction.Commit(); } } }
public void Add(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Added; try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public async Task RemoveAsync_Gets_Removed() { var newGlass = new Glass { Name = "newGlass" + DateTime.Now.Ticks}; await _glassRepository.AddAsync(newGlass); await _glassRepository.RemoveAsync(newGlass); var glasses = await _glassRepository.GetAllAsync(); Assert.True(glasses.All(o => o.GlassId != newGlass.GlassId)); }
public void Remove_Gets_Removed() { var newGlass = new Glass { Name = "newGlass" + DateTime.Now.Ticks}; _glassRepository.Add(newGlass); _glassRepository.Remove(newGlass); var glasses = _glassRepository.GetAll(); Assert.True(glasses.All(o => o.GlassId != newGlass.GlassId)); }
public async Task<int> UpdateAsync(Glass glass) { using (var context = DapperHelper.GetConnection()) { context.Open(); using (var transaction = context.BeginTransaction()) { var result = await context.ExecuteAsync(@"UPDATE Glasses set Name = @Name WHERE GlassId = @GlassId", new { glass.Name, glass.GlassId }, transaction); transaction.Commit(); return result; } } }
public virtual async Task RemoveAsync(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Deleted; try { await context.SaveChangesAsync(); } catch (Exception e) { Log.Debug(e); throw; } } }
public virtual async Task<int> UpdateAsync(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Modified; try { return await context.SaveChangesAsync(); } catch (Exception e) { throw; } } }
public virtual async Task AddAsync(Glass glass) { using (var context = new MicrobrewitContext()) { context.Entry(glass).State = EntityState.Added; try { await context.SaveChangesAsync(); } catch (DbEntityValidationException dbEx) { //foreach (var validationErrors in dbEx.EntityValidationErrors) //{ // foreach (var validationError in validationErrors.ValidationErrors) // { // Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // throw dbEx; // } //} throw; } catch (Exception ex) { throw; } } }