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