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