public async Task <Airplanes> FindAPlane(AirplaneDBO model)
{
try
{
var endpoint = $"airplanes?access_key={_aviationStackKey}&limit=5&engines_type={model.Engine_Type}&engines_count={model.Engine_Count}&plane_age={model.Age}";
var response = await _client.GetAsync(endpoint);
var json = await response.Content.ReadAsStringAsync();
return(JsonSerializer.Deserialize <Airplanes>(json));
}
catch (Exception e)
{
throw e;
}
}
public IActionResult AddPlane(AddPlaneViewModel postModel)
{
var dboPlanes = new AirplaneDBO();
dboPlanes.Name = postModel.Name;
dboPlanes.Have_Ridden = postModel.Have_Ridden;
dboPlanes.Engine_Type = postModel.Engine_Type;
dboPlanes.Age = postModel.Age;
dboPlanes.Description = postModel.Description;
dboPlanes.Does_Exist = postModel.Does_Exist;
dboPlanes.Email_Address = User.Identity.Name;
dboPlanes.Engine_Count = postModel.Engine_Count;
dboPlanes.Plane_Status = postModel.Plane_Status;
dboPlanes.Picture = postModel.Picture;
dboPlanes.Rating = postModel.Rating;
_airplaneRepository.AddAirplane(dboPlanes);
return(RedirectToAction(nameof(Planes)));
}
public IActionResult UpdatePurse(UpdatePlaneViewModel model)
{
var dboPlane = new AirplaneDBO();
dboPlane.Age = model.NewAge;
dboPlane.Description = model.NewDescription;
dboPlane.Does_Exist = model.NewDoes_Exist;
dboPlane.EmailAddress = model.NewEmailAddress;
dboPlane.Engine_Count = model.NewEngine_Count;
dboPlane.Engine_Type = model.NewEngine_Type;
dboPlane.Have_Ridden = model.NewHave_Ridden;
dboPlane.iatacode = model.Newiatacode;
dboPlane.Name = model.NewName;
dboPlane.Picture = model.NewPicture;
dboPlane.Plane_Status = model.NewPlane_Status;
dboPlane.Rating = model.NewRating;
_airplaneRepository.UpdateSelectedPlane(dboPlane);
return(RedirectToAction(nameof(Planes)));
}
public async Task <bool> AddAirplane(AirplaneDBO dboAirplane)
{
var queryString = @$ "INSERT INTO DreamPlanes (Name, IataCode, Description, Email, Engine_Count, Age, Engine_Type, Plane_Status, Have_Ridden, Rating, Picture, Does_Exist, Picture)
VALUES(@{nameof(AirplaneDBO.Name)},@{nameof(AirplaneDBO.iatacode)}, @{nameof(AirplaneDBO.Description)}, @{nameof(AirplaneDBO.EmailAddress)}, @{nameof(AirplaneDBO.Engine_Count)}, @{nameof(AirplaneDBO.Engine_Type)}), @{nameof(AirplaneDBO.Age)},@{nameof(AirplaneDBO.Have_Ridden)},@{nameof(AirplaneDBO.Rating)},@{nameof(AirplaneDBO.Plane_Status)},@{nameof(AirplaneDBO.Picture)},@{nameof(AirplaneDBO.Does_Exist)};";
