public void TaskSetTaskOwnerTest()
{
DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
int expected = 0;
int actual;
actual = target.TaskSetTaskOwner(1,6);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
private void TaskToDB()
{
if (!IfTaskGreedChanged())
return;
DataManager dm = new DataManager();
MathManager mm = new MathManager();
//int col = 4;
//int rows = taskDataGridView.Rows.Count;
//int col;
int rows;
if (Convert.ToInt32(updatedTaskIndexes.Count.ToString()) == 0) // no changes were found, there fore no need to save any data
return;
//string[] read = new string[4];
for(int i = 0; i < Convert.ToInt32(updatedTaskIndexes.Count.ToString()); i++)
{
rows = updatedTaskIndexes.ElementAt(i).getRow();
int task_ID = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[1].Value.ToString());
if (mm.isTask_Id_Exist(task_ID) >= 0)
{ // task already exist, therefore we need only to update
int storyId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[0].Value.ToString());
if (mm.isTask_Story_IDValid(storyId) >= 0)
{
int ans = dm.TaskSetTaskStoryID(task_ID, storyId);
}
else
{
MessageBox.Show("Invalid Story id at line:" + (rows + 1));
updatedTaskIndexes.RemoveAt(i);
return;
}
int priority = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[2].Value.ToString());
if (mm.isTask_PriorityValid(priority) >= 0)
{
dm.TaskSetTaskPriority(task_ID, priority);
}
else
{
MessageBox.Show("Invalid Priority value at line:" + (rows + 1));
updatedTaskIndexes.RemoveAt(i);
return;
}
string descriptions = taskDataGridView.Rows[rows].Cells[5].Value.ToString();
dm.TaskSetTaskDescription(task_ID, descriptions);
int ownerId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[3].Value.ToString());
if (mm.isTask_Ovner_IdValid(ownerId) >= 0)
{
dm.TaskSetTaskOwner(task_ID, ownerId);
}
else
{
MessageBox.Show("Invalid Owner Id at line:" + (rows + 1));
updatedTaskIndexes.RemoveAt(i);
return;
}
}
else
{
int storyId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[0].Value.ToString());
int priority = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[2].Value.ToString());
string descriptions = taskDataGridView.Rows[rows].Cells[5].Value.ToString();
int ownerId = Convert.ToInt32(taskDataGridView.Rows[rows].Cells[3].Value.ToString());
int ans = dm.TaskAddNewTask(storyId, priority, descriptions,
ownerId);
MessageBox.Show("Added");
if (ans == -1)
{
MessageBox.Show("Error while creating new task");
updatedTaskIndexes.RemoveAt(i);
return;
}
}
}
int size = Convert.ToInt32(updatedTaskIndexes.Count.ToString());
for (int i = 0; i < size; i++)
{
updatedTaskIndexes.RemoveAt(0);
}
}