private void FormEmployee_Load(object sender, EventArgs e)
{
// Read DB
EmployeeLayer emp = new EmployeeLayer();
dataGridView1.DataSource = emp.ReadEmployee();
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
// Read again
EmployeeLayer emp = new EmployeeLayer();
dataGridView1.DataSource = emp.ReadEmployee();
textBoxEmpId.Text = "";
textBoxFn.Text = "";
textBoxLn.Text = "";
textBoxLn.Text = "";
}
public static void SaveRecord(EmployeeLayer emp)
{
// Open connection:
if (connDB.State == ConnectionState.Closed)
{
connDB = UtilityDB.ConnectDB();
cmd = new SqlCommand();
}
cmd.Connection = connDB;
cmd.CommandText = string.Format("insert into Employees values({0},'{1}','{2}','{3}')", emp.EmployeeId, emp.FirstName, emp.LastName, emp.JobTitle);
cmd.ExecuteNonQuery();
connDB.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (textBoxEmpId.Text == "" || textBoxFn.Text == "" || textBoxLn.Text == "" || textBoxJT.Text == "")
{
MessageBox.Show("Can not be empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// create object
EmployeeLayer emp = new EmployeeLayer();
// fill the object with text input
emp.EmployeeId = Convert.ToInt32(textBoxEmpId.Text);
emp.FirstName = textBoxFn.Text;
emp.LastName = textBoxLn.Text;
emp.JobTitle = textBoxLn.Text;
// call function to save employee in database
emp.saveRecord(emp);
}
}
