partial void InsertGrucoxProprioceptionProgramSession(GrucoxProprioceptionProgramSession instance);
partial void DeleteGrucoxProprioceptionProgramSession(GrucoxProprioceptionProgramSession instance);
private static bool StoreDataProprioceptionProgram_RemoteDB(DataClasses.ProprioceptionProgram proprioceptionProgram, int UserID, int DifficultyLevel) { GrucoxProprioceptionProgramSession ProprioceptionProgramSession = new GrucoxProprioceptionProgramSession(); ProprioceptionProgramSession.DeviceUID = (new Grucox.DataManager(CalibrationSettings.Default.DataManagerConnectionString)).GetDeviceMacAddress(); ProprioceptionProgramSession.LiveUserID = UserID; ProprioceptionProgramSession.SessionDate = DateTime.Now.Subtract(TimeSpan.FromMinutes(10)); ProprioceptionProgramSession.SessionDuration = TimeSpan.FromSeconds(proprioceptionProgram.SessionDuration.Value); ProprioceptionProgramSession.LeftMaxConcP = Convert.ToDecimal(proprioceptionProgram.LeftMaxConcP); ProprioceptionProgramSession.LeftMaxEcceP = Convert.ToDecimal(proprioceptionProgram.LeftMaxEcceP); ProprioceptionProgramSession.RightMaxConcP = Convert.ToDecimal(proprioceptionProgram.RightMaxConcP); ProprioceptionProgramSession.RightMaxEcceP = Convert.ToDecimal(proprioceptionProgram.RightMaxEcceP); ProprioceptionProgramSession.LeftAvgConcP = Convert.ToDecimal(proprioceptionProgram.LeftAvgConcP); ProprioceptionProgramSession.LeftAvgEcceP = Convert.ToDecimal(proprioceptionProgram.LeftAvgEcceP); ProprioceptionProgramSession.RightAvgConcP = Convert.ToDecimal(proprioceptionProgram.RightAvgConcP); ProprioceptionProgramSession.RightAvgEcceP = Convert.ToDecimal(proprioceptionProgram.RightAvgEcceP); ProprioceptionProgramSession.LeftStrengthIndex = Convert.ToDecimal(proprioceptionProgram.LeftStrengthIndex); ProprioceptionProgramSession.LeftEnduranceIndex = Convert.ToDecimal(proprioceptionProgram.LeftEnduranceIndex); ProprioceptionProgramSession.RightStrengthIndex = Convert.ToDecimal(proprioceptionProgram.RightStrengthIndex); ProprioceptionProgramSession.RightEnduranceIndex = Convert.ToDecimal(proprioceptionProgram.RightEnduranceIndex); ProprioceptionProgramSession.DistConc = Convert.ToDecimal(proprioceptionProgram.DistConc); ProprioceptionProgramSession.DistEcce = Convert.ToDecimal(proprioceptionProgram.DistEcce); ProprioceptionProgramSession.EnergyBurned = Convert.ToDecimal(proprioceptionProgram.EnergyBurned); ProprioceptionProgramSession.DifficultyLevel = proprioceptionProgram.DifficultyLevel; ProprioceptionProgramSession.SessionDescription = "Proprioception Program"; DataClasses.GrucoxDataClassesRemoteDBDataContext dc = new DataClasses.GrucoxDataClassesRemoteDBDataContext(); var matchedItem = (from sessions in dc.GetTable<DataClasses.GrucoxProprioceptionProgramSession>() //************************************** where sessions.ItemID == ProprioceptionProgramSession.ItemID //******Check if customer already exists select sessions).SingleOrDefault(); //************************************** if (matchedItem == null) //If customer does not exist { try { dc.GrucoxProprioceptionProgramSessions.InsertOnSubmit(ProprioceptionProgramSession); dc.GrucoxProprioceptionProgramSessions.Context.SubmitChanges(); //Add the new customer to the Customers Table return true; } catch (Exception ex) { return false; } } else //Customer already exists { try { dc.SubmitChanges(); return true; } catch (Exception ex) { return false; } } }