public static string AddCarTypeTo_db(BOLCarType carType) { try { CarsType isExist = ValidateCarInput.IsExist(carType); if (isExist == null) { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { ef.CarsTypes.Add(new CarsType { ManufacturerName = carType.ManufacturerName, Model = carType.Model, DailyCost = carType.DailyCost, CostDayOverdue = carType.CostDayOverdue, ManufactureYear = carType.ManufactureYear, Gear = carType.Gear }); ef.SaveChanges(); return("OK"); } } else { throw new InvalidOperationException($"this car type is already exist please change the values and try again"); } } catch { return("this car type is already exist please change the values and try again"); } }
internal static CarsType IsExist(BOLCarType carType) { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { CarsType carTipe = ef.CarsTypes.FirstOrDefault(u => u.ManufacturerName == carType.ManufacturerName && u.Model == carType.Model && u.ManufactureYear == carType.ManufactureYear && u.Gear == carType.Gear && u.DailyCost == carType.DailyCost); if (carTipe != null) { return(carTipe); } else { return(carTipe); } } }
public static string UpDataCarTypeTo_db(BOLCarType oldCarType, BOLCarType newCarType) { CarsType isExist = ValidateCarInput.IsExist(oldCarType); try { if (isExist != null) { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { CarsType isTheNewExist = ValidateCarInput.IsExist(newCarType); if (isTheNewExist == null) { CarsType dbUser = ef.CarsTypes.FirstOrDefault(u => u.CarTypeID == isExist.CarTypeID); dbUser.ManufacturerName = newCarType.ManufacturerName; dbUser.Model = newCarType.Model; dbUser.DailyCost = newCarType.DailyCost; dbUser.ManufactureYear = newCarType.ManufactureYear; dbUser.Gear = newCarType.Gear; ef.SaveChanges(); return("Ok"); } else { return("this car type is already exist please change the values and try again"); } } } else { throw new InvalidOperationException($"this car type is not exist please change the values and try again"); } } catch { return("this car type is not exist please change the values and try again"); } }
public static BOLCarType GetCarsTypeFrom_db(string name, string model, string gear) { try { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { CarsType typeModel = ef.CarsTypes.FirstOrDefault(u => u.ManufacturerName == name && u.Model == model && u.Gear == gear); BOLCarType a = new BOLCarType { ManufacturerName = typeModel.ManufacturerName, Model = typeModel.Model, DailyCost = typeModel.DailyCost, CostDayOverdue = typeModel.CostDayOverdue, ManufactureYear = typeModel.ManufactureYear, Gear = typeModel.Gear }; return(a); } } catch { return(null); } }
public IHttpActionResult Post([FromBody] BOLCarType newCarType) { RentTypeOfCars.AddCarTypeTo_db(newCarType); return(Ok()); }