public List<File> getFiles(User u)
{
DBManager mdb = new DBManager();
DataTable dt = mdb.getFile(u.phoneId,false);
List<File> list = new List<File>();
if (dt != null)
foreach (DataRow r in dt.Rows)
{
File f = new File();
f.name = (string)r["name"];
f.process = (bool)r["process"];
f.isZip = (bool)r["isZip"];
list.Add(f);
}
return list;
}
public List<User> getUsers()
{
DBManager mdb = new DBManager();
DataTable dt = mdb.getUsers(null);
List<User> list = new List<User>();
if (dt != null)
foreach (DataRow r in dt.Rows)
{
User u = new User();
u.name = (string)r["Name"];
u.phoneId = (string)r["phoneId"];
u.phoneModel = (string)r["phoneModel"];
u.version = (string)r["version"];
u.maxLocation = (int)r["maxLocations"];
if (r["lastLocationProcess"] != DBNull.Value)
u.lastLocationProcess = (DateTime)r["lastLocationProcess"];
list.Add(u);
}
return list;
}