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