public static List <Customer> GetList() { var list = new List <Customer>(); db.ReaderRows(db.ReturnCommand("select * from tbCustomer"), row => list.Add(new Customer(AccountDAO.GetById((uint)row[0]), (string)row[1], (string)row[2], (string)row[3], row[4] + ""))); return(list); }
public static List <Employee> GetList() { var list = new List <Employee>(); string query = "select LoginId, EmpName, EmpBirthDate, EmpCPF, EmpRG, EmpRG_n, EmpGender, EmpPhoneNumber, EmpSalary, EmpImage from tbEmployee"; db.ReaderRows(db.ReturnCommand(query), row => list.Add(new Employee((uint)row[0], AccountDAO.GetById((uint)row[0]), (string)row[1], row[2].ToString(), (string)row[3], row[4].ToString(), Convert.ToChar(row[5]), Convert.ToChar(row[6]), row[7].ToString(), (decimal)row[8], row[9].ToString()))); return(list); }
public static IEnumerable <Customer> GetList() { var list = new List <Customer>(); Database.ReaderRows(Database.ReturnCommand("select * from tbCustomer"), row => list.Add(new Customer((uint)row[0], AccountDAO.GetById((uint)row[0]), (string)row[1], (string)row[2], row[3] + ""))); return(list); }