private void addLabourerBtn_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(labourerNameTextBox.Text))
{
MessageBox.Show("Please enter the name of labourer");
return;
}
if (String.IsNullOrEmpty(ageTextBox.Text))
{
MessageBox.Show("Please enter the age of labourer");
return;
}
if (genderComboBox.SelectedItem == null)
{
MessageBox.Show("Please select the gender");
return;
}
if (String.IsNullOrEmpty(startWorkDate.Text))
{
MessageBox.Show("Please select Start Work Date");
return;
}
if (String.IsNullOrEmpty(endWorkDate.Text))
{
MessageBox.Show("Please select End Work Date");
return;
}
DBConnector dBConn = new DBConnector();
dBConn.connect();
Labourer labr = new Labourer();
labr.Name = labourerNameTextBox.Text;
labr.Age = int.Parse(ageTextBox.Text);
labr.Gender = genderComboBox.SelectedItem.ToString();
labr.StartDate = startWorkDate.Text;
labr.EndDate = endWorkDate.Text;
LabourerHandler labHnd = new LabourerHandler();
int recordCnt = labHnd.addNewLabourer(dBConn.getConn(), labr);
MessageBox.Show(recordCnt + "record has been inserted!!");
labourerGridView.DataSource = labHnd.getAllLabourer(dBConn.getConn());
}
private void btnLabourer_Click(object sender, EventArgs e)
{
panel1.Hide();
panel2.Hide();
panel3.Hide();
panel4.Show();
panel5.Hide();
panel6.Hide();
DBConnector dBConn = new DBConnector();
dBConn.connect();
LabourerHandler labHnd = new LabourerHandler();
//labourerGridView.DataSource = labHnd.BindSource();
labourerGridView.DataSource = labHnd.getAllLabourer(dBConn.getConn());
}