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.HardwareKitDTO Get(Guid id) { //Entity.HardwareKit result = new Entity.HardwareKit(); //try //{ // result = _hardwareKitRepository.FindBy(kt => kt.Guid.Equals(id)).Select(p => Mapper.Configuration.Mapper.Map<Entity.HardwareKit>(p)).FirstOrDefault(); // if (result != null) // { // result.KitDevices = _kitDeviceRepository.FindBy(kt => kt.KitGuid.Equals(id)).Select(p => Mapper.Configuration.Mapper.Map<Entity.KitDevice>(p)).ToList(); // } //} //catch (Exception ex) //{ // _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); //} //return result; var hardwareKitDTO = new Entity.HardwareKitDTO(); try { hardwareKitDTO = _hardwareKitRepository.GetHardwareKitDetails(new Entity.SearchRequest { Guid = id.ToString().ToUpper(), Version = component.helper.SolutionConfiguration.Version, CompanyId = component.helper.SolutionConfiguration.CompanyId.ToString().ToUpper(), InvokingUser = component.helper.SolutionConfiguration.CurrentUserId, PageNumber = 1, PageSize = 10 }); } catch (Exception ex) { _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); } return(hardwareKitDTO); }