public static List <EmpManagement> GetEmployee()
{
List <EmpManagement> emp = new List <EmpManagement>();
String query = "select * from emp_details";
MySqlCommand cmd = new MySqlCommand(query, Connection.dbConn);
Connection.dbConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = (int)reader["emp_id"];
String account = reader["external_id"].ToString();
String empname = reader["lastname"].ToString() + ", " + reader["firstname"].ToString() + ' ' + reader["middlename"].ToString();
String position = reader["position"].ToString();
String salary = string.Format("{0:#,###,###.##}", reader["salary"].ToString());
EmpManagement employee = new EmpManagement(id, empname, position, account, salary);
emp.Add(employee);
}
Connection.dbConn.Close();
return(emp);
}
private void LoadSearch()
{
List <EmpManagement> emp = EmpManagement.GetSearch(txtAN.Text, txtL.Text, txtF.Text);
lvEmp.Items.Clear();
foreach (EmpManagement e in emp)
{
ListViewItem item = new ListViewItem(new String[] { e.Id.ToString(), e.AccountNo.ToString(), e.Empname.ToString(), e.Position.ToString(), e.Salary.ToString() });
item.Tag = e;
lvEmp.Items.Add(item);
}
}
public void LoadAll()
{
List <EmpManagement> emp = EmpManagement.GetEmployee();
lvEmp.Items.Clear();
foreach (EmpManagement e in emp)
{
ListViewItem item = new ListViewItem(new String[] { e.Id.ToString(), e.AccountNo.ToString(), e.Empname.ToString(), e.Position.ToString(), e.Salary.ToString() });
item.Tag = e;
lvEmp.Items.Add(item);
}
}
