public async Task <VehicleMake> AddNewVehicleMake(VehicleMake vehicle) { context.Add(vehicle); await context.SaveChangesAsync(); return(vehicle); }
public async Task <VehicleMake> UpdateVehicleMake(VehicleMake vehicleMakeChanges) { var vehicle = context.vehicleMakes.Attach(vehicleMakeChanges); vehicle.State = Microsoft.EntityFrameworkCore.EntityState.Modified; await context.SaveChangesAsync(); return(vehicleMakeChanges); }
public async Task <int> AddMake(VehicleMake make) { if (db != null) { db.vehicleMakes.Add(make); await db.SaveChangesAsync(); return(make.ID); } return(0); }
public async Task <int> UpdateMake(VehicleMake make) { if (db != null) { //Update that model //db.vehicleModels.Update(model); db.Entry(make).State = EntityState.Modified; //Commit the transaction await db.SaveChangesAsync(); return(make.ID); } return(0); }
public async Task <VehicleMake> DeleteVehicleMake(int id) { VehicleMake vehicle = await context.vehicleMakes.FindAsync(id); if (vehicle != null) { //context.Remove(vehicle_fk); var commandText = "delete from VehicleModel where MakeId = @id"; var vehicle_model = new SqlParameter("@id", id); context.Database.ExecuteSqlCommand(commandText, vehicle_model); context.vehicleMakes.Remove(vehicle); await context.SaveChangesAsync(); } return(vehicle); }