public Customer GetCustomerByEmail(string email)
{
Customer customer = new Customer();
IDataReader dr = new CustomerDataAdapter().GetCustomerByEmail(email);
if (dr.Read())
{
customer = PopulateReader(dr);
}
dr.Close();
return customer;
}
public bool Insert(Customer customer)
{
using (CustomerDataAdapter adapter = new CustomerDataAdapter())
{
return adapter.InsertCustomer(customer.Company,
customer.Name, customer.PhoneNo, customer.Email,
customer.Fax,
customer.Address, customer.Website, customer.Remarks,
customer.PostCode
, customer.Country, customer.Rating);
}
}
public Customer GetCustomersById(int id)
{
Customer customer = new Customer();
using (IDataReader dr = new CustomerDataAdapter().GetCustomerByCode(id))
{
if (dr.Read())
{
customer = PopulateReader(dr);
}
dr.Close();
}
return customer;
}
public void Save(Customer customer)
{
customer.Save();
}
private void InsertCustomer()
{
InventorySystem.Business.Customer customer = new InventorySystem.Business.Customer();
CustomerModule customerModule = new CustomerModule();
if (ViewState["id"] != null)
customer.Id = Convert.ToInt32(ViewState["id"]);
customer.Name = txtCustName.Text;
customer.Company = txtCustCompName.Text;
customer.Address = txtCustAddress.Text;
customer.Website = txtCustWebsite.Text;
customer.Remarks = txtCustRemarks.Text;
customer.Email = txtCustEmail.Text;
customer.Fax = txtCustFaxNo.Text;
customer.PostCode = txtCustPostalCode.Text;
//customer.Country = txtCustCountry.Text;
customer.Country = ddlCountry.TextField;
customer.PhoneNo = txtCustPhoneNo.Text;
customer.Rating = RatingExample.CurrentRating;
customerModule.Save(customer);
}
private Customer PopulateReader(IDataReader dr)
{
Customer customer = new Customer();
customer.Id = Convert.ToInt32(dr["id"]);
customer.Company = dr["Company"].ToString();
customer.Name = dr["Name"].ToString();
customer.PhoneNo = dr["PhoneNo"].ToString();
customer.Email = dr["Email"].ToString();
customer.Fax = dr["Fax"].ToString();
customer.Address = dr["Address"].ToString();
customer.Website = dr["Website"].ToString();
customer.Remarks = dr["Remarks"].ToString();
customer.PostCode = dr["PostCode"].ToString();
customer.Country = dr["Country"].ToString();
customer.Rating = Int32.Parse(dr["Rating"].ToString());
return customer;
}