public static void updateData(EmployeeMPM updateEmployee)
{
try
{
connect();
string updateQuery = "UPDATE employee SET name = '" + updateEmployee.Name.ToString() + "', supervisor = '" + updateEmployee.Supervisor.ToString() + "', depo = '" + updateEmployee.Depo.ToString() + "',branch = '" + updateEmployee.Branch.ToString() + "',employee_type = '" + updateEmployee.Employee_type.ToString() + "',category = '" + updateEmployee.Category.ToString() + "',join_date = '" + updateEmployee.Join_date.ToString() + "',status='" + updateEmployee.Status.ToString() + "', resign_date ='" + updateEmployee.Resign_date.ToString() + "', reason = '" + updateEmployee.Reason.ToString() + "' WHERE nik = '" + updateEmployee.NIK.ToString() + "'";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = updateQuery;
cmd.Connection = conn;
int updates = cmd.ExecuteNonQuery();
if (updates == 1)
{
MessageBox.Show("Employee " + updateEmployee.Name + " has been updated");
}
disconnect();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
disconnect();
}
}
public static void insertData(EmployeeMPM newEmployee)
{
try
{
connect();
string insertQuery = "INSERT into employee (nik,name,supervisor,depo,branch,employee_type,category,join_date,status) VALUES (@nik,@name,@supervisor,@depo,@branch,@employee_type,@category,@join_date,@status)";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = insertQuery;
cmd.Parameters.AddWithValue("@nik", newEmployee.NIK);
cmd.Parameters.AddWithValue("@name", newEmployee.Name);
cmd.Parameters.AddWithValue("@supervisor", newEmployee.Supervisor);
cmd.Parameters.AddWithValue("@depo", newEmployee.Depo);
cmd.Parameters.AddWithValue("@branch", newEmployee.Branch);
cmd.Parameters.AddWithValue("@employee_type", newEmployee.Employee_type);
cmd.Parameters.AddWithValue("@category", newEmployee.Category);
cmd.Parameters.AddWithValue("@join_date", newEmployee.Join_date);
cmd.Parameters.AddWithValue("@status", "ACTIVE");
cmd.Connection = conn;
int ins = cmd.ExecuteNonQuery();
if (ins == 1)
{
MessageBox.Show(newEmployee.Name + " has been added");
}
disconnect();
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
disconnect();
}
}
//DSS
public static ObservableCollection <EmployeeMPM> DSSEmployee()
{
ObservableCollection <EmployeeMPM> EmployeeList = new ObservableCollection <EmployeeMPM>();
try
{
connect();
string query = "SELECT id,nik,name,supervisor,depo,branch,employee_type,category,join_date,status,resign_date,reason FROM employee WHERE employee_type LIKE 'DSS%' ORDER BY nik ASC";
MySqlCommand command = new MySqlCommand(query, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
EmployeeMPM employee = new EmployeeMPM();
employee.Id = reader.GetInt32(0);
employee.NIK = reader.GetString(1);
employee.Name = reader.GetString(2);
employee.Supervisor = reader.GetString(3);
employee.Depo = reader.GetString(4);
employee.Branch = reader.GetString(5);
employee.Employee_type = reader.GetString(6);
employee.Category = reader.GetString(7);
employee.Join_date = reader.GetString(8);
employee.Status = reader.GetString(9);
employee.Resign_date = reader.GetString(10);
employee.Reason = reader.GetString(11);
EmployeeList.Add(employee);
}
disconnect();
return(EmployeeList);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
disconnect();
}
return(null);
}