private void OnSaveEmployeeForm()
{
OleDbCommand dbCommand = new OleDbCommand();
dbCommand.Connection = EmployeeListModel.DataBaseModel.dbConnection;
if (EmployeeListModel.Nik != "")
{
if (EmployeeListModel.IsNikEditable == true)
{
dbCommand.CommandText = "INSERT INTO tbEmployeeList (NIK,NameEmp,Occupation) VALUES ('" + EmployeeListModel.Nik + "','" + EmployeeListModel.Name + "','" + EmployeeListModel.Occupation + "')";
dbCommand.ExecuteNonQuery();
}
else
{
dbCommand.CommandText = "UPDATE tbEmployeeList SET NameEmp = '" + EmployeeListModel.Name + "', Occupation = '" + EmployeeListModel.Occupation + "' WHERE NIK = '" + EmployeeListModel.Nik + "'";
dbCommand.ExecuteNonQuery();
}
EmployeeListModel.Refresh();
MaterialDesignThemes.Wpf.DialogHost.CloseDialogCommand.Execute(null, null);
}
else
{
System.Windows.MessageBox.Show("Please add NIK");
}
}
private async void OnDeleteEmployeeForm()
{
try
{
FillDataField();
var dialog = new Views.DeleteDialogConfirmView();
object result = await MaterialDesignThemes.Wpf.DialogHost.Show(dialog, "EmployeeFormDialogHost");
if (!(result is bool boolResult && boolResult))
{
OleDbCommand dbCommand = new OleDbCommand();
dbCommand.Connection = EmployeeListModel.DataBaseModel.dbConnection;
dbCommand.CommandText = "DELETE FROM tbEmployeeList WHERE NIK='" + EmployeeListModel.Nik + "'";
dbCommand.ExecuteNonQuery();
EmployeeListModel.Refresh();
}
}
catch (Exception)
{
System.Windows.MessageBox.Show("Please Select one Item");
}
}
