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; } }
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 ActionResult SingleSiteData(string Filter, Int64 SiteId, Int64 NetworkModeId, Int64 BandId, Int64 CarrierId, Int64 ScopeId, string Sector) { Response r = new Response(); AV_GetSiteDashboardInfo rec = new AV_GetSiteDashboardInfo(); try { AV_GetSiteDashboardInfoBL sdb = new AV_GetSiteDashboardInfoBL(); if (Filter == "Dashboard_Site_Sector") { rec = sdb.GetSectorDataSet(SiteId, NetworkModeId, BandId, CarrierId, ScopeId, Sector, Filter); } else { rec = sdb.GetDataSet(SiteId, NetworkModeId, BandId, CarrierId, ScopeId, Filter); TempData["HandoverStatus"] = rec.HandoverStatus; TempData["MOMTStatus"] = rec.MOMTStatus; TempData["TeamMembers"] = rec.TeamMember; TempData["OoklaResult"] = rec.OoklaTestResult; } TempData["PingThroughtput"] = rec.PingThroughtput; TempData["DLThroughtput"] = rec.DLThroughtput; TempData["ULThroughtput"] = rec.ULThroughtput; TempData["SiteSectorInfo"] = rec.SiteSectorInfo; //TempData["graphDataMTMOSMOSMT"] = rec.GraphDataMTMOSMOSMT; r.Status = "success"; r.Message = "success"; } catch (Exception ex) { r.Status = "error"; r.Message = ex.Message; } return(Json(rec, "application/json", Encoding.UTF8, JsonRequestBehavior.AllowGet)); }