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