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