public List <Entities.Concrete.Employee.Employee> GetAllEmployees()
{
List <Entities.Concrete.Employee.Employee> employeeList = new List <Entities.Concrete.Employee.Employee>();
using (var conn = GetConnection())
{
using (SqlCommand command = new SqlCommand("[dbo].[stpEmployeeSelect]", (SqlConnection)conn))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var lclEmployeee = EmployeeMapper.SqlDataReaderToEntity(reader);
employeeList.Add(lclEmployeee);
}
}
}
conn.Close();
}
return(employeeList);
}
public Entities.Concrete.Employee.Employee GetEmployeeByCompanyID(long prmCompanyID)
{
Entities.Concrete.Employee.Employee employee = null;
using (var conn = GetConnection())
{
using (SqlCommand command = new SqlCommand("[dbo].[stpEmployeeSelectByCompanyID]", (SqlConnection)conn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter {
ParameterName = "@prmCompanyID", SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Input, Value = prmCompanyID
});
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
employee = EmployeeMapper.SqlDataReaderToEntity(reader);
}
}
}
conn.Close();
}
return(employee);
}
