//Find
public static Client Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM clients WHERE id = @ClientId;", conn);
SqlParameter clientIdParameter = new SqlParameter();
clientIdParameter.ParameterName = "@ClientId";
clientIdParameter.Value = id.ToString();
cmd.Parameters.Add(clientIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int foundClientId = 0;
string foundClientName = null;
int foundClientStylestId = 0;
while (rdr.Read())
{
foundClientId = rdr.GetInt32(0);
foundClientName = rdr.GetString(1);
foundClientStylestId = rdr.GetInt32(2);
}
Client foundClient = new Client(foundClientName, foundClientStylestId, foundClientId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundClient);
}
//GETRESTAURANT METHOD
public List <Client> GetClient()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM clients WHERE stylist_Id = @Stylist_Id;", conn);
SqlParameter stylistIdParameter = new SqlParameter();
stylistIdParameter.ParameterName = "@Stylist_Id";
stylistIdParameter.Value = this.GetId();
cmd.Parameters.Add(stylistIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
List <Client> clients = new List <Client> {
};
while (rdr.Read())
{
int clientId = rdr.GetInt32(0);
string clientName = rdr.GetString(1);
int clientStylistId = rdr.GetInt32(2);
Client newClient = new Client(clientName, clientStylistId, clientId);
clients.Add(newClient);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(clients);
}
//Save
public void Save()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO clients (name, stylist_Id) OUTPUT INSERTED.id VALUES (@ClientName, @ClientClientId);", conn);
SqlParameter nameParameter = new SqlParameter();
nameParameter.ParameterName = "@ClientName";
nameParameter.Value = this.GetName();
SqlParameter clientIdParameter = new SqlParameter();
clientIdParameter.ParameterName = "@ClientClientId";
clientIdParameter.Value = this.GetStylistId();
cmd.Parameters.Add(clientIdParameter);
cmd.Parameters.Add(nameParameter);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
this._id = rdr.GetInt32(0);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
public void Update(string newName)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE clients SET name = @NewName OUTPUT INSERTED.name WHERE id = @ClientId;", conn);
SqlParameter newNameParameter = new SqlParameter();
newNameParameter.ParameterName = "@NewName";
newNameParameter.Value = newName;
cmd.Parameters.Add(newNameParameter);
SqlParameter clientIdParameter = new SqlParameter();
clientIdParameter.ParameterName = "@ClientId";
clientIdParameter.Value = this.GetId();
cmd.Parameters.Add(clientIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
this._name = rdr.GetString(0);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
