public QueryCountResponse Count(EntityQuery query) { QueryCountResponse response = new QueryCountResponse { Success = true, Message = "The query was successfully executed.", Timestamp = DateTime.UtcNow }; try { var entity = GetEntity(query.EntityName); if (entity == null) { response.Success = false; response.Message = string.Format("The query is incorrect. Specified entity '{0}' does not exist.", query.EntityName); response.Object = 0; response.Errors.Add(new ErrorModel { Message = response.Message }); response.Timestamp = DateTime.UtcNow; return response; } try { if (query.Query != null) ProcessQueryObject(entity, query.Query); } catch (Exception ex) { response.Success = false; response.Message = "The query is incorrect and cannot be executed"; response.Object = 0; response.Errors.Add(new ErrorModel { Message = ex.Message }); response.Timestamp = DateTime.UtcNow; return response; } IStorageEntityRelationRepository entityRelationRepository = erpService.StorageService.GetEntityRelationRepository(); List<Field> fields = ExtractQueryFieldsMeta(query); var recRepo = erpService.StorageService.GetRecordRepository(); response.Object = recRepo.Count(query.EntityName, query.Query); } catch (Exception ex) { response.Success = false; response.Message = "The query is incorrect and cannot be executed"; response.Object = 0; response.Errors.Add(new ErrorModel { Message = ex.Message }); response.Timestamp = DateTime.UtcNow; return response; } return response; }
public QueryCountResponse Count(EntityQuery query) { QueryCountResponse response = new QueryCountResponse { Success = true, Message = "The query was successfully executed.", Timestamp = DateTime.UtcNow }; try { var entity = GetEntity(query.EntityName); if (entity == null) { response.Success = false; response.Message = string.Format("The query is incorrect. Specified entity '{0}' does not exist.", query.EntityName); response.Object = 0; response.Errors.Add(new ErrorModel { Message = response.Message }); response.Timestamp = DateTime.UtcNow; return response; } //try //{ // if (query.Query != null) // ProcessQueryObject(entity, query.Query); //} //catch (Exception ex) //{ // response.Success = false; // response.Message = "The query is incorrect and cannot be executed"; // response.Object = 0; // response.Errors.Add(new ErrorModel { Message = ex.Message }); // response.Timestamp = DateTime.UtcNow; // return response; //} List<Field> fields = DbContext.Current.RecordRepository.ExtractQueryFieldsMeta(query); response.Object = DbContext.Current.RecordRepository.Count(query.EntityName, query.Query); } catch (Exception ex) { response.Success = false; response.Message = "The query is incorrect and cannot be executed"; response.Object = 0; response.Errors.Add(new ErrorModel { Message = ex.Message }); response.Timestamp = DateTime.UtcNow; return response; } return response; }