/// <summary> /// Remove airline company by using given airline company. /// </summary> /// <param name="token"></param> /// <param name="airline"></param> public void RemoveAirline(LoginToken <Administrator> token, AirlineCompany airline) { CheckTokenValidity(token, out bool isTokenValid); if (isTokenValid) { _ticketDAO.RemoveTicketsByAirlineCompanyId(airline.ID); _flightDAO.RemoveFlightsByAirlineCompanyId(airline.ID); _airlineDAO.Remove(airline); } }
/// <summary> /// Modify airline details by using modified airline data. /// </summary> /// <param name="token"></param> /// <param name="airline"></param> public void ModifyAirlineDetails(LoginToken <AirlineCompany> token, AirlineCompany airline) { if (token != null) { _airlineDAO.Update(airline); } else { throw new Exception("Token can't be null"); } }
/// <summary> /// Create new airline company by using given airline company. /// </summary> /// <param name="token"></param> /// <param name="airline"></param> public long CreateNewAirline(LoginToken <Administrator> token, AirlineCompany airline) { if (token != null) { return(_airlineDAO.Add(airline)); } else { throw new Exception("Token can't be null"); } }
/// <summary> /// Remove airline company by using given airline company. /// </summary> /// <param name="token"></param> /// <param name="airline"></param> public void RemoveAirline(LoginToken <Administrator> token, AirlineCompany airline) { if (token != null) { _ticketDAO.RemoveTicketsByAirlineCompanyId(airline.ID); _flightDAO.RemoveFlightsByAirlineCompanyId(airline.ID); _airlineDAO.Remove(airline); } else { throw new Exception("Token can't be null"); } }
public long Add(AirlineCompany t) { StringBuilder sb = new StringBuilder(); sb = new StringBuilder(); sb.Append($"INSERT INTO AirlineCompanies(AIRLINE_NAME, USER_NAME, PASSWORD, COUNTRY_CODE)"); sb.Append($" values('{ t.AIRLINE_NAME}', '{ t.USER_NAME}', '{ t.PASSWORD}', { t.COUNTRY_CODE})"); string SQL2 = sb.ToString(); DL.ExecuteSqlNonQuery(SQL2); SQL2 = $"SELECT ID FROM AirlineCompanies WHERE USER_NAME = '{t.USER_NAME}'"; return(Int64.Parse(DL.ExecuteSqlScalarStatement(SQL2))); }
public void Remove(AirlineCompany t) { StringBuilder sb = new StringBuilder(); sb.Append($"DELETE FROM AirlineCompanies WHERE ID = {t.ID}"); string SQL = sb.ToString(); string res = DL.ExecuteSqlNonQuery(SQL); if (res == "") { throw new AirlineCompanyDeleteErrorException("AirlineCompanie delete error"); } }
//public long GetAirlineCompanyIdByCountryCode(long countryCode) //{ // AirlineCompany a = null; // string SQL = $"SELECT ID FROM AirlineCompanies WHERE COUNTRY_CODE = {countryCode}"; // DataSet DS = DL.GetSqlQueryDS(SQL, "AirlineCompanies"); // DataTable dt = DS.Tables[0]; // foreach (DataRow dr in dt.Rows) // { // a = new AirlineCompany(); // a.ID = (long)dr["ID"]; // } // if (a != null) // { // return a.ID; // } // else // { // throw new AirlineCompanyDoesNotExistException("Airline Company Doesn't Exist"); // } //} public void Update(AirlineCompany t) { StringBuilder sb = new StringBuilder(); sb.Append($"UPDATE AirlineCompanies SET AIRLINE_NAME = '{t.AIRLINE_NAME}', USER_NAME = '{t.USER_NAME}', PASSWORD = '******', COUNTRY_CODE = {t.COUNTRY_CODE}"); sb.Append($" WHERE ID = {t.ID}"); string SQL = sb.ToString(); string res = DL.ExecuteSqlNonQuery(SQL); if (res == "") { throw new AirlineCompanyUpdateErrorException("AirlineCompany update error"); } }
/// <summary> /// Create new airline company by using given airline company. /// </summary> /// <param name="token"></param> /// <param name="airline"></param> public long CreateNewAirline(LoginToken <Administrator> token, AirlineCompany airline) { CheckTokenValidity(token, out bool isTokenValid); if (isTokenValid) { string res = _airlineDAO.CheckIfAirlineCompanyExist(airline); if (res == "0") { return(_airlineDAO.Add(airline)); } else { throw new AirlineCompanyAlreadyExistException("AirlineCompany already exists"); } } return(0); }
public IList <AirlineCompany> GetAllAirlineCompaniesByScheduledTime(string typeName) { IList <AirlineCompany> airlineCompanies = new List <AirlineCompany>(); StringBuilder sb = new StringBuilder(); string str1 = ""; if (typeName == "Arrivals") { str1 = $" WHERE(REAL_LANDING_TIME BETWEEN GETDATE() AND DATEADD(hour, 12, GETDATE()) OR (REAL_LANDING_TIME BETWEEN DATEADD(hour, -4, GETDATE()) AND GETDATE())))"; } else if (typeName == "Departures") { str1 = $" WHERE (REAL_DEPARTURE_TIME BETWEEN GETDATE() AND DATEADD(hour, 12, GETDATE())))"; } else if (typeName == "" || typeName == null) { str1 = $" WHERE(REAL_DEPARTURE_TIME BETWEEN GETDATE() AND DATEADD(hour, 12, GETDATE())) AND (REAL_LANDING_TIME BETWEEN GETDATE() AND DATEADD(hour, 12, GETDATE()) OR (LANDING_TIME BETWEEN DATEADD(hour, -4, GETDATE()) AND GETDATE())))"; } //sb.Append($"SELECT * FROM AirlineCompanies"); sb.Append($" SELECT a.AIRLINE_NAME"); sb.Append($" FROM AirlineCompanies as a"); sb.Append($" WHERE a.AIRLINE_NAME IN (SELECT a.AIRLINE_NAME"); sb.Append($" FROM Flights as f"); sb.Append($" INNER JOIN AirlineCompanies as a on f.AIRLINECOMPANY_ID = a.ID"); sb.Append($" INNER JOIN Countries as c on f.ORIGIN_COUNTRY_CODE = c.ID"); sb.Append($" INNER JOIN Countries as co on f.DESTINATION_COUNTRY_CODE = co.ID"); sb.Append(str1); string SQL = sb.ToString(); DataSet DS = DL.GetSqlQueryDS(SQL, "AirlineCompanies"); DataTable dt = DS.Tables[0]; foreach (DataRow dr in dt.Rows) { AirlineCompany a = new AirlineCompany(); //a.ID = (long)dr["ID"]; a.AIRLINE_NAME = (string)dr["AIRLINE_NAME"]; //a.USER_NAME = (string)dr["USER_NAME"]; //a.PASSWORD = (string)dr["PASSWORD"]; //a.COUNTRY_CODE = (long)dr["COUNTRY_CODE"]; airlineCompanies.Add(a); } return(airlineCompanies); }
public IList <AirlineCompany> GetAllAirlinesByCountry(long countryId) { IList <AirlineCompany> airlineCompanies = new List <AirlineCompany>(); StringBuilder sb = new StringBuilder(); sb.Append($"SELECT * FROM AirlineCompanies WHERE COUNTRY_CODE = '{countryId}'"); string SQL = sb.ToString(); DataSet DS = DL.GetSqlQueryDS(SQL, "AirlineCompanies"); DataTable dt = DS.Tables[0]; foreach (DataRow dr in dt.Rows) { AirlineCompany a = new AirlineCompany(); a.ID = (long)dr["ID"]; a.AIRLINE_NAME = (string)dr["AIRLINE_NAME"]; a.USER_NAME = (string)dr["USER_NAME"]; a.PASSWORD = (string)dr["PASSWORD"]; a.COUNTRY_CODE = (long)dr["COUNTRY_CODE"]; airlineCompanies.Add(a); } return(airlineCompanies); }
public bool TryAirlineLogin(string userName, string password, out LoginToken <AirlineCompany> token) { _arilineDAO = new AirlineDAOMSSQL(); AirlineCompany airline = _arilineDAO.GetAirlineByUsername(userName); if (airline != null) { if (airline.PASSWORD == password) { token = new LoginToken <AirlineCompany>() { User = airline }; return(true); } else { throw new WrongPasswordException("Wrong password exception"); } } token = null; return(false); }
public long Add(AirlineCompany t) { StringBuilder sb = new StringBuilder(); string SQL1 = $"SELECT COUNT(*) FROM AirlineCompanies WHERE USER_NAME = '{t.USER_NAME}' OR EXISTS (SELECT USER_NAME FROM Customers WHERE USER_NAME = '{t.USER_NAME}')"; string res = DL.ExecuteSqlScalarStatement(SQL1); if (res == "0") { sb = new StringBuilder(); sb.Append($"INSERT INTO AirlineCompanies(AIRLINE_NAME, USER_NAME, PASSWORD, COUNTRY_CODE)"); sb.Append($" values('{ t.AIRLINE_NAME}', '{ t.USER_NAME}', '{ t.PASSWORD}', { t.COUNTRY_CODE})"); string SQL2 = sb.ToString(); DL.ExecuteSqlNonQuery(SQL2); SQL2 = $"SELECT ID FROM AirlineCompanies WHERE USER_NAME = '{t.USER_NAME}'"; return(Int64.Parse(DL.ExecuteSqlScalarStatement(SQL2))); } else { throw new AirlineCompanyAlreadyExistException("AirlineCompany already exists"); } }