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