/* Helper method to map result to object */ private static CustomerActireRecord MapResultsetToObject(SqlDataReader reader) { CustomerActireRecord NewCustomer = new CustomerActireRecord(); NewCustomer.Id = reader.GetInt32(0); NewCustomer.Name = reader.GetString(1); NewCustomer.Salary = (double)reader.GetDecimal(4); NewCustomer.Age = reader.GetInt32(2); NewCustomer.Adrress = reader.GetString(3); return(NewCustomer); }
public static CustomerActireRecord Find(int id) { string sql = "SELECT * FROM CUSTOMERS WHERE ID = @id;"; CustomerActireRecord NewCustomer = null; using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { NewCustomer = MapResultsetToObject(reader); } } } } return(NewCustomer); }