public static List <Stylist> StylistsWithSpeciality(Speciality inputSpeciality) { List <Stylist> stylistOutput = new List <Stylist> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT stylists.* FROM specialities JOIN stylists_specialities ON (specialities.id = stylists_specialities.speciality_id) JOIN stylists ON (stylists_specialities.stylist_id = stylists.id) WHERE specialities.id = @SpecialityId;"; MySqlParameter specialityId = new MySqlParameter(); specialityId.ParameterName = "@SpecialityId"; specialityId.Value = inputSpeciality.GetId(); cmd.Parameters.Add(specialityId); var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int stylistId = (int)rdr.GetInt32(0); string stylistName = rdr.GetString(1); Stylist myStylist = new Stylist(stylistName); myStylist.SetId(stylistId); stylistOutput.Add(myStylist); } conn.Close(); if (conn != null) { conn.Dispose(); } return(stylistOutput); }
public void AddSpeciality(Speciality newSpeciality) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO specialities_stylists (speciality_id, stylist_id) VALUES (@SpecialityId, @StylistId);"; MySqlParameter speciality_id = new MySqlParameter(); speciality_id.ParameterName = "@SpecialityId"; speciality_id.Value = newSpeciality.GetId(); cmd.Parameters.Add(speciality_id); MySqlParameter stylist_id = new MySqlParameter(); stylist_id.ParameterName = "@StylistId"; stylist_id.Value = _id; cmd.Parameters.Add(stylist_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object obj) { if (!(obj is Speciality)) { return(false); } else { Speciality newSpeciality = (Speciality)obj; bool idEquality = this.GetId().Equals(newSpeciality.GetId()); bool nameEquality = this.GetName().Equals(newSpeciality.GetName()); return(idEquality && nameEquality); } }
public override bool Equals(System.Object otherSpeciality) { if (!(otherSpeciality is Speciality)) { return(false); } else { Speciality newSpeciality = (Speciality)otherSpeciality; bool areIdsEqual = (this.GetId() == newSpeciality.GetId()); bool areNamesEqual = (this.GetDescription() == newSpeciality.GetDescription()); return(areIdsEqual && areNamesEqual); } }
public override bool Equals(System.Object otherSpeciality) { if (!(otherSpeciality is Speciality)) { return(false); } else { Speciality newSpeciality = (Speciality)otherSpeciality; bool idEquality = this.GetId() == newSpeciality.GetId(); bool descriptionEquality = this.GetDescription() == newSpeciality.GetDescription(); return(idEquality && descriptionEquality); } }
// Function to add a speciality to this stylist. public void AddSpeciality(Speciality newSpeciality) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylists_specialities (stylist_id, speciality_id) VALUES (@stylistId, @specialityId);"; cmd.Parameters.AddWithValue(@"stylistId", this._id); cmd.Parameters.AddWithValue(@"specialityId", newSpeciality.GetId()); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddSpeciality(Speciality speciality) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO specialities_stylists (stylist_id, speciality_id) VALUES (@StylistId, @SpecialityId);"; MySqlParameter specialityId = new MySqlParameter("@SpecialityId", speciality.GetId()); MySqlParameter stylistId = new MySqlParameter("@StylistId", this._id); cmd.Parameters.Add(specialityId); cmd.Parameters.Add(stylistId); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }