//updating one airline
public void Update(AirlineCompanie t)
{
string SqlCommand = "Update_One_airline";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand(SqlCommand, con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter(@"id", t._Id));
cmd.Parameters.Add(new SqlParameter(@"_AirLine_Name", t._AirLine_Name));
cmd.Parameters.Add(new SqlParameter(@"_User_Name", t._User_Name));
cmd.Parameters.Add(new SqlParameter(@"_Password", t._Password));
cmd.Parameters.Add(new SqlParameter(@"_First_Name", t._First_Name));
cmd.Parameters.Add(new SqlParameter(@"_Last_Name", t._Last_Name));
cmd.Parameters.Add(new SqlParameter(@"_Email", t._Email));
cmd.Parameters.Add(new SqlParameter(@"_Phone_Number", t._Phone_Number));
cmd.Parameters.Add(new SqlParameter(@"_Area_Code", t._Area_Code));
cmd.Parameters.Add(new SqlParameter(@"_Country_Code", t._Country_Code));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection.Close();
}
}
}
public void MofidyAirlineDetails(LoginToken <AirLineCompanyLogin> token, AirlineCompanie airline)
{
if (token.User.GetAirLineCompanyr())
{
_airlineDAO.Update(airline);
}
}
//delete one airline from database
public void Remove(AirlineCompanie t)
{
string SqlCommand = "Remove_One_Airline";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand(SqlCommand, con);
try
{
cmd.Connection.Open();
cmd.Parameters.Add(new SqlParameter(@"id", t._Id));
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection.Close();
}
}
}
public void UpdateAirlineDetails(LoginToken <AdministratorLogin> token, AirlineCompanie airline)
{
if (token.User.GetAdministrator())
{
_airlineDAO.Update(airline);
}
}
public void RemoveAirline(LoginToken <AdministratorLogin> token, AirlineCompanie airline)
{
if (token.User.GetAdministrator())
{
_airlineDAO.Remove(airline);
}
}
public AirlineCompanie GetAirlineByUesrName(LoginToken <AirLineCompanyLogin> token, string name)
{
AirlineCompanie airline = new AirlineCompanie();
if (token.User.GetAirLineCompanyr())
{
return(airline = _airlineDAO.GetAirlineByUserName(name));
}
return(null);
}
public IHttpActionResult MofidyAirlineDetails([FromBody] AirlineCompanie airline)
{
try
{
FlyingCenterSystem fly = FlyingCenterSystem.GetInstance();
LoginToken <AirLineCompanyLogin> token = new LoginToken <AirLineCompanyLogin>();
string _name = Request.GetRequestContext().Principal.Identity.Name;
string _pass = Thread.CurrentPrincipal.Identity.Name;
fly.GetAirlineFacade(_name, _pass, out token).MofidyAirlineDetails(token, airline);
return(Ok());
}
catch (Exception ex)
{
log.Error(ex);
log.Info(ex.StackTrace);
return(BadRequest(ex.Message));
}
}
public IHttpActionResult DeleteAirlineFromRedis(string key, AirlineCompanie airline)
{
string myMail = "*****@*****.**";
try
{
var host = "LocalHost";
SetRedis.Remove(host, key);
SendGridServ.Execute(myMail, airline._Email, airline._AirLine_Name, "Email response", "Better luck next time");
return(Ok());
}
catch (Exception ex)
{
log.Error(ex);
log.Info(ex.StackTrace);
return(BadRequest(ex.Message));
}
}
//get all airlines by country name
public IList <AirlineCompanie> GetAllAirlinesByCountry(int countryId)
{
List <AirlineCompanie> list = new List <AirlineCompanie>();
string SqlCommand = "Get_All_Airlines_By_Country";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand(SqlCommand, con);
try
{
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default);
cmd.Parameters.Add(new SqlParameter(@"Country_Code", countryId));
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
while (reader.Read() == true)
{
AirlineCompanie airline = new AirlineCompanie();
airline._Id = (int)reader["Id"];
airline._AirLine_Name = (string)reader["AirLine_Name"];
airline._User_Name = (string)reader["User_Name"];
airline._Password = (string)reader["Password"];
airline._First_Name = (string)reader["First_Name"];
airline._Last_Name = (string)reader["Last_Name"];
airline._Email = (string)reader["Email"];
airline._Phone_Number = (int)reader["Phone_Number"];
airline._Area_Code = (int)reader["Area_Code"];
airline._Country_Code = (int)reader["Country_Code"];
list.Add(airline);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection.Close();
}
}
}
public IHttpActionResult GetAirlineRedis([FromBody] AirlineCompanie airline)
{
try
{
string host = "LocalHost";
string key = "key" + SetRedis.airlineNum++;
if (SetRedis.airlineNum == 20)
{
SetRedis.airlineNum = 0;
}
SetRedis.setToRedis(host, key, airline.ToString());
return(Ok());
}
catch (Exception ex)
{
log.Error(ex);
log.Info(ex.StackTrace);
return(BadRequest(ex.Message));
}
}
public IHttpActionResult CreateNewAirline([FromBody] AirlineCompanie airline)
{
string myMail = "*****@*****.**";
try
{
FlyingCenterSystem fly = FlyingCenterSystem.GetInstance();
LoginToken <AdministratorLogin> token = new LoginToken <AdministratorLogin>();
string _name = Request.GetRequestContext().Principal.Identity.Name;
string _pass = Thread.CurrentPrincipal.Identity.Name;
fly.GetAdministratorFacad(_name, _pass, out token).CreateNewAirline(token, airline);
SendGridServ.Execute(myMail, airline._Email, airline._AirLine_Name, "Welcome to the site", "Welcome to the site");
return(Ok());
}
catch (Exception ex)
{
log.Error(ex);
log.Info(ex.StackTrace);
return(BadRequest(ex.Message));
}
}
{/// <summary>
/// This class handle connecttion to Dao Administrator functions
/// </summary>
/// <param name="token"></param>
/// <param name="airline"></param>
public void CreateNewAirline(LoginToken <AdministratorLogin> token, AirlineCompanie airline)
{
{ _airlineDAO.Add(airline); }
}
