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