private void GetSettingsValue(int synonymsGradingId, CacheObject cacheObjectType, out object cacheValue)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM \"SynonymGradings\" WHERE id=:id";
cmd.Parameters.Add("id", synonymsGradingId);
NpgsqlDataReader reader = PostgreSQLConn.ExecuteReader(cmd, Parent.CurrentUser);
reader.Read();
int? sid = DbValueConverter.Convert <int>(reader["id"]);
bool?allKnown = DbValueConverter.Convert <bool>(reader["all_known"]);
bool?halfKnown = DbValueConverter.Convert <bool>(reader["half_known"]);
bool?oneKnown = DbValueConverter.Convert <bool>(reader["one_known"]);
bool?firstKnown = DbValueConverter.Convert <bool>(reader["first_known"]);
bool?prompt = DbValueConverter.Convert <bool>(reader["prompt"]);
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, synonymsGradingId, expires)] = allKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, synonymsGradingId, expires)] = halfKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, synonymsGradingId, expires)] = oneKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, synonymsGradingId, expires)] = firstKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, synonymsGradingId, expires)] = prompt;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsId, synonymsGradingId, expires)] = sid;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsSynonymGradingsAllKnown: cacheValue = allKnown; break;
case CacheObject.SettingsSynonymGradingsHalfKnown: cacheValue = halfKnown; break;
case CacheObject.SettingsSynonymGradingsOneKnown: cacheValue = oneKnown; break;
case CacheObject.SettingsSynonymGradingsFirstKnown: cacheValue = firstKnown; break;
case CacheObject.SettingsSynonymGradingsPrompt: cacheValue = prompt; break;
case CacheObject.SettingsSynonymGradingsId: cacheValue = sid; break;
default: cacheValue = null; break;
}
}
}
}
private void GetSettingsValue(int queryTypeId, CacheObject cacheObjectType, out object cacheValue)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM \"QueryTypes\" WHERE id=:id";
cmd.Parameters.Add("id", queryTypeId);
NpgsqlDataReader reader = PostgreSQLConn.ExecuteReader(cmd, Parent.CurrentUser);
reader.Read();
int? qid = DbValueConverter.Convert <int>(reader["id"]);
bool?imageRecognition = DbValueConverter.Convert <bool>(reader["image_recognition"]);
bool?listeningComprehension = DbValueConverter.Convert <bool>(reader["listening_comprehension"]);
bool?multipleChoice = DbValueConverter.Convert <bool>(reader["multiple_choice"]);
bool?sentenceMode = DbValueConverter.Convert <bool>(reader["sentence"]);
bool?wordMode = DbValueConverter.Convert <bool>(reader["word"]);
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesImageRecognition, queryTypeId, expires)] = imageRecognition;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesListeningComprehension, queryTypeId, expires)] = listeningComprehension;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesMultipleChoice, queryTypeId, expires)] = multipleChoice;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesSentence, queryTypeId, expires)] = sentenceMode;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesWord, queryTypeId, expires)] = wordMode;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryTypesId, queryTypeId, expires)] = qid;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsQueryTypesImageRecognition: cacheValue = imageRecognition; break;
case CacheObject.SettingsQueryTypesListeningComprehension: cacheValue = listeningComprehension; break;
case CacheObject.SettingsQueryTypesMultipleChoice: cacheValue = multipleChoice; break;
case CacheObject.SettingsQueryTypesSentence: cacheValue = sentenceMode; break;
case CacheObject.SettingsQueryTypesWord: cacheValue = wordMode; break;
case CacheObject.SettingsQueryTypesId: cacheValue = qid; break;
default: cacheValue = null; break;
}
}
}
}
/// <summary>
/// Gets the settings value.
/// </summary>
/// <param name="synonymsGradingId">The synonyms grading id.</param>
/// <param name="cacheObjectType">Type of the cache object.</param>
/// <param name="cacheValue">The cache value.</param>
/// <remarks>Documented by Dev08, 2009-01-13</remarks>
private void GetSettingsValue(int synonymsGradingId, CacheObject cacheObjectType, out object cacheValue)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "SELECT * FROM \"SynonymGradings\" WHERE id=@id";
cmd.Parameters.Add("@id", synonymsGradingId);
SqlCeDataReader reader = MSSQLCEConn.ExecuteReader(cmd);
reader.Read();
int? sid = DbValueConverter.Convert <int>(reader["id"]);
bool?allKnown = DbValueConverter.Convert <bool>(reader["all_known"]);
bool?halfKnown = DbValueConverter.Convert <bool>(reader["half_known"]);
bool?oneKnown = DbValueConverter.Convert <bool>(reader["one_known"]);
bool?firstKnown = DbValueConverter.Convert <bool>(reader["first_known"]);
bool?prompt = DbValueConverter.Convert <bool>(reader["prompt"]);
reader.Close();
//save all values to cache
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, synonymsGradingId, expires)] = allKnown;
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, synonymsGradingId, expires)] = halfKnown;
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, synonymsGradingId, expires)] = oneKnown;
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, synonymsGradingId, expires)] = firstKnown;
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, synonymsGradingId, expires)] = prompt;
parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsId, synonymsGradingId, expires)] = sid;
//set output value (the call by reference parameter)
switch (cacheObjectType)
{
case CacheObject.SettingsSynonymGradingsAllKnown: cacheValue = allKnown; break;
case CacheObject.SettingsSynonymGradingsHalfKnown: cacheValue = halfKnown; break;
case CacheObject.SettingsSynonymGradingsOneKnown: cacheValue = oneKnown; break;
case CacheObject.SettingsSynonymGradingsFirstKnown: cacheValue = firstKnown; break;
case CacheObject.SettingsSynonymGradingsPrompt: cacheValue = prompt; break;
case CacheObject.SettingsSynonymGradingsId: cacheValue = sid; break;
default: cacheValue = null; break;
}
}
}
private void GetSettingsValue(int typeGradingsId, CacheObject cacheObjectType, out object cacheValue)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM \"TypeGradings\" WHERE id=:id";
cmd.Parameters.Add("id", typeGradingsId);
NpgsqlDataReader reader = PostgreSQLConn.ExecuteReader(cmd, Parent.CurrentUser);
reader.Read();
int? gid = DbValueConverter.Convert <int>(reader["id"]);
bool?allCorrect = DbValueConverter.Convert <bool>(reader["all_correct"]);
bool?halfCorrect = DbValueConverter.Convert <bool>(reader["half_correct"]);
bool?noneCorrect = DbValueConverter.Convert <bool>(reader["none_correct"]);
bool?prompt = DbValueConverter.Convert <bool>(reader["prompt"]);
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsTypeGradingsAllCorrect, typeGradingsId, expires)] = allCorrect;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsTypeGradingsHalfCorrect, typeGradingsId, expires)] = halfCorrect;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsTypeGradingsNoneCorrect, typeGradingsId, expires)] = noneCorrect;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsTypeGradingsPrompt, typeGradingsId, expires)] = prompt;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsTypeGradingsId, typeGradingsId, expires)] = gid;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsTypeGradingsAllCorrect: cacheValue = allCorrect; break;
case CacheObject.SettingsTypeGradingsHalfCorrect: cacheValue = halfCorrect; break;
case CacheObject.SettingsTypeGradingsNoneCorrect: cacheValue = noneCorrect; break;
case CacheObject.SettingsTypeGradingsPrompt: cacheValue = prompt; break;
case CacheObject.SettingsTypeGradingsId: cacheValue = gid; break;
default: cacheValue = null; break;
}
}
}
}
private void GetSettingsValue(int multipleChoiceId, CacheObject cacheObjectType, out object cacheValue)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM \"MultipleChoiceOptions\" WHERE id=:id";
cmd.Parameters.Add("id", multipleChoiceId);
NpgsqlDataReader reader = PostgreSQLConn.ExecuteReader(cmd, Parent.CurrentUser);
reader.Read();
int? mid = DbValueConverter.Convert <int>(reader["id"]);
bool?allowMultipleCorrectAnswers = DbValueConverter.Convert <bool>(reader["allow_multiple_correct_answers"]);
bool?allowRandomDistractors = DbValueConverter.Convert <bool>(reader["allow_random_distractors"]);
int? maxCorrectAnswers = DbValueConverter.Convert <int>(reader["max_correct_answers"]);
int? numberOfChoices = DbValueConverter.Convert <int>(reader["number_of_choices"]);
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsMultipleChoiceOptionsAllowMultipleCorrectAnswers, multipleChoiceId, expires)] = allowMultipleCorrectAnswers;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsMultipleChoiceOptionsAllowRandomDistractors, multipleChoiceId, expires)] = allowRandomDistractors;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsMultipleChoiceOptionsMaxCorrectAnswers, multipleChoiceId, expires)] = maxCorrectAnswers;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsMultipleChoiceOptionsNumberOfChoices, multipleChoiceId, expires)] = numberOfChoices;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsMultipleChoiceOptionsId, multipleChoiceId, expires)] = mid;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsMultipleChoiceOptionsAllowMultipleCorrectAnswers: cacheValue = allowMultipleCorrectAnswers; break;
case CacheObject.SettingsMultipleChoiceOptionsAllowRandomDistractors: cacheValue = allowRandomDistractors; break;
case CacheObject.SettingsMultipleChoiceOptionsMaxCorrectAnswers: cacheValue = maxCorrectAnswers; break;
case CacheObject.SettingsMultipleChoiceOptionsNumberOfChoices: cacheValue = numberOfChoices; break;
case CacheObject.SettingsMultipleChoiceOptionsId: cacheValue = mid; break;
default: cacheValue = null; break;
}
}
}
}
/// <summary>
/// Gets the settings value.
/// </summary>
/// <param name="queryDirectionsId">The query directions id.</param>
/// <param name="cacheObjectType">Type of the cache object.</param>
/// <param name="cacheValue">The cache value.</param>
/// <remarks>Documented by Dev08, 2009-01-13</remarks>
private void GetSettingsValue(int queryDirectionsId, CacheObject cacheObjectType, out object cacheValue)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "SELECT * FROM \"QueryDirections\" WHERE id=@id";
cmd.Parameters.Add("@id", queryDirectionsId);
SqlCeDataReader reader = MSSQLCEConn.ExecuteReader(cmd);
reader.Read();
int? did = DbValueConverter.Convert <int>(reader["id"]);
bool?questionToAnswer = DbValueConverter.Convert <bool>(reader["question2answer"]);
bool?answerToQuestion = DbValueConverter.Convert <bool>(reader["answer2question"]);
bool?mixed = DbValueConverter.Convert <bool>(reader["mixed"]);
reader.Close();
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryDirectionsQuestion2Answer, queryDirectionsId, expires)] = questionToAnswer;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryDirectionsAnswer2Question, queryDirectionsId, expires)] = answerToQuestion;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryDirectionsMixed, queryDirectionsId, expires)] = mixed;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsQueryDirectionsId, queryDirectionsId, expires)] = did;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsQueryDirectionsQuestion2Answer: cacheValue = questionToAnswer; break;
case CacheObject.SettingsQueryDirectionsAnswer2Question: cacheValue = answerToQuestion; break;
case CacheObject.SettingsQueryDirectionsMixed: cacheValue = mixed; break;
case CacheObject.SettingsQueryDirectionsId: cacheValue = did; break;
default: cacheValue = null; break;
}
}
private void GetSettingsValue(int snoozeOptionsId, CacheObject cacheObjectType, out object cacheValue)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM \"SnoozeOptions\" WHERE id=:id";
cmd.Parameters.Add("id", snoozeOptionsId);
NpgsqlDataReader reader = PostgreSQLConn.ExecuteReader(cmd, Parent.CurrentUser);
reader.Read();
int? sid = DbValueConverter.Convert <int>(reader["id"]);
bool? cardsEnabled = DbValueConverter.Convert <bool>(reader["cards_enabled"]);
bool? rightsEnabled = DbValueConverter.Convert <bool>(reader["rights_enabled"]);
bool? timeEnabled = DbValueConverter.Convert <bool>(reader["time_enabled"]);
int? snoozeCards = DbValueConverter.Convert <int>(reader["snooze_cards"]);
int? snoozeHigh = DbValueConverter.Convert <int>(reader["snooze_high"]);
int? snoozeLow = DbValueConverter.Convert <int>(reader["snooze_low"]);
ESnoozeMode?snoozeMode = DbValueConverter.Convert <ESnoozeMode>(reader["snooze_mode"]);
int? snoozeRights = DbValueConverter.Convert <int>(reader["snooze_rights"]);
int? snoozeTime = DbValueConverter.Convert <int>(reader["snooze_time"]);
//cache values
DateTime expires = DateTime.Now.Add(Cache.DefaultSettingsValidationTime);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeCardsEnabled, snoozeOptionsId, expires)] = cardsEnabled;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeRightsEnabled, snoozeOptionsId, expires)] = rightsEnabled;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeTimeEnabled, snoozeOptionsId, expires)] = timeEnabled;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeCards, snoozeOptionsId, expires)] = snoozeCards;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeHigh, snoozeOptionsId, expires)] = snoozeHigh;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeLow, snoozeOptionsId, expires)] = snoozeLow;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeMode, snoozeOptionsId, expires)] = snoozeMode;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeRights, snoozeOptionsId, expires)] = snoozeRights;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeTime, snoozeOptionsId, expires)] = snoozeTime;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSnoozeOptionsId, snoozeOptionsId, expires)] = sid;
//set output value
switch (cacheObjectType)
{
case CacheObject.SettingsSnoozeCardsEnabled: cacheValue = cardsEnabled; break;
case CacheObject.SettingsSnoozeRightsEnabled: cacheValue = rightsEnabled; break;
case CacheObject.SettingsSnoozeTimeEnabled: cacheValue = timeEnabled; break;
case CacheObject.SettingsSnoozeCards: cacheValue = snoozeCards; break;
case CacheObject.SettingsSnoozeHigh: cacheValue = snoozeHigh; break;
case CacheObject.SettingsSnoozeLow: cacheValue = snoozeLow; break;
case CacheObject.SettingsSnoozeMode: cacheValue = snoozeMode; break;
case CacheObject.SettingsSnoozeRights: cacheValue = snoozeRights; break;
case CacheObject.SettingsSnoozeTime: cacheValue = snoozeTime; break;
case CacheObject.SettingsSnoozeOptionsId: cacheValue = sid; break;
default: cacheValue = null; break;
}
}
}
}
