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);
}
