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