public IActionResult CreateAirline([FromBody] AirlineModel airline)
{
if (airline == null || airline.Name == null)
{
return(this.Ok(new ResponseModel
{
Success = false,
Message = "Please provide all information."
}));
}
else if (this.Repository.AddAirline(airline) != null)
{
return(this.Ok(new ResponseModel
{
Success = true,
Message = "Successfully added a new airline"
}));
}
else
{
return(this.Ok(new ResponseModel
{
Success = false,
Message = "Airline with name \"" + airline.Name + "\" already exists."
}));
}
}
public ActionResult Create(AirlineModel model)
{
EnsureIncrementInitialized();
// Begin change tracking
_db.BeginChangeTracking();
if (!ModelState.IsValid)
{
return(View(model));
}
var airline = new Airline()
{
Id = (int)_bucket.Increment(IncrementDocument).Value,
Name = model.Name,
Callsign = model.Callsign
};
// Add the document and save the changes
_db.Save(airline);
_db.SubmitChanges();
// Collect mutation state for queries on the next page view
TempData["AirlineMutationState"] = _db.MutationState;
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id, AirlineModel model)
{
// Begin tracking changes
_db.BeginChangeTracking();
// Query must execute after call to BeginChangeTracking()
var query = from p in _db.Query <Airline>()
where p.Id == id
select p;
var airline = query.FirstOrDefault();
if (airline == null)
{
return(HttpNotFound());
}
if (!ModelState.IsValid)
{
return(View(model));
}
// Make changes to document(s) and submit them
airline.Name = model.Name;
airline.Callsign = model.Callsign;
_db.SubmitChanges();
// Collect mutation state for queries on the next page view
TempData["AirlineMutationState"] = _db.MutationState;
return(RedirectToAction("Index"));
}
public AirlinesEdit()
{
InitializeComponent();
Airline = new AirlineModel();
Data.DataContext = Airline;
Title.Content = "CREATION OF AIRLINE DATA";
OldData.Visibility = Visibility.Collapsed;
}
public AirlinesEdit(AirlineModel airline)
{
InitializeComponent();
Airline = airline;
AirlineOld = airline;
Data.DataContext = Airline;
OldData.DataContext = AirlineOld;
Title.Content = "UPDATE OF AIRLINE DATA";
}
private static void CreateNewAirline(SqlCrud sql)
{
// Test Data
var airline = new AirlineModel
{
Name = "Turkish Airlines"
};
sql.CreateAirline(airline);
}
public void CreateAirline(AirlineModel airline)
{
var sql = "USE FlightBookingSystemDB " +
"insert into dbo.Airlines (Name) values (@Name);";
_db.SaveData(sql, new
{
airline.Name
}, _connectionString);;
}
public async Task <AirlineModel> GetAirline(int airlineId)
{
AirlineModel airline = new AirlineModel();
using (var connection = GetOpenConnection())
{
airline = connection.Query <AirlineModel>(
@"select * from Airlines where AirlineId = " + airlineId).FirstOrDefault();
}
return(airline);
}
public static AirlineModel MapToModel(this Airline entity)
{
var airline = new AirlineModel
{
AirlineId = entity.AirlineId,
AirlineName = entity.AirlineName,
NetPrice = entity.NetPrice,
CreateDate = entity.CreateDate,
UpdateDate = entity.UpdateDate
};
return(airline);
}
public static Airline MapToEntity(this AirlineModel model)
{
var airline = new Airline
{
AirlineId = model.AirlineId,
AirlineName = model.AirlineName,
NetPrice = model.NetPrice,
CreateDate = model.CreateDate,
UpdateDate = model.UpdateDate
};
return(airline);
}
public async Task Post([FromBody] AirlineModel airline)
{
using (var connection = GetOpenConnection())
{
string query = "INSERT INTO Airlines (AirlineName, AirlineCode, CountryName) " +
"VALUES(@AirlineName, @AirlineCode, @CountryName)";
SqlCommand cmd = new SqlCommand(query, (SqlConnection)connection);
cmd.Parameters.AddWithValue("@AirlineName", airline.AirlineName);
cmd.Parameters.AddWithValue("@AirlineCode", airline.AirlineCode);
cmd.Parameters.AddWithValue("@CountryName", airline.CountryName);
cmd.ExecuteNonQuery();
}
}
public AirlineModel getAirlineDetails(string id, string AirlineUrl)
{
AirlineModel airlineModels = new AirlineModel();
Uri uri = new Uri(AirlineUrl);
using (HttpClient httpClient = new HttpClient())
{
httpClient.BaseAddress = uri;
httpClient.DefaultRequestHeaders.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var Response = httpClient.GetAsync("api/Airline?id=" + id, HttpCompletionOption.ResponseContentRead);
airlineModels = JsonConvert.DeserializeObject <AirlineModel>(Response.Result.Content.ReadAsStringAsync().Result);
}
return(airlineModels);
}
public ActionResult <AirlineModel> Get(int id)
{
AirlineModel airlineModelobj = new AirlineModel();
var DataObj = airlineModels.Where(x => x.id == Convert.ToInt32(id)).FirstOrDefault();
if (DataObj != null)
{
airlineModelobj.BaseFare = DataObj.BaseFare;
airlineModelobj.TotalSeats = DataObj.TotalSeats;
airlineModelobj.SeatPreference = DataObj.SeatPreference;
airlineModelobj.PriceSeatPref = DataObj.PriceSeatPref;
}
return(airlineModelobj);
}
public AirlineModel AddAirline(AirlineModel airline)
{
if (!this.WriteContext.Airlines.Any(a => a.Name == airline.Name))
{
this.WriteContext.Airlines.Add(new Airline
{
Name = airline.Name,
Flights = null,
AirlinePlanes = null
});
this.WriteContext.SaveChanges();
return(airline);
}
return(null);
}
public async Task PostEdit([FromBody] AirlineModel airline)
{
using (var connection = GetOpenConnection())
{
string query = "UPDATE Airlines " +
"SET AirlineName = @AirlineName, AirlineCode = @AirlineCode, CountryName = @CountryName " +
"WHERE AirlineId = @AirlineId";
SqlCommand cmd = new SqlCommand(query, (SqlConnection)connection);
cmd.Parameters.AddWithValue("@AirlineId", airline.AirlineId);
cmd.Parameters.AddWithValue("@AirlineName", airline.AirlineName);
cmd.Parameters.AddWithValue("@AirlineCode", airline.AirlineCode);
cmd.Parameters.AddWithValue("@CountryName", airline.CountryName);
cmd.ExecuteNonQuery();
}
}
public async Task PostEdit([FromBody] AirlineModel airline)
{
string url = "https://localhost:44393/airlines/edit-airline/";
try
{
using (var httpClient = new HttpClient())
{
var stringContent = new StringContent(JsonConvert.SerializeObject(airline), Encoding.UTF8, "application/json");
using (var response = await httpClient.PostAsync(url, stringContent))
{
await response.Content.ReadAsStringAsync();
}
}
}
catch (Exception e)
{
_logger.LogError("ERROR Editing airline: " + e.Message);
}
}
public ActionResult Create(AirlineModel model)
{
_airlineService.CreateAirline(model);
return(RedirectToAction("Index"));
}
public AirlineViewModel(AirlineModel airline)
{
this.Name = airline.Name;
this.Flights = airline.Flights.Select(b => new FlightViewModel(b)).ToList();
}
public void CreateAirline(AirlineModel model)
{
Insert(model.MapToEntity());
}
public static Airline ToEntity(this AirlineModel model)
{
return(AutoMapperConfiguration.Mapper.Map <AirlineModel, Airline>(model));
}
public static Airline ToEntity(this AirlineModel model, Airline destination)
{
return(AutoMapperConfiguration.Mapper.Map(model, destination));
}
