public void Remove(AirlineCompany t) { SqlConnection con = new SqlConnection(AppConfig.CONNECTION_STRING); using (con) { SqlCommand cmd = new SqlCommand($"DELETE_AirlineCompanie", con); cmd.Parameters.Add(new SqlParameter("@id", t.Id)); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); con.Close(); } }
public void ChangeMyPassword(LoginToken <AirlineCompany> token, string oldPassword, string newPassword) { if (token.User != null) { AirlineCompany company = _airlineDAO.GetAirlineByUsername(token.User.UserName); if (company.Password.ToString() == oldPassword) { company.Password = newPassword; _airlineDAO.Update(company); } else { throw new WrongPasswordException("Wrong Password"); } } }
public void Add(AirlineCompany t) { SqlConnection con = new SqlConnection(AppConfig.CONNECTION_STRING); using (con) { SqlCommand cmd = new SqlCommand("ADD_COMPANY", con); cmd.Parameters.Add(new SqlParameter("@AIRLINE_NAME", t.AirlineName)); cmd.Parameters.Add(new SqlParameter("@USER_NAME", t.UserName)); cmd.Parameters.Add(new SqlParameter("@PASSWORD", t.Password)); cmd.Parameters.Add(new SqlParameter("@COUNTRY_CODE", t.CountryCode)); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); con.Close(); } }
public bool TryAirlineLogin(string userName, string password, out LoginToken <AirlineCompany> token) { AirlineCompany company = _airlineDAO.GetAirlineByUsername(userName); if (company != null) { if (company.UserName == userName) { if (company.Password == password) { token = new LoginToken <AirlineCompany>(); token.User = company; return(true); } else { throw new WrongPasswordException("Wrong Password"); } } } token = null; return(false); }
public override bool Equals(object obj) { AirlineCompany other = obj as AirlineCompany; return(this == other); }