public bool SaveCustomer(MyCustomer customer)
{
SqlCommand cmd = new SqlCommand("InsertCustomer", _cn);
cmd.CommandType = CommandType.StoredProcedure;
if (customer.Id != 0)
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = customer.Id;
}
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value
= customer.Name;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value
= customer.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value
= customer.LastName;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value
= customer.Email;
cmd.Parameters.Add("@DateBirth", SqlDbType.DateTime).Value
= customer.DateBirth;
int id = Convert.ToInt32(cmd.ExecuteScalar());
customer.Id = id;
return(id > 0);
}
private static MyCustomer GetCustomerByReader(SqlDataReader reader)
{
MyCustomer customer = new MyCustomer();
customer.Id = reader.GetInt32(0);
customer.Name = reader.GetString(1);
customer.FirstName = reader.GetString(2);
customer.LastName = reader.GetString(3);
customer.Email = reader.GetString(4);
customer.DateBirth = reader.GetDateTime(5);
return(customer);
}
public MyCustomer GetCustomerById(int id)
{
SqlCommand cmd = new SqlCommand("GetCustomers", _cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter();
param.ParameterName = "@Id";
param.SqlDbType = SqlDbType.Int;
param.Value = id;
cmd.Parameters.Add(param);
SqlDataReader reader = cmd.ExecuteReader();
MyCustomer customer = null;
while (reader.Read())
{
customer = GetCustomerByReader(reader);
}
return(customer);
}