protected override List <CustomerBase> ExecuteCommand()
{
objCommand.CommandText = "select * from Customer";
SqlDataReader dr = null;
dr = objCommand.ExecuteReader();
while (dr.Read())
{
CustomerBase icust = Factory <CustomerBase> .Create(dr["CustomerType"].ToString());
icust.Id = Convert.ToInt32(dr["Id"]);
icust.CustomerType = dr["CustomerType"].ToString();
icust.CustomerName = dr["CustomerName"].ToString();
icust.BillAmount = Convert.ToDecimal(dr["BillAmount"]);
icust.BillDate = Convert.ToDateTime(dr["BillDate"]);
icust.PhoneNumber = dr["PhoneNumber"].ToString();
icust.Address = dr["Address"].ToString();
AnyTypes.Add(icust);
}
return(AnyTypes);
}
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);
}
