/// <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(); }