public List <AirlineCompanies> GetAll() { List <AirlineCompanies> ac_list = new List <AirlineCompanies>(); try { using (var conn = new NpgsqlConnection(GlobalConfig.GetConn)) { conn.Open(); string sp_name = "sp_get_all_airlinecomapnies"; NpgsqlCommand command = new NpgsqlCommand(sp_name, conn); command.CommandType = System.Data.CommandType.StoredProcedure; var reader = command.ExecuteReader(); while (reader.Read()) { AirlineCompanies ac = new AirlineCompanies(); { ac.Name = (string)reader["name"]; ac.ID = (long)reader["id"]; ac.CountryId = (long)reader["country_id"]; ac.UserId = (long)reader["user_id"]; } ac_list.Add(ac); } } } catch (Exception ex) { log.Error($"Something went wrong in GetAll AirlineCompanies {ex} check connection"); } return(ac_list); }
public AirlineCompanies GetById(long id) { AirlineCompanies ac = new AirlineCompanies(); try { using (var conn = new NpgsqlConnection(GlobalConfig.GetConn)) { conn.Open(); using (var cmd = new NpgsqlCommand("sp_get_airlinecompanies_by_id", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new NpgsqlParameter("x", id)); var reader = cmd.ExecuteReader(); if (reader.Read()) { ac.Name = (string)reader["name"]; ac.ID = (long)reader["id"]; ac.CountryId = (long)reader["country_id"]; ac.UserId = (long)reader["user_id"]; } } } } catch (Exception ex) { log.Error($"Something went wrong in GetAirlineCompaniesById {ex} check connection"); } return(ac); }
public void CreateNewAirline(LoginToken <Administrator> token, AirlineCompanies airline) { if (token != null) { if (_airlineDAO != null) { _airlineDAO.Add(airline); } else { _airlineDAO = new AirlineCompaniesDAOPGSQL(); _airlineDAO.Add(airline); } } }
public void UpdateAirlineDetails(LoginToken <Administrator> token, AirlineCompanies airline) { if (token != null) { if (_airlineDAO != null) { _airlineDAO.Update(airline); } else { _airlineDAO = new AirlineCompaniesDAOPGSQL(); _airlineDAO.Update(airline); } } }
public void ModifyAirlineDetails(LoginToken <AirlineCompanies> token, AirlineCompanies airline) { if (token != null) { if (_airlineDAO != null) { _airlineDAO.Update(airline); } else { _airlineDAO = new AirlineCompaniesDAOPGSQL(); _airlineDAO.Update(airline); } } }
public AirlineCompanies GetAirlineById(LoginToken <Administrator> token, int id) { AirlineCompanies air = new AirlineCompanies(); if (token != null) { if (_airlineDAO != null) { air = _airlineDAO.GetById(id); } else { _airlineDAO = new AirlineCompaniesDAOPGSQL(); air = _airlineDAO.GetById(id); } } return(air); }
public void RemoveAirline(LoginToken <Administrator> token, AirlineCompanies airline) { if (token != null) { if (token.User.Level >= 2) { if (_airlineDAO != null) { _airlineDAO.Remove(airline.ID); } else { _airlineDAO = new AirlineCompaniesDAOPGSQL(); _airlineDAO.Remove(airline.ID); } } else { Console.WriteLine("Your level of administration is too low,you must be level 2 or higher"); } } }
public override bool Equals(object obj) { AirlineCompanies other = (AirlineCompanies)obj; return(this.ID == other.ID); }
public void Add(AirlineCompanies ac) { ExecuteNonQuery($"call sp_add_airlinecompanies('{ac.Name}',{ac.CountryId},{ac.UserId})"); log.Info($"New Airline has added {ac}"); }
public void Update(AirlineCompanies ac) { ExecuteNonQuery($"call sp_update_airlinecompany({ac.ID},{ac.Name},{ac.CountryId},{ac.UserId})"); }
public bool TryLogin(string userName, string password, out LoginToken <IUser> token, out FacadeBase facade) { token = new LoginToken <IUser>(); List <Users> users = _userDAO.GetAll(); try { if (userName != "admin" && password != "9999") { for (int i = 0; i < users.Count; i++) { if (users[i].UserName == userName && users[i].Password == password) { if (users[i].UserRole == 1) { List <Administrator> administrators = _adminDAO.GetAll(); for (int b = 0; b < administrators.Count; b++) { if (administrators[b].User_id == users[i].ID) { Administrator admin = administrators[b]; admin.User = users[i]; token.User = admin; facade = new LoggedInAdministratorFacade(); return(true); } } } else if (users[i].UserRole == 2) { List <AirlineCompanies> airCompanies = _arilineDAO.GetAll(); for (int b = 0; b < airCompanies.Count; b++) { if (airCompanies[b].UserId == users[i].ID) { AirlineCompanies air = airCompanies[b]; air.User = users[i]; token.User = air; facade = new LoggedInAirlineFacade(); return(true); } } } else if (users[i].UserRole == 3) { List <Customers> customers = _customerDAO.GetAll(); for (int b = 0; b < customers.Count; b++) { if (customers[b].UserId == users[i].ID) { Customers cus = customers[b]; cus.User = users[i]; token.User = cus; facade = new LoggedInCustomerFacade(); return(true); } } } } } } else { Administrator a = new Administrator(); token.User = a; facade = new LoggedInAdministratorFacade(); } } catch (WrongCredentialsException ex) { log.Error($"Wrong credentials... Try again {ex}"); } token = null; facade = new AnonymousUserFacade(); return(false); }