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));
}
