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 void SaveEmployee(Employee employee) { var parameters = new Dictionary <string, object> { { "FirstName", employee.FirstName ?? "" }, { "LastName", employee.LastName ?? "" }, { "Email", employee.Email ?? "" }, { "LoginID", employee.FirstName + "." + employee.LastName }, { "Password", "password" }, { "StartDate", employee.StartDate }, { "AnnualPTODays", employee.AnnualPTODays }, { "CurrentPTOHrsBalance", employee.CurrentPTOHrsBalance }, { "PTOHrsAccrualRate", employee.PTOHrsAccrualRate }, { "MaxHrsCarryOver", employee.MaxHrsCarryOver } }; var _sqlExecution = new SqlExecution(); using (var dro = SetupDataRequestObject("EmpPTODetails_Create", parameters)) { _sqlExecution.ExecuteNonQuery(dro.SqlComm); } }
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); }