/// <summary>
/// Sets the properties for a media object.
/// </summary>
/// <param name="id">The id of the media object.</param>
/// <param name="properties">The properties for the media object.</param>
/// <remarks>Documented by Dev03, 2008-08-05</remarks>
/// <remarks>Documented by Dev03, 2009-01-13</remarks>
public void SetProperties(int id, Dictionary <MLifter.DAL.Interfaces.MediaProperty, string> properties)
{
SqlCeCommand cmd1 = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
SqlCeTransaction tran = cmd1.Connection.BeginTransaction();
cmd1.CommandText = "DELETE FROM MediaProperties WHERE media_id=@id;";
cmd1.Parameters.Add("@id", id);
MSSQLCEConn.ExecuteNonQuery(cmd1);
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "INSERT INTO MediaProperties (media_id, property, value) VALUES (@media_id, @property, @value);";
cmd.Parameters.Add("@media_id", SqlDbType.Int, 4);
cmd.Parameters.Add("@property", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@value", SqlDbType.NVarChar, 100);
foreach (KeyValuePair <MediaProperty, string> item in properties)
{
cmd.Parameters["@media_id"].Value = id;
cmd.Parameters["@property"].Value = item.Key.ToString();
cmd.Parameters["@value"].Value = item.Value;
MSSQLCEConn.ExecuteNonQuery(cmd);
}
tran.Commit();
}
/// <summary>
/// Sets the chapter for a card.
/// </summary>
/// <param name="id">The card id.</param>
/// <param name="chapter">The chapter id.</param>
/// <remarks>Documented by Dev03, 2008-08-06</remarks>
/// <remarks>Documented by Dev08, 2009-01-09</remarks>
public void SetChapter(int id, int chapter)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
SqlCeTransaction transaction = cmd.Connection.BeginTransaction();
cmd.CommandText = "SELECT count(*) FROM \"Chapters\" WHERE id=@chapterid";
cmd.Parameters.Add("chapterid", chapter);
if (Convert.ToInt32(MSSQLCEConn.ExecuteScalar(cmd)) < 1)
{
throw new IdAccessException(chapter);
}
Dictionary <int, int> cardChapterCache = parent.CurrentUser.Cache[ObjectLifetimeIdentifier.GetIdentifier(CacheObject.CardChapterList, 0)] as Dictionary <int, int>;
if (cardChapterCache != null)
{
cardChapterCache[id] = chapter;
}
using (SqlCeCommand cmd2 = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd2.CommandText = "DELETE FROM \"Chapters_Cards\" WHERE cards_id=@id; ";
cmd2.CommandText += "INSERT INTO \"Chapters_Cards\" (chapters_id, cards_id) VALUES (@chapterid, @id);";
cmd2.CommandText += "UPDATE Cards SET chapters_id=@chapterid WHERE id=@id;";
cmd2.Parameters.Add("@chapterid", chapter);
cmd2.Parameters.Add("@id", id);
MSSQLCEConn.ExecuteNonQuery(cmd2);
}
transaction.Commit();
}
}
/// <summary>
/// Sets a single property value for a media object.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="property">The property.</param>
/// <param name="value">The value.</param>
/// <remarks>Documented by Dev02, 2008-08-07</remarks>
/// <remarks>Documented by Dev03, 2009-01-13</remarks>
public void SetPropertyValue(int id, MLifter.DAL.Interfaces.MediaProperty property, string value)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
SqlCeTransaction tran = cmd.Connection.BeginTransaction();
if (GetPropertyValue(id, property) == null)
{
cmd.CommandText = "INSERT INTO MediaProperties (media_id, property, value) VALUES (@media_id, @property, @value);";
}
else
{
cmd.CommandText = "UPDATE MediaProperties SET value=@value WHERE media_id=@media_id AND property=@property;";
}
Dictionary <MediaProperty, string> properties = Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.GetIdentifier(CacheObject.MediaProperties, id)] as Dictionary <MediaProperty, string>;
if (properties == null)
{
properties = new Dictionary <MediaProperty, string>();
}
properties[property] = value;
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.MediaProperties, id, new TimeSpan(1, 0, 0))] = properties;
cmd.Parameters.Add("@media_id", id);
cmd.Parameters.Add("@property", property.ToString());
cmd.Parameters.Add("@value", value);
MSSQLCEConn.ExecuteNonQuery(cmd);
tran.Commit();
}
/// <summary>
/// Copies the statistics.
/// </summary>
/// <param name="lmId">The lm id.</param>
/// <param name="statistic">The statistic.</param>
/// <remarks>Documented by Dev08, 2009-02-09</remarks>
public void CopyStatistics(int lmId, IStatistic statistic)
{
if (statistic.StartTimestamp == null || statistic.EndTimestamp == null) //do not save invalid sessions
{
return;
}
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser);
cmd.CommandText = "INSERT INTO LearningSessions(user_id, lm_id, starttime, endtime, sum_right, sum_wrong, " +
"pool_content, box1_content, box2_content, box3_content, box4_content, box5_content, box6_content, box7_content, box8_content, box9_content, box10_content)" +
"VALUES(@userid, @lmid, @starttime, @endtime, @sumright, @sumwrong, @pool, @b1, @b2, @b3, @b4, @b5, @b6, @b7, @b8, @b9, @b10)";
cmd.Parameters.Add("@userid", parent.CurrentUser.Id);
cmd.Parameters.Add("@lmid", lmId);
cmd.Parameters.Add("@starttime", statistic.StartTimestamp);
cmd.Parameters.Add("@endtime", statistic.EndTimestamp);
cmd.Parameters.Add("@sumright", statistic.Right);
cmd.Parameters.Add("@sumwrong", statistic.Wrong);
int counter = 0;
foreach (int box in statistic.Boxes)
{
++counter;
cmd.Parameters.Add("@b" + counter.ToString(), box);
}
cmd.Parameters.Add("@pool", parent.GetParentDictionary().Boxes.Box[0].MaximalSize); //pool max size => cards in pools
MSSQLCEConn.ExecuteNonQuery(cmd);
}
public void RecalculateBoxSizes(int sessionId)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE LearningSessions SET pool_content=@pool, box1_content=@b1, box2_content=@b2, box3_content=@b3, " +
"box4_content=@b4, box5_content=@b5, box6_content=@b6, box7_content=@b7, box8_content=@b8, box9_content=@b9, box10_content=@b10 WHERE id=@sid AND user_id=@uid AND lm_id=@lmid";
cmd.Parameters.Add("sid", sessionId);
cmd.Parameters.Add("@uid", Parent.CurrentUser.Id);
cmd.Parameters.Add("@lmid", Parent.GetParentDictionary().Id);
int counter = 0;
int cardsInBoxes = 0;
BoxSizes boxContent = GetCurrentBoxContent();
foreach (int box in boxContent.Sizes)
{
if (counter == 0)
{
cmd.Parameters.Add("@pool", box);
++counter;
continue;
}
cmd.Parameters.Add("@b" + Convert.ToString(counter++), box);
cardsInBoxes += box;
}
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Deletes the chapter.
/// </summary>
/// <param name="lmid">The id of the learning module.</param>
/// <param name="id">The id.</param>
/// <remarks>Documented by Dev02, 2008-08-05</remarks>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void DeleteChapter(int lmid, int id)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "DELETE FROM LearningModules_Cards WHERE cards_id IN (SELECT cards_id FROM Chapters_Cards WHERE chapters_id=@id); ";
cmd.CommandText += "DELETE FROM Cards_MediaContent WHERE cards_id IN (SELECT cards_id FROM Chapters_Cards WHERE chapters_id=@id); ";
cmd.CommandText += "DELETE FROM UserCardState WHERE cards_id IN (SELECT cards_id FROM Chapters_Cards WHERE chapters_id=@id); ";
cmd.CommandText += "DELETE FROM TextContent WHERE cards_id IN (SELECT cards_id FROM Chapters_Cards WHERE chapters_id=@id); ";
cmd.CommandText += "DELETE FROM LearnLog WHERE cards_id IN (SELECT cards_id FROM Chapters_Cards WHERE chapters_id=@id); ";
cmd.CommandText += "DELETE FROM Chapters_Cards WHERE chapters_id=@id; ";
cmd.CommandText += "DELETE FROM SelectedLearnChapters WHERE chapters_id=@id; ";
cmd.CommandText += "DELETE FROM Cards_MediaContent WHERE cards_id NOT IN (SELECT cards_id FROM LearningModules_Cards); ";
cmd.CommandText += "DELETE FROM UserCardState WHERE cards_id NOT IN (SELECT cards_id FROM LearningModules_Cards); ";
cmd.CommandText += "DELETE FROM TextContent WHERE cards_id NOT IN (SELECT cards_id FROM LearningModules_Cards); ";
cmd.CommandText += "DELETE FROM LearnLog WHERE cards_id NOT IN (SELECT cards_id FROM LearningModules_Cards); ";
cmd.CommandText += "DELETE FROM Cards WHERE id NOT IN (SELECT cards_id FROM LearningModules_Cards); ";
cmd.CommandText += "DELETE FROM Chapters WHERE id=@id";
cmd.Parameters.Add("@id", id);
if (MSSQLCEConn.ExecuteNonQuery(cmd) < 1)
{
throw new IdAccessException(id);
}
parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(CacheObject.ChaptersList, lmid));
}
}
/// <summary>
/// Deletes the media object.
/// </summary>
/// <param name="id">The id.</param>
/// <remarks>Documented by Dev03, 2008-08-05</remarks>
/// <remarks>Documented by Dev03, 2009-01-13</remarks>
public void DeleteMedia(int id)
{
SqlCeCommand deletecmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
deletecmd.CommandText = "DELETE FROM MediaProperties WHERE media_id=@id; DELETE FROM MediaContent WHERE id=@id;";
deletecmd.Parameters.Add("@id", id);
MSSQLCEConn.ExecuteNonQuery(deletecmd);
}
/// <summary>
/// Sets the default.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="Default">if set to <c>true</c> [default].</param>
/// <remarks>Documented by Dev03, 2009-01-09</remarks>
public void SetDefault(int id, bool Default)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE TextContent SET is_default=@isdefault WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@isdefault", Default);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Sets the type.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="Type">The type.</param>
/// <remarks>Documented by Dev03, 2009-01-09</remarks>
public void SetType(int id, WordType Type)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE TextContent SET type=@typ WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@typ", Type);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Clears the media for card style.
/// </summary>
/// <param name="Id">The style id.</param>
/// <remarks>Documented by Dev03, 2009-03-05</remarks>
/// <remarks>Documented by Dev03, 2009-03-05</remarks>
public void ClearMediaForCardStyle(int Id)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "DELETE FROM \"MediaContent_CardStyles\" WHERE cardstyles_id = @cardstyle_id";
cmd.Parameters.Add("@cardstyle_id", Id);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the word.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="Word">The word.</param>
/// <remarks>Documented by Dev03, 2009-01-09</remarks>
public void SetWord(int id, string Word)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE TextContent SET text=@text WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@text", Word);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Deletes the extension.
/// </summary>
/// <param name="guid">The GUID.</param>
public void DeleteExtension(Guid guid)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "DELETE FROM \"ExtensionActions\" WHERE guid=@guid; ";
cmd.CommandText += "DELETE FROM \"Extensions\" WHERE guid=@guid";
cmd.Parameters.Add("@guid", guid.ToString());
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the extension version.
/// </summary>
/// <param name="guid">The GUID.</param>
/// <param name="versionName">Name of the version.</param>
/// <remarks>Documented by Dev08, 2009-07-02</remarks>
public void SetExtensionVersion(Guid guid, Version versionName)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Extensions\" SET version=@version WHERE guid=@guid;";
cmd.Parameters.Add("@guid", guid.ToString());
cmd.Parameters.Add("@version", versionName.ToString());
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the GUID.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="guid">The GUID.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetGuid(int id, string guid)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"LearningModules\" SET guid=@guid WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@guid", guid);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the type of the extension.
/// </summary>
/// <param name="guid">The GUID.</param>
/// <param name="extensionType">Type of the extension.</param>
/// <remarks>Documented by Dev08, 2009-07-02</remarks>
public void SetExtensionType(Guid guid, ExtensionType extensionType)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Extensions\" SET type=@type WHERE guid=@guid;";
cmd.Parameters.Add("@guid", guid.ToString());
cmd.Parameters.Add("@type", extensionType.ToString());
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the extension LM.
/// </summary>
/// <param name="guid">The GUID.</param>
/// <param name="lmid">The lmid.</param>
public void SetExtensionLM(Guid guid, int lmid)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Extensions\" SET lm_id=@lmid WHERE guid=@guid";
cmd.Parameters.Add("@guid", guid.ToString());
cmd.Parameters.Add("@lmid", lmid);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the description.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="description">The description.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetDescription(int id, string description)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"LearningModules\" SET description=@description WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@description", description);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the allowed settings.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="settingsId">The settings id.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetAllowedSettings(int id, int settingsId)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"LearningModules\" SET allowed_settings_id=@settingsid WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@settingsid", settingsId);
MSSQLCEConn.ExecuteNonQuery(cmd);
parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(CacheObject.AllowedLearningModuleSettings, id));
}
}
public void ClearAllBoxes(int id)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"UserCardState\" SET box=0, active=1 WHERE user_id=@userid " +
"AND cards_id IN (SELECT cards_id FROM \"LearningModules_Cards\" WHERE lm_id=@lmid);";
cmd.Parameters.Add("@lmid", id);
cmd.Parameters.Add("@userid", Parent.CurrentUser.Id);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the author.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="author">The author.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetAuthor(int id, string author)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"LearningModules\" SET author=@author WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@author", author);
MSSQLCEConn.ExecuteNonQuery(cmd);
parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(CacheObject.LearningModuleAuthor, id));
}
}
/// <summary>
/// Sets the title.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="title">The title.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetTitle(int id, string title)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"LearningModules\" SET title=@title WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@title", title);
MSSQLCEConn.ExecuteNonQuery(cmd);
parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(CacheObject.LearningModuleTitle, id));
}
}
public void CardFromBoxDeleted(int sessionId, int boxId)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = string.Format("UPDATE LearningSessions SET {0}_content={0}_content - 1 WHERE id=@sid AND user_id=@uid AND lm_id=@lmid", boxId > 0 ? "box" + boxId.ToString() : "pool");
cmd.Parameters.Add("sid", sessionId);
cmd.Parameters.Add("@uid", Parent.CurrentUser.Id);
cmd.Parameters.Add("@lmid", Parent.GetParentDictionary().Id);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Sets the description of the chapter.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="description">The description.</param>
/// <remarks>Documented by Dev02, 2008-08-05</remarks>
/// <remarks>Documented by Dev05, 2009-01-15</remarks>
public void SetDescription(int id, string description)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Chapters\" SET description=@description WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@description", description);
MSSQLCEConn.ExecuteNonQuery(cmd);
Parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(CacheObject.ChapterDescription, id));
}
}
public void CardAdded(int sessionId)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE LearningSessions SET pool_content=pool_content + 1 WHERE id=@sid AND user_id=@uid AND lm_id=@lmid";
cmd.Parameters.Add("sid", sessionId);
cmd.Parameters.Add("@uid", Parent.CurrentUser.Id);
cmd.Parameters.Add("@lmid", Parent.GetParentDictionary().Id);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Updates the media.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="media">The media.</param>
/// <remarks>Documented by Dev02, 2008-08-06</remarks>
/// <remarks>Documented by Dev03, 2009-01-13</remarks>
public void UpdateMedia(int id, System.IO.Stream media)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "UPDATE MediaContent SET data=@data WHERE id=@id";
cmd.Parameters.Add("@data", SqlDbType.Image);
cmd.Parameters.Add("@id", SqlDbType.Int, 4);
cmd.Parameters["@data"].Value = GetByteArrayFromStream(media, null, null);
cmd.Parameters["@id"].Value = id;
MSSQLCEConn.ExecuteNonQuery(cmd);
}
/// <summary>
/// Sets the extension stream.
/// </summary>
/// <param name="guid">The GUID.</param>
/// <param name="extensionStream">The extension stream.</param>
/// <remarks>Documented by Dev08, 2009-07-02</remarks>
public void SetExtensionStream(Guid guid, Stream extensionStream)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Extensions\" SET data=@data WHERE guid=@guid";
cmd.Parameters.Add("@guid", guid.ToString());
cmd.Parameters.Add("@data", SqlDbType.Image);
cmd.Parameters["@data"].Value = GetByteArrayFromStream(extensionStream, null, null);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Sets the settings.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="Settings">The settings.</param>
/// <remarks>Documented by Dev05, 2009-01-15</remarks>
public void SetSettings(int id, ISettings Settings)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"Chapters\" SET settings_id=@value WHERE id=@id";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@value", (Settings as DbSettings).Id);
MSSQLCEConn.ExecuteNonQuery(cmd);
Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.ChapterSetting, id)] = (Settings as DbSettings).Id;
}
}
/// <summary>
/// Sets the highscore.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="highscore">The highscore.</param>
/// <remarks>Documented by Dev08, 2009-01-13</remarks>
public void SetHighscore(int id, double highscore)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd.CommandText = "UPDATE \"UserProfilesLearningModulesSettings\" SET highscore=@value WHERE user_id=@uid and lm_id=@lm_id;";
cmd.Parameters.Add("@uid", parent.CurrentUser.Id);
cmd.Parameters.Add("@lm_id", id);
cmd.Parameters.Add("@value", highscore);
MSSQLCEConn.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Clears all words.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="side">The side.</param>
/// <param name="type">The type.</param>
/// <remarks>Documented by Dev03, 2009-01-09</remarks>
public void ClearAllWords(int id, Side side, WordType type)
{
SqlCeCommand cmd = MSSQLCEConn.CreateCommand(Parent.CurrentUser);
cmd.CommandText = "DELETE FROM TextContent WHERE cards_id=@id AND side=@side AND type=@type";
cmd.Parameters.Add("@id", id);
cmd.Parameters.Add("@side", side.ToString());
cmd.Parameters.Add("@type", type.ToString());
MSSQLCEConn.ExecuteNonQuery(cmd);
Parent.CurrentUser.Cache.Uncache(ObjectLifetimeIdentifier.GetIdentifier(ObjectLifetimeIdentifier.GetCacheObject(side, type), id));
}
/// <summary>
/// Sets the card style.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="cardStyle">The card style.</param>
/// <remarks>Documented by Dev08, 2009-01-12</remarks>
public void SetCardStyle(int id, string cardStyle)
{
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
using (SqlCeCommand cmd2 = MSSQLCEConn.CreateCommand(parent.CurrentUser))
{
cmd2.CommandText = "UPDATE \"CardStyles\" SET value=@value WHERE id=@id";
cmd2.Parameters.Add("@id", id);
cmd2.Parameters.Add("@value", cardStyle);
MSSQLCEConn.ExecuteNonQuery(cmd2);
}
}
}