public static bool Exists(string id)
 {
     pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter();
     if (ta.GetSumByID(id) == 0)
         return false;
     return true;
 }
 public static List<User> GetAll()
 {
     pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter();
     pmanAPI.App_Data.pmanDB.UserDataTable table = ta.GetData();
     return LoadFromModel(table);
 }
        public static User GetByID(string id)
        {
            try{
               pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.UserTableAdapter();
               pmanAPI.App_Data.pmanDB.UserDataTable table = ta.GetDataByID(id);
               pmanAPI.App_Data.pmanDB.UserRow row = (pmanAPI.App_Data.pmanDB.UserRow)table.Rows[0];

               return User.LoadFromModel(row);
               }
               catch(Exception){
               return null;
               }
        }