private void _ExecuteRequest_ForPage(List <SiteView> onlineViews, int pageToRequest, out int totalNumberPages) { var pageSize = _onlineUrls.PageSize; var urlQuery = _onlineUrls.Url_ViewsListForSite(OnlineSession, pageSize, 1); var webRequest = CreateLoggedInWebRequest(urlQuery); webRequest.Method = "GET"; OnlineSession.StatusLog.AddStatus($"Web request: {urlQuery}", -10); var response = GetWebResponseLogErrors(webRequest, "get views list"); var xmlDoc = GetWebResponseAsXml(response); var nsManager = XmlHelper.CreateTableauXmlNamespaceManager("iwsOnline"); var workbooks = xmlDoc.SelectNodes("//iwsOnline:view", nsManager); _views = new List <SiteView>(); foreach (XmlNode itemXml in workbooks) { try { var ds = new SiteView(itemXml); _views.Add(ds); } catch { AppDiagnostics.Assert(false, "View parse error"); OnlineSession.StatusLog.AddError("Error parsing view: " + itemXml.InnerXml); } } totalNumberPages = DownloadPaginationHelper.GetNumberOfPagesFromPagination( xmlDoc.SelectSingleNode("//iwsOnline:pagination", nsManager), pageSize); }
/// <summary> /// Does sanity checking and error logging on missing data in views /// </summary> /// <param name="view"></param> private void SanityCheckView(SiteView view, XmlNode xmlNode) { if (string.IsNullOrWhiteSpace(view.Id)) { _onlineSession.StatusLog.AddError(view.Name + " is missing a view ID. Not returned from server! xml=" + xmlNode.OuterXml); } }
public async Task Insert(SiteView entity) { try { var vList = new Site { Company_Id = entity.Company_Id, Site_Code = entity.Site_Code, Site_Name = entity.Site_Name, Address1 = entity.Address1, Address2 = entity.Address2, Address3 = entity.Address3, Address4 = entity.Address4, PostCode = entity.PostCode, City = entity.City, State = entity.State, Country = entity.Country, isActive = entity.isActive, AddedBy = entity.AddedBy, AddedOn = DateTime.Now }; adbContext.site.Add(vList); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Edit(SiteView site) { ResponseHelper objHelper = new ResponseHelper(); if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = "Invalid Model State"; return(BadRequest(objHelper)); } try { if (SiteRepository.Exists(site)) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Data already available"; return(Ok(objHelper)); } await SiteRepository.Update(site); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Save Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public bool Exists(SiteView entity) { int intCount = 0; if (entity.Site_Id > 0) //Update Validation { intCount = adbContext.site.Where(w => w.Company_Id == entity.Company_Id && w.Site_Id != entity.Site_Id && (w.Site_Code == entity.Site_Code || w.Site_Name == entity.Site_Name)).Count(); } else //Insert Validation { intCount = adbContext.site.Where(w => w.Company_Id == entity.Company_Id && (w.Site_Code == entity.Site_Code || w.Site_Name == entity.Site_Name)).Count(); } return(intCount > 0 ? true : false); }
private void LoadSiteView() { if (sconnDataShare.SiteLiveViewEnabled == true) { int currentTabId = 0;//default is first tab; if (_siteView != null) { currentTabId = _siteView.SiteTabView.SelectedIndex; } _siteView = new SiteView(_viewedSiteId); _siteView.SiteTabView.SelectedIndex = currentTabId; DataView.Children.Clear(); DataView.Children.Add(_siteView); } }
private void GetFocusedRowData(int index) { if (index >= 0 && SiteView.RowCount > 0) { SiteView.FocusedRowHandle = index; btnSave.Enabled = false; btnAddNew.Enabled = btnModify.Enabled = true; txtSiteCode.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.SiteCode.ToString()).ToString(); txtSiteName.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.SiteName.ToString()).ToString(); txtSiteAddress.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.SiteAddress.ToString()).ToString(); cmbCity.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.CityName.ToString()).ToString(); cmbCountry.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.CountryName.ToString()).ToString(); cmbType.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.SiteType.ToString()).ToString(); txtNotes.Text = SiteView.GetRowCellValue(index, SiteManager.SiteDetails.Notes.ToString()).ToString(); } }
/// <summary> /// Get a page's worth of Views listing /// </summary> /// <param name="onlineViews"></param> /// <param name="pageToRequest">Page # we are requesting (1 based)</param> /// <param name="totalNumberPages">Total # of pages of data that Server can return us</param> private void ExecuteRequest_ForPage(List <SiteView> onlineViews, int pageToRequest, out int totalNumberPages) { int pageSize = _onlineUrls.PageSize; //Create a web request, in including the users logged-in auth information in the request headers var urlQuery = _onlineUrls.Url_ViewsList(_onlineSession, pageSize, pageToRequest); var webRequest = CreateLoggedInWebRequest(urlQuery); webRequest.Method = "GET"; _onlineSession.StatusLog.AddStatus("Web request: " + urlQuery, -10); var response = GetWebReponseLogErrors(webRequest, "get views list"); var xmlDoc = GetWebResponseAsXml(response); //Get all the view nodes var nsManager = XmlHelper.CreateTableauXmlNamespaceManager("iwsOnline"); var views = xmlDoc.SelectNodes("//iwsOnline:view", nsManager); //Get information for each of the data sources foreach (XmlNode itemXml in views) { try { var thisView = new SiteView(itemXml); onlineViews.Add(thisView); SanityCheckView(thisView, itemXml); } catch { AppDiagnostics.Assert(false, "View parse error"); _onlineSession.StatusLog.AddError("Error parsing view: " + itemXml.OuterXml); } } //end: foreach //------------------------------------------------------------------- //Get the updated page-count //------------------------------------------------------------------- totalNumberPages = DownloadPaginationHelper.GetNumberOfPagesFromPagination( xmlDoc.SelectSingleNode("//iwsOnline:pagination", nsManager), pageSize); }
/// <summary> /// Build a list of Views /// </summary> /// <param name="xmlViewsList"></param> /// <returns></returns> private List <SiteView> GenerateViewsList(XmlNodeList xmlViewsList) { var onlineViews = new List <SiteView>(); //Get information for each of the data sources foreach (XmlNode itemXml in xmlViewsList) { try { var thisItem = new SiteView(itemXml); onlineViews.Add(thisItem); } catch { AppDiagnostics.Assert(false, "1024-1113: Workbook parse error"); _onlineSession.StatusLog.AddError("1024-1113: Error parsing workbook: " + itemXml.InnerXml); } } //end: foreach return(onlineViews); }
public async Task <ActionResult <SitesObj> > GetSite(int id) { var siteView = _context.Site.Select(s => new SiteView { Id = s.Id, Name = s.Name, Brand = s.Brand.Name, Address = s.Address, PostCode = s.PostCode, Latitude = s.Latitude, Longitude = s.Longitude, RegionLevel1 = s.SiteRegion.Where(sr => sr.Region.GeographicalLevel == 1).Select(sr => sr.Region.Name).First(), RegionLevel2 = s.SiteRegion.Where(sr => sr.Region.GeographicalLevel == 2).Select(sr => sr.Region.Name).First(), ModifiedDate = s.ModifiedDate, }); var siteCheck = siteView.Where(s => s.Id == id); var site = new SiteView(); if (siteCheck.Count() == 0) { return(NotFound()); } else { site = await siteCheck.FirstAsync(); } SitesObj sitesobj = new SitesObj(); sitesobj.Sites.Add(site); var fuelTypes = _context.Price.Where(p => p.SiteId == id).Select(f => f.Fuel.Name).Distinct(); sitesobj.QueryInfo.FuelTypes = fuelTypes.ToList(); return(sitesobj); }
private void InitializeViews() { this._detailedView = new MapView(new Position(1, 1), Size.Empty) { CursorMode = CursorMode.Disabled }; this._overviewView = new MapView(Position.Origin, Size.Empty); this._siteView = new SiteView(new Position(1, 1), Size.Empty); this._detailedView.CursorMoved += (newPosition) => { if (this._state == null) { return; } this._overviewView.CursorPosition = new Position( (int)(newPosition.X * this._state.World.OverviewScale), (int)(newPosition.Y * this._state.World.OverviewScale)); this._siteView.CursorPosition = newPosition; this._overviewView.RecalulatePositions(); this._siteView.RecalulatePositions(); // Detect if the cursor is currently on a site var sites = this._state.GetAllSites(); if (sites.ContainsKey(newPosition)) { this._cursorSite = sites[newPosition]; } else { this._cursorSite = null; } }; }
/// <summary> /// Execute request for Workbook Views /// </summary> public void ExecuteRequest() { if (string.IsNullOrWhiteSpace(_userId)) { OnlineSession.StatusLog.AddError("User ID required to query workbooks"); } try { var urlQuery = _onlineUrls.Url_ViewsListForWorkbook(_workbookId, OnlineSession); var webRequest = CreateLoggedInWebRequest(urlQuery); webRequest.Method = "GET"; OnlineSession.StatusLog.AddStatus($"Web request: {urlQuery}", -10); var response = GetWebResponseLogErrors(webRequest, "get views list"); var xmlDoc = GetWebResponseAsXml(response); var nsManager = XmlHelper.CreateTableauXmlNamespaceManager("iwsOnline"); var workbooks = xmlDoc.SelectNodes("//iwsOnline:view", nsManager); _views = new List <SiteView>(); foreach (XmlNode itemXml in workbooks) { try { var ds = new SiteView(itemXml); _views.Add(ds); } catch { AppDiagnostics.Assert(false, "View parse error"); OnlineSession.StatusLog.AddError("Error parsing view: " + itemXml.InnerXml); } } } catch (Exception exPageRequest) { StatusLog.AddError($"Workbooks error during page request: {exPageRequest.Message}"); } }
public async Task Update(SiteView entity) { try { var vList = adbContext.site.Where(x => x.Site_Id == entity.Site_Id).FirstOrDefault(); if (vList != null) { vList.Company_Id = entity.Company_Id; vList.Site_Code = entity.Site_Code.Trim(); vList.Site_Name = entity.Site_Name.Trim(); vList.Address1 = entity.Address1; vList.Address2 = entity.Address2; vList.Address3 = entity.Address3; vList.Address4 = entity.Address4; vList.PostCode = entity.PostCode; vList.City = entity.City; vList.State = entity.State; vList.Country = entity.Country; vList.isActive = entity.isActive; vList.UpdatedBy = entity.UpdatedBy; vList.UpdatedOn = DateTime.Now; adbContext.site.Update(vList); await Task.FromResult(adbContext.SaveChanges()); } else { throw new Exception("Data Not Available"); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Adds a view to the list /// </summary> /// <param name="newView"></param> internal void AddView(SiteView newView) { _views.Add(newView); }