public string GetSpecialty()
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT specialties.* FROM specialty_stylist JOIN stylists ON (stylists.id = specialty_stylist.stylist_id) JOIN specialties ON (specialties.id = specialty_stylist.specialty_id) WHERE stylists.id = @StylistId;";
MySqlParameter stylistId = new MySqlParameter("@StylistId", _id);
cmd.Parameters.Add(stylistId);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
int id = 0;
string specialty = "";
while (rdr.Read())
{
id = rdr.GetInt32(0);
specialty = rdr.GetString(1);
}
Specialty mySpecialty = new Specialty(specialty);
mySpecialty.SetId(id);
conn.Dispose();
return(mySpecialty.GetSpecialty());
}
public override bool Equals(System.Object otherSpecialty)
{
if (!(otherSpecialty is Specialty))
{
return(false);
}
else
{
Specialty newSpecialty = (Specialty)otherSpecialty;
return(newSpecialty.GetSpecialty() == _specialty);
}
}
public override bool Equals(System.Object otherSpecialty)
{
if (!(otherSpecialty is Specialty))
{
return(false);
}
else
{
Specialty newSpecialty = (Specialty)otherSpecialty;
bool idEquality = (this.GetId() == newSpecialty.GetId());
bool specialtyEquality = (this.GetSpecialty() == newSpecialty.GetSpecialty());
return(idEquality && specialtyEquality);
}
}
public override bool Equals(System.Object speciality2)
{
if (!(speciality2 is Specialty))
{
return(false);
}
else
{
Specialty speciality1 = (Specialty)speciality2;
bool idEquality = (this.GetId() == speciality1.GetId());
bool specialityEq = (this.GetSpecialty() == speciality1.GetSpecialty());
return(idEquality && specialityEq);
}
}
