public void Tree() { var sur = new TSS_SectionBL().SurveyBySiteSurveyId(70418); TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL(); var result = sb.ToList("SURVEY_BY_WO", 728833.ToString(), true); // new TSS_SurveyDocumentBL().GetSections("SURVEY_SECTIONS_BY_SITESURVEYID", 70418.ToString(), true); }
public ActionResult Edit(int Id = 0, int ProjectSiteId = 0) { if (Id > 0) { var oob = Permission.AllowProject(Convert.ToInt64(Id)); if (oob == null) { TempData["msg_error"] = "This Project is not assigned to you. Please contact administrator for project assignment."; return(RedirectToAction("index", "error", new { Area = "Project" })); } else { TempData["ProjectEntity"] = oob; TempData.Keep("ProjectEntity"); } } AD_DefinationBL db = new AD_DefinationBL(); Sec_UserSettingsDL udl = new Sec_UserSettingsDL(); ViewBag.FormType = (TempData["FormType"] != null) ? "Edit" : "New"; ViewBag.Id = Id; ViewBag.Bands = db.ToList("Bands"); ViewBag.ProjectSiteId = ProjectSiteId; ViewBag.ProjectSite = ub.ToList("Get_By_Id", ProjectSiteId.ToString()).FirstOrDefault(); if (ViewBag.ProjectSite == null) { TempData["msg_error"] = "Record Not Exist or You Are Not Authorize to access !"; return(RedirectToAction("All")); } ViewBag.Carriers = db.ToList("Carriers"); ViewBag.Regions = db.ToList("UserRegions", Convert.ToString(ViewBag.UserId)); DataTable Table = udl.GetDataTable("UserProjects", Convert.ToString(ViewBag.UserId), null, null); ViewBag.Projects = Table.ToList <PM_Projects>().Where(x => x.ProjectId == Id).ToList(); ViewBag.Cities = db.ToList("UserCities", Convert.ToString(ViewBag.UserId)); ViewBag.SubCheckList = db.ToList("byDefinationType", "Sub CheckList"); SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList(); ViewBag.NetworkModes = db.SelectedList("NetworkModes", null, "-NetworkMode-"); var hjh = db.MultiSelecet("NetworkModes", null, "-NetworkMode-"); ViewBag.NetworkModesm = hjh; ViewBag.States = sl.Definations("UserStates", Convert.ToString(ViewBag.UserId), "-State-"); //sl.States(); TSS_SurveyDocumentBL sdb = new TSS_SurveyDocumentBL(); ViewBag.Surveys = sdb.ToList("GetAll_byIsActive", true.ToString());; ViewBag.Scopes = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes(); ViewBag.Clients = sl.Clients("UserClients", Convert.ToString(ViewBag.UserId)); ViewBag.SiteTypes = sl.Definations("SiteTypes"); ViewBag.SiteClasses = sl.Definations("SiteClasses"); ViewBag.CheckList = sl.Definations("byDefinationType", "CheckList", "-CheckList-"); ViewBag.Sectors = sl.Sectors(); return(View()); }
public List <TSS_Section> SiteSectionBySurveyId(Int64 Id) { try { TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL(); return(sb.GetSectionBySurveyId("GET_SECTIONS_BY_SurveyId", Id.ToString())); } catch (Exception) { throw; } }
public List <TSS_COPList> GetAllCOP() { try { TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL(); return(sb.GetAllSurveys("GetAllCOP", null, true)); } catch (Exception) { throw; } }
public List <TSS_SurveyDocument> SurveyDocument(Int64 Id, int UserId, string IMEI = null) { try { TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL(); return(sb.ToList("SURVEY_BY_WO", Id.ToString(), true, UserId, 0, IMEI)); //TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL(); //return new List<TSS_SurveyDocument>() { new TSS_SectionBL().SurveyBySiteSurveyId(Id)}; //return sb.ToList("SURVEY_BY_WO", Id.ToString(), true); } catch (Exception) { throw; } }
public ActionResult Workorder(Int64 Id = 0) { AD_DefinationBL db = new AD_DefinationBL(); Sec_UserSettingsDL udl = new Sec_UserSettingsDL(); ViewBag.FormType = (TempData["FormType"] != null) ? "Edit" : "New"; ViewBag.Bands = db.ToList("Bands"); ViewBag.Id = Id; ViewBag.Carriers = db.ToList("Carriers"); DataTable Table = udl.GetDataTable("UserProjects", Convert.ToString(ViewBag.UserId), null, null); ViewBag.Projects = Table.ToList <PM_Projects>(); ViewBag.Cities = db.ToList("UserCities", Convert.ToString(ViewBag.UserId)); ViewBag.SubCheckList = db.ToList("byDefinationType", "Sub CheckList"); Common.SelectedList sl = new Common.SelectedList(); ViewBag.NetworkModes = db.SelectedList("NetworkModes", null, "-NetworkMode-"); var hjh = db.MultiSelecet("NetworkModes", null, "-NetworkMode-"); ViewBag.NetworkModesm = hjh; ViewBag.States = sl.Definations("UserStates", Convert.ToString(ViewBag.UserId), "-State-"); //sl.States(); ViewBag.Regions = db.ToList("UserRegions", Convert.ToString(ViewBag.UserId)); TSS_SurveyDocumentBL sdb = new TSS_SurveyDocumentBL(); ViewBag.Surveys = sdb.ToList("GetAll_byIsActive", true.ToString());; ViewBag.Scopes = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes(); ViewBag.Clients = sl.Clients("UserClients", Convert.ToString(ViewBag.UserId)); ViewBag.SiteTypes = sl.Definations("SiteTypes"); ViewBag.SiteClasses = sl.Definations("SiteClasses"); ViewBag.CheckList = sl.Definations("byDefinationType", "CheckList", "-CheckList-"); ViewBag.Sectors = sl.Sectors(); WorkorderEdit we = new WorkorderEdit(); return(View("Workorder", we)); }
public ActionResult Edit(int Id = 0) { ViewBag.FormType = "Edit"; AV_SitesBL sb = new AV_SitesBL(); AV_Site Site = new AV_Site(); List <AV_Sector> Sectors = new List <AV_Sector>(); sb.SiteWithSectors(Id, ref Site, ref Sectors); ViewBag.Site = Site; Common.SelectedList sl = new Common.SelectedList(); AD_DefinationBL db = new AD_DefinationBL(); ViewBag.NetworkModes = db.SelectedList("NetworkModes", null, "-NetworkMode-"); ViewBag.Bands = db.ToList("Bands"); ViewBag.Carriers = db.ToList("Carriers"); ViewBag.Scopes = sl.Scopes(); ViewBag.Sectors = sl.Sectors(); List <SWI.Libraries.Common.SelectedList> Markets = new List <SelectedList>(); if (ViewBag.IsAdmin) { ViewBag.UserMarkets = db.SelectedList("AllCities"); Markets = ViewBag.UserMarkets; } else { ViewBag.UserMarkets = db.SelectedList("UserCities", Convert.ToString(ViewBag.UserId)); Markets = ViewBag.UserMarkets; } //bands network mode etc dropdowns WorkorderEdit we = new WorkorderEdit(); Sec_UserSettingsDL udl = new Sec_UserSettingsDL(); we.Site = Site; we.Site.StateId = we.Site.State; we.Site.RegionId = we.Site.Region; we.Site.MarketId = we.Site.Market; we.Site.SiteType = we.Site.SiteTypeId; we.Site.SiteClass = we.Site.SiteClassId; we.Bands = ViewBag.Bands; ViewBag.Id = Id; we.Carriers = ViewBag.Carriers; DataTable Table = udl.GetDataTable("UserProjects", Convert.ToString(ViewBag.UserId), null, null); we.Projects = Table.ToList <PM_Projects>(); we.Cities = db.ToList("UserCities", Convert.ToString(ViewBag.UserId)); we.SubCheckList = db.ToList("byDefinationType", "Sub CheckList"); we.NetworkModes = ViewBag.NetworkModes; var hjh = db.MultiSelecet("NetworkModes", null, "-NetworkMode-"); we.NetworkModesm = hjh; we.States = sl.Definations("UserStates", Convert.ToString(ViewBag.UserId), "-State-"); //sl.States(); we.Regions = db.ToList("UserRegions", Convert.ToString(ViewBag.UserId)); // we.Regions = we.Regions.Where(x => x.PDefinationId ==we.State).ToList(); we.UserMarkets = Markets; // we.UserMarkets = we.UserMarkets; //.Where(x=>x.Value==Convert.ToString(we.Region)).ToList(); TSS_SurveyDocumentBL sdb = new TSS_SurveyDocumentBL(); we.Surveys = sdb.ToList("GetAll_byIsActive", true.ToString()); we.Clients = sl.Clients("UserClients", Convert.ToString(ViewBag.UserId)); we.Scopes = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes(); we.SiteTypes = sl.Definations("SiteTypes"); we.SiteClasses = sl.Definations("SiteClasses"); we.CheckList = sl.Definations("byDefinationType", "CheckList", "-CheckList-"); we.Sectors = Sectors; we.Sectors[0].Bands = we.Bands; we.Sectors[0].Carriers = we.Carriers; return(View("Workorder", we)); // return View(Sectors); }