/// <summary>
/// Update or Register a new user
/// </summary>
/// <param name="NewUser"></param>
public static bool RegisterNewUser(DataClasses.UserProfile NewUser)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
try
{
var matchedItem = (from users in dc.GetTable<DataClasses.UserProfile>() //**************************************
where users.id == NewUser.id //******Check if customer already exists
select users).SingleOrDefault(); //**************************************
if (matchedItem == null) //If customer does not exist
{
try
{
dc.UserProfiles.InsertOnSubmit(NewUser);
dc.UserProfiles.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;
}
}
}
catch (System.Data.SqlClient.SqlException)
{
frmMessageDialog.DisplayBriefMessage("Local Database Connection Error");
return false;
}
catch (Exception ex)
{
frmMessageDialog.DisplayBriefMessage(ex.Message);
return false;
}
}
public static void DeleteUser(DataClasses.UserProfile CurrentUser)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedUser = (from sessions in dc.GetTable<DataClasses.UserProfile>()
where sessions.id == CurrentUser.id
select sessions).SingleOrDefault();
try
{
dc.UserProfiles.DeleteOnSubmit(matchedUser);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static bool StoreDataVO2Max_LocalDB(DataClasses.VO2MaxProgram1 vO2MaxProgram1, int UserID)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedItem = (from sessions in dc.GetTable<DataClasses.VO2MaxProgram1>() //**************************************
where sessions.id == vO2MaxProgram1.id //******Check if customer already exists
select sessions).SingleOrDefault(); //**************************************
if (matchedItem == null) //If customer does not exist
{
try
{
dc.VO2MaxProgram1s.InsertOnSubmit(vO2MaxProgram1);
dc.VO2MaxProgram1s.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;
}
}
}
private static bool StoreDataDynamicStrength_LocalDB(DataClasses.DynamicStrengthTest dynamicStrengthTest, int UserID)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedItem = (from sessions in dc.GetTable<DataClasses.DynamicStrengthTest>() //**************************************
where sessions.id == dynamicStrengthTest.id //******Check if customer already exists
select sessions).SingleOrDefault(); //**************************************
if (matchedItem == null) //If customer does not exist
{
try
{
dc.DynamicStrengthTests.InsertOnSubmit(dynamicStrengthTest);
dc.DynamicStrengthTests.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;
}
}
}
private static bool StoreDataProprioceptionProgram_LocalDB(DataClasses.ProprioceptionProgram proprioceptionProgram, int UserID, int DifficultyLevel)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedItem = (from sessions in dc.GetTable<DataClasses.ProprioceptionProgram>() //**************************************
where sessions.id == proprioceptionProgram.id //******Check if customer already exists
select sessions).SingleOrDefault(); //**************************************
if (matchedItem == null) //If customer does not exist
{
try
{
dc.ProprioceptionPrograms.InsertOnSubmit(proprioceptionProgram);
dc.ProprioceptionPrograms.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;
}
}
}
public static void ResetUserData(DataClasses.UserProfile CurrentUser)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedEntries = (from sessions in dc.GetTable<DataClasses.CustomProgram>()
where sessions.UserID == CurrentUser.id
select sessions).ToList<DataClasses.CustomProgram>();
try
{
foreach (DataClasses.CustomProgram entry in matchedEntries)
dc.CustomPrograms.DeleteOnSubmit(entry);
dc.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static bool StoreDataRehabLeft_LocalDB(DataClasses.RehabProgramLeft rehabProgramLeft, int UserID)
{
DataClasses.GrucoxDataClassDataContext dc = new DataClasses.GrucoxDataClassDataContext();
var matchedItem = (from sessions in dc.GetTable<DataClasses.RehabProgramLeft>()
where sessions.id == rehabProgramLeft.id
select sessions).SingleOrDefault();
if (matchedItem == null)
{
try
{
dc.RehabProgramLefts.InsertOnSubmit(rehabProgramLeft);
dc.RehabProgramLefts.Context.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
else
{
try
{
dc.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}