public void TestDeleteAll()
{
Task task1 = new Task("Darbas", DateTime.Now, "sourceId|15");
task1.Save();
Task task2 = new Task("Darbas2", DateTime.Now, "sourceId|15");
task2.Save();
Task.DeleteAll();
}
public void SaveNewTask(string dataEntered, AbstractMainForm form)
{
Task task = new Task().ParseString(dataEntered);
if (task != null)
{
task.Save();
form.MTextBox.Text = string.Empty;
m_log.DebugFormat("New task was saved. Name {0}, date {1}", task.Text,
DBTypesConverter.ToFullDateStringByCultureInfo(task.DateRemainder));
}
}
public void TestDelete()
{
Task task = new Task("Darbas", DateTime.Now, "sourceId|15");
task.Save();
task.Delete();
using (IConnection con = new ConnectionCollector().GetConnection())
{
IDataReader reader = con.ExecuteReader("SELECT NAME, DATE_REMAINDER, SOURCE_ID FROM TASK");
Assert.IsTrue(reader.Read());
}
}
public void TestLoadTasksForShowing()
{
Task task1 = new Task("Darbas", DateTime.Now.AddSeconds(-1), "sourceId|sekundė-1");
task1.Save();
Task task2 = new Task("Darbas2", DateTime.Now.AddMonths(-1), "sourceId|mėnuo-1");
task2.Save();
Task task3 = new Task("Darbas3", DateTime.Now.AddMinutes(1), "sourceId|mintė+1");
task3.Save();
using (IConnection con = new ConnectionCollector().GetConnection())
{
List<Task> tasks = new DbHelper().LoadTasksForShowing();
Assert.AreEqual(2, tasks.Count);
}
}
public void TestUpdate()
{
DateTime now = DateTime.Now;
Task task = new Task("Darbas", now, "sourceId|15");
task.Save();
task.DateRemainder = now.AddYears(1);
task.Text = "Krabas";
task.Showed = true;
task.SourceId = "skriptas";
task.Update();
using (IConnection con = new ConnectionCollector().GetConnection())
{
IDataReader reader = con.ExecuteReader("SELECT NAME, DATE_REMAINDER, SOURCE_ID, SHOWED FROM TASK");
Assert.IsTrue(reader.Read());
Assert.AreEqual(task.Text, reader.GetString(0));
Assert.AreEqual(DBTypesConverter.ToFullDateStringByCultureInfo(task.DateRemainder), reader.GetString(1));
Assert.AreEqual(task.SourceId, reader.GetString(2));
Assert.AreEqual(1, reader.GetInt32(3));
}
}