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); }