public Entity.SearchResult <List <Entity.HardwareKitResponse> > List(Entity.SearchRequest request, bool isAssigned, string companyId)
        {
            Entity.SearchResult <List <Entity.HardwareKitResponse> > result = new Entity.SearchResult <List <Entity.HardwareKitResponse> >();
            try
            {
                logger.Information(Constants.ACTION_ENTRY, "HardwareKitRepository.Get");
                using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
                {
                    List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
                    if (!string.IsNullOrEmpty(companyId))
                    {
                        parameters.Add(sqlDataAccess.CreateParameter("companyguid", Guid.Parse(companyId), DbType.Guid, ParameterDirection.Input));
                    }

                    parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("isAssigned", isAssigned ? 1 : 0, DbType.Int32, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
                    System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[HardwareKit_List]", CommandType.StoredProcedure, null), parameters.ToArray());
                    result.Items = DataUtils.DataReaderToList <Entity.HardwareKitResponse>(dbDataReader, null);
                    result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
                }
                logger.Information(Constants.ACTION_EXIT, "HardwareKitRepository.Get");
            }
            catch (Exception ex)
            {
                logger.Error(Constants.ACTION_EXCEPTION, ex);
            }
            return(result);
        }
Example #2
0
 public Entity.SearchResult <List <Entity.AllRuleResponse> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.AllRuleResponse> > result = new SearchResult <List <AllRuleResponse> >();
     try
     {
         IOT.DataResponse <List <IOT.AllRuleResult> > rules = _iotConnectClient.Rule.All(new IoTConnect.Model.PagingModel()
         {
             PageNo = 1, PageSize = 1000
         }).Result;
         if (rules.status && rules.data != null)
         {
             result = new Entity.SearchResult <List <Entity.AllRuleResponse> >()
             {
                 Items = rules.data.Select(p => Mapper.Configuration.Mapper.Map <Entity.AllRuleResponse>(p)).ToList(),
                 Count = rules.data.Count
             };
         }
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(new Entity.SearchResult <List <Entity.AllRuleResponse> >());
     }
     return(result);
 }
Example #3
0
 public Entity.SearchResult <List <Entity.AllRuleResponse> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.AllRuleResponse> > result = new SearchResult <List <AllRuleResponse> >();
     try
     {
         IOT.DataResponse <List <IOT.AllRuleResult> > rules = _iotConnectClient.Rule.All(new IoTConnect.Model.PagingModel()
         {
             PageNo = 1, PageSize = 1000
         }).Result;
         if (rules.status && rules.data != null)
         {
             result = new Entity.SearchResult <List <Entity.AllRuleResponse> >()
             {
                 Items = rules.data.Select(p => Mapper.Configuration.Mapper.Map <Entity.AllRuleResponse>(p)).ToList(),
                 Count = rules.data.Count
             };
         }
     }
     catch (Exception ex)
     {
         _logger.Error(Constants.ACTION_EXCEPTION, $"NotificationsService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.AllRuleResponse> >());
     }
     return(result);
 }
        public Entity.SearchResult <List <Entity.EntityListItem> > List(Entity.SearchRequest request)
        {
            try
            {
                var result = _entityRepository.List(request);
                Entity.SearchResult <List <Entity.EntityListItem> > response = new Entity.SearchResult <List <Entity.EntityListItem> >()
                {
                    Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.EntityListItem>(p)).ToList(),
                    Count = result.Count
                };
                foreach (var entity in response.Items)
                {
                    var deviceResult = _deviceService.GetDeviceCountersByEntity(entity.Guid);

                    if (deviceResult.IsSuccess && deviceResult.Data != null)
                    {
                        entity.TotalDevices      = deviceResult.Data.counters.total;
                        entity.TotalConnected    = deviceResult.Data.counters.connected;
                        entity.TotalDisconnected = deviceResult.Data.counters.disConnected;
                    }
                }
                return(response);
            }
            catch (Exception ex)
            {
                _logger.Error(Constants.ACTION_EXCEPTION, $"EntityService.List, Error: {ex.Message}");
                return(new Entity.SearchResult <List <Entity.EntityListItem> >());
            }
        }
 public Entity.SearchResult <List <Entity.EntityDetail> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.EntityDetail> > result = new Entity.SearchResult <List <Entity.EntityDetail> >();
     try
     {
         logger.InfoLog(Constants.ACTION_ENTRY, "EntityRepository.Get");
         using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
         {
             List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
             if (!request.EntityId.Equals(Guid.Empty) && !request.EntityId.Equals(SolutionConfiguration.EntityGuid))
             {
                 parameters.Add(sqlDataAccess.CreateParameter("parentEntityGuid", request.EntityId, DbType.Guid, ParameterDirection.Input));
             }
             parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
             DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Entity_List]", CommandType.StoredProcedure, null), parameters.ToArray());
             result.Items = DataUtils.DataReaderToList <Entity.EntityDetail>(dbDataReader, null);
             result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
         }
         logger.InfoLog(Constants.ACTION_EXIT, "EntityRepository.Get");
     }
     catch (Exception ex)
     {
         logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
     }
     return(result);
 }
 public Entity.SearchResult <List <Entity.GreenHouseDetail> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.GreenHouseDetail> > result = new Entity.SearchResult <List <Entity.GreenHouseDetail> >();
     try
     {
         _logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
         {
             List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
             parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
             DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[GreenHouse_List]", CommandType.StoredProcedure, null), parameters.ToArray());
             result.Items = DataUtils.DataReaderToList <Entity.GreenHouseDetail>(dbDataReader, null);
             result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
         }
         _logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
     }
     return(result);
 }
