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 static Specialty Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM specialties WHERE id=@id;";
cmd.Parameters.Add(new MySqlParameter("@id", id));
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
string tempSpecialty = "";
int tempId = 0;
while (rdr.Read())
{
tempId = rdr.GetInt32(0);
tempSpecialty = rdr.GetString(1);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
Specialty thisSpecialty = new Specialty(tempSpecialty);
thisSpecialty.SetId(tempId);
return(thisSpecialty);
}
public static List <Specialty> GetListOfSpecialties()
{
List <Specialty> allSpecialties = new List <Specialty> {
};
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())
{
Specialty newSpecialty = new Specialty();
newSpecialty.SetId(rdr.GetInt32(0));
newSpecialty.SetSpecialtyType(rdr.GetString(1));
allSpecialties.Add(newSpecialty);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allSpecialties);
}
public static List <Specialty> GetAll()
{
List <Specialty> mySpecialties = new List <Specialty>();
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 specialty = rdr.GetString(1);
Specialty newSpecialty = new Specialty(specialty);
newSpecialty.SetId(id);
mySpecialties.Add(newSpecialty);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(mySpecialties);
}
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 = '" + id + "';";
var rdr = cmd.ExecuteReader() as MySqlDataReader;
Specialty foundSpecialty = new Specialty();
while (rdr.Read())
{
int stylistId = rdr.GetInt32(0);
string stylistSpecialtyType = rdr.GetString(1);
foundSpecialty.SetId(stylistId);
foundSpecialty.SetSpecialtyType(stylistSpecialtyType);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundSpecialty);
}
