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