public void AddStylist(Stylist newStylist) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylist_specialty (stylists_id, specialties_id) VALUES (@StylistId, @SpecialtyId);"; MySqlParameter category_id = new MySqlParameter(); cmd.Parameters.AddWithValue("@SpecialtyId", this._id); cmd.Parameters.AddWithValue("@StylistId", newStylist.GetId()); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void RemoveStylist(Stylist stylist) { int stylistId = stylist.GetId(); MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"DELETE FROM specialties_stylists WHERE stylist_id = @stylistId;"; MySqlParameter stylistIdParameter = new MySqlParameter("@stylistId", stylistId); cmd.Parameters.Add(stylistIdParameter); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddStylist(Stylist stylist) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO stylists_specialties (stylist_id, specialty_id) VALUES (@StylistId, @SpecialtyId)"; cmd.Parameters.AddWithValue("@StylistId", stylist.GetId()); cmd.Parameters.AddWithValue("@SpecialtyId", _id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherStylist) { if (!(otherStylist is Stylist)) { return(false); } else { Stylist newStylist = (Stylist)otherStylist; bool nameEquality = this.GetName().Equals(newStylist.GetName()); bool idEquality = this.GetId().Equals(newStylist.GetId()); bool descriptionEquality = this.GetDescription().Equals(newStylist.GetDescription()); bool timestampEquality = this.GetTimestamp().Equals(newStylist.GetTimestamp()); if (nameEquality == true && idEquality == true && descriptionEquality == true) { return(true); } return(false); } }
public void AddStylist(Stylist newStylist) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO specialties_stylists (specialty_id, stylist_id) VALUES (@SpecialtyId, @StylistId);"; cmd.Parameters.Add(new MySqlParameter("@SpecialtyId", _id)); cmd.Parameters.Add(new MySqlParameter("@StylistId", newStylist.GetId())); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddStylist(Stylist newStylist) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylists_specialties(stylist_id, specialty_id) VALUES (@stylistId, @Id);"; cmd.Parameters.AddWithValue("@Id", this.Id); cmd.Parameters.AddWithValue("@stylistId", newStylist.GetId()); cmd.ExecuteNonQuery(); Id = (int)cmd.LastInsertedId; conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddStylist(Stylist stylist) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO stylists_clients (client_id, stylist_id) VALUES (@ClientId, @StylistId);"; MySqlParameter clientIdParameter = new MySqlParameter("@ClientId", this._id); MySqlParameter stylistIdParameter = new MySqlParameter("@StylistId", stylist.GetId()); cmd.Parameters.Add(clientIdParameter); cmd.Parameters.Add(stylistIdParameter); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddStylist(Stylist newStylist) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(@"INSERT INTO specialties_stylists (specialty_id, stylist_id) VALUES (@SpecialtyId, @StylistId);", conn); cmd.Parameters.Add(new MySqlParameter("@SpecialtyId", _id)); MySqlParameter stylist_id = new MySqlParameter(); stylist_id.ParameterName = "@StylistId"; stylist_id.Value = newStylist.GetId(); cmd.Parameters.Add(stylist_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddStylist(Stylist newStylist) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylists_clients (stylist_id, client_id) VALUES (@StylistId, @ClientId);"; MySqlParameter stylist_id = new MySqlParameter(); stylist_id.ParameterName = "@StylistId"; stylist_id.Value = newStylist.GetId(); cmd.Parameters.Add(stylist_id); MySqlParameter client_id = new MySqlParameter(); client_id.ParameterName = "@ClientId"; client_id.Value = _id; cmd.Parameters.Add(client_id); cmd.ExecuteNonQuery(); conn.Close(); if(conn != null) { conn.Dispose(); } }
public void ToDictionary(Stylist stylist) { _Styler.Add(stylist.GetId(), stylist.GetStylistName()); }
public void AddStylist(Stylist stylist) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylists_specialties (specialty_id, stylist_id) VALUES ('" + _id + "', '" + stylist.GetId() + "');"; cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }