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