// Save the Assigned Project data into database.
private void AssignButton_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show(AssignConfirmMessage,
AssignConfirmTitle,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
int pID = this.ProjectID;
Console.WriteLine(pID);
if (pID == -1)
{
foreach (ProjectsData project in pNameList)
{
if (project.ProjectID != -1)
{
int ID = Convert.ToInt32(project.ProjectID);
pAssign = new PProjectAssign(this);
pAssign.AddAssign(ID);
}
}
}
else
{
pAssign = new PProjectAssign(this);
pAssign.AddAssign(pID);
}
AssignRefresh?.Invoke(this, new EventArgs());
MessageBox.Show(AssignConfirmOk);
}
}
// Refresh the form.
private void RefreshForm()
{
pAssign = new PProjectAssign(this);
projectNameBox.SelectedIndex = 0;
projectList = pAssign.AssignList();
assignedList.DataSource = new BindingList <ProjectAssignData>(projectList.OrderBy(x => x.ProjectName).ToList());
}
private void F201_ProjectAssign_Load(object sender, EventArgs e)
{
// Getting the necessary lists.
pAssign = new PProjectAssign(this);
projectList = pAssign.AssignList();
pNameList = pAssign.GetProjects();
// DataGridView Lists
selectProjectList = pAssign.GetProjects();
selectProjectList.RemoveAt(0);
selectEmployeeList = pAssign.GetEmployeeDatas();
selectRoleList = pAssign.GetRoleDatas();
// Setting Datasource for the combobox, DataGridView
projectNameBox.DataSource = pNameList;
projectNameBox.DisplayMember = "ProjectName";
dataProjectAssign.DataSource = assignedList;
assignedList.DataSource = new BindingList <ProjectAssignData>(projectList.OrderBy(x => x.ProjectName).ToList());
// Setting some attributes for the DataGrid. Rename the columns.
// Hide the ProjectName Column to replace with a combobox.
dataProjectAssign.Columns["ProjectName"].Visible = false;
ProjectCol.DataPropertyName = "ProjectName";
ProjectCol.DataSource = selectProjectList;
middleProjectBox.DataSource = selectProjectList;
middleProjectBox.ValueMember = "ProjectID";
ProjectCol.DisplayMember = "ProjectName";
//ProjectCol.ValueMember = "ProjectID".ToString();
//
// Hide the EmployeeName column and replace with a combobox
dataProjectAssign.Columns["EmployeeName"].Visible = false;
EmployeeCol.DataPropertyName = "EmployeeName";
EmployeeCol.DataSource = selectEmployeeList;
middleEmpBox.DataSource = selectEmployeeList;
middleEmpBox.ValueMember = "EmployeeID";
EmployeeCol.DisplayMember = "EmployeeName";
//EmployeeCol.ValueMember = "EmployeeID";
//
// Hide the Role column and replace with a combobox
dataProjectAssign.Columns["Role"].Visible = false;
RoleCol.DataPropertyName = "Role";
RoleCol.DataSource = selectRoleList;
middleRoleBox.DataSource = selectRoleList;
middleRoleBox.ValueMember = "RoleID";
RoleCol.DisplayMember = "RoleName";
//RoleCol.ValueMember = "RoleID";
//
dataProjectAssign.Columns["StartDate"].HeaderText = "Start Date";
dataProjectAssign.Columns["EndDate"].HeaderText = "End Date";
dataProjectAssign.Columns["ProjectAssignID"].Visible = false;
dataProjectAssign.Columns["ProjectID"].Visible = false;
dataProjectAssign.Columns["EmployeeID"].Visible = false;
dataProjectAssign.Columns["RoleID"].Visible = false;
// Setting autosize mode.
EmployeeCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
ProjectCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
public F201_ProjectAssignAdd()
{
InitializeComponent();
this.ControlBox = false;
pAssign = new PProjectAssign(this);
// Get the list of projects and assign it to the project combobox.
pNameList = pAssign.GetProjects();
projectNameBox.DataSource = pNameList;
projectNameBox.DisplayMember = "ProjectName";
// Get the list of employees and assign it to the employee combobox.
employeeList = pAssign.GetEmployeeDatas();
employeeBox.DataSource = employeeList;
employeeBox.DisplayMember = "EmployeeName";
// Get the list of roles and assign it to the role combobox.
roleList = pAssign.GetRoleDatas();
roleBox.DataSource = roleList;
roleBox.DisplayMember = "RoleName";
}
