private void StoryToDb()
{
if (!IfStoryGreedChanged())
return;
DataManager dm = new DataManager();
int cols = 6;
int rows = storyDataGridView.RowCount;
string[] read = new string[cols];
for (int i = 0; i < rows - 1; i++)
{
for (int j = 0; j < cols; j++)
{
read[j] = storyDataGridView.Rows[0].Cells[j + 1].Value.ToString();
}
for (int j = 0; j < cols; j++)
{
if (j == 2 || j == 3)
continue; // description might be null
if (read[j] == null)
return;
}
int ans = dm.StoryAddNewStory(Convert.ToInt32(read[0]), DateTime.Parse(read[1]), read[2], null, read[3],
Convert.ToInt32(read[4]), Convert.ToInt32(read[5]));
if (ans == -1)
MessageBox.Show("Error while creating new story");
}
}
public void Storyadd_new_storyTest()
{
DataManager target = new DataManager(); // TODO: Initialize to an appropriate value
// int ID = 0; // TODO: Initialize to an appropriate value
int Story_Owner = 0; // TODO: Initialize to an appropriate value
DateTime Current_Sprint = DateTime.Parse("01.12.2012"); ; // TODO: Initialize to an appropriate value
int Work_Status = 0; // TODO: Initialize to an appropriate value
int Priority = 0; // TODO: Initialize to an appropriate value
string Description = string.Empty; // TODO: Initialize to an appropriate value
int expected = 0; // TODO: Initialize to an appropriate value
int actual;
string str = " ";
Image pic = null;
actual = target.StoryAddNewStory(Story_Owner, Current_Sprint, str, pic, Description, Priority, Work_Status);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
private void StoryToDb()
{
//systemId = storydataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["SystemId"].Value.ToString();
string id = storyDataGridView.Rows[0].Cells[0].Value.ToString();
if (!IfStoryGreedChanged())
return;
DataManager dm = new DataManager();
MathManager mm = new MathManager();
int rows;
if (Convert.ToInt32(updatedStoryIndexes.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(updatedStoryIndexes.Count.ToString()); i++)
{
rows = updatedStoryIndexes.ElementAt(i).getRow();
//MessageBox.Show("6: " + storyDataGridView.Rows[rows].Cells[6].Value.ToString() + "1: " + storyDataGridView.Rows[rows].Cells[1].Value.ToString());
int story_ID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[0].Value.ToString());
if (mm.isStory_Id_Exist(story_ID) >= 0)
{
int programmerID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[2].Value.ToString());
if (mm.isProgrammer_Id_Exist(Convert.ToInt32(programmerID)) >= 0)
{
dm.StorySetOwnerID(story_ID, programmerID);
}
else
{
MessageBox.Show("Invalid story owner ID at line: " + (rows + 1));
return;
}
// if (mm.isStory_current_Sprint_valid(DateTime.Parse(read[1])) >= 0)
//{
dm.StorySetCurrentSprint(story_ID, DateTime.Parse(storyDataGridView.Rows[rows].Cells[3].Value.ToString()));
//}
/*else
{
MessageBox.Show("Invalid date of story_current_sprint at line: " + (i + 1));
return;
}*/
//dm.StorySetStoryDemoDes(story_ID, storyDataGridView.Rows[rows].Cells[4].Value.ToString());
//dm.StorySetStoryDemoPic(story_ID);
dm.StorySetStoryDescription(story_ID, storyDataGridView.Rows[rows].Cells[6].Value.ToString());
//MessageBox.Show("Passed here");
int priority = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[1].Value.ToString());
if (mm.isTask_PriorityValid(priority) >= 0)
{
dm.StorySetStoryPriority(story_ID, priority);
}
else
{
MessageBox.Show("Invalid priority value at line: " + (rows + 1));
return;
}
int workStatus = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[7].Value.ToString());
dm.StorySetStoryWorkStatus(story_ID, workStatus);
}
else
{
int workStatus = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[7].Value.ToString());
int priority = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[1].Value.ToString());
int programmerID = Convert.ToInt32(storyDataGridView.Rows[rows].Cells[2].Value.ToString());
int ans = dm.StoryAddNewStory(programmerID, DateTime.Parse(storyDataGridView.Rows[rows].Cells[3].Value.ToString()), storyDataGridView.Rows[rows].Cells[4].Value.ToString(), null, storyDataGridView.Rows[rows].Cells[6].Value.ToString(),
priority, workStatus);
if (ans == -1)
{
MessageBox.Show("Error while creating new story");
return;
}
}
}
}
