public SimpleResponse<int> GetCompanyExtentCount(GetFilteredExtentRequest request) { try { var scope = 0; if (request.Scope.HasValue) scope = request.Scope.Value; var innerSelect = GetCompanyCountInnerSelectSQL(scope, request.CompanyID); try { var response = GenericGetExtentWithCustomSelectCount<Company>( request.CompanyID, request.CreatedAfter, request.CreatedBefore, request.ModifiedAfter, request.ModifiedBefore, request.Deleted, request.Active, request.Template, request.Path, null, null, innerSelect, request.Conditions, request.LogicalOperator); return response; } catch (Exception ex) { return ErrorHandler.Handle<SimpleResponse<int>>(ex); } } catch (Exception ex) { return ErrorHandler.Handle<SimpleResponse<int>>(ex); } }
public GetListResponse<Profile> GetProfileExtent(GetFilteredExtentRequest request) { var scope = 0; if (request.Scope.HasValue) scope = request.Scope.Value; //note! Areatype select is typically part of the request.Conditions, scope is currently not used var innerSelect = GetProfileInnerSelectSQL(scope, request.CompanyID); try { var response = GenericGetExtentWithCustomSelect<Profile>( request.CompanyID, request.CreatedAfter, request.CreatedBefore, request.ModifiedAfter, request.ModifiedBefore, request.Deleted, request.Active, request.Template, request.Path, request.Limit, request.Offset, request.SortColumns, null, null, innerSelect, request.Conditions, request.LogicalOperator); return response; } catch (Exception ex) { return ErrorHandler.Handle<GetListResponse<Profile>>(ex); } }
public SimpleResponse<int> GetScheduledReportTaskExtentCount(GetFilteredExtentRequest request) { var scope = 0; if (request.Scope.HasValue) scope = request.Scope.Value; //for reports from group - not used currently //var groupID = request.OwnerID.HasValue ? request.OwnerID.Value : Guid.Empty; var innerSelect = GetScheduledReportTaskCountInnerSelectSQL(scope, request.CompanyID); try { var response = GenericGetExtentWithCustomSelectCount<ScheduledTask>( request.CompanyID, request.CreatedAfter, request.CreatedBefore, request.ModifiedAfter, request.ModifiedBefore, request.Deleted, request.Active, request.Template, request.Path, null, null, innerSelect, request.Conditions, request.LogicalOperator); return response; } catch (Exception ex) { return ErrorHandler.Handle<SimpleResponse<int>>(ex); } }
public GetListResponse<Contact> GetContactExtent(GetFilteredExtentRequest req) { try { var response = GenericGetExtent<Contact>( req.CompanyID, req.CreatedAfter, req.CreatedBefore, req.ModifiedAfter, req.ModifiedBefore, req.Deleted, req.Active, req.Template, req.Path, req.Limit, req.Offset, req.SortColumns, null, null); return response; } catch (Exception ex) { return ErrorHandler.Handle<GetListResponse<Contact>>(ex); } }
public GetListResponse<History> GetHistoryExtent(GetFilteredExtentRequest request) { try { var response = new GetListResponse<History>(); var db = ImardaDatabase.CreateDatabase(Util.GetConnName<History>()); Guid? companyID = request.CompanyID; DateTime? createdAfter = request.ModifiedAfter; DateTime? createdBefore = request.ModifiedBefore; bool? deleted = request.Deleted; bool? active = request.Active; Guid? ownerID = request.OwnerID; int? ownerType = request.OwnerType; var scope = 0; if (request.Scope.HasValue) scope = request.Scope.Value; int startNum = 1; int endNum = Int32.MaxValue; if (request.Offset.HasValue) { startNum = request.Offset.Value; if (startNum < 1) startNum = 1; if (request.Limit.HasValue && request.Limit.Value > 0) endNum = startNum + request.Limit.Value - 1; } var whereClause = ""; var con = ""; //these are 'AND'd together string[] filters = { companyID.HasValue && companyID.Value != Guid.Empty ? string.Format(" [CompanyID] = '{0}' ", companyID.Value.ToString()) : null, createdAfter.HasValue ? string.Format(" [DateCreated] >= '{0}' ", createdAfter.Value.ToString("s")) : null, createdBefore.HasValue ? string.Format(" [DateCreated] <= '{0}' ", createdBefore.Value.ToString("s")) : null, deleted.HasValue ? " [Deleted] = " + (deleted.Value ? '1' : '0') : null, active.HasValue ? " [Active] = " + (active.Value ? '1' : '0') : null, ownerID.HasValue ? string.Format(" [OwnerID] = '{0}' ", ownerID.ToString()) : null, ownerType.HasValue ? string.Format(" [OwnerType] = '{0}' ", ownerType.ToString()) : null, }; var filterClause = new StringBuilder(); con = ""; foreach (var filter in filters) { if (filter != null) { filterClause.Append(con).Append(filter); con = " AND "; } } var conditionClause = new StringBuilder(); con = ""; //add any further conditions these ar OR'd together currently foreach (Condition condition in request.Conditions) { var part = condition.GetSQL(); conditionClause.Append(con).Append(part); con = " OR "; } if (conditionClause.Length > 0) filterClause.Append(string.Format(" OR ( {0} )", conditionClause.ToString())); whereClause = filterClause.ToString(); var sortClause = ""; con = ""; foreach (SortColumn sortColumn in request.SortColumns) { var part = sortColumn.FieldName; sortClause += con + part; if (sortColumn.SortDescending) sortClause += " DESC"; con = ", "; } if (string.IsNullOrEmpty(sortClause)) sortClause = "ID"; //we need some column for the OVER part var query = GetFilteredHistoryExtentSQL(scope, startNum, endNum, whereClause, sortClause); using (IDataReader dr = db.ExecuteDataReader(CommandType.Text, query)) { response.List = new List<History>(); while (dr.Read()) { response.List.Add(GetFromData<History>(dr)); } return response; } } catch (Exception ex) { return ErrorHandler.Handle<GetListResponse<History>>(ex); } }
public GetListResponse<SecurityEntity> GetSecurityEntityExtent(GetFilteredExtentRequest request) { var scope = 0; if (request.Scope.HasValue) scope = request.Scope.Value; //for users from fleet var fleetID = request.OwnerID.HasValue ? request.OwnerID.Value : Guid.Empty; var innerSelect = GetSecurityEntityInnerSelectSQL(scope, request.CompanyID); try { var response = GenericGetExtentWithCustomSelect<SecurityEntity>( request.CompanyID, request.CreatedAfter, request.CreatedBefore, request.ModifiedAfter, request.ModifiedBefore, request.Deleted, request.Active, request.Template, request.Path, request.Limit, request.Offset, request.SortColumns, null, null, innerSelect, request.Conditions, request.LogicalOperator); return response; } catch (Exception ex) { return ErrorHandler.Handle<GetListResponse<SecurityEntity>>(ex); } }