Example #7
0
 public Entity.SearchResult <List <Entity.AllRuleResponse> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.AllRuleResponse> > result = new Entity.SearchResult <List <Entity.AllRuleResponse> >();
     try
     {
         var rules = _iotConnectClient.Rule.All(new IOT.PagingModel()
         {
             PageNo = request.PageNumber, PageSize = request.PageSize, SearchText = request.SearchText, SortBy = request.OrderBy
         }).Result;
         if (rules != null && rules.data != null && rules.data.Any())
         {
             result = new Entity.SearchResult <List <Entity.AllRuleResponse> >()
             {
                 Items = rules.data.Select(r => Mapper.Configuration.Mapper.Map <Entity.AllRuleResponse>(r)).ToList(),
                 Count = rules.data.Count
             };
         }
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(result);
     }
     return(result);
 }
        public Entity.HardwareKitDTO GetHardwareKitDetails(Entity.SearchRequest request)
        {
            Entity.SearchResult <List <Entity.HardwareKit> > result = new Entity.SearchResult <List <Entity.HardwareKit> >();
            var hardwareKitDto = new Entity.HardwareKitDTO();

            try
            {
                _logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
                using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
                {
                    List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
                    parameters.Add(sqlDataAccess.CreateParameter("guid", request.Guid, DbType.String, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
                    System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[KitDevice_List]", CommandType.StoredProcedure, null), parameters.ToArray());
                    result.Items = DataUtils.DataReaderToList <Entity.HardwareKit>(dbDataReader, null);
                    result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
                    HardwareKitDTO hardwareKitDTO = new HardwareKitDTO();

                    if (result.Count >= 0)
                    {
                        var hardwareKit = result.Items.FirstOrDefault();
                        hardwareKitDto = (from c in result.Items
                                          group c by new
                        {
                            c.KitGuid,
                            c.KitCode,
                            c.KitType,
                        } into gcs
                                          select new HardwareKitDTO()
                        {
                            Guid = hardwareKit.Guid,
                            CompanyGuid = hardwareKit.CompanyGuid,
                            KitTypeGuid = result.Items.Count > 0 ? result.Items[0].TemplateGuid : hardwareKit.KitTypeGuid,
                            KitCode = gcs.Key.KitCode,
                            KitDevices = gcs.Select(x => new KitDeviceDTO()
                            {
                                Name = x.Name,
                                IsProvisioned = x.IsProvisioned,
                                Note = x.Note,
                                Tag = x.TagGuid,
                                KitGuid = x.KitGuid,
                                UniqueId = x.UniqueId,
                                ParentUniqueId = x.ParentUniqueId,
                            }).ToList()
                        }).FirstOrDefault();
                    }
                }
                _logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name);
            }
            catch (Exception ex)
            {
                _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
            }

            return(hardwareKitDto);
        }
Example #9
0
 public Entity.SearchResult <List <Entity.AdminRule> > List(Entity.SearchRequest request)
 {
     try
     {
         return(_adminRuleRepository.List(request));
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, $"AdminRuleService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.AdminRule> >());
     }
 }
 public Entity.SearchResult <List <Entity.AdminRule> > List(Entity.SearchRequest request)
 {
     try
     {
         return(_adminRuleRepository.List(request));
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(new Entity.SearchResult <List <Entity.AdminRule> >());
     }
 }
Example #11
0
 public Entity.SearchResult <List <Entity.HardwareKitResponse> > List(Entity.SearchRequest request, bool isAssigned)
 {
     try
     {
         var result = _hardwareKitRepository.List(request, isAssigned, null);
         return(result);
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(new Entity.SearchResult <List <Entity.HardwareKitResponse> >());
     }
 }
 public Entity.SearchResult <List <Entity.HardwareKitResponse> > List(Entity.SearchRequest request, bool isAssigned)
 {
     try
     {
         var result = _hardwareKitRepository.List(request, isAssigned, null);
         return(result);
     }
     catch (Exception ex)
     {
         _logger.Error(Constants.ACTION_EXCEPTION, $"HardwareKitService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.HardwareKitResponse> >());
     }
 }
Example #13
0
 public Entity.SearchResult <List <Entity.DeviceSearchResponse> > GatewayList(Entity.SearchRequest request)
 {
     try
     {
         var result = _deviceRepository.GatewayList(request);
         return(new Entity.SearchResult <List <Entity.DeviceSearchResponse> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.DeviceSearchResponse>(p)).ToList(),
             Count = result.Count
         });
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, $"DeviceService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.DeviceSearchResponse> >());
     }
 }
