private void InsertData()
{
try
{
EmployeeModel model = new EmployeeModel()
{
Code = txtCode.Text.Trim(),
EmployeeName = txtName.Text.Trim(),
Age = txtAge.Text.Trim()
};
if (MasterProcessor.InsertDataIntoCsv(model))
{
MessageBox.Show("Insert Data Successfull!");
}
else
{
MessageBox.Show("Failed Insert Data!");
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("failed InsertData: " + ex.Message.ToString());
}
}
private void UpdateData()
{
try
{
EmployeeModel model = new EmployeeModel()
{
//Code = txtCode.Text.Trim(),
EmployeeName = txtName.Text.Trim(),
Age = txtAge.Text.Trim()
};
if (MasterProcessor.UpdateDataIntoCsv(txtCode.Text.Trim(), MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee), model))
{
MessageBox.Show("Update Data Successfull!");
}
else
{
MessageBox.Show("Failed Update Data!");
}
//var principalForm = Application.OpenForms.OfType<UserControlMaster>().FirstOrDefault();
//principalForm.LoadDataMaster();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("failed UpdateData: " + ex.Message.ToString());
}
}
public void EditData()
{
try
{
if (dataGridMaster.RowCount > 0)
{
int index = dataGridMaster.SelectedCells[0].RowIndex;
string code = (string)dataGridMaster["Code", index].Value;
var queryData = MasterProcessor.FindDataByCode(code, MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee));
using (fmInputMaster f = new fmInputMaster())
{
f.txtCode.Enabled = false;
f.txtCode.Text = queryData.Code;
f.txtName.Text = queryData.EmployeeName;
f.txtAge.Text = queryData.Age;
f.lblFlag.Text = "edit";
f.ShowDialog();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public void LoadEmployee()
{
try
{
cbEmployee.DisplayMember = "EmployeeName";
cbEmployee.ValueMember = "Code";
cbEmployee.DataSource = MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void RdSortByAge_CheckedChanged(object sender, EventArgs e)
{
if (rdSortByAge.Checked == true)
{
try
{
dataGridMaster.DataSource = MasterProcessor.BubleSortingEmployee(MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee), "age");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
public void LoadDataMaster()
{
try
{
//dataGridMaster.AutoGenerateColumns = false;
dataGridMaster.DataSource = MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee);
rdSortByCode.Checked = false;
rdSoftByName.Checked = false;
rdSortByAge.Checked = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void RdSortByName_CheckedChanged(object sender, EventArgs e)
{
if (rdSortByName.Checked == true)
{
try
{
List <SalaryModel> salary = SalaryProcessor.loadCsvFileSalary(SalaryProcessor.pathSalary);
List <EmployeeModel> employee = MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee);
dataGridSalary.DataSource = SalaryProcessor.BubleSortingSalary(SalaryProcessor.MergeSalary(salary, employee), "name");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
public void LoadDataSalary()
{
try
{
List <SalaryModel> salary = SalaryProcessor.loadCsvFileSalary(SalaryProcessor.pathSalary);
List <EmployeeModel> employee = MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee);
dataGridSalary.DataSource = SalaryProcessor.MergeSalary(salary, employee);
rdSortByCode.Checked = false;
rdSortByName.Checked = false;
rdSortBySalary.Checked = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void RemoveItem()
{
try
{
if (dataGridMaster.RowCount > 0)
{
int index = dataGridMaster.SelectedCells[0].RowIndex;
string code = (string)dataGridMaster["Code", index].Value;
bool found = false;
var checkExist = SalaryProcessor.loadCsvFileSalary(SalaryProcessor.pathSalary);
foreach (var item in checkExist)
{
if (item.EmpCode.Trim().ToLower() == code.Trim().ToLower())
{
found = true;
}
}
if (!found)
{
DialogResult msg = MessageBox.Show("Do you want to delete this data?", "Confirmation", MessageBoxButtons.YesNo);
if (msg == DialogResult.Yes)
{
if (MasterProcessor.RemoveItemOnList(code, MasterProcessor.loadCsvFileEmployee(MasterProcessor.pathEmployee)))
{
MessageBox.Show("Delete data successfull!");
}
}
}
else
{
MessageBox.Show("Sorry! This data cannot be Delete, It is Relate to another!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
