public List <Specialty> GetSpecialties() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT specialties.* FROM stylists JOIN stylists_specialties ON (stylists.id = stylists_specialties.stylist_id) JOIN specialties ON (stylists_specialties.specialty_id = specialties.id) WHERE stylists.id = @stylistId;"; MySqlParameter stylistIdParameter = new MySqlParameter(); stylistIdParameter.ParameterName = "@stylistId"; stylistIdParameter.Value = _id; cmd.Parameters.Add(stylistIdParameter); var rdr = cmd.ExecuteReader() as MySqlDataReader; List <Specialty> specialties = new List <Specialty> { }; while (rdr.Read()) { int specialtyId = rdr.GetInt32(0); string specialtyDescription = rdr.GetString(1); Specialty newSpecialty = new Specialty(specialtyDescription, specialtyId); specialties.Add(newSpecialty); } conn.Close(); if (conn != null) { conn.Dispose(); } return(specialties); }
public static List <Specialty> GetAll() { List <Specialty> allSpecialties = new List <Specialty>(); MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM specialty;"; var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int specialtyId = rdr.GetInt32(0); string specialtyName = rdr.GetString(1); Specialty newSpecialty = new Specialty(specialtyName, specialtyId); allSpecialties.Add(newSpecialty); } return(allSpecialties); }
public static List <Specialty> GetAllByStylist(int stylistId) { List <Specialty> specialties = new List <Specialty> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT DISTINCT specialties.* FROM stylists JOIN specialties_stylists ON (stylists.id = specialties_stylists.stylist_id) JOIN specialties ON (specialties_stylists.specialty_id = specialties.id) WHERE stylist_id = @stylistId;"; cmd.Parameters.AddWithValue("@stylistId", stylistId); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { Specialty newSpecialty = new Specialty(rdr.GetString(1)); newSpecialty.Id = rdr.GetInt32(0); specialties.Add(newSpecialty); } DB.Close(conn); return(specialties); }
public void AddSpecialty(Specialty newSpecialty) { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO stylists_specialties (stylist_id, specialty_id) VALUES (@stylistId, @specialtyId);"; cmd.Parameters.Add(new MySqlParameter("@stylistId", this._stylistId)); cmd.Parameters.Add(new MySqlParameter("@specialtyId", newSpecialty.GetSpecialtyId())); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public static Specialty Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM specialties WHERE id = (@searchId);"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterName = "@searchId"; searchId.Value = id; cmd.Parameters.Add(searchId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int specialtyId = 0; string specialtyName = ""; string specialtyPrice = ""; while (rdr.Read()) { specialtyId = rdr.GetInt32(0); specialtyName = rdr.GetString(1); specialtyPrice = rdr.GetString(2); } Specialty newSpecialty = new Specialty(specialtyName, specialtyPrice); newSpecialty._specialtyId = specialtyId; conn.Close(); if (conn != null) { conn.Dispose(); } return(newSpecialty); }
public static Specialty GetByID(int searchID) { Specialty result = null; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = $"SELECT * FROM specialties WHERE (id = {searchID});"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); string name = rdr.GetString(1); result = new Specialty(name, id); } DB.Close(conn); return(result); }
public static Specialty 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 description = string.Empty; while (rdr.Read()) { specialtyId = rdr.GetInt32(0); description = rdr.GetString(1); } Specialty foundSpecialty = new Specialty(description, specialtyId); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundSpecialty); }
public static List <Specialty> GetAll() { List <Specialty> allSpecialtys = new List <Specialty> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(@"SELECT * FROM specialties;", conn); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int stylistId = rdr.GetInt32(0); string stylistName = rdr.GetString(1); Specialty newSpecialty = new Specialty(stylistName, stylistId); allSpecialtys.Add(newSpecialty); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allSpecialtys); }
public List <Specialty> GetAllSpecialties() { return(Specialty.GetAll()); }
public void AddSpecialty(Specialty specialty) { specialty.AddStylist(_id); }
public void AddSpecialty(string s) { Specialty newSpecialty = new Specialty(s); newSpecialty.Save(); }