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 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);
}
}
