public static Customer POCustomer(BO.Customer cust)
{
return(new Customer
{
CustomerID = cust.CustomerID,
Name = cust.Name,
Company = cust.Company,
Address = cust.Address,
PostCode = cust.PostCode,
City = cust.City,
Phone = cust.Phone,
Mobile = cust.Mobile,
Email = cust.Email,
OrderIDs = cust.OrderIDs
});
}
internal static Project1.BO.Customer GetCustomer(string userName)
{
string connectionString = ConfigurationManager.ConnectionStrings["Project1"].ToString();
string sql = "select * from customers where username = '******'";
Project1.BO.Customer customer = new Customer();
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
using (SqlCommand myCommand = new SqlCommand(sql, myConnection))
{
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
if (myDataReader.Read())
{
customer = new BO.Customer(
myDataReader["FirstName"].ToString(),
myDataReader["LastName"].ToString(),
myDataReader["Address1"].ToString(),
myDataReader["Address2"].ToString(),
myDataReader["City"].ToString(),
myDataReader["State"].ToString(),
myDataReader["Zip"].ToString(),
myDataReader["PhoneNumber"].ToString(),
myDataReader["UserName"].ToString(),
myDataReader["CustomerID"].ToString());
}
}
}
}
return customer;
}
