public void DeleteStylist(int stylistId)
{
MySqlConnection conn = DB.Connection();
conn.Open();
Stylist selectedStylist = Stylist.Find(stylistId);
Dictionary <string, object> model = new Dictionary <string, object>();
List <Client> stylistClient = selectedStylist.GetClients();
List <Specialty> stylistSpecialty = selectedStylist.GetSpecialties();
model.Add("stylist", selectedStylist);
foreach (Specialty client in stylistSpecialty)
{
client.Delete();
}
foreach (Specialty specialty in stylistSpecialty)
{
specialty.Delete();
}
MySqlCommand cmd = new MySqlCommand(@"DELETE FROM stylists WHERE id = @thisId", conn);
cmd.Parameters.AddWithValue("@thisId", _id);
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}