partial void InsertGrucoxStaticStrengthTestSession(GrucoxStaticStrengthTestSession instance);
partial void DeleteGrucoxStaticStrengthTestSession(GrucoxStaticStrengthTestSession instance);
private static bool StoreDataStaticStrength_RemoteDB(DataClasses.StaticStrengthTest staticStrengthTest, int UserID)
{
DataClasses.GrucoxStaticStrengthTestSession StaticStrengthTestSession = new GrucoxStaticStrengthTestSession();
StaticStrengthTestSession.DeviceUID = (new Grucox.DataManager(CalibrationSettings.Default.DataManagerConnectionString)).GetDeviceMacAddress();
StaticStrengthTestSession.LiveUserID = UserID;
StaticStrengthTestSession.SessionDate = DateTime.Now.Subtract(TimeSpan.FromMinutes(10));
StaticStrengthTestSession.LeftMaxTorque = Convert.ToDecimal(staticStrengthTest.LeftMaxTorque.Value);
StaticStrengthTestSession.RightMaxTorque = Convert.ToDecimal(staticStrengthTest.RightMaxTorque.Value);
DataClasses.GrucoxDataClassesRemoteDBDataContext dc = new DataClasses.GrucoxDataClassesRemoteDBDataContext();
var matchedItem = (from sessions in dc.GetTable<DataClasses.GrucoxStaticStrengthTestSession>() //**************************************
where sessions.ItemID == StaticStrengthTestSession.ItemID //******Check if customer already exists
select sessions).SingleOrDefault(); //**************************************
if (matchedItem == null) //If customer does not exist
{
try
{
dc.GrucoxStaticStrengthTestSessions.InsertOnSubmit(StaticStrengthTestSession);
dc.GrucoxStaticStrengthTestSessions.Context.SubmitChanges(); //Add the new customer to the Customers Table
return true;
}
catch (Exception)
{
return false;
}
}
else //Customer already exists
{
try
{
dc.SubmitChanges();
return true;
}
catch (Exception)
{
return false;
}
}
}
