private void btnSubmit_Click(object sender, EventArgs e)
{
EmployeeProjectHour objEPH = new EmployeeProjectHour();
try
{
if (radioButtonAdd.Checked == true)
{
objEPH.InsEmployeeProjectHours(int.Parse(comboBoxEPHEmplyeeID.SelectedValue.ToString()), int.Parse(comboBoxEPHProjectID.SelectedValue.ToString()), dateTimePickerEPH.Value.Date, int.Parse(comboBoxEPHHours.SelectedValue.ToString()));
}
else if (radioButtonUpdate.Checked == true)
{
objEPH.UpdEmployeeProjectHours(int.Parse(comboBoxEPHEmplyeeID.SelectedValue.ToString()), int.Parse(comboBoxEPHProjectID.SelectedValue.ToString()), dateTimePickerEPH.Value.Date, int.Parse(comboBoxEPHHours.SelectedValue.ToString()));
}
else if (radioButtonDelete.Checked == true)
{
objEPH.DelEmployeeProjectHours(int.Parse(comboBoxEPHEmplyeeID.SelectedValue.ToString()), int.Parse(comboBoxEPHProjectID.SelectedValue.ToString()), dateTimePickerEPH.Value.Date);
}
else
{
MessageBox.Show("Please select an option to modify a employe project hours.", "Warning", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
}
catch (Exception ev)
{
MessageBox.Show(ev.ToString());
}
RefreshAll();
}
private void RefreshAll()
{
EmployeeProjectHour objHours = new EmployeeProjectHour();
dataGridViewEmployeeHours.DataSource = objHours.SelEmployeeProjectHours().ToList();
Employee objEmployeeName = new Employee();
dataGridViewEmployeeName.DataSource = objEmployeeName.SelEmployee().ToList();
Project objProjectName = new Project();
dataGridViewProjectID.DataSource = objProjectName.SelProjects().ToList();
BindEmployeeComboBox();
BindProjectComboBox();
BindHoursComboBox();
}
private void tabPageEPH_Enter(object sender, EventArgs e)
{
EmployeeProjectHour objEPH = new EmployeeProjectHour();
dataGridViewEPH.DataSource = objEPH.SelEmployeeProjectHour().ToList();
}
