private void LoadReratedMoods(int id, SQLiteDatabase sqLiteDatabase)
{
try
{
RerateMood reratedMood = new RerateMood();
string commandText = "SELECT [RerateMoodID], [MoodsID], [MoodListID], [MoodRating] FROM RerateMood WHERE [ThoughtRecordID] = " + id;
if (sqLiteDatabase.IsOpen)
{
var data = sqLiteDatabase.RawQuery(commandText, null);
if (data != null)
{
if (data.MoveToFirst())
{
do
{
reratedMood = new RerateMood();
reratedMood.RerateMoodId = data.GetInt(0);
reratedMood.ThoughtRecordId = id;
reratedMood.MoodsId = data.GetInt(1);
reratedMood.MoodListId = data.GetInt(2);
reratedMood.MoodRating = data.GetInt(3);
reratedMood.IsNew = false;
reratedMood.IsDirty = false;
RerateMoodList.Add(reratedMood);
}while (data.MoveToNext());
}
}
data.Close();
}
}
catch (Exception e)
{
throw new Exception("Load of Rerate Moods failed - " + e.Message);
}
}
public void RemoveRerateMood(RerateMood reratedMood)
{
try
{
if (reratedMood != null)
{
RerateMoodList.Remove(reratedMood);
}
}
catch (Exception e)
{
throw new Exception("Attempt to remove Rerate Mood failed - " + e.Message);
}
}
public void AddRerateMood(RerateMood newRerateMood)
{
try
{
if (newRerateMood != null)
{
RerateMoodList.Add(newRerateMood);
IsDirty = true;
}
}
catch (Exception e)
{
throw new Exception("Attempt to add Rerate Mood failed - " + e.Message);
}
}