public string InsertCarInfo(Car_Info car_Info)
{
string queryString = $@"INSERT INTO Car_Info (C_Brand,C_Image,C_Engine,C_Battery,C_Coolant,C_Fuel,C_AirConditioning,C_PowerTrain,C_Braking,C_Tires,C_Steering,UId) VALUES
('{car_Info.C_Brand}'
,'{car_Info.C_Image}'
,'{car_Info.C_Engine}'
,'{car_Info.C_Battery}'
,'{car_Info.C_Coolant}'
,'{car_Info.C_Fuel}'
,'{car_Info.C_AirConditioning}'
,'{car_Info.C_PowerTrain}'
,'{car_Info.C_Braking}'
,'{car_Info.C_Tires}'
,'{car_Info.C_Steering}'
,{car_Info.UId})";
var data = _db.ExecuteString <int>(queryString);
if (data != 0)
{
return("CarInfoAdd Succes.");
}
else
{
return("CarInfoAdd failed.");
}
}
public string UpdateCarinfo(Car_Info car_Info)
{
string queryString = $@"UPDATE Car_Info SET C_Brand='{car_Info.C_Brand}',
C_Image='{car_Info.C_Image}',
C_Engine='{car_Info.C_Engine}',
C_Battery='{car_Info.C_Battery}',
C_Coolant='{car_Info.C_Coolant}',
C_Fuel='{car_Info.C_Fuel}',
C_AirConditioning='{car_Info.C_AirConditioning}',
C_PowerTrain='{car_Info.C_PowerTrain}',
C_Braking='{car_Info.C_Braking}',
C_Tires='{car_Info.C_Tires}',
C_Steering='{car_Info.C_Steering}',
UId={car_Info.UId}
Where C_Id = {car_Info.C_Id}";
var data = _db.ExecuteString <int>(queryString);
if (data != 0)
{
return("Update Car Information success.");
}
else
{
return("Update CarInformation failed.");
}
}
public IActionResult UpdateCarinfo([FromForm] Car_Info car_Info)
{
try
{
string pathImage = Path.Combine(Directory.GetCurrentDirectory(), $@"wwwroot/images/{car_Info.FileImage.FileName}");
using (var stream = new FileStream(pathImage, FileMode.Create))
{
car_Info.FileImage.CopyTo(stream);
}
car_Info.C_Image = _url + car_Info.FileImage.FileName;
var result = carInfoService.UpdateCarinfo(car_Info);
return(StatusCode(StatusCodes.Status200OK, result));
}
catch (Exception e)
{
return(StatusCode
(StatusCodes.Status500InternalServerError, e.Message));
}
}
