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); }