public static SpecialtyClass Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM specialties WHERE id = @thisId;"; MySqlParameter thisId = new MySqlParameter(); thisId.ParameterName = "@thisId"; thisId.Value = id; cmd.Parameters.Add(thisId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int specialtyId = 0; string feature = ""; while (rdr.Read()) { specialtyId = rdr.GetInt32(0); feature = rdr.GetString(1); } SpecialtyClass foundSpecialty = new SpecialtyClass(feature, specialtyId); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundSpecialty); }
public static List <SpecialtyClass> GetAll() { List <SpecialtyClass> allSpecialties = new List <SpecialtyClass> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM specialties;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); string feature = rdr.GetString(1); SpecialtyClass newSpecialty = new SpecialtyClass(feature, id); allSpecialties.Add(newSpecialty); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allSpecialties); }
public void AddSpecialty(SpecialtyClass newSpecialty) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT into stylists_specialties(stylist_Id, specialty_Id) VALUES (@stylistId, @specialtyId);"; MySqlParameter stylist_Id = new MySqlParameter(); stylist_Id.ParameterName = "@stylistId"; stylist_Id.Value = _id; cmd.Parameters.Add(stylist_Id); MySqlParameter specialty_Id = new MySqlParameter(); specialty_Id.ParameterName = "@specialtyId"; specialty_Id.Value = newSpecialty.GetId(); cmd.Parameters.Add(specialty_Id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherSpecialty) { if (!(otherSpecialty is SpecialtyClass)) { return(false); } else { SpecialtyClass newSpecialty = (SpecialtyClass)otherSpecialty; bool specialtyEquality = (this.GetFeature() == newSpecialty.GetFeature() && this.GetId() == newSpecialty.GetId()); return(specialtyEquality); } }
public List <SpecialtyClass> GetSpecialties() { List <SpecialtyClass> allSpecialties = new List <SpecialtyClass> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT specialties.* FROM specialties JOIN stylists_specialties ON (specialties.Id = stylists_specialties.specialty_Id) JOIN stylists ON (stylists_specialties.stylist_Id = stylists.Id) WHERE stylists.Id = (@specialtyId);"; MySqlParameter stylistId = new MySqlParameter(); stylistId.ParameterName = "@stylistId"; stylistId.Value = this._id; cmd.Parameters.Add(stylistId); MySqlParameter specialtyId = new MySqlParameter(); specialtyId.ParameterName = "@specialtyId"; specialtyId.Value = this._id; cmd.Parameters.Add(specialtyId); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int specialty_Id = rdr.GetInt32(0); string feature = rdr.GetString(1); SpecialtyClass newSpecialty = new SpecialtyClass(feature, specialty_Id); allSpecialties.Add(newSpecialty); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allSpecialties); }