public static DataClasses.DynamicStrengthTest GetDynamicStrengthRemotePB(int UserID)
        {
            DataClasses.GrucoxDataClassesRemoteDBDataContext dc = new DataClasses.GrucoxDataClassesRemoteDBDataContext();
            List<DataClasses.GrucoxDynamicStrengthTestSession> ListDynamicStrengthPB = new List<DataClasses.GrucoxDynamicStrengthTestSession>();
            DataClasses.DynamicStrengthTest DynamicStrengthPB = new DynamicStrengthTest();

            try
            {
                ListDynamicStrengthPB = (from sessions in dc.GetTable<DataClasses.GrucoxDynamicStrengthTestSession>()
                                         where sessions.LiveUserID == UserID
                                         select sessions).ToList<DataClasses.GrucoxDynamicStrengthTestSession>();
            }
            catch (Exception)
            {
                //For Diagnostics - Should be removed
                DataComms.CreateThreadInstance("DB Access during GetDynamicStrengthRemotePB");
                DynamicStrengthPB.LeftMaxTorqueConc = 0;
                DynamicStrengthPB.LeftMaxTorqueEcce = 0;
                DynamicStrengthPB.RightMaxTorqueConc = 0;
                DynamicStrengthPB.RightMaxTorqueEcce = 0;
                DynamicStrengthPB.SpeedLeftMaxConc = 0;
                DynamicStrengthPB.SpeedLeftMaxEcce = 0;
                DynamicStrengthPB.SpeedRightMaxConc = 0;
                DynamicStrengthPB.SpeedRightMaxEcce = 0;
            }
            finally
            {
                if (ListDynamicStrengthPB.Count > 0)
                {
                    DynamicStrengthPB.LeftMaxTorqueConc = (double)(ListDynamicStrengthPB.First(x => x.LeftMaxTorqueConc == ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueConc))).LeftMaxTorqueConc;
                    DynamicStrengthPB.LeftMaxTorqueEcce = (double)(ListDynamicStrengthPB.First(x => x.LeftMaxTorqueEcce == ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueEcce))).LeftMaxTorqueEcce;
                    DynamicStrengthPB.RightMaxTorqueConc = (double)(ListDynamicStrengthPB.First(x => x.RightMaxTorqueConc == ListDynamicStrengthPB.Max(i => i.RightMaxTorqueConc))).RightMaxTorqueConc;
                    DynamicStrengthPB.RightMaxTorqueEcce = (double)(ListDynamicStrengthPB.First(x => x.RightMaxTorqueEcce == ListDynamicStrengthPB.Max(i => i.RightMaxTorqueEcce))).RightMaxTorqueEcce;
                    DynamicStrengthPB.SpeedLeftMaxConc = (int)(ListDynamicStrengthPB.First(x => x.LeftMaxTorqueConc == ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueConc))).SpeedLeftMaxConc;
                    DynamicStrengthPB.SpeedLeftMaxEcce = (int)(ListDynamicStrengthPB.First(x => x.LeftMaxTorqueEcce == ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueEcce))).SpeedLeftMaxEcce;
                    DynamicStrengthPB.SpeedRightMaxConc = (int)(ListDynamicStrengthPB.First(x => x.RightMaxTorqueConc == ListDynamicStrengthPB.Max(i => i.RightMaxTorqueConc))).SpeedRightMaxConc;
                    DynamicStrengthPB.SpeedRightMaxEcce = (int)(ListDynamicStrengthPB.First(x => x.RightMaxTorqueEcce == ListDynamicStrengthPB.Max(i => i.RightMaxTorqueEcce))).SpeedRightMaxEcce;
                }
                else
                {
                    DynamicStrengthPB.LeftMaxTorqueConc = 0;
                    DynamicStrengthPB.LeftMaxTorqueEcce = 0;
                    DynamicStrengthPB.RightMaxTorqueConc = 0;
                    DynamicStrengthPB.RightMaxTorqueEcce = 0;
                    DynamicStrengthPB.SpeedLeftMaxConc = 0;
                    DynamicStrengthPB.SpeedLeftMaxEcce = 0;
                    DynamicStrengthPB.SpeedRightMaxConc = 0;
                    DynamicStrengthPB.SpeedRightMaxEcce = 0;
                }
            }
            return DynamicStrengthPB;
        }
        public static DataClasses.DynamicStrengthTest GetDynamicStrengthPB(int UserID)
        {
            DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
            List<DataClasses.DynamicStrengthTest> ListDynamicStrengthPB = new List<DataClasses.DynamicStrengthTest>();
            DataClasses.DynamicStrengthTest DynamicStrengthPB = new DynamicStrengthTest();

            ListDynamicStrengthPB = (from sessions in dc.GetTable<DataClasses.DynamicStrengthTest>()
                                     where sessions.UserID == UserID
                                     select sessions).ToList<DataClasses.DynamicStrengthTest>();

            if (ListDynamicStrengthPB.Count > 0)
            {
                DynamicStrengthPB.LeftMaxTorqueConc = (ListDynamicStrengthPB.First(x => x.LeftMaxTorqueConc == (double)ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueConc))).LeftMaxTorqueConc;
                DynamicStrengthPB.LeftMaxTorqueEcce = (ListDynamicStrengthPB.First(x => x.LeftMaxTorqueEcce == (double)ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueEcce))).LeftMaxTorqueEcce;
                DynamicStrengthPB.RightMaxTorqueConc = (ListDynamicStrengthPB.First(x => x.RightMaxTorqueConc == (double)ListDynamicStrengthPB.Max(i => i.RightMaxTorqueConc))).RightMaxTorqueConc;
                DynamicStrengthPB.RightMaxTorqueEcce = (ListDynamicStrengthPB.First(x => x.RightMaxTorqueEcce == (double)ListDynamicStrengthPB.Max(i => i.RightMaxTorqueEcce))).RightMaxTorqueEcce;
                DynamicStrengthPB.SpeedLeftMaxConc = (ListDynamicStrengthPB.First(x => x.LeftMaxTorqueConc == (double)ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueConc))).SpeedLeftMaxConc;
                DynamicStrengthPB.SpeedLeftMaxEcce = (ListDynamicStrengthPB.First(x => x.LeftMaxTorqueEcce == (double)ListDynamicStrengthPB.Max(i => i.LeftMaxTorqueEcce))).SpeedLeftMaxEcce;
                DynamicStrengthPB.SpeedRightMaxConc = (ListDynamicStrengthPB.First(x => x.RightMaxTorqueConc == (double)ListDynamicStrengthPB.Max(i => i.RightMaxTorqueConc))).SpeedRightMaxConc;
                DynamicStrengthPB.SpeedRightMaxEcce = (int)(ListDynamicStrengthPB.First(x => x.RightMaxTorqueEcce == (double)ListDynamicStrengthPB.Max(i => i.RightMaxTorqueEcce))).SpeedRightMaxEcce;
            }
            else
            {
                DynamicStrengthPB.LeftMaxTorqueConc = 0;
                DynamicStrengthPB.LeftMaxTorqueEcce = 0;
                DynamicStrengthPB.RightMaxTorqueConc = 0;
                DynamicStrengthPB.RightMaxTorqueEcce = 0;
                DynamicStrengthPB.SpeedLeftMaxConc = 0;
                DynamicStrengthPB.SpeedLeftMaxEcce = 0;
                DynamicStrengthPB.SpeedRightMaxConc = 0;
                DynamicStrengthPB.SpeedRightMaxEcce = 0;
            }

            return DynamicStrengthPB;
        }
 partial void UpdateDynamicStrengthTest(DynamicStrengthTest instance);
 partial void DeleteDynamicStrengthTest(DynamicStrengthTest instance);
 partial void InsertDynamicStrengthTest(DynamicStrengthTest instance);