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