Beispiel #1
0
        public int addNewLabourer(MySqlConnection conn, Labourer labourer)
        {
            string sql = "INSERT INTO labourer(name, age, gender)"
                         + " VALUES ('" + labourer.Name + "', " + labourer.Age + ", '" + labourer.Gender + "')";

            MySqlCommand sqlComm = new MySqlCommand(sql, conn);

            return(sqlComm.ExecuteNonQuery());
        }
Beispiel #2
0
        private void btnTestAdd_Click(object sender, EventArgs e)
        {
            DbConnector dbConn = new DbConnector();

            dbConn.connect();

            Labourer labr = new Labourer();

            labr.Name   = labourerName.Text;
            labr.Age    = int.Parse(labourerAge.Text);
            labr.Gender = labourerGender.Text;
            //labr.CreateTime = lbrCreateTime.Text;

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

            MessageBox.Show(recordCnt + " record has been inserted!!");
        }
Beispiel #3
0
        public List <Labourer> getAllLabourer(MySqlConnection conn)
        {
            List <Labourer> listLabr = new List <Labourer>();
            string          sql      = "SELECT * FROM labourer";
            MySqlCommand    sqlComm  = new MySqlCommand(sql, conn);
            MySqlDataReader myReader;

            myReader = sqlComm.ExecuteReader();

            while (myReader.Read())
            {
                Labourer aLabr = new Labourer();
                aLabr.Id     = (int)myReader.GetValue(0);
                aLabr.Name   = (string)myReader.GetValue(1);
                aLabr.Age    = (int)myReader.GetValue(2);
                aLabr.Gender = (string)myReader.GetValue(3);
                listLabr.Add(aLabr);
            }
            return(listLabr);
        }