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