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.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.SearchResult <List <Entity.AlertResponse> > GetAlertList(Entity.AlertRequest request) { Entity.SearchResult <List <Entity.AlertResponse> > result = new Entity.SearchResult <List <Entity.AlertResponse> >(); try { logger.InfoLog(Constants.ACTION_ENTRY, MethodBase.GetCurrentMethod().Name); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, "v1"); parameters.Add(sqlDataAccess.CreateParameter("companyGuid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input)); if (!string.IsNullOrEmpty(request.EntityGuid)) { parameters.Add(sqlDataAccess.CreateParameter("entityGuid", Guid.Parse(request.EntityGuid), DbType.Guid, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(request.DeviceGuid)) { parameters.Add(sqlDataAccess.CreateParameter("deviceGuid", Guid.Parse(request.DeviceGuid), DbType.Guid, 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("[Alert_List]", CommandType.StoredProcedure, null), parameters.ToArray()); result.Items = DataUtils.DataReaderToList <Entity.AlertResponse>(dbDataReader, null); result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString()); } logger.InfoLog(Constants.ACTION_EXIT, MethodBase.GetCurrentMethod().Name); } catch (Exception ex) { logger.ErrorLog(Constants.ACTION_EXCEPTION, ex); } return(result); }
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); }
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); }
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.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); }
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.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); }
public Entity.SearchResult <List <Entity.AlertResponse> > AlertList(Entity.AlertRequest request) { Entity.SearchResult <List <Entity.AlertResponse> > result = new Entity.SearchResult <List <Entity.AlertResponse> >(); try { result = _notificationsRepository.GetAlertList(request); } catch (Exception ex) { _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); return(result); } return(result); }
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); }
public Entity.SearchResult <List <Entity.Device> > List(Entity.SearchRequest request) { try { Entity.SearchResult <List <Model.DeviceDetail> > result = _deviceRepository.List(request); return(new Entity.SearchResult <List <Entity.Device> >() { Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.Device>(p)).ToList(), Count = result.Count }); } catch (Exception ex) { _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); return(new Entity.SearchResult <List <Entity.Device> >()); } }
public Entity.SearchResult <List <Entity.Device> > List(Entity.SearchRequest request) { try { Entity.SearchResult <List <Entity.DeviceDetail> > result = _deviceRepository.List(request); return(new Entity.SearchResult <List <Entity.Device> >() { Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.Device>(p)).ToList(), Count = result.Count }); } catch (Exception ex) { _logger.Error(Constants.ACTION_EXCEPTION, $"DeviceService.List, Error: {ex.Message}"); return(new Entity.SearchResult <List <Entity.Device> >()); } }
public Entity.SearchResult <List <Entity.Elevator> > List(Entity.SearchRequest request) { try { Entity.SearchResult <List <Entity.Elevator> > result = _deviceRepository.List(request); return(new Entity.SearchResult <List <Entity.Elevator> >() { Items = result.Items.Select(p => Mapper.Configuration.Mapper.Map <Entity.Elevator>(p)).ToList(), Count = result.Count }); } catch (Exception ex) { _logger.ErrorLog(ex, $"DeviceService.List, Error: {ex.Message}"); return(new Entity.SearchResult <List <Entity.Elevator> >()); } }
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.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.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> >()); } }
public Entity.DeviceDetailModel Get(Guid deviceId) { Entity.SearchResult <List <Entity.DeviceDetailModel> > listResult = new Entity.SearchResult <List <Entity.DeviceDetailModel> >(); var result = new Entity.DeviceDetailModel(); try { logger.InfoLog(Constants.ACTION_ENTRY, "DeviceRepository.Get"); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CompanyId, component.helper.SolutionConfiguration.Version); parameters.Add(sqlDataAccess.CreateParameter("companyGuid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("guid", deviceId, DbType.Guid, ParameterDirection.Input)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Device_Get]", CommandType.StoredProcedure, null), parameters.ToArray()); listResult.Items = DataUtils.DataReaderToList <Entity.DeviceDetailModel>(dbDataReader, null); if (listResult.Items.Count > 0) { result = listResult.Items[0]; result.DeviceMediaFiles = GetMediaFiles(result.Guid.Value, "M"); result.DeviceImageFiles = GetMediaFiles(result.Guid.Value, "I"); result.DeviceAttributes = _uow.DbContext.DeviceAttribute.Where(u => u.DeviceGuid == deviceId && !u.IsDeleted).Select(g => new Entity.DeviceAttribute() { Guid = g.Guid, AttrGuid = g.AttrGuid, AttrName = g.AttrName, DispName = g.DisplayName }).ToList(); } } logger.InfoLog(Constants.ACTION_EXIT, "DeviceRepository.Get"); } catch (Exception ex) { logger.ErrorLog(Constants.ACTION_EXCEPTION, ex); } return(result); }
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); }