Example #14
0
 public Entity.SearchResult <List <Entity.Generator> > List(Entity.SearchRequest request)
 {
     try
     {
         Entity.SearchResult <List <Model.Generator> > result = _generatorRepository.List(request);
         return(new Entity.SearchResult <List <Entity.Generator> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.Generator>(p)).ToList(),
             Count = result.Count
         });
     }
     catch (Exception ex)
     {
         _logger.InfoLog(Constants.ACTION_EXCEPTION, $"GeneratorService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.Generator> >());
     }
 }
 public Entity.SearchResult <List <Entity.UserResponse> > List(Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.UserResponse> > result = new Entity.SearchResult <List <Entity.UserResponse> >();
     try
     {
         logger.InfoLog(Constants.ACTION_ENTRY, "UserRepository.Get");
         using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
         {
             List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version);
             parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
             if (request.EntityId != Guid.Empty)
             {
                 parameters.Add(sqlDataAccess.CreateParameter("entityGuid", request.EntityId, DbType.Guid, ParameterDirection.Input));
             }
             if (request.ParentEntityGuid != Guid.Empty)
             {
                 parameters.Add(sqlDataAccess.CreateParameter("parentEntityGuid", request.ParentEntityGuid, DbType.Guid, ParameterDirection.Input));
             }
             parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input));
             parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
             System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[User_List]", CommandType.StoredProcedure, null), parameters.ToArray());
             result.Items = DataUtils.DataReaderToList <Entity.UserResponse>(dbDataReader, null);
             // result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
             var count = parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault();
             if (count != null && !string.IsNullOrWhiteSpace(count.Value.ToString()))
             {
                 result.Count = int.Parse(count.Value.ToString());
             }
             var outPut = parameters.Where(p => p.ParameterName.Equals("output")).FirstOrDefault();
             if (outPut != null)
             {
                 int outputvalue = int.Parse(outPut.Value.ToString());
                 result.Count = outputvalue < 0 ? outputvalue : result.Count;
             }
         }
         logger.InfoLog(Constants.ACTION_EXIT, "UserRepository.Get");
     }
     catch (Exception ex)
     {
         logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
     }
     return(result);
 }
 public Entity.SearchResult <List <Entity.Role> > List(Entity.SearchRequest request)
 {
     try
     {
         var result = _roleRepository.List(request);
         return(new Entity.SearchResult <List <Entity.Role> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.Role>(p)).ToList(),
             Count = result.Count
         });
     }
     catch (Exception ex)
     {
         _logger.Error(Constants.ACTION_EXCEPTION, $"RoleService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.Role> >());
     }
 }
Example #17
0
 public Entity.SearchResult <List <Entity.DeviceDetailMobile> > MList(Entity.SearchRequest request)
 {
     try
     {
         Entity.SearchResult <List <Model.DeviceDetail> > result = _deviceRepository.List(request);
         return(new Entity.SearchResult <List <Entity.DeviceDetailMobile> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.DeviceDetailMobile>(p)).ToList(),
             Count = result.Count
         });
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(new Entity.SearchResult <List <Entity.DeviceDetailMobile> >());
     }
 }
 public Entity.SearchResult <List <Entity.UserResponse> > List(Entity.SearchRequest request)
 {
     try
     {
         var result = _userRepository.List(request);
         return(new Entity.SearchResult <List <Entity.UserResponse> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.UserResponse>(p)).ToList(),
             Count = result.Count
         });
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
         return(new Entity.SearchResult <List <Entity.UserResponse> >());
     }
 }
