public static bool addEmployee(Employee em)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO employee (employee_no, full_name, image_url, old_employee_no, employee_type, epf_no, salutation, occupation, initials, first_name, last_name, nic_no, date_issued, nationality, religion, date_of_birth, place_of_birth, married, date_of_marriage, action_status, blood_group) VALUES (N'" + em.getEmployee_no() + "', N'" + em.getFull_name() + "', N'" + em.getImg_url() + "', N'" + em.getOld_employee_no() + "', N'" + em.getEmployee_type() + "', N'" + em.getEpf_no() + "', N'" + em.getSalutation() + "', N'" + em.getOccupation() + "', N'" + em.getInitials() + "', N'" + em.getFirst_name() + "', N'" + em.getLast_name() + "', N'" + em.getNic_no() + "', '" + em.getDate_issued() + "', N'" + em.getNationality() + "', N'" + em.getReligion() + "', '" + em.getDate_of_birth().ToString("yyyy-MM-dd") + "', N'" + em.getPlace_of_birth() + "', " + em.getMarried() + ", '" + em.getDate_of_marriage().ToString("yyyy-MM-dd") + "', N'" + em.getAction_status() + "', N'" + em.getBlood_group() + "')";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT * FROM employee ORDER BY idemployee DESC LIMIT 1";
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Employee.employee_id = int.Parse(reader["idemployee"].ToString());
Employee.emp_no = reader["employee_no"].ToString();
Employee.employee_name = reader["full_name"].ToString();
Console.Write(Employee.employee_id+"\n "+Employee.emp_no+"\n "+Employee.employee_name+"\n ");
}
reader.Close();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
public void updateEmployeePersonalDetails()
{
Employee employee = new Employee();
employee.setAction_status(this.action_status.Text);
employee.setBlood_grouph(this.blood_group.Text);
employee.setDate_issued(this.date_issued.Text);
employee.setEmployee_no(this.employee_no.Text);
employee.setEmployee_type(this.employee_type.Text);
employee.setEpf_no(this.epf_no.Text);
employee.setFirst_name(this.first_name.Text);
//employee.setFull_name(full_name.Text);
//employee.setImg_url();
employee.setInitials(this.initials.Text);
employee.setLast_name(this.last_name.Text);
employee.setDate_of_birth(this.dob_date.Value.Date);
employee.setDate_of_marriage(this.marry_date.Value.Date);
if (this.married.Checked) { employee.setMarried(1); }
else { employee.setMarried(0); }
employee.setNationality(this.nationality.Text);
employee.setNic_no(this.nic_no.Text);
employee.setOccupation(this.occupation.Text);
employee.setOld_employee_no(this.old_employee_no.Text);
employee.setPlace_of_birth(this.place_of_birth.Text);
employee.setReligion(this.religion.Text);
employee.setSalutation(this.salutation.Text);
bool state = EmployeeHandler.updateEmployee(employee);
Console.Write(state+"\n");
}
public static bool updateEmployee(Employee em)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE employee SET employee_no=N'" + em.getEmployee_no() + "', old_employee_no=N'" + em.getOld_employee_no() + "', employee_type=N'" + em.getEmployee_type() + "', epf_no=N'" + em.getEpf_no() + "', salutation=N'" + em.getSalutation() + "', occupation=N'" + em.getOccupation() + "', initials=N'" + em.getInitials() + "', first_name=N'" + em.getFirst_name() + "', last_name=N'" + em.getLast_name() + "', nic_no=N'" + em.getNic_no() + "', date_issued='" + em.getDate_issued() + "', nationality=N'" + em.getNationality() + "', religion=N'" + em.getReligion() + "', date_of_birth='" + em.getDate_of_birth().ToString("yyyy-MM-dd") + "', place_of_birth=N'" + em.getPlace_of_birth() + "', married=" + em.getMarried() + ", date_of_marriage='" + em.getDate_of_marriage().ToString("yyyy-MM-dd") + "', action_status=N'" + em.getAction_status() + "', blood_group=N'" + em.getBlood_group() + "' WHERE idemployee=" + Employee.employee_id;
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return true;
}
else
{
return false;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
public static Employee getEmployee()
{
Employee em = new Employee();
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM employee WHERE idemployee="+Employee.employee_id;
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
em.setAction_status(reader.GetString("action_status"));
em.setBlood_grouph(reader.GetString(""));
em.setDate_issued(reader.GetString(""));
}
reader.Close();
dbcon.closeConnection();
return em;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
public static Employee getEmployee(string no)
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM employee WHERE employee_no=N'" + no + "'";
cmd.Connection = dbcon.connection;
MySqlDataReader reader = cmd.ExecuteReader();
Employee e = null;
if (reader.Read())
{
e = new Employee();
Employee.employee_id = int.Parse(reader["idemployee"].ToString());
Employee.emp_no = reader["employee_no"].ToString();
Employee.employee_name = reader["full_name"].ToString();
Console.Write(Employee.employee_id+"\n");
e.setAction_status(reader["action_status"].ToString());
e.setBlood_grouph(reader["blood_group"].ToString());
e.setDate_issued(reader["date_issued"].ToString());
e.setDate_of_birth(Convert.ToDateTime(reader["date_of_birth"]));
e.setDate_of_marriage(Convert.ToDateTime(reader["date_of_marriage"]));
e.setEmployee_no(reader["employee_no"].ToString());
e.setEmployee_type(reader["employee_type"].ToString());
e.setEpf_no(reader["epf_no"].ToString());
e.setFirst_name(reader["first_name"].ToString());
e.setLast_name(reader["last_name"].ToString());
e.setFull_name(reader["full_name"].ToString());
e.setImg_url(reader["image_url"].ToString());
e.setInitials(reader["initials"].ToString());
if (reader["married"].ToString() == "True") { e.setMarried(1); }
else { e.setMarried(0); }
e.setNationality(reader["nationality"].ToString());
e.setNic_no(reader["nic_no"].ToString());
e.setOccupation(reader["occupation"].ToString());
e.setOld_employee_no(reader["old_employee_no"].ToString());
e.setPlace_of_birth(reader["place_of_birth"].ToString());
e.setReligion(reader["religion"].ToString());
e.setSalutation(reader["salutation"].ToString());
}
reader.Close();
dbcon.closeConnection();
return e;
}
else
{
return null;
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return null;
//}
}
private void btnSave_Click(object sender, EventArgs e)
{
Employee employee = new Employee();
employee.setAction_status(action_status.Text);
employee.setBlood_grouph(blood_group.Text);
employee.setDate_issued(date_issued.Text);
employee.setEmployee_no(employee_no.Text);
employee.setEmployee_type(employee_type.Text);
employee.setEpf_no(epf_no.Text);
employee.setFirst_name(first_name.Text);
employee.setFull_name(full_name.Text);
//employee.setImg_url();
employee.setInitials(initials.Text);
employee.setLast_name(last_name.Text);
employee.setDate_of_birth(dob_date.Value.Date);
employee.setDate_of_marriage(marry_date.Value.Date);
if (married.Checked) { employee.setMarried(1); }
else { employee.setMarried(0); }
employee.setNationality(nationality.Text);
employee.setNic_no(nic_no.Text);
employee.setOccupation(occupation.Text);
employee.setOld_employee_no(old_employee_no.Text);
employee.setPlace_of_birth(place_of_birth.Text);
employee.setReligion(religion.Text);
employee.setSalutation(salutation.Text);
//Add a new employee
if (Employee.employee_id == 0)
{
bool state = EmployeeHandler.addEmployee(employee);
if (state)
{
MessageBox.Show("Employee personal details added succesfully...!");
//btnSave2.Enabled = true;
//btnSave3.Enabled = true;
//btnSave4.Enabled = true;
//btnSave5.Enabled = true;
}
else
{
MessageBox.Show("Adding employee personal details failed...!");
}
}
//Update existing employee
else
{
bool state = EmployeeHandler.updateEmployee(employee);
if (state)
{
MessageBox.Show("Employee personal details updated succesfully...!");
}
else
{
MessageBox.Show("Updating employee personal details failed...!");
}
}
}
