protected override List <ICustomer> ExecuteCommand()
{
Command.CommandText = "select * from tblCustomer";
var sqlDataReader = Command.ExecuteReader();
while (sqlDataReader.Read())
{
var customer = FactoryCustomerLookUp.CreateCustomer("Customer");
customer.Id = Convert.ToInt32(sqlDataReader["Id"]);
customer.CustomerType = sqlDataReader["CustomerType"].ToString();
customer.CustomerName = sqlDataReader["CustomerName"].ToString();
customer.PhoneNumber = sqlDataReader["PhoneNumber"].ToString();
customer.BillAmount = Convert.ToDecimal(sqlDataReader["BillAmount"].ToString());
customer.BillDate = Convert.ToDateTime(sqlDataReader["BillDate"].ToString());
customer.Address = sqlDataReader["Address"].ToString();
AnyTypes.Add(customer);
}
return(AnyTypes);
}
public void CbxCustomerTypeSelectedIndexChanged()
{
var comboBox = (ComboBox)_uiControls["CbxCustomerType"];
_customer = FactoryCustomerLookUp.CreateCustomer(comboBox.Text);
}