public ActionResult Index()
{
ReportsViewModel viewModel;
// Get the default report
var reportList = PowerBiHelper.FetchReports(ConfigHelper.SeatMapReportId);
var reportDefault = PowerBiHelper.FetchReport(_defaultReportId);
// Build up the view model
viewModel = reportDefault.Report != null
? new ReportsViewModel()
{
SelectedReportId = new Guid(reportDefault.Report.Id),
Reports = new SelectList(reportList, "Id", "Name", _defaultReportId),
Report = reportDefault.Report,
AccessToken = PowerBiHelper.CreatePowerBiToken(reportDefault.Report.Id)
}
: new ReportsViewModel()
{
SelectedReportId = Guid.Empty,
Reports = new SelectList(reportList, "Id", "Name", _defaultReportId),
Report = null,
AccessToken = string.Empty
};
return(View(viewModel));
}
public async Task <ActionResult> Index(int concertId)
{
if (concertId == 0)
{
return(RedirectToAction("Index", "Home"));
}
// Map to ViewModel
var viewModel = _findSeatsRepository.GetFindSeatsData(concertId);
// Add Collections
viewModel.ExpirationMonths = GetCardExpirationMonths();
viewModel.ExpirationYears = GetCardExpirationYears();
// Get SeatMap
if (!WingtipTicketApp.Config.RunningInDev)
{
var seatMap = PowerBiHelper.FetchReport(ConfigHelper.SeatMapReportId);
viewModel.SeatMap = seatMap.Report;
viewModel.AccessToken = seatMap.AccessToken;
}
//viewModel.SeatMap.EmbedUrl += "&$filter={BookedSeats/ConcertFilterId} eq " + concertId;
return(View(viewModel));
}
public JsonResult UploadFiles()
{
var results = new List <UploadFileViewModel>();
foreach (string file in Request.Files)
{
var postedFile = Request.Files[file];
if (postedFile == null || postedFile.ContentLength == 0)
{
continue;
}
PowerBiHelper.UploadReport(postedFile);
results.Add(new UploadFileViewModel()
{
Name = postedFile.FileName,
Length = postedFile.ContentLength,
Type = postedFile.ContentType
});
}
return(Json(results, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ReportsViewModel viewModel;
// Get the default report
var defaultReport = PowerBiHelper.FetchReport(_defaultsRepository.GetApplicationDefault(DefaultReportCode));
// Build up the view model
if (defaultReport.Report != null)
{
viewModel = new ReportsViewModel()
{
SelectedReportId = new Guid(defaultReport.Report.Id),
Reports = PowerBiHelper.FetchReports(defaultReport.Report.Id, "Seatingmap"),
Report = defaultReport.Report,
AccessToken = defaultReport.AccessToken
};
}
else
{
viewModel = new ReportsViewModel()
{
SelectedReportId = Guid.Empty,
Reports = PowerBiHelper.FetchReports(null, "Seatingmap"),
Report = null,
AccessToken = string.Empty
};
}
return(View(viewModel));
}
public ActionResult Tables(string datasetId)
{
if (AzureAuthenticationHelper.IsAuthenticated())
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
return(this.View(helper.GetTables(datasetId).Value));
}
return(this.RedirectToAction("Index"));
}
public ActionResult Tables(string datasetId)
{
if (AzureAuthenticationHelper.IsAuthenticated())
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
return this.View(helper.GetTables(datasetId).Value);
}
return this.RedirectToAction("Index");
}
public ActionResult Index(ReportsViewModel viewModel)
{
// Get the selected report
var reportResult = PowerBiHelper.FetchReport(viewModel.SelectedReportId.ToString());
// Build up the view model
viewModel.Reports = PowerBiHelper.FetchReports(viewModel.SelectedReportId.ToString());
viewModel.Report = reportResult.Report;
viewModel.AccessToken = reportResult.AccessToken;
return(View(viewModel));
}
public ActionResult Index(ReportsViewModel viewModel)
{
// Get the selected report
var reportList = PowerBiHelper.FetchReports(ConfigHelper.SeatMapReportId);
var reportResult = PowerBiHelper.FetchReport(viewModel.SelectedReportId.ToString());
// Build up the view model
viewModel.Reports = new SelectList(reportList, "Id", "Name", _defaultReportId);
viewModel.Report = reportResult.Report;
viewModel.AccessToken = reportResult.AccessToken;
return(View(viewModel));
}
public ActionResult TransferCustomers()
{
//return this.Json("Yay", JsonRequestBehavior.AllowGet);
var credentials = AzureAuthenticationHelper.GetReportingCredentials();
if (ServiceHandler.Instance.TryAuthenticate(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword))
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
var customersRaw = ServiceHandler.Instance.Client.GetCustomersRaw(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword,
Customer.All,
1,
AccountManager.All);
if (customersRaw.OwnerDocument != null)
{
var namespaceManager = new XmlNamespaceManager(customersRaw.OwnerDocument.NameTable);
namespaceManager.AddNamespace("tlp", "http://www.timelog.com/XML/Schema/tlp/v4_4");
var customers = customersRaw.SelectNodes("tlp:Customer", namespaceManager);
if (customers != null)
{
var tableConstructed = false;
var rowsList = new List <string>();
foreach (XmlNode customer in customers)
{
if (!tableConstructed)
{
helper.DeleteRows(helper.GetDefaultDatasetId(), "Customers");
var tableSchemaJson = helper.BuildTableSchemaJson("Customers", typeof(Customer));
helper.UpdateTableSchema(helper.GetDefaultDatasetId(), "Customers", tableSchemaJson);
tableConstructed = true;
}
rowsList.Add(helper.BuildTableRowJson(new Customer(customer, namespaceManager)));
}
helper.AddRows(helper.GetDefaultDatasetId(), "Customers", rowsList, 100);
}
}
return(this.Json("Yay", JsonRequestBehavior.AllowGet));
}
return(this.Json("Failed", JsonRequestBehavior.AllowGet));
}
public ActionResult Transfer()
{
if (AzureAuthenticationHelper.IsAuthenticated())
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
this.ViewBag.DatasetStatus = helper.IsDefaultDatasetAvailable() ? "detected" : "created";
helper.CreateDefaultDataset();
// helper.AddRow("6ac4bc17-a85d-4f03-bc5a-e73460568d3c", "Customers");
return(this.View());
}
return(this.RedirectToAction("Index"));
}
public ActionResult Transfer()
{
if (AzureAuthenticationHelper.IsAuthenticated())
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
this.ViewBag.DatasetStatus = helper.IsDefaultDatasetAvailable() ? "detected" : "created";
helper.CreateDefaultDataset();
// helper.AddRow("6ac4bc17-a85d-4f03-bc5a-e73460568d3c", "Customers");
return this.View();
}
return this.RedirectToAction("Index");
}
public async Task <ActionResult> Index(int concertId)
{
if (concertId == 0)
{
return(RedirectToAction("Index", "Home"));
}
// Map to ViewModel
var viewModel = _findSeatsRepository.GetFindSeatsData(concertId);
// Add Collections
viewModel.ExpirationMonths = GetCardExpirationMonths();
viewModel.ExpirationYears = GetCardExpirationYears();
// Get DocumentDB MetaData
VenueMetaData metaData = null;
if (!WingtipTicketApp.Config.RunningInDev)
{
metaData = await _venueMetaDataRepository.GetVenueMetaData(viewModel.Concert.VenueId);
}
viewModel.VenueMetaData =
metaData != null ?
new FindSeatsViewModel.VenueMetaDataViewModel()
{
VenueId = metaData.VenueId,
Data = metaData.Data,
} : null;
// Get SeatMap
if (!WingtipTicketApp.Config.RunningInDev)
{
var seatMap = PowerBiHelper.FetchReport(ConfigHelper.SeatMapReportId);
viewModel.SeatMap = seatMap.Report;
viewModel.AccessToken = seatMap.AccessToken;
}
return(View(viewModel));
}
public ActionResult TransferWorkUnits()
{
return(this.Json("Yay", JsonRequestBehavior.AllowGet));
var credentials = AzureAuthenticationHelper.GetReportingCredentials();
if (ServiceHandler.Instance.TryAuthenticate(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword))
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
var workUnitsRaw = ServiceHandler.Instance.Client.GetWorkUnitsRaw(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword,
WorkUnit.All,
Employee.All,
Allocation.All,
Task.All,
Project.All,
Department.All,
DateTime.Now.AddMonths(-6).ToString(),
DateTime.Now.ToString());
if (workUnitsRaw.OwnerDocument != null)
{
var namespaceManager = new XmlNamespaceManager(workUnitsRaw.OwnerDocument.NameTable);
namespaceManager.AddNamespace("tlp", "http://www.timelog.com/XML/Schema/tlp/v4_4");
var workUnits = workUnitsRaw.SelectNodes("tlp:WorkUnit", namespaceManager);
if (workUnits != null)
{
var tableConstructed = false;
var rowsList = new List <string>();
foreach (XmlNode workUnit in workUnits)
{
if (!tableConstructed)
{
try
{
helper.DeleteRows(helper.GetDefaultDatasetId(), "WorkUnits");
}
catch (Exception)
{
// Ignore. Probably first request
throw new Exception("PowerBI table definition out of sync. Please delete entire dataset and try transferring again.");
}
var tableSchemaJson = helper.BuildTableSchemaJson("WorkUnits", typeof(WorkUnit));
helper.UpdateTableSchema(helper.GetDefaultDatasetId(), "WorkUnits", tableSchemaJson);
tableConstructed = true;
}
rowsList.Add(helper.BuildTableRowJson(new WorkUnit(workUnit, namespaceManager)));
}
helper.AddRows(helper.GetDefaultDatasetId(), "WorkUnits", rowsList, 100);
}
}
return(this.Json("Yay", JsonRequestBehavior.AllowGet));
}
return(this.Json("Failed", JsonRequestBehavior.AllowGet));
}
public ActionResult TransferWorkUnits()
{
return this.Json("Yay", JsonRequestBehavior.AllowGet);
var credentials = AzureAuthenticationHelper.GetReportingCredentials();
if (ServiceHandler.Instance.TryAuthenticate(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword))
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
var workUnitsRaw = ServiceHandler.Instance.Client.GetWorkUnitsRaw(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword,
WorkUnit.All,
Employee.All,
Allocation.All,
Task.All,
Project.All,
Department.All,
DateTime.Now.AddMonths(-6),
DateTime.Now);
if (workUnitsRaw.OwnerDocument != null)
{
var namespaceManager = new XmlNamespaceManager(workUnitsRaw.OwnerDocument.NameTable);
namespaceManager.AddNamespace("tlp", "http://www.timelog.com/XML/Schema/tlp/v4_4");
var workUnits = workUnitsRaw.SelectNodes("tlp:WorkUnit", namespaceManager);
if (workUnits != null)
{
var tableConstructed = false;
var rowsList = new List<string>();
foreach (XmlNode workUnit in workUnits)
{
if (!tableConstructed)
{
try
{
helper.DeleteRows(helper.GetDefaultDatasetId(), "WorkUnits");
}
catch (Exception)
{
// Ignore. Probably first request
throw new Exception("PowerBI table definition out of sync. Please delete entire dataset and try transferring again.");
}
var tableSchemaJson = helper.BuildTableSchemaJson("WorkUnits", typeof(WorkUnit));
helper.UpdateTableSchema(helper.GetDefaultDatasetId(), "WorkUnits", tableSchemaJson);
tableConstructed = true;
}
rowsList.Add(helper.BuildTableRowJson(new WorkUnit(workUnit, namespaceManager)));
}
helper.AddRows(helper.GetDefaultDatasetId(), "WorkUnits", rowsList, 100);
}
}
return this.Json("Yay", JsonRequestBehavior.AllowGet);
}
return this.Json("Failed", JsonRequestBehavior.AllowGet);
}
public ActionResult TransferCustomers()
{
//return this.Json("Yay", JsonRequestBehavior.AllowGet);
var credentials = AzureAuthenticationHelper.GetReportingCredentials();
if (ServiceHandler.Instance.TryAuthenticate(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword))
{
var helper = new PowerBiHelper(AzureAuthenticationHelper.GetSession());
var customersRaw = ServiceHandler.Instance.Client.GetCustomersRaw(
credentials.SiteCode,
credentials.ApiId,
credentials.ApiPassword,
Customer.All,
1,
AccountManager.All,
string.Empty);
if (customersRaw.OwnerDocument != null)
{
var namespaceManager = new XmlNamespaceManager(customersRaw.OwnerDocument.NameTable);
namespaceManager.AddNamespace("tlp", "http://www.timelog.com/XML/Schema/tlp/v4_4");
var customers = customersRaw.SelectNodes("tlp:Customer", namespaceManager);
if (customers != null)
{
var tableConstructed = false;
var rowsList = new List<string>();
foreach (XmlNode customer in customers)
{
if (!tableConstructed)
{
helper.DeleteRows(helper.GetDefaultDatasetId(), "Customers");
var tableSchemaJson = helper.BuildTableSchemaJson("Customers", typeof(Customer));
helper.UpdateTableSchema(helper.GetDefaultDatasetId(), "Customers", tableSchemaJson);
tableConstructed = true;
}
rowsList.Add(helper.BuildTableRowJson(new Customer(customer, namespaceManager)));
}
helper.AddRows(helper.GetDefaultDatasetId(), "Customers", rowsList, 100);
}
}
return this.Json("Yay", JsonRequestBehavior.AllowGet);
}
return this.Json("Failed", JsonRequestBehavior.AllowGet);
}
