public AV_GetSiteDashboardInfo GetSectorDataSet(Int64 SiteId, Int64 NetworkModeId, Int64 BandId, Int64 CarrierId, Int64 ScopeId, string Sector, string FilterOption) { try { AV_GetSiteDashboardInfoDL sdd = new AV_GetSiteDashboardInfoDL(); DataSet ds = sdd.GetDataSet(SiteId, NetworkModeId, BandId, CarrierId, ScopeId, FilterOption, Sector); AV_GetSiteDashboardInfo sd = new AV_GetSiteDashboardInfo(); sd.PingThroughtput = ds.Tables[0].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.DLThroughtput = ds.Tables[1].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.ULThroughtput = ds.Tables[2].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.SiteSectorInfo = ds.Tables[3].ToList <SiteSectorInfo>(); //.OrderBy(m => m.SiteCode).ToList(); sd.PciSignalStrength = ds.Tables[4].ToList <PciSignalStrength>(); List <SiteDashboardThroughtputChartmomt> objMTSMTMOSMT = ds.Tables[5].ToList <SiteDashboardThroughtputChartmomt>(); if (objMTSMTMOSMT.Count() > 0) { sd.GraphDataMTMOSMOSMT = objMTSMTMOSMT.GroupBy(x => x.TestType).Select(p => new groupByTestType { TestTypeGroup = p.Key, SiteDashboardThroughtputChartmomtList = p.OrderBy(x => x.SiteCode).ToList() }).ToList(); } return(sd); } catch { throw; } }
public AV_GetSiteDashboardInfo GetDataSet(Int64 SiteId, Int64 NetworkModeId, Int64 BandId, Int64 CarrierId, Int64 ScopeId, string FilterOption) { try { AV_GetSiteDashboardInfoDL sdd = new AV_GetSiteDashboardInfoDL(); DataSet ds = sdd.GetDataSet(SiteId, NetworkModeId, BandId, CarrierId, ScopeId, FilterOption, null); AV_GetSiteDashboardInfo sd = new AV_GetSiteDashboardInfo(); sd.TeamMember = ds.Tables[0].ToList <SiteDashboardTeamMember>(); sd.ClientOrVendor = ds.Tables[1].ToList <SiteDashboardClientOrVendor>(); sd.PingThroughtput = ds.Tables[2].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.DLThroughtput = ds.Tables[3].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.ULThroughtput = ds.Tables[4].ToList <SiteDashboardThroughtputChart>().OrderBy(m => m.SiteCode).ToList(); sd.MOMTStatus = ds.Tables[5].ToList <MOMTStatus>(); sd.HandoverStatus = ds.Tables[6].ToList <HandoverStatus>(); sd.OoklaTestResult = ds.Tables[7].ToList <OoklaTestResult>(); return(sd); } catch { throw; } }