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