internal async Task <Tuple <Status, string> > AddMake(string make) { Vehicle_Makes result = dBase.Vehicle_Makes.FirstOrDefault(name => name.Make_Name.ToLower() == make.ToLower()); if (result == null) { Vehicle_Makes added = dBase.Vehicle_Makes.Add(new Vehicle_Makes() { Make_Name = make }); if (added != null) { dBase.Vehicle_Makes.OrderBy(x => x.Make_Name); await dBase.SaveChangesAsync(); return(new Tuple <Status, string>(Status.Success, $" {make} Successfully Added")); } else { return(new Tuple <Status, string>(Status.Failure, "Something Went Wrong")); } } else { return(new Tuple <Status, string>(Status.Failure, $" {make} Already Exists")); } }
internal async Task <Tuple <Status, string> > TryDeleteMake(string make) { Vehicle_Makes chosenMake = dBase.Vehicle_Makes.FirstOrDefault(id => id.Make_Name == make); int makeId = chosenMake.Make_ID; bool models = false, types = false, vehicles = false, rentals = false; if (dBase.Vehicle_Models.FirstOrDefault(model => model.Make_ID == makeId) != null) { models = true; } if (dBase.Vehicle_Types.FirstOrDefault(model => model.Make_ID == makeId) != null) { types = true; } if (dBase.Vehicles.FirstOrDefault(model => model.Vehicle_Types.Make_ID == makeId) != null) { vehicles = true; } if (dBase.Rentals.FirstOrDefault(model => model.Vehicle.Vehicle_Types.Make_ID == makeId) != null) { rentals = true; } if (models || types || vehicles || rentals) { string error = concatErrorString(models, types, vehicles, rentals); return(new Tuple <Status, string>(Status.Failure, error)); } else { dBase.Vehicle_Makes.Remove(chosenMake); await dBase.SaveChangesAsync(); return(new Tuple <Status, string>(Status.Success, make + " Deleted")); } }