public List <User> GetUsers()
{
var data = _dapperHelper.GetAll <User>("Select e.*, c.CollegeName,d.DepartmentName, r.RoleName from [User] e " +
"Left join RoleAuthor r on r.ID= e.RoleID " +
"Left join College c on c.ID= e.CollegeID " +
"Left join Department d on d.ID= e.DepartmentID ", null, commandType: CommandType.Text);
return(data.ToList());
}
public List <Job> ListAll()
{
var data = _dapperHelper.GetAll <Job>("[dbo].[SP_Job_List]", null, commandType: CommandType.StoredProcedure);
return(data.ToList());
}
public List <College> GetCompanies()
{
var data = _dapperHelper.GetAll <College>("Select * from College", null, commandType: CommandType.Text);
return(data.ToList());
}
/// <summary>
/// This method is used for get all employees
/// </summary>
/// <returns>employees</returns>
public List <Employee> GetAll()
{
var employees = _dapperHelper.GetAll <Employee>("SP_Employee_GetAll", null, commandType: CommandType.StoredProcedure);
return(employees.ToList());
}
public List <Department> GetDepartments()
{
var data = _dapperHelper.GetAll <Department>("Select * from Department", null, commandType: CommandType.Text);
return(data.ToList());
}
public List <RoleAuthor> GetRoleAuthors()
{
var data = _dapperHelper.GetAll <RoleAuthor>("Select e.* from [RoleAuthor] e ", null, commandType: CommandType.Text);
return(data.ToList());
}