public static List <Stylist> GetAll()
{
List <Stylist> allItems = new List <Stylist> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM stylists order by level desc;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
Stylist newItem = new Stylist();
newItem.SetName(rdr.GetString(1));
newItem.SetId(rdr.GetInt32(0));
newItem.SetDescription(rdr.GetString(2));
newItem.SetLevel(rdr.GetInt32(3));
newItem.SetHair(rdr.GetInt32(4));
newItem.SetScissors(rdr.GetInt32(5));
newItem.SetScissorsName(rdr.GetString(6));
allItems.Add(newItem);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allItems);
}
public static List <Stylist> GetListOfStylists()
{
List <Stylist> allStylists = new List <Stylist> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM stylists;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
Stylist newStylist = new Stylist();
newStylist.SetId(rdr.GetInt32(0));
newStylist.SetName(rdr.GetString(1));
newStylist.SetDescription(rdr.GetString(2));
newStylist.SetTimestamp(rdr.GetDateTime(3));
allStylists.Add(newStylist);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allStylists);
}
public static Stylist Find(int check)
{
Stylist ret = new Stylist();
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM stylists where id = " + check + ";";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
rdr.Read();
if (rdr.IsDBNull(0) == false)
{
ret.SetName(rdr.GetString(1));
ret.SetId(rdr.GetInt32(0));
ret.SetDescription(rdr.GetString(2));
ret.SetLevel(rdr.GetInt32(3));
ret.SetHair(rdr.GetInt32(4));
ret.SetScissors(rdr.GetInt32(5));
ret.SetScissorsName(rdr.GetString(6));
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(ret);
}
public static Stylist Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM `stylists` WHERE id = '" + id + "';";
var rdr = cmd.ExecuteReader() as MySqlDataReader;
Stylist foundStylist = new Stylist();
while (rdr.Read())
{
int stylistId = rdr.GetInt32(0);
string stylistName = rdr.GetString(1);
string stylistDescription = rdr.GetString(2);
DateTime timestamp = rdr.GetDateTime(3);
foundStylist.SetId(stylistId);
foundStylist.SetName(stylistName);
foundStylist.SetDescription(stylistDescription);
foundStylist.SetTimestamp(timestamp);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundStylist);
}