//// update airline details in db public void ModifyAirlineDetails(LoginToken <AirLineCompany> token, AirLineCompany airline) { if (ValidUserToken(token)) { _airlineDAO.Update(airline); } }
// get a airline from db by username public AirLineCompany GetAirlineByUsername(string username) { AirLineCompany airLineCompany = null; using (cmd.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd.Connection.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = $"SELECT * FROM AirlineCompanies WHERE USER_NAME = '{username}'"; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { AirLineCompany a = new AirLineCompany { ID = (long)reader["ID"], AirLineName = (string)reader["AIRLINE_NAME"], UserName = (string)reader["USER_NAME"], Password = (string)reader["PASSWORD"], CountryCode = (long)reader["COUNTRY_CODE"] }; airLineCompany = a; } if (airLineCompany == null) { return(null); } return(airLineCompany); } } }
// checking if exist and inserting a new airline to db public long ADD(AirLineCompany t) { SqlCommand cmd2 = new SqlCommand(); lock (key) { { using (cmd.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd.Connection.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = $"SELECT COUNT(*) FROM AirlineCompanies WHERE USER_NAME = '{t.UserName}' OR EXISTS (SELECT USER_NAME FROM Customers WHERE USER_NAME = '{t.UserName}')"; string res = cmd.ExecuteScalar().ToString(); if (res != "0") { throw new AlreadyExistException($"AirlineCompany user name {t.UserName} already exists"); } cmd.Connection.Close(); } using (cmd2.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd2.Connection.Open(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = $"INSERT INTO AirlineCompanies(AIRLINE_NAME, USER_NAME, PASSWORD, COUNTRY_CODE, EMAIL)" + $"values('{ t.AirLineName}', '{ t.UserName}', '{ t.Password}', { t.CountryCode}, '{t.Email}');" + $"SELECT ID FROM AirlineCompanies WHERE USER_NAME = '{t.UserName}'"; t.ID = (long)cmd2.ExecuteScalar(); } return(t.ID); } } }
// get all airline from db with the same country id public IList <AirLineCompany> GetAllAirlineByCountry(long countryid) { IList <AirLineCompany> airLineCompanys = new List <AirLineCompany>(); using (cmd.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd.Connection.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = $"SELECT * FROM AirlineCompanies WHERE COUNTRY_CODE = {countryid} "; using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default)) { while (reader.Read()) { AirLineCompany airLineCompany = new AirLineCompany { ID = (long)reader["ID"], AirLineName = (string)reader["AIRLINE_NAME"], UserName = (string)reader["USER_NAME"], Password = (string)reader["PASSWORD"], CountryCode = (long)reader["COUNTRY_CODE"] }; airLineCompanys.Add(airLineCompany); } } return(airLineCompanys); } }
//// updating the info of an airline company in the system // updating the table in the database public void UpdateAirlineDetails(LoginToken <Administrator> token, AirLineCompany airline) { if (ValidUserToken(token)) { _airlineDAO.Update(airline); } }
// delete an existing airline from the system // first delete from ticktes after that from flights and at the end from airline // remove from data base public void RemoveAirline(LoginToken <Administrator> token, AirLineCompany airline) { if (ValidUserToken(token)) { _airlineDAO.Remove(airline); } }
/// <summary> /// Creates a new airline company and adds it to the table in the DB amd take out his id /// </summary> public long CreateNewAirline(LoginToken <Administrator> token, AirLineCompany airline) { if (ValidUserToken(token)) { airline.ID = _airlineDAO.ADD(airline); } return(airline.ID); }
public override bool Equals(object obj) { if (ReferenceEquals(obj, null)) { return(false); } AirLineCompany country = obj as AirLineCompany; return(this.ID == country.ID); }
// update airline from in db public void Update(AirLineCompany t) { using (cmd.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd.Connection.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = $"UPDATE AirlineCompanies SET AIRLINE_NAME = '{t.AirLineName}', USER_NAME = '{t.UserName}', PASSWORD = '******', COUNTRY_CODE = {t.CountryCode}" + $" WHERE ID = {t.ID} "; cmd.ExecuteNonQuery(); } }
// delete airline from db public void Remove(AirLineCompany airlinecompany) { using (cmd.Connection = new SqlConnection(FlightCenterConfig.DAO_CON)) { cmd.Connection.Open(); cmd.CommandType = CommandType.Text; cmd.CommandText = $"DELETE FROM Tickets WHERE Tickets.FLIGHT_ID = (select Flights.ID from Flights WHERE Flights.AIRLINE_COMPANY_ID = { airlinecompany.ID});" + $"DELETE FROM Flights WHERE Flights.AIRLINE_COMPANY_ID = {airlinecompany.ID});" + $"DELETE FROM AirlineCompanies WHERE (ID = {airlinecompany.ID});"; cmd.ExecuteNonQuery(); } }
public bool TryAirLineLogin(string username, string password, out LoginToken <AirLineCompany> token) { AirLineCompany company = _airlineDAO.GetAirlineByUsername(username); if (company != null) { if (company.Password == password) { token = new LoginToken <AirLineCompany>() { User = company }; return(true); } throw new WrongPasswordException("airline company wrong password"); } token = null; return(false); }
// get airline user name from db by user name public string GetAirlineUserName(LoginToken <Administrator> token, string userName) { AirLineCompany airLine = new AirLineCompany(); if (ValidUserToken(token)) { airLine = _airlineDAO.GetAirlineByUsername(userName); if (airLine == null) { return(null); } return(airLine.UserName); } if (airLine == null) { return(null); } return(airLine.UserName); }