Esempio n. 1
0
        private void button9_Click(object sender, EventArgs e)
        {
            DBConnector dbConn = new DBConnector();

            dbConn.connect();

            LabourerHandler labHnd  = new LabourerHandler();
            List <Labourer> theList = labHnd.getAllLabourer(dbConn.getConn());

            // for all
            dataGridView1.DataSource = theList;
        }
Esempio n. 2
0
        private void button7_Click(object sender, EventArgs e)
        {
            DBConnector dbConn = new DBConnector();

            dbConn.connect();

            Labourer labr = new Labourer();

            labr.Name   = textBox6.Text;
            labr.Age    = int.Parse(textBox7.Text);
            labr.Gender = textBox8.Text;

            LabourerHandler labHnd    = new LabourerHandler();
            int             recordCnt = labHnd.addNewLabourer(dbConn.getConn(), labr);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }