private int GetWagonConfigId(int id)
{
WagonEntity wagonEntity = _context.Wagons.Find(id);
return(_context.WagonConfig.Where(x => x.WagonConfigId == wagonEntity.WagonConfigId)
.Select(x => x.WagonConfigId).SingleOrDefault());
}
public WagonEntity Update(JObject entity, int id)
{
WagonEntity existingWagon = _context.Wagons.Find(id);
JToken value;
if (entity.TryGetValue("number", StringComparison.OrdinalIgnoreCase, out value) && (value.Type == JTokenType.Integer))
{
existingWagon.Number = value.Value <int>();
}
if (entity.TryGetValue("numberOfPlaces", StringComparison.OrdinalIgnoreCase, out value) && (value.Type == JTokenType.Integer))
{
existingWagon.NumberOfPlaces = value.Value <int>();
}
if (entity.TryGetValue("trainId", StringComparison.OrdinalIgnoreCase, out value) && (value.Type == JTokenType.Integer))
{
existingWagon.TrainId = value.Value <int>();
}
if (entity.TryGetValue("wagonConfigId", StringComparison.OrdinalIgnoreCase, out value) && (value.Type == JTokenType.Integer))
{
existingWagon.WagonConfigId = value.Value <int>();
}
_context.Wagons.Update(existingWagon);
_context.SaveChanges();
return(existingWagon);
}
public Wagon UpdateWagon(JObject item, int id)
{
WagonEntity wagonEntity = _wagonRepository.Update(item, id);
if (wagonEntity != null)
{
return(_wagonRepository.GetById(id).ToDomain());
}
else
{
return(null);
}
}
public void Delete(int id)
{
using var transaction = _context.Database.BeginTransaction();
try
{
WagonEntity wagon = _context.Wagons.FirstOrDefault(item => item.WagonId == id);
_context.Wagons.Remove(wagon);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
}
}
public int Insert(WagonEntity entity)
{
using var transaction = _context.Database.BeginTransaction();
try
{
_context.Wagons.Add(entity);
_context.SaveChanges();
transaction.Commit();
return(entity.WagonId);
}
catch (Exception e)
{
transaction.Rollback();
return(-1);
}
}
public static Wagon ToDomain(this WagonEntity wagon)
{
if (wagon != null)
{
return(new Wagon
{
WagonId = wagon.WagonId,
Number = wagon.Number,
NumberOfPlaces = wagon.NumberOfPlaces,
WagonConfigId = wagon.WagonConfigId
});
}
else
{
return(null);
}
}
