public GradeSynonyms(IGradeSynonyms defaultSettings, IGradeSynonyms userSettings)
{
this.defaultSettings = defaultSettings;
this.userSettings = userSettings;
}
public GradeSynonyms(IGradeSynonyms defaultSettings, IGradeSynonyms userSettings)
{
this.defaultSettings = defaultSettings;
this.userSettings = userSettings;
}
/// <summary>
/// Sets the grade synonyms.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="GradeSynonyms">The grade synonyms.</param>
/// <remarks>Documented by Dev11, 2008-08-14</remarks>
public void SetGradeSynonyms(int id, IGradeSynonyms GradeSynonyms)
{
using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
{
using (NpgsqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT synonym_gradings FROM \"Settings\" WHERE id=:id";
cmd.Parameters.Add("id", id);
int gsid = Convert.ToInt32(PostgreSQLConn.ExecuteScalar(cmd, Parent.CurrentUser));
if (gsid > 0)
{
using (NpgsqlCommand cmd2 = con.CreateCommand())
{
cmd2.CommandText = "UPDATE \"SynonymGradings\" SET all_known=:a_k, half_known=:h_k, one_known=:o_k, first_known=:f_k, prompt=:p WHERE id=:id";
cmd2.Parameters.Add("id", gsid);
cmd2.Parameters.Add("a_k", GradeSynonyms.AllKnown);
cmd2.Parameters.Add("h_k", GradeSynonyms.HalfKnown);
cmd2.Parameters.Add("o_k", GradeSynonyms.OneKnown);
cmd2.Parameters.Add("f_k", GradeSynonyms.FirstKnown);
cmd2.Parameters.Add("p", GradeSynonyms.Prompt);
PostgreSQLConn.ExecuteNonQuery(cmd2, Parent.CurrentUser);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFk, id, Cache.DefaultSettingsValidationTime)] = gsid;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.AllKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.HalfKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.OneKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.FirstKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.Prompt;
}
}
else
{
using (NpgsqlCommand cmd3 = con.CreateCommand())
{
cmd3.CommandText = "INSERT INTO \"SynonymGradings\" (all_known, half_known, one_known, first_known, prompt) VALUES " +
"(:a_k, :h_k, :o_k, :f_k, :p); UPDATE \"Settings\" SET synonym_gradings=currval('\"SynonymGradings\"') WHERE id=:id;" +
"SELECT synonym_grading FROM \"Settings\" WHERE id=:id";
cmd3.Parameters.Add("id", id);
cmd3.Parameters.Add("a_k", GradeSynonyms.AllKnown);
cmd3.Parameters.Add("h_k", GradeSynonyms.HalfKnown);
cmd3.Parameters.Add("o_k", GradeSynonyms.OneKnown);
cmd3.Parameters.Add("f_k", GradeSynonyms.FirstKnown);
cmd3.Parameters.Add("p", GradeSynonyms.Prompt);
int? synonymsGrading = PostgreSQLConn.ExecuteScalar<int>(cmd3, Parent.CurrentUser);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFk, id, Cache.DefaultSettingsValidationTime)] = synonymsGrading;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.AllKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.HalfKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.OneKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.FirstKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.Prompt;
}
}
}
}
}
/// <summary>
/// Sets the grade synonyms.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="GradeSynonyms">The grade synonyms.</param>
/// <remarks>Documented by Dev05, 2009-01-15</remarks>
public void SetGradeSynonyms(int id, IGradeSynonyms GradeSynonyms)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "SELECT synonym_gradings FROM \"Settings\" WHERE id=@id";
cmd.Parameters.Add("@id", id);
int gsid = Convert.ToInt32(MSSQLCEConn.ExecuteScalar(cmd));
if (gsid > 0)
{
SqlCeCommand cmd2 = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd2.CommandText = "UPDATE \"SynonymGradings\" SET all_known=@a_k, half_known=@h_k, one_known=@o_k, first_known=@f_k, prompt=@p WHERE id=@id";
cmd2.Parameters.Add("@id", gsid);
cmd2.Parameters.Add("@a_k", GradeSynonyms.AllKnown);
cmd2.Parameters.Add("@h_k", GradeSynonyms.HalfKnown);
cmd2.Parameters.Add("@o_k", GradeSynonyms.OneKnown);
cmd2.Parameters.Add("@f_k", GradeSynonyms.FirstKnown);
cmd2.Parameters.Add("@p", GradeSynonyms.Prompt);
MSSQLCEConn.ExecuteNonQuery(cmd2);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFk, id, Cache.DefaultSettingsValidationTime)] = gsid;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.AllKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.HalfKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.OneKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.FirstKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, gsid, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.Prompt;
}
else
{
SqlCeCommand cmd3 = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd3.CommandText = "INSERT INTO \"SynonymGradings\" (all_known, half_known, one_known, first_known, prompt) VALUES " +
"(@a_k, @h_k, @o_k, @f_k, @p); UPDATE \"Settings\" SET synonym_gradings=@@IDENTITY WHERE id=@id;" +
"SELECT synonym_grading FROM \"Settings\" WHERE id=@id";
cmd3.Parameters.Add("@id", id);
cmd3.Parameters.Add("@a_k", GradeSynonyms.AllKnown);
cmd3.Parameters.Add("@h_k", GradeSynonyms.HalfKnown);
cmd3.Parameters.Add("@o_k", GradeSynonyms.OneKnown);
cmd3.Parameters.Add("@f_k", GradeSynonyms.FirstKnown);
cmd3.Parameters.Add("@p", GradeSynonyms.Prompt);
int? synonymsGrading = MSSQLCEConn.ExecuteScalar<int>(cmd3);
//Save to Cache
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFk, id, Cache.DefaultSettingsValidationTime)] = synonymsGrading;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsAllKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.AllKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsHalfKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.HalfKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsOneKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.OneKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsFirstKnown, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.FirstKnown;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.SettingsSynonymGradingsPrompt, synonymsGrading.Value, Cache.DefaultSettingsValidationTime)] = GradeSynonyms.Prompt;
}
}