private void HandleFormLoad(object sender, EventArgs e)
{
_readItem = Communicator.Instance.GetReadItem() ?? new ReadItem();
if (_readItem == null)
{
_currentChapter = _startingChapter = 1;
setCurrentChapterTextBox.Text = setStartingChapterTextBox.Text = @"1";
}
else
{
setCurrentChapterTextBox.Text = _readItem.CurrentChapter.ToString();
setStartingChapterTextBox.Text = _readItem.StartingChapter.ToString();
if (_readItem.LastRead != null) setDateLastReadDateTimePicker.Value = (DateTime) _readItem.LastRead;
setOnlineURLTextbox.Text = _readItem.OnlineUrl;
personalNoteTextBox.Text = _readItem.PersonalNote;
if (_readItem.FinishedReading != null)
finishedReadingCheckBox.Checked = (bool) _readItem.FinishedReading;
}
}
public static void InsertNewReadingItem(ReadItem item)
{
try
{
using (SQLiteConnection sqLiteConnection = new SQLiteConnection(ConnectionString))
{
sqLiteConnection.Open();
using (SQLiteCommand insertCommand = new SQLiteCommand(sqLiteConnection))
{
insertCommand.CommandText =
"INSERT INTO READING_LIST (MANGA_ID, READ_STARTING_CHAPTER, READ_CURRENT_CHAPTER, READ_ONLINE_URL, " +
"READ_IS_FINISHED, READ_LAST_TIME, READ_NOTE) VALUES (?, ?, ?, ?, ?, ?, ?)";
insertCommand.Parameters.AddWithValue(null, GetMangaId(item.Title));
insertCommand.Parameters.AddWithValue(null, item.StartingChapter);
insertCommand.Parameters.AddWithValue(null, item.CurrentChapter);
insertCommand.Parameters.AddWithValue(null, item.OnlineUrl);
insertCommand.Parameters.AddWithValue(null, item.FinishedReading);
insertCommand.Parameters.AddWithValue(null, item.LastRead);
insertCommand.Parameters.AddWithValue(null, item.PersonalNote);
insertCommand.ExecuteNonQuery();
}
sqLiteConnection.Close();
}
}
catch (Exception ex)
{
ErrorMessageBox.Show(ex.Message, ex.ToString());
Logger.ErrorLogger("error.txt", ex.ToString());
}
}
public void SetReadItem(ReadItem readItemItem)
{
_readItemItem = readItemItem;
}
public void ClearReadItem()
{
_readItemItem = null;
}