Exemplo n.º 1
0
        public List <dtoEmployee> GetEmployees()
        {
            dalEmployee        dalEmployee = new dalEmployee();
            List <dtoEmployee> listEmp     = new List <dtoEmployee>();
            DataTable          employees   = dalEmployee.GetEmployees();

            for (int i = 0; i < employees.Rows.Count; i++)
            {
                dtoEmployee employee = new dtoEmployee();
                DataRow     row      = employees.Rows[i];
                employee.EmployeeID  = Convert.ToInt32(row[0]);
                employee.FullName    = row[1].ToString();
                employee.Potrait     = (byte[])row[2];
                employee.BirthDay    = Convert.ToDateTime(row[3]);
                employee.Gender      = row[4].ToString();
                employee.Address     = row[5].ToString();
                employee.PhoneNumber = row[6].ToString();
                employee.Email       = row[7].ToString();
                employee.BasicSalary = Convert.ToDecimal(row[8]);
                employee.JobTitleID  = Convert.ToInt32(row[9]);
                employee.StartDay    = Convert.ToDateTime(row[10]);
                listEmp.Add(employee);
            }
            return(listEmp);
        }
Exemplo n.º 2
0
        public string GetEmployeeName(int id)
        {
            dalEmployee dal  = new dalEmployee();
            DataTable   data = dal.GetEmployees();

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