public void UpdateTasks()
{
SqlTransaction transaction = null;
try
{
if (_taskTable.Rows.Count == 0)
{
GetTask();
}
DateTime dueDate = DateUtils.SqlUtcNow;
_taskRow.DueDt = dueDate;
TasksTD tasksDataSet = new TasksTD();
tasksDataSet.Merge(_taskTable);
TasksTD.UpdateTasks(tasksDataSet, ref transaction);
SqlUtils.CommitTransaction(transaction);
GetTask();
Assert.AreEqual(dueDate, _taskRow.DueDt);
}
catch (Exception ex)
{
SqlUtils.RollbackTransaction(transaction);
Assert.Fail(ex.Message);
}
}
public void IsExistingTask_InvalidTaskId()
{
try
{
bool isExisting = TasksTD.IsExistingTask(9999999);
Assert.AreEqual(false, isExisting);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void GetTask_InvalidTaskId()
{
try
{
DataTable taskTable = TasksTD.GetTask(9999999);
Assert.AreNotEqual(null, taskTable, "TaskDataTable is null.");
Assert.AreEqual(0, taskTable.Rows.Count, "TaskDataTable does not contain 0 rows.");
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void IsExistingTask()
{
try
{
bool isExisting = TasksTD.IsExistingTask(1);
Assert.AreNotEqual(null, isExisting);
Assert.AreEqual(true, isExisting);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void GetTask()
{
try
{
_taskTable.Merge(TasksTD.GetTask(1), false);
Assert.AreNotEqual(null, _taskTable);
Assert.AreEqual(1, _taskTable.Rows.Count);
_taskRow = (TasksTD.TasksRow)_taskTable.Rows[0];
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public void UpdateTasks_NullDataSet()
{
SqlTransaction transaction = null;
try
{
TasksTD.UpdateTasks(null, ref transaction);
Assert.Fail("Update should have failed.");
}
catch (Exception ex)
{
Assert.AreEqual("The DataSet and/or DataTable is null or empty.", ex.Message);
}
finally
{
SqlUtils.RollbackTransaction(transaction);
}
}
