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());
}
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!!");
}
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);
}