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