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); }