public JsonResult Template(int ClientId, int CityId, string Net, string Band)
        {
            AV_GetSettingTemplateBL temp = new AV_GetSettingTemplateBL();
            var rec = temp.ToList("byClinet_City_Net_Band", ClientId.ToString(), CityId.ToString(), Net, Band);

            return(Json(rec, JsonRequestBehavior.AllowGet));
        }
        public ActionResult Site(int SiteId, int NetworkModeId, int BandId)
        {
            AV_SiteConfigurationsBL site = new AV_SiteConfigurationsBL();
            var SiteData = site.ToList("GET_Configuration", SiteId.ToString(), NetworkModeId.ToString(), BandId.ToString());

            if (SiteData != null && SiteData.Count > 0)
            {
                ViewBag.Values = SiteData;
                ViewBag.SiteId = SiteId;
                var Single = SiteData.FirstOrDefault();
                if (Single != null)
                {
                    ViewBag.ClientId = Single.ClientId;
                    ViewBag.CityId   = Single.CityId;

                    ViewBag.RevisionId = (Single.SiteId > 0) ? Single.RevisionId + 1 : 1;
                    AV_GetSettingTemplateBL temp = new AV_GetSettingTemplateBL();
                    var Templates = temp.ToList("Template");
                    TempData["Templates"] = Templates;
                    ViewBag.TestCategory  = Templates.GroupBy(test => test.TestCateoryID)
                                            .Select(grp => grp.First())
                                            .ToList();

                    ViewBag.GetTestTypes = new Func <int, List <AV_GetSettingTemplate> >(GetTestTypes);
                    ViewBag.GetKpi       = new Func <int, List <AV_GetSettingTemplate> >(GetKpi);


                    ViewBag.NetworkModeId = NetworkModeId;
                    ViewBag.BandId        = BandId;
                }
                else
                {
                    TempData["msg_error"] = "Site Record Not Found";
                }
            }
            else
            {
                TempData["msg_error"] = "Site Record Not Found";
            }



            return(View());
        }
        public ActionResult TestTemplate()
        {
            AV_GetSettingTemplateBL temp = new AV_GetSettingTemplateBL();
            var Templates = temp.ToList("Template");

            TempData["Templates"] = Templates;



            ViewBag.TestCategory = Templates.GroupBy(test => test.TestCateoryID)
                                   .Select(grp => grp.First())
                                   .ToList();


            ViewBag.GetTestTypes = new Func <int, List <AV_GetSettingTemplate> >(GetTestTypes);

            ViewBag.GetKpi = new Func <int, List <AV_GetSettingTemplate> >(GetKpi);



            return(PartialView("~/views/TemplateSetting/_TestTemplate.cshtml"));
        }