public static List <EmployeeLog> LoadDataEmployeeLog() { List <EmployeeLog> employees = new List <EmployeeLog>(); MySqlConnection conn = new MySqlConnection(GlobalVariable.ConnectionString); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = QueryGetDataEmployeeLog(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EmployeeLog emp = new EmployeeLog(); emp.EmployeeLogID = ReaderHepler.GetValueFromReader <int>(reader, nameof(EmployeeLog.EmployeeLogID)); emp.Firstname = ReaderHepler.GetValueFromReader <string>(reader, nameof(EmployeeLog.Firstname)); emp.Lastname = ReaderHepler.GetValueFromReader <string>(reader, nameof(EmployeeLog.Lastname)); emp.DateOfBirth = ReaderHepler.GetValueFromReader <DateTime>(reader, nameof(EmployeeLog.DateOfBirth)); emp.StartWorkDate = ReaderHepler.GetValueFromReader <DateTime>(reader, nameof(EmployeeLog.StartWorkDate)); emp.Salary = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.Salary)); emp.ProvidentFundRate = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.ProvidentFundRate)); emp.ProvidentFundCollectAmount = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.ProvidentFundCollectAmount)); emp.employeeLogDetails = GetEmployeeLogDetail(emp.EmployeeLogID); employees.Add(emp); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(employees); }
public static List <EmployeeLogDetail> GetEmployeeLogDetail(int employeeLogID) { List <EmployeeLogDetail> employeeLogDetails = new List <EmployeeLogDetail>(); MySqlConnection conn = new MySqlConnection(GlobalVariable.ConnectionString); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = QueryGetEmployeeLogDetail(employeeLogID); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EmployeeLogDetail emp = new EmployeeLogDetail(); emp.EmployeeLogID = ReaderHepler.GetValueFromReader <int>(reader, nameof(EmployeeLogDetail.EmployeeLogID)); emp.EmployeeLogDetailID = ReaderHepler.GetValueFromReader <int>(reader, nameof(EmployeeLogDetail.EmployeeLogDetailID)); emp.WorkYear = ReaderHepler.GetValueFromReader <string>(reader, nameof(EmployeeLogDetail.WorkYear)); emp.Month = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLogDetail.Month)); emp.Salary = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLogDetail.Salary)); emp.PVDRate = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLogDetail.PVDRate)); emp.CompanyPaidPercent = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLogDetail.CompanyPaidPercent)); emp.ProvidentFundCollect = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLogDetail.ProvidentFundCollect)); employeeLogDetails.Add(emp); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(employeeLogDetails); }