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