// public static StylistSpecialties FindById(int searchId)
// {
// int id = 0;
// int stylistId = 0;
// int specialtiesId = 0;
// MySqlConnection conn = DB.Connection();
// conn.Open();
// MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
// cmd.CommandText = @"SELECT * FROM stylist_specialties WHERE id = @idMatch;";
// MySqlParameter parameterId = new MySqlParameter();
// parameterId.ParameterName = "@idMatch";
// parameterId.Value = searchId;
// cmd.Parameters.Add(parameterId);
// MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
// while(rdr.Read())
// {
// id = rdr.GetInt32(0);
// stylistId = rdr.GetInt32(1);
// specialtiesId = rdr.GetInt32(2);
// }
// StylistSpecialties foundStylistSpecialties = new StylistSpecialties(stylistId, specialtiesId, id);
// conn.Close();
// if (conn != null)
// {
// conn.Dispose();
// }
// return foundStylistSpecialties;
// }
public static List <StylistSpecialties> GetAll()
{
List <StylistSpecialties> newStylistSpecialtiess = new List <StylistSpecialties> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM stylist_specialties;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
int stylistId = rdr.GetInt32(1);
int specialtiesId = rdr.GetInt32(2);
StylistSpecialties newStylistSpecialties = new StylistSpecialties(stylistId, specialtiesId, id);
newStylistSpecialtiess.Add(newStylistSpecialties);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(newStylistSpecialtiess);
}
public override bool Equals(System.Object otherStylistSpecialties)
{
if (!(otherStylistSpecialties is StylistSpecialties))
{
return(false);
}
else
{
StylistSpecialties newStylistSpecialties = (StylistSpecialties)otherStylistSpecialties;
bool idEquality = (this.GetId() == newStylistSpecialties.GetId());
bool stylistIDEquality = (this.GetStylistID() == newStylistSpecialties.GetStylistID());
bool specialtiesIDEquality = (this.GetSpecialtiesID() == newStylistSpecialties.GetSpecialtiesID());
return(idEquality && stylistIDEquality && specialtiesIDEquality);
}
}
