//fill taskss that are underway to task combobox
private void FillTasks(int projectid)
{
cboTask.Items.Clear();
ProjectDatabaseDataSet.ProjectsRow projectRow =
dsProject.Projects.FindByProjectID(projectid);
DataRow[] taskRows =
projectRow.GetChildRows("FK_Tasks_Projects");
foreach (ProjectDatabaseDataSet.TasksRow taskRow in dsProject.Tasks)
{
if (taskRow.ProjectID == projectRow.ProjectID &&
taskRow.StatusID == 2)
{
this.cboTask.DisplayMember = "TaskName";
this.cboTask.ValueMember = "TaskID";
this.cboTask.DataSource = dsProject.Tables["Tasks"];
cboTask.Items.Add(new TasksCombo
{
name = taskRow.TaskName,
id = taskRow.TaskID.ToString()
});
}
}
}
// select changed from project to project
private void lstProject_SelectedIndexChanged(object sender, EventArgs e)
{
lstvEmployee.Items.Clear(); //clears listview so listview will not display info from previous selected projects
txtHours.Clear();
if (isLoaded) //makes sure isloaded is set to true
{
if (lstProject.SelectedIndex != -1) //if there is a selection
{
int projectID = (int)lstProject.SelectedValue;
ProjectDatabaseDataSet.ProjectsRow projectRow = dsProject.Projects.FindByProjectID(projectID);
txtName.Text = projectRow.ProjectName;
txtDescription.Text = projectRow.Description;
txtStatus.Text = projectRow.StatusID.ToString();
txtStartDate.Text = projectRow.StartDate.ToString();
txtEndDate.Text = projectRow.EndDate.ToString();
int projectManager = (int)projectRow[1];
foreach (DataRow employees in dsProject.Employees.Rows)
{
if ((int)employees[0] == projectManager)
{
txtManager.Text = employees["FullName"].ToString();
//local variable for total hours worked on project
decimal projectHours = 0;
foreach (DataRow tasks in dsProject.Tasks.Rows)
{
if ((int)tasks[2] == projectID)
{
int taskID = (int)tasks[0];
foreach (DataRow employeeTask in dsProject.Work.Rows)
{
if ((int)employeeTask[2] == taskID)
{
int employeeID = (int)employeeTask[1];
//local variable for suming task hours for a project
decimal taskHours = 0;
foreach (DataRow employee in dsProject.Employees.Rows)
{
if ((int)employee[0] == employeeID)
{
//sums task hours
taskHours += decimal.Parse(employeeTask[4].ToString());
ListViewItem item = new ListViewItem(employee["FullName"].ToString());
item.SubItems.Add(tasks[1].ToString());
item.SubItems.Add(employeeTask[3].ToString());
item.SubItems.Add(employeeTask[4].ToString());
//adds to listview
lstvEmployee.Items.Add(item);
//to sum local variable for calculating project total hours
projectHours += taskHours;
//displays total hours
txtHours.Text = projectHours.ToString();
}
}
}
}
}
}
}
}
}
}
}
