public IQueryable <T> GetMasterCheckListCategories <T>(CheckListFilterModel searchFilterModel, TokenModel token) where T : class, new()
{
SqlParameter[] parameters = { new SqlParameter("@SearchText", searchFilterModel.SearchText),
new SqlParameter("@PageNumber", searchFilterModel.pageNumber),
new SqlParameter("@PageSize", searchFilterModel.pageSize),
new SqlParameter("@SortColumn", searchFilterModel.sortColumn),
new SqlParameter("@SortOrder", searchFilterModel.sortOrder),
new SqlParameter("@CategoryName", searchFilterModel.CategoryName) };
return(_context.ExecStoredProcedureListWithOutput <T>(SQLObjects.CHK_MasterCheckListCategoryList, parameters.Length, parameters).AsQueryable());
}
public IQueryable <T> GetAllCheckList <T>(CheckListFilterModel searchFilterModel, TokenModel tokenModel) where T : class, new()
{
try
{
SqlParameter[] parameters = { new SqlParameter("@SearchText", searchFilterModel.SearchText),
new SqlParameter("@Type", searchFilterModel.Type),
new SqlParameter("@OrganizationId", tokenModel.OrganizationID),
new SqlParameter("@PageNumber", searchFilterModel.pageNumber),
new SqlParameter("@PageSize", searchFilterModel.pageSize),
new SqlParameter("@SortColumn", searchFilterModel.sortColumn),
new SqlParameter("@SortOrder", searchFilterModel.sortOrder) };
return(_context.ExecStoredProcedureListWithOutput <T>(SQLObjects.CHK_GetAllCheckLists, parameters.Length, parameters).AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