Example #19
0
 public Entity.SearchResult <List <Entity.EntityDetail> > List(Entity.SearchRequest request)
 {
     try
     {
         var result   = _entityRepository.List(request);
         var response = new Entity.SearchResult <List <Entity.EntityDetail> >()
         {
             Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.EntityDetail>(p)).ToList(),
             Count = result.Count
         };
         //foreach (var item in response.Items) {
         //    item.EntityDetails = GetEntityDetail(item.Guid);
         //}
         return(response);
     }
     catch (Exception ex)
     {
         _logger.Error(Constants.ACTION_EXCEPTION, $"EntityService.List, Error: {ex.Message}");
         return(new Entity.SearchResult <List <Entity.EntityDetail> >());
     }
 }
Example #20
0
        public Entity.SearchResult <List <Entity.AdminRule> > List(Entity.SearchRequest request)
        {
            var isAdmin = false;

            Entity.SearchResult <List <Entity.AdminRule> > result = new Entity.SearchResult <List <Entity.AdminRule> >();
            try
            {
                logger.InfoLog(Constants.ACTION_ENTRY, "AdminRuleRepository.Get");


                var checkForAdmin = _companyRepository.FindBy(x => x.Guid.Equals(component.helper.SolutionConfiguration.CompanyId)).FirstOrDefault();

                if (checkForAdmin == null)
                {
                    isAdmin = true;
                }
                else
                {
                    isAdmin = false;
                }

                using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
                {
                    List <DbParameter> parameters = sqlDataAccess.CreateParams(SolutionConfiguration.CurrentUserId, request.Version);
                    parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("isAdmin", isAdmin, DbType.Boolean, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
                    DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[AdminRule_List]", CommandType.StoredProcedure, null), parameters.ToArray());
                    result.Items = DataUtils.DataReaderToList <Entity.AdminRule>(dbDataReader, null);
                    result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString());
                }
                logger.InfoLog(Constants.ACTION_EXIT, "AdminRuleRepository.Get");
            }
            catch (Exception ex)
            {
                logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
            }
            return(result);
        }
        public Entity.SearchResult <List <Entity.HardwareKitResponse> > GetSubscriberKitDetails(string companyId, Entity.SearchRequest request, bool isAssigned)
        {
            Entity.SearchResult <List <Entity.HardwareKitResponse> > result = new Entity.SearchResult <List <Entity.HardwareKitResponse> >();
            try
            {
                result = _hardwareKitRepository.List(request, isAssigned, companyId);

                return(new Entity.SearchResult <List <Entity.HardwareKitResponse> >()
                {
                    Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.HardwareKitResponse>(p)).ToList(),
                    Count = result.Count
                });
            }
            catch (Exception ex)
            {
                _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
            }
            return(result);
        }
        public Entity.SearchResult <List <Entity.SubscriberData> > SubscriberList(string solutionID, Entity.SearchRequest request)
        {
            try
            {
                bool isTitleCase = component.helper.SolutionConfiguration.isTitleCase;

                if (isTitleCase && !string.IsNullOrEmpty(request.OrderBy))
                {
                    request.OrderBy = titleCase(request.OrderBy);
                }

                var result = _subscriberHelper.SubscriberList(solutionID, request);
                return(new Entity.SearchResult <List <Entity.SubscriberData> >()
                {
                    Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.SubscriberData>(p)).ToList(),
                    Count = result.Count
                });
            }
            catch (Exception ex)
            {
                _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
                return(new Entity.SearchResult <List <Entity.SubscriberData> >());
            }
        }
Example #23
0
 public Entity.SearchResult <List <Entity.SubscriberData> > SubscriberList(string solutionID, Entity.SearchRequest request)
 {
     Entity.SearchResult <List <Entity.SubscriberData> > result = new Entity.SearchResult <List <Entity.SubscriberData> >();
     try
     {
         //Entity.Subscriber response = _httpClientHelper.Get<Entity.Subscriber>(string.Format("{0}solution/subscriber?pageNo={2}&pageSize={3}&displayDataOf=0&productCode={1}", apiBaseURL, solutionID, request.PageNumber, request.PageSize), _subcriptionAccessToken);
         Entity.Subscriber response = _httpClientHelper.Get <Entity.Subscriber>(string.Format("{0}solution/subscriber?displayDataOf=0&productCode={1}&pageNo={2}&pageSize={3}&search={4}&orderBy={5}", apiBaseURL, solutionID, request.PageNumber, request.PageSize, request.SearchText, request.OrderBy), _subcriptionAccessToken);
         result.Items = response.data;
         result.Count = [email protected];
     }
     catch (Exception ex)
     {
         _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name);
     }
     return(result);
 }