public string GetCustomerName(int id)
{
dalCustomer dal = new dalCustomer();
DataTable data = dal.GetCustomers();
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow row = data.Rows[i];
if (Convert.ToInt32(row[0]) == id)
{
return(row[1].ToString());
}
}
return(null);
}
public DateTime GetCustomerBirthDay(int id)
{
DateTime customerBD = new DateTime();
dalCustomer dal = new dalCustomer();
DataTable data = dal.GetCustomers();
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow row = data.Rows[i];
if (Convert.ToInt32(row[0]) == id)
{
customerBD = Convert.ToDateTime(row[5]);
}
}
return(customerBD);
}
public List <dtoCustomer> GetCustomers()
{
dalCustomer dalCustomer = new dalCustomer();
List <dtoCustomer> listEmp = new List <dtoCustomer>();
DataTable Customers = dalCustomer.GetCustomers();
for (int i = 0; i < Customers.Rows.Count; i++)
{
dtoCustomer Customer = new dtoCustomer();
DataRow row = Customers.Rows[i];
Customer.CustomerID = Convert.ToInt32(row[0]);
Customer.FullName = row[1].ToString();
Customer.Gender = row[2].ToString();
Customer.PhoneNumber = row[3].ToString();
Customer.Email = row[4].ToString();
Customer.BirthDay = Convert.ToDateTime(row[5]);
Customer.Address = row[6].ToString();
listEmp.Add(Customer);
}
return(listEmp);
}
