private WorksheetEntry GetWorksheetEntry(SpreadsheetEntry entry, int day)
{
WorksheetFeed wsFeed = entry.Worksheets;
WorksheetEntry res = null;
res = wsFeed.Entries[day] as WorksheetEntry;
return res;
}
public Roster()
{
spreadsheet = GDriveManager.getSpreadsheet(Constants.ROSTER_URI);
logger.Info("Spreadsheet " + spreadsheet.Title.Text + " loaded.");
loadRoster();
}
public void LoadSpreadSheet(string spreadSheetId)
{
SpreadsheetQuery query = new SpreadsheetQuery();
query.Uri = new Uri("https://spreadsheets.google.com/feeds/spreadsheets/private/full/" + spreadSheetId);
SpreadsheetFeed feed = service.Query(query);
spreadSheetEntry = (SpreadsheetEntry)feed.Entries[0];
}
private CellFeed GetCellFeed(SpreadsheetsService service, SpreadsheetEntry spEntry)
{
WorksheetFeed wsFeed = spEntry.Worksheets;
WorksheetEntry wsEntry = (WorksheetEntry)wsFeed.Entries[0];
AtomLink wLink = wsEntry.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
CellQuery cellQuery = new CellQuery(wLink.HRef.ToString());
CellFeed cellFeed = service.Query(cellQuery);
return cellFeed;
}
public StatusReporter()
{
this.service = new SpreadsheetsService("Seeker");
this.service.setUserCredentials(username, password);
XmlTextReader reader = new XmlTextReader(@"\\cob-hds-1\compression\QC\QCing\otherFiles\SpreadSheetDictionary.xml");
this.spreadsheets = new Dictionary<string, string>();
string key = "";
string value = "";
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Text:// Display text
Console.Write(reader.Name);
key = reader.Value;
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.Text)
{
value = reader.Value;
break;
}
}
if (value != "")
{
if (!this.spreadsheets.ContainsKey(key))
{
this.spreadsheets.Add(key, value);
}
}
break;
}
}
SpreadsheetQuery query = new SpreadsheetQuery();
this.allSheets = this.service.Query(query);
for (int i = 0; i < allSheets.Entries.Count; i++)
{
if (this.allSheets.Entries[i].AlternateUri.Content.Contains("0AnSESHA7JsTFdFFBNjZ1U3JzdEFXdlZOa0dhQXJNMEE"))
{
this.ReportSpreadSheet = (SpreadsheetEntry)allSheets.Entries[i];
}
if (this.allSheets.Entries[i].AlternateUri.Content.Contains("0AnSESHA7JsTFdDBGUWtqRVJVbEFFYVlaUmZnRTBaVWc"))
{
this.failSheet = (SpreadsheetEntry)allSheets.Entries[i];
}
}
}
public Google2uAccountWorkbook(SpreadsheetEntry in_spreadsheet, Service in_service)
{
Workbook = in_spreadsheet;
WorkbookName = in_spreadsheet.Title.Text;
_Service = in_service;
foreach (var link in in_spreadsheet.Links.Where(in_link => in_link.Rel.Equals("alternate", StringComparison.OrdinalIgnoreCase)))
{
WorkbookUrl = link.HRef.ToString();
break;
}
Worksheets = new List<Google2uWorksheet>();
}
public WorksheetEntry GetCurrentWorksheet(SpreadsheetEntry spreadsheet)
{
var currentDate = String.Format("{0} {1}", DateTime.Now.ToString("MMMM", CultureInfo.InvariantCulture),
DateTime.Now.ToString("yyyy", CultureInfo.InvariantCulture));
var wsFeed = spreadsheet.Worksheets;
foreach (WorksheetEntry entry in wsFeed.Entries.Cast<WorksheetEntry>().Where(entry => entry.Title.Text.Equals(currentDate)))
return entry;
Debug.WriteLine("Worksheet not found.");
return null;
}
public void Authenticate( string refreshToken, string spreadsheetName )
{
var authorizationUrl = OAuthUtil.CreateOAuth2AuthorizationUrl( oAuthParams );
Console.WriteLine( authorizationUrl );
/*if( !string.IsNullOrEmpty( accessCode ) )
{
oAuthParams.AccessCode = accessCode;
}*/
if( !string.IsNullOrEmpty( refreshToken ) )
{
oAuthParams.RefreshToken = refreshToken;
OAuthUtil.RefreshAccessToken( oAuthParams );
}
else
{
OAuthUtil.GetAccessToken( oAuthParams );
}
var accessToken = oAuthParams.AccessToken;
var requestFactory = new GOAuth2RequestFactory( null, applicationName, oAuthParams );
_spreadsheetsService.RequestFactory = requestFactory;
var spreadsheetFeed = _spreadsheetsService.Query( new SpreadsheetQuery() );
_spreadsheetEntries.Clear();
foreach( var entry in spreadsheetFeed.Entries )
{
var spreadsheetEntry = entry as SpreadsheetEntry;
if( spreadsheetEntry == null )
{
continue;
}
_spreadsheetEntries.Add( spreadsheetEntry );
if( spreadsheetName.Equals( spreadsheetEntry.Title.Text ) )
{
_currentEntry = spreadsheetEntry;
}
}
}
/// <summary>
/// Prints a list of all worksheets in the specified spreadsheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the spreadsheet whose worksheets are to be retrieved</param>
private static void PrintAllWorksheets(SpreadsheetsService service,
SpreadsheetEntry entry)
{
AtomLink link = entry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
WorksheetQuery query = new WorksheetQuery(link.HRef.ToString());
WorksheetFeed feed = service.Query(query);
Console.WriteLine("Worksheets in " + entry.Title.Text + ":");
foreach (WorksheetEntry worksheet in feed.Entries)
{
allWorksheets.Add(worksheet);
Console.WriteLine(" " + worksheet.Title.Text);
}
Console.WriteLine();
}
public static ListFeed getListFeedQuery(SpreadsheetEntry spreadsheet, string worksheetName, string query)
{
WorksheetFeed wsFeed = spreadsheet.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries.ToList().Find((AtomEntry e) => e.Title.Text.Equals(worksheetName, StringComparison.InvariantCultureIgnoreCase));
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
if (query != null && !"".Equals(query)) {
listQuery.SpreadsheetQuery = query;
}
return GDriveManager.getService().Query(listQuery);
}
private List<DatablockDetectionInfo> ParseSpreadsheet(SpreadsheetEntry spreadsheet)
{
WorksheetFeed wsFeed = spreadsheet.Worksheets;
if (wsFeed.Entries.Count == 0)
return null;
var worksheet = (WorksheetEntry) wsFeed.Entries[0];
if (worksheet.Rows < 2)
return null;
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
var listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = sheetsAPI.Service.Query(listQuery);
var headers = new List<string>();
spreadsheetRows = listFeed.Entries;
nameColumnIndex = -1;
var row = (ListEntry) spreadsheetRows[0];
for (int index = 0; index < row.Elements.Count; index++)
{
ListEntry.Custom element = row.Elements[index];
if (element.LocalName.Equals("name", StringComparison.OrdinalIgnoreCase))
nameColumnIndex = index;
headers.Add(element.LocalName);
}
List<DatablockDetectionInfo> datablockTypes = AutoDetectDatablockType(headers);
if (datablockTypes == null)
{
Debug.Log("Unable to auto detect datablock type");
return null;
}
return datablockTypes;
}
public WorksheetEntry CreateWorksheet(SpreadsheetEntry spreadsheet, string name)
{
var numberOfDays = (uint)DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month);
var wsFeed = spreadsheet.Worksheets;
var worksheet = new WorksheetEntry(2, numberOfDays) { Title = { Text = name } };
worksheet = _service.Insert(wsFeed, worksheet);
//Insert First Line
var cellQuery = new CellQuery(worksheet.CellFeedLink);
var cellFeed = _service.Query(cellQuery);
for (var i = 1; i <= numberOfDays; i++)
{
cellFeed.Insert(new CellEntry(1, (uint)i, i.ToString(CultureInfo.InvariantCulture)));
}
return worksheet;
}
public WorksheetEntry RedoWorksheet(SpreadsheetEntry spreadsheet, string worksheetName, List<string> headerNames)
{
var createdTempWorksheet = false;
if (spreadsheet.Worksheets.Entries.Count <= 1)
{
_spreadsheetFacade.CreateWorksheet(spreadsheet, "Temp", 1, 1);
createdTempWorksheet = true;
}
_spreadsheetFacade.DeleteWorksheet(spreadsheet, worksheetName); //TODO: fazer backup
_spreadsheetFacade.CreateWorksheet(spreadsheet, worksheetName, 1, (uint)headerNames.Count);
if (createdTempWorksheet)
_spreadsheetFacade.DeleteWorksheet(spreadsheet, "Temp");
var worksheet = _spreadsheetFacade.GetWorksheet(spreadsheet, worksheetName);
_spreadsheetFacade.CreateHeader(worksheet, headerNames);
return worksheet;
}
//returns the first worksheet entry matching the specified name, or the first one in the sheet if no name is specified.
public static WorksheetEntry findWorksheetByName(string worksheet, SpreadsheetEntry spreadsheet)
{
WorksheetFeed wsFeed = spreadsheet.Worksheets;
WorksheetEntry worksheetEntry = null;
if (String.IsNullOrEmpty(worksheet)) //if no worksheet specified, use the first
{
worksheetEntry = (WorksheetEntry)wsFeed.Entries[0];
}
else
{
foreach (WorksheetEntry entry in wsFeed.Entries)
{
if (entry.Title.Text.Equals(worksheet)) //find first matching worksheet
{
worksheetEntry = entry;
break;
}
}
}
return worksheetEntry;
}
/// <summary>
/// Get Worksheets in the given <paramref name="spreadsheet"/>.
/// </summary>
/// <param name="spreadsheet">The <typeparamref name="Google.GData.Spreadsheets.SpreadsheetEntry" /> from which the worksheets should be returned.</param>
/// <returns>Returns a <typeparamref name="Google.GData.Spreadsheets.WorksheetEntry" /> array.</returns>
public virtual WorksheetEntry[] GetWorksheets(SpreadsheetEntry spreadsheet)
{
if (spreadsheet == null)
{
spreadsheet = GetSpreadsheets()[0];
}
var result = new WorksheetEntry[spreadsheet.Worksheets.Entries.Count];
spreadsheet.Worksheets.Entries.CopyTo(result, 0);
return result;
}
/// <summary>
/// Get Spreadsheets accessible by the user. Can be filtered with <paramref name="title"/>.
/// </summary>
/// <param name="title">Filters the accessible spreadsheets. (optional)</param>
/// <returns>Returns a <typeparamref name="Google.GData.Spreadsheets.SpreadsheetEntry" /> array.</returns>
public virtual SpreadsheetEntry[] GetSpreadsheets(string title = null)
{
var query = new SpreadsheetQuery();
if (title != null)
{
query.Title = title;
}
SpreadsheetFeed feed = this.service.Query(query);
// Have to use this "dirty" workaround...
var result = new SpreadsheetEntry[feed.Entries.Count];
feed.Entries.CopyTo(result, 0);
return result;
}
public void reloadLog(string log)
{
PropertyManager.getManager().setProperty("lootLogURI", log);
spreadsheet = GDriveManager.getSpreadsheet(log);
logger.Info("Spreadsheet " + spreadsheet.Title.Text + " loaded.");
loadEvents();
loadArmorTypes();
loadLogFeed();
logURI = log;
}
private void GetWins(SpreadsheetsService service, SpreadsheetEntry entry, WorksheetFeed wsFeed, List<Player> Players)
{
int cellID = 0;
List<CellFeed> cellFeeds = DoCellQuery(service, wsFeed, 2, 3, 3);
for (int i = 0; i < cellFeeds.Count; i++)
{
CellFeed currentCellFeed = cellFeeds[i];
if (currentCellFeed != null)
{
foreach (CellEntry cell in currentCellFeed.Entries)
{
string playerList = cell.InputValue;
string[] playerNames = null;
if (!String.IsNullOrWhiteSpace(playerList))
{
playerNames = playerList.Split(',').Select(sValue => sValue.Trim()).ToArray();
}
else
{
break;
}
foreach (string playerName in playerNames)
{
string placement = null;
string playerNameTrimmed = null;
if (playerName.Contains("("))
{
placement = Regex.Match(playerName, @"\(([^)]*)\)").Groups[1].Value;
playerNameTrimmed = playerName.Remove(playerName.Length - 4);
}
else
{
playerNameTrimmed = playerName;
}
if (Players.Exists(player => player.Name == playerNameTrimmed))
{
Player myPlayer = new Player();
myPlayer = Players.Find(player => player.Name == playerNameTrimmed);
myPlayer.Wins += 1;
if (placement != null)
{
if (myPlayer.Placement == null)
{
myPlayer.Placement = new List<int>();
}
myPlayer.Placement.Add(Int32.Parse(placement));
}
foreach (GameEvent gameEvent in GamesPlayed)
{
if (gameEvent.Name == wsFeed.Entries[i].Title.Text && gameEvent.ID == cellID)
{
if (gameEvent.Winners == null)
{
gameEvent.Winners = new List<Player>();
}
gameEvent.Winners.Add(myPlayer);
}
}
}
}
cellID++;
}
}
}
foreach (Player player in Players)
{
player.WinPercentage = player.GetWinPercentage();
}
GetLosses(service, entry, wsFeed, Players);
}
private void GetPlayers(SpreadsheetsService service, SpreadsheetEntry entry, WorksheetFeed wsFeed)
{
int cellID = 0;
Players = new List<Player>();
List<CellFeed> cellFeeds = DoCellQuery(service, wsFeed, 2, 2, 2);
for (int i = 0; i < cellFeeds.Count; i++)
{
CellFeed currentCellFeed = cellFeeds[i];
if (currentCellFeed != null)
{
foreach (CellEntry cell in currentCellFeed.Entries)
{
string playerList = cell.InputValue;
string[] playerNames = null;
if (!String.IsNullOrWhiteSpace(playerList))
{
playerNames = playerList.Split(',').Select(sValue => sValue.Trim()).ToArray();
}
else
{
break;
}
foreach (string playerName in playerNames)
{
if (!Players.Exists(player => player.Name == playerName))
{
Players.Add(new Player() { Name = playerName });
}
Player myPlayer = new Player();
myPlayer = Players.Find(player => player.Name == playerName);
myPlayer.GamesPlayed += 1;
foreach (GameEvent gameEvent in GamesPlayed)
{
if (gameEvent.Name == wsFeed.Entries[i].Title.Text && gameEvent.ID == cellID)
{
if (gameEvent.Participants == null)
{
gameEvent.Participants = new List<Player>();
}
gameEvent.Participants.Add(myPlayer);
}
}
}
cellID++;
}
}
}
GetWins(service, entry, wsFeed, Players);
}
public static List<SelectListItem> GetWorkSheets(SpreadsheetEntry spreadSheet)
{
var indexValue = 0;
return spreadSheet.Worksheets.Entries.Select(worksheet => new SelectListItem
{
Text = worksheet.Title.Text.ToString(), Value = (indexValue++).ToString()
}).ToList();
}
public void CreateWorksheet(SpreadsheetEntry spreadsheet, string worksheeTitle, uint rows = 100, uint cols = 10)
{
//TODO: tratar se está autenticado
var worksheet = new WorksheetEntry(rows, cols, worksheeTitle);
_connection.SpreadsheetService.Insert(spreadsheet.Worksheets, worksheet);
}
public void logItConference(string fileName, string result)
{
try
{
this.canClose = false;
WorksheetEntry worksheet = null;
CellFeed cells = null;
// FIND THE SPREADSHEET AND WORKSHEET
SpreadsheetQuery query = new SpreadsheetQuery();
this.allSheets = this.service.Query(query);
String lastCode = "";
this.currentSpreadSheet = new SpreadsheetEntry();
string s = fileName;
string code = this.getCode(s);
if (code == "NO FILE CODE FOUND")
{
return;
}
string spreadsheetCode = spreadsheets[code];
if (lastCode != this.getFullCode(s))
{
lastCode = this.getFullCode(s);
for (int i = 0; i < this.allSheets.Entries.Count; i++)
{
if (this.allSheets.Entries[i].AlternateUri.Content.Contains(spreadsheetCode))
{
this.currentSpreadSheet = (SpreadsheetEntry)this.allSheets.Entries[i];
WorksheetFeed wsFeed = this.currentSpreadSheet.Worksheets;
for (int x = 0; x < wsFeed.Entries.Count; x++)
{
WorksheetEntry wksht = (WorksheetEntry)wsFeed.Entries[x];
worksheet = wksht;
CellQuery Querycells = new CellQuery(wksht.CellFeedLink);
Querycells.MaximumColumn = 1;
Querycells.MaximumRow = 2;
Querycells.MinimumColumn = 1;
Querycells.MinimumRow = 2;
this.cells = this.service.Query(Querycells);
string fix = System.IO.Path.GetFileName(s);
if (fix.Contains(this.cells.Entries[0].Content.Content))
{
this.currentWorkSheet = wksht;
break;
}
}
}
}
// NOW, if all went well, we are in the right sheet. Create the list of the needed things--
//List of languages
CellQuery languageQuery = new CellQuery(this.currentWorkSheet.CellFeedLink);
languageQuery.MinimumRow = 3;
languageQuery.MaximumColumn = 2;
languageQuery.MinimumColumn = 2;
languageQuery.ReturnEmpty = ReturnEmptyCells.no;
CellFeed languages = this.service.Query(languageQuery);
//OVP tabs
CellQuery OVPTabs = new CellQuery(this.currentWorkSheet.CellFeedLink);
OVPTabs.MinimumRow = OVPTabs.MaximumRow = 1;
CellFeed columnHeadings = this.service.Query(OVPTabs);
//USE THIS TO FIND EACH INDIVIDUAL VIDEO'S COLUMN
uint row = this.getLanguageRow(s, languages);
uint col = this.getEditColumn(s, columnHeadings, "QC", this.currentWorkSheet);
//OVP tabs
//USE THIS TO FIND EACH INDIVIDUAL VIDEO'S COLUMN
if (col == 0 || row == 0)
{
// something failed--write to the google doc to say that it failed
return;
}
//Get Individual Cell
CellQuery edit = new CellQuery(this.currentWorkSheet.CellFeedLink);
edit.MaximumRow = edit.MinimumRow = row;
edit.MaximumColumn = edit.MinimumColumn = col;
edit.ReturnEmpty = ReturnEmptyCells.yes;
CellFeed editCell = this.service.Query(edit);
CellEntry temp = (CellEntry)editCell.Entries[0];
if (this.initials == "")
{
temp.InputValue = "";
}
else
{
temp.InputValue = result;
}
temp.Update();
this.canClose = true;
}
}
catch (Exception exeption)
{
logger.writeErrorLog("Failed to log " + fileName + " in conference google docs " + DateTime.Now);
this.canClose = true;
}
this.canClose = true;
}
public void DeleteWorksheet(SpreadsheetEntry spreadsheet, string worksheetName)
{
//TODO: tratar se está autenticado
var worksheet = spreadsheet.Worksheets.Entries.FirstOrDefault(e => e.Title.Text == worksheetName);
worksheet?.Delete();
}
private void ShowExportUI()
{
DatablockManager datablockManager = DatablockManager.Instance;
EditorGUILayout.HelpBox("Export datablocks of the selected type to a Google sheet. Select the worksheet you want to export to. Note: All exiting data on the first sheet will be overwritten.", MessageType.None);
EditorGUILayout.BeginHorizontal();
GUI.backgroundColor = new Color(0, 0.8f, .8f);
if (GUILayout.Button("Refresh Spreesheets"))
{
spreadsheetEntries.Clear();
var query = new SpreadsheetQuery();
SpreadsheetFeed feed = null;
try
{
feed = sheetsAPI.Service.Query(query);
}
catch (Exception)
{
Debug.LogError("OAuth error");
sheetsAPI.ClearOAuthToken();
throw;
}
// Iterate through all of the spreadsheets returned
foreach (SpreadsheetEntry entry in feed.Entries)
{
spreadsheetEntries.Add(entry);
}
}
GUI.backgroundColor = new Color(1f, 0.2f, .4f);
if (GUILayout.Button("Clear OAuth token"))
{
sheetsAPI.ClearOAuthToken();
}
GUI.backgroundColor = Color.white;
EditorGUILayout.EndHorizontal();
var options = new List<string>(spreadsheetEntries.Select(s => s.Title.Text));
if (spreadsheetEntries.Count == 0)
{
options.Insert(0, "No spreadsheets found");
}
else
{
options.Insert(0, "Select");
}
if (spreadsheetIndex >= options.Count)
spreadsheetIndex = 0;
int tempSpreadsheetIndex = EditorGUILayout.Popup("Select spreedsheet", spreadsheetIndex, options.ToArray());
if (tempSpreadsheetIndex != spreadsheetIndex)
{
canBeExported = false;
spreadsheetIndex = tempSpreadsheetIndex;
if (spreadsheetIndex != 0)
{
DatablockManager.Instance.RefreshAssets();
spreadsheet = spreadsheetEntries.FirstOrDefault(s => s.Title.Text == options[spreadsheetIndex]);
if (spreadsheet.Worksheets.Entries.Count == 0)
{
Debug.LogError("Spreadsheet has no worksheet. Please add a worksheet to use this spreadsheet.");
return;
}
canBeExported = true;
}
}
if (spreadsheetIndex != 0 && canBeExported)
{
List<Type> types = DatablockList.GetInstances(typeof (Datablock));
datablockTypeIndex = EditorGUILayout.Popup("Choose datablock type", datablockTypeIndex, types.Select(d => d.ToString()).ToArray());
Type datablockType = types[datablockTypeIndex];
GUI.backgroundColor = new Color(0, 0.8f, 0);
string exportLabel = exportData ? "Export " + datablockManager.GetDatablocks(datablockType).Count() + " datablocks" : "Export schema";
if (GUILayout.Button(exportLabel))
{
ExportDatablocks(datablockType);
}
GUI.backgroundColor = Color.white;
EditorGUILayout.HelpBox("All data on the first sheet will be overwritten.", MessageType.Warning);
}
showExportOptions = EditorGUILayout.Foldout(showExportOptions, "Export options");
if (showExportOptions)
{
EditorGUI.indentLevel = 1;
exportData = EditorGUILayout.Toggle("Export data", exportData);
exportFullValues = EditorGUILayout.Toggle(new GUIContent("Include full values", "Exports the full value of a field even if it inherits its value."), exportFullValues);
}
}
private WorksheetEntry GetWorksheet(SpreadsheetEntry pSpreadsheetEntry)
{
AtomLink link = tDicingSpreadsheet.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
string tLink = link.HRef.ToString();
WorksheetQuery tWorksheetQuery = new WorksheetQuery(tLink);
tWorksheetQuery.Title = tSheetName;
WorksheetFeed wfeed = tService.Query(tWorksheetQuery);
WorksheetEntry wentry = wfeed.Entries.FirstOrDefault() as WorksheetEntry;
return wentry;
}
/// <summary>
/// this will reload the list of spreadsheets from the server and reset the
/// currently active spreadsheet/worksheet
/// </summary>
/// <returns></returns>
public void Refresh()
{
Application.sf = null;
Application.se = null;
Application.we = null;
}
private void GetGameDateName(SpreadsheetsService service, SpreadsheetEntry entry, WorksheetFeed wsFeed)
{
GamesPlayed = new List<GameEvent>();
List<CellFeed> cellFeeds = DoCellQuery(service, wsFeed, 2, 1, 1);
int gameID = 0;
for (int i = 0; i < cellFeeds.Count; i++)
{
CellFeed currentCellFeed = cellFeeds[i];
if (currentCellFeed != null)
{
foreach (CellEntry cell in currentCellFeed.Entries)
{
GameEvent newGameEvent = new GameEvent();
string dateTimeString = cell.InputValue;
DateTime dateTime = DateTime.Parse(dateTimeString);
newGameEvent.Date = dateTime;
newGameEvent.Name = wsFeed.Entries[i].Title.Text;
newGameEvent.ID = gameID;
GamesPlayed.Add(newGameEvent);
gameID++;
}
}
}
GetPlayers(service, entry, wsFeed);
}
public SpellManager()
{
spreadsheet = GDriveManager.getSpreadsheet(Constants.SPELL_LISTING_URI);
logger.Info("Spreadsheet " + spreadsheet.Title.Text + " loaded");
loadSpellTemplate();
loadSpellLog();
}
private void FindSpreadsheet()
{
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed feed = service.Query(query);
if (feed.Entries.Count <= 0)
Debug.LogWarning("No spreadsheets found");
foreach (SpreadsheetEntry spreadsheet in feed.Entries)
{
if (spreadsheet.Title.Text == googleSpreadsheetName)
{
sheet = spreadsheet;
break;
}
}
WorksheetFeed wsFeed = sheet.Worksheets;
worksheet = (WorksheetEntry)wsFeed.Entries[0];
if (wsFeed.Entries.Count <= 0)
Debug.LogWarning("No sheets in spreadsheet found");
}
/// <summary>
/// Creates a new instance of the RestoreData class.
/// </summary>
/// <param name="settings">The current Settings object.</param>
/// <param name="values">The current float-array with the values.</param>
/// <param name="sheetEntries">The current array of SpreadsheetEntry objects.</param>
/// <param name="sheetService">The current SpreadsheetService object.</param>
public RestoreData(Settings settings, float[] values, SpreadsheetEntry[] sheetEntries, SpreadsheetsService sheetService)
{
this.Settings = settings;
this.Values = values;
this.SheetEntries = sheetEntries;
this.SheetService = SheetService;
}