public void Save()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO clients (name, stylist_id) OUTPUT INSERTED.id VALUES (@ClientName, @ClientStylistId);", conn);
SqlParameter nameParameter = new SqlParameter();
nameParameter.ParameterName = "@ClientName";
nameParameter.Value = this.GetName();
cmd.Parameters.Add(nameParameter);
SqlParameter stylistIdParameter = new SqlParameter();
stylistIdParameter.ParameterName = "@ClientStylistId";
stylistIdParameter.Value = this.GetStylistId();
cmd.Parameters.Add(stylistIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
this._id = rdr.GetInt32(0);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
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 foundClientStylistId = 0;
while (rdr.Read())
{
foundClientId = rdr.GetInt32(0);
foundClientName = rdr.GetString(1);
foundClientStylistId = rdr.GetInt32(2);
}
Client foundClient = new Client(foundClientName, foundClientStylistId, foundClientId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(foundClient);
}
