public static List <ClientClass> GetAll() { List <ClientClass> allClients = new List <ClientClass>(); MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM clients;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int clientId = rdr.GetInt32(0); string name = rdr.GetString(1); string phoneNumber = rdr.GetString(2); int stylistId = rdr.GetInt32(3); ClientClass newClient = new ClientClass(name, phoneNumber, stylistId, clientId); allClients.Add(newClient); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allClients); }
public static ClientClass Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM clients WHERE Id = @thisId;"; MySqlParameter thisId = new MySqlParameter(); thisId.ParameterName = "@thisId"; thisId.Value = id; cmd.Parameters.Add(thisId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int clientId = 0; string name = ""; string phoneNumber = ""; int stylistId = 0; while (rdr.Read()) { clientId = rdr.GetInt32(0); name = rdr.GetString(1); phoneNumber = rdr.GetString(2); stylistId = rdr.GetInt32(3); } ClientClass foundClient = new ClientClass(name, phoneNumber, stylistId, clientId); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundClient); }
public List <ClientClass> GetClients() { List <ClientClass> allStylistClients = new List <ClientClass>(); MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM clients WHERE stylistId = @stylistId;"; MySqlParameter stylistId = new MySqlParameter(); stylistId.ParameterName = "@stylistId"; stylistId.Value = this._id; cmd.Parameters.Add(stylistId); var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int clientId = rdr.GetInt32(0); string name = rdr.GetString(1); string phoneNumber = rdr.GetString(2); ClientClass newClient = new ClientClass(name, phoneNumber, _id, clientId); allStylistClients.Add(newClient); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allStylistClients); }
public override bool Equals(System.Object otherClient) { if (!(otherClient is ClientClass)) { return(false); } else { ClientClass newClient = (ClientClass)otherClient; bool clientEquality = (this.GetName() == newClient.GetName() && this.GetPhoneNumber() == newClient.GetPhoneNumber() && this.GetId() == newClient.GetId() && this.GetStylistId() == newClient.GetStylistId()); return(clientEquality); } }
public static void ClearAll() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"DELETE FROM stylists;"; cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } ClientClass.ClearAll(); }