public void Add(Fermentable fermentable)
{
using (var context = new MicrobrewitContext())
{
if (fermentable.Supplier != null)
fermentable.Supplier = null;
context.Entry(fermentable).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 virtual void Update(Fermentable fermentable)
{
using (var context = new MicrobrewitContext())
{
context.Entry(fermentable).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(Fermentable fermentable)
{
using (var context = DapperHelper.GetConnection())
{
context.Open();
using (var transaction = context.BeginTransaction())
{
try
{
var fermentableId =
context.Query<int>("INSERT Fermentables(Name,SuperFermentableId,EBC,Lovibond,PPG,SupplierId,Type,Custom) " +
"VALUES(@Name,@SuperFermentableId,@EBC,@Lovibond,@PPG,@SupplierId,@Type,@Custom);" +
"SELECT CAST(SCOPE_IDENTITY() as int);",
new
{
fermentable.Name,
fermentable.SuperFermentableId,
fermentable.EBC,
fermentable.Lovibond,
fermentable.PPG,
fermentable.SupplierId,
fermentable.Type,
fermentable.Custom,
}, transaction);
fermentable.FermentableId = fermentableId.SingleOrDefault();
transaction.Commit();
}
catch (Exception e)
{
Log.Error(e.ToString());
transaction.Rollback();
throw;
}
}
}
}
public async Task RemoveAsync_Gets_Removed()
{
var newFermentable = new Fermentable { Name = "newFermentable" + DateTime.Now.Ticks, Type = "Grain", Custom = true };
await _fermentableRepository.AddAsync(newFermentable);
await _fermentableRepository.RemoveAsync(newFermentable);
var fermentables = await _fermentableRepository.GetAllAsync(0, 20);
Assert.True(fermentables.All(o => o.FermentableId != newFermentable.FermentableId));
}
public void Remove_Gets_Removed()
{
var newFermentable = new Fermentable { Name = "newFermentable" + DateTime.Now.Ticks, Type = "Grain", Custom = true };
_fermentableRepository.Add(newFermentable);
_fermentableRepository.Remove(newFermentable);
var fermentables = _fermentableRepository.GetAll();
Assert.True(fermentables.All(o => o.FermentableId != newFermentable.FermentableId));
}
public void Add_FermentableId_Gets_Set()
{
var newFermentable = new Fermentable { Name = "newFermentable" + DateTime.Now.Ticks, Type = "Grain", Custom = true };
_fermentableRepository.Add(newFermentable);
var fermentable = _fermentableRepository.GetSingle(newFermentable.FermentableId);
Assert.NotNull(fermentable);
}
public async Task AddAsync_Gets_Added()
{
var newFermentable = new Fermentable { Name = "newFermentable" + DateTime.Now.Ticks, Type = "Grain", Custom = true };
await _fermentableRepository.AddAsync(newFermentable);
var fermentables = await _fermentableRepository.GetAllAsync(0, 20);
Assert.True(fermentables.Any(o => o.Name == newFermentable.Name));
}
public void Add_Gets_Added()
{
var newFermentable = new Fermentable {Name = "newFermentable" + DateTime.Now.Ticks, Type = "Grain", Custom = true};
_fermentableRepository.Add(newFermentable);
var fermentables = _fermentableRepository.GetAll();
Assert.True(fermentables.Any(o => o.Name == newFermentable.Name));
}
public async Task RemoveAsync(Fermentable fermentable)
{
using (var context = DapperHelper.GetConnection())
{
context.Open();
using (var transaction = context.BeginTransaction())
{
try
{
await context.ExecuteAsync("DELETE FROM Fermentables WHERE FermentableId = @FermentableId",
new { fermentable.FermentableId }, transaction);
transaction.Commit();
}
catch (Exception e)
{
Log.Error(e.ToString());
transaction.Rollback();
throw;
}
}
}
}
public async Task<int> UpdateAsync(Fermentable fermentable)
{
using (var context = DapperHelper.GetConnection())
{
context.Open();
using (var transaction = context.BeginTransaction())
{
try
{
var result = await context.ExecuteAsync("Update Fermentables set Name = @Name,SuperFermentableId = @SuperFermentableId,EBC = @EBC,Lovibond = @Lovibond,PPG= @PPG,SupplierId = @SupplierId,Type = @Type, Custom = @Custom " +
"WHERE FermentableId = @FermentableId;",
new
{
fermentable.FermentableId,
fermentable.Name,
fermentable.SuperFermentableId,
fermentable.EBC,
fermentable.Lovibond,
fermentable.PPG,
fermentable.SupplierId,
fermentable.Type,
fermentable.Custom,
}, transaction);
transaction.Commit();
return result;
}
catch (Exception e)
{
Log.Error(e.ToString());
transaction.Rollback();
throw;
}
}
}
}
public virtual async Task RemoveAsync(Fermentable fermentable)
{
using (var context = new MicrobrewitContext())
{
context.Entry(fermentable).State = EntityState.Deleted;
try
{
await context.SaveChangesAsync();
}
catch (Exception e)
{
Log.Debug(e);
throw;
}
}
}
public virtual async Task<int> UpdateAsync(Fermentable fermentable)
{
using (var context = new MicrobrewitContext())
{
context.Entry(fermentable).State = EntityState.Modified;
try
{
return await context.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
}
}
public virtual async Task AddAsync(Fermentable fermentable)
{
using (var context = new MicrobrewitContext())
{
if (fermentable.Supplier != null)
fermentable.Supplier = null;
context.Entry(fermentable).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;
}
}
}
