public IQueryable <T> GetDocuments <T>(CommonFilterModel categoryFilterModel, TokenModel tokenModel) where T : class, new() { SqlParameter[] parameters = { new SqlParameter("@SearchText", categoryFilterModel.SearchText), new SqlParameter("@PageNumber", categoryFilterModel.pageNumber), new SqlParameter("@PageSize", categoryFilterModel.pageSize), new SqlParameter("@OrganizationId", tokenModel.OrganizationID), new SqlParameter("@SortColumn", categoryFilterModel.sortColumn), new SqlParameter("@SortOrder", categoryFilterModel.sortOrder) }; return(_context.ExecStoredProcedureListWithOutput <T>(SQLObjects.MasterDFA_GetDocuments.ToString(), parameters.Length, parameters).AsQueryable()); }
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 List <MasterOrganizationModel> GetMasterOrganizations(string businessName, string orgName, string country, string sortOrder, string sortColumn, int page, int pageSize) { SqlParameter[] parameters = { new SqlParameter("@BusinessName", businessName), new SqlParameter("@organizationName", orgName), new SqlParameter("@Country", country), new SqlParameter("@PageNumber", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@SortColumn", sortColumn), new SqlParameter("@SortOrder", sortOrder), }; return(_masterContext.ExecStoredProcedureListWithOutput <MasterOrganizationModel>("Org_GetMasterOrganization", parameters.Length, parameters).ToList()); }
public List <OrganizationDatabaseDetailsModel> GetOrganizationDatabaseDetails(string databaseName, string organizationName, int organizationID, string sortColumn, string sortOrder, int pageNumber, int pageSize) { SqlParameter[] parameters = { new SqlParameter("@DatabaseName", databaseName), new SqlParameter("@OrganizationName", organizationName), new SqlParameter("@OrganizationID", organizationID), new SqlParameter("@SortColumn", sortColumn), new SqlParameter("@SortOrder", sortOrder), new SqlParameter("@PageNumber", pageNumber), new SqlParameter("@PageSize", pageSize), }; return(_context.ExecStoredProcedureListWithOutput <OrganizationDatabaseDetailsModel>("ORG_GetOrganizationDatabaseDetail", parameters.Length, parameters).ToList()); }
public IQueryable <T> GetSectionItemsByID <T>(int id, TokenModel tokenModel) where T : class, new() { SqlParameter[] parameters = { new SqlParameter("@SectionItemId", id) }; return(_context.ExecStoredProcedureListWithOutput <T>(SQLObjects.MasterDFA_GetSectionItemsByID.ToString(), parameters.Length, parameters).AsQueryable()); }