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