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