public IList <PTOData> LoadYear(int empId, int year) { var parameters = new Dictionary <string, object> { { "EmployeeID", empId }, { "Year", year } }; List <PTOData> results = new List <PTOData>(); var _sqlExecution = new SqlExecution(); using (var dro = SetupDataRequestObject("EmpPTOBalanceByYear_Get", parameters)) { using (var reader = _sqlExecution.ExecuteReader(dro.SqlComm)) { LoadFromReader(reader, results); } } return(results); }
public IList <PTOData> Save(PTOEntry entry) { List <PTOData> updatedResults = new List <PTOData>(); var parameters = new Dictionary <string, object> { { "EmployeePTOBalanceID", entry.Id }, { "HrsTaken", entry.Hours }, { "Comments", entry.Comments ?? "" } }; var _sqlExecution = new SqlExecution(); using (var dro = SetupDataRequestObject("EmpPTOBalance_Update", parameters)) { using (var reader = _sqlExecution.ExecuteReader(dro.SqlComm)) { LoadFromReader(reader, updatedResults); } } return(updatedResults); }
public IList <Employee> LoadEmployees() { List <Employee> results = new List <Employee>(); var _sqlExecution = new SqlExecution(); using (var dro = SetupDataRequestObject("EmployeeInfo_GET")) { using (var reader = _sqlExecution.ExecuteReader(dro.SqlComm)) { while (reader.Read()) { var e = new Employee(); e.EmployeeID = Convert.ToInt32(reader["EmployeeID"]); e.FirstName = reader["FirstName"].ToString(); e.LastName = reader["LastName"].ToString(); results.Add(e); } } } return(results); }