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