/// <summary>
/// Método para inserir um novo veículo no banco
/// </summary>
/// <param name="model"></param>
/// <param name="brand"></param>
/// <param name="year"></param>
/// <param name="type"></param>
/// <param name="cor"></param>
public void NewVehicle(string model, string brand, string year, EnumType?type, Cor cor)
{
Vehicle vehicle = new Vehicle();
vehicle.model = model;
vehicle.brand = brand;
vehicle.year = year;
vehicle.type = type;
MyDb.Attach(cor);
vehicle.cor = cor;
MyDb.Vehicle.Add(vehicle);
//Roda o SQL no banco
MyDb.SaveChanges();
///inicia uma transação roda o sql commita e faz rollback em caso de erro
//try {
// MyDb.Database.BeginTransaction();
//
// MyDb.SaveChanges();
// MyDb.Database.CommitTransaction();
//}
//catch (Exception) {
// MyDb.Database.RollbackTransaction(); ;
//}
}
public IActionResult DeleteDoctor([FromRoute]int id)
{
var d = new Doctor
{
IdDoctor = id
};
_myDBContext.Attach(d);
_myDBContext.Remove(d);
_myDBContext.SaveChanges();
return Ok();
}
public async Task Update(T oldEntity, T entity)
{
if (entity == null)
{
throw new ArgumentNullException(nameof(entity));
}
var contextEntry = DbContext.Entry <T>(oldEntity);
contextEntry.State = EntityState.Detached;
DbContext.Attach(entity);
DbContext.Set <T>().Update(entity);
await DbContext.SaveChangesAsync();
}
