internal async Task <Tuple <Status, string> > TryDeleteModel(string make, string model) { Vehicle_Models chosenModel = dBase.Vehicle_Models.FirstOrDefault(id => id.Model_Name == model); int modelId = chosenModel.Model_ID; bool types = false, vehicles = false, rentals = false; if (dBase.Vehicle_Types.FirstOrDefault(carModel => carModel.Make_ID == modelId) != null) { types = true; } if (dBase.Vehicles.FirstOrDefault(carModel => carModel.Vehicle_Types.Make_ID == modelId) != null) { vehicles = true; } if (dBase.Rentals.FirstOrDefault(carModel => carModel.Vehicle.Vehicle_Types.Make_ID == modelId) != null) { rentals = true; } if (types || vehicles || rentals) { string error = concatErrorString(types, vehicles, rentals); return(new Tuple <Status, string>(Status.Failure, error)); } else { dBase.Vehicle_Models.Remove(chosenModel); await dBase.SaveChangesAsync(); return(new Tuple <Status, string>(Status.Success, model + " Deleted")); } }
private async Task <Tuple <Status, string> > TryAddModelToDB(string model, int makeID, string make) { Vehicle_Models added = dBase.Vehicle_Models.Add(new Vehicle_Models() { Model_Name = model, Make_ID = makeID }); if (added != null) { await dBase.SaveChangesAsync(); return(new Tuple <Status, string>(Status.Success, $" {model} Successfully Added To The {make}'s")); } else { return(new Tuple <Status, string>(Status.Failure, "Something Went Wrong")); } }