private void DeleteAllDataInWorksheet(ListFeed listFeed)
{
foreach (var row in listFeed.Entries)
{
row.Delete();
}
}
public SpreadSheet()
{
service = new SpreadsheetsService("stock-market");
service.setUserCredentials("shurai", "$gva99void!");
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed feed = service.Query(query);
SpreadsheetEntry ssentry = (SpreadsheetEntry)feed.Entries[0];
AtomLink sslink = ssentry.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
WorksheetQuery wkquery = new WorksheetQuery(sslink.HRef.ToString());
WorksheetFeed wkfeed = service.Query(wkquery);
WorksheetEntry wkentry = (WorksheetEntry)wkfeed.Entries[0];
listFeedLink = wkentry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = service.Query(listQuery);
Console.WriteLine("Worksheet has {0} rows: ", listFeed.Entries.Count);
foreach (ListEntry worksheetRow in listFeed.Entries)
{
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
foreach (ListEntry.Custom element in elements)
{
Console.Write(element.Value + "\t");
}
Console.WriteLine();
}
}
private void AddBadCards(BoardStatsAnalysis boardStatsAnalysis, ListFeed listFeed)
{
if (boardStatsAnalysis.BoardStats.BadCardStats.Count > 0)
{
var errorRow = _spreadsheetEntryFactory.GetBadCardEntry(boardStatsAnalysis);
_googleClient.Insert(listFeed, errorRow);
}
}
public double getPriceByName(String name)
{
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
query.SpreadsheetQuery = "market=" + name;
listFeed = service.Query(query);
ListEntry e = (ListEntry)listFeed.Entries[0];
string num = e.Elements[1].Value.ToString();
double result = Convert.ToDouble(num);
Console.WriteLine(result);
return result;
}
private void AddGoodCards(BoardStatsAnalysis boardStatsAnalysis, ListFeed listFeed)
{
foreach (var dayGroups in boardStatsAnalysis.CompletedCardStats.GroupBy(b => b.DoneAction.DateInTimeZone(_configuration.TimeZone).ToShortDateString()))
{
var dayGroupList = dayGroups.ToList();
for (int i = 0; i < dayGroupList.Count(); i++)
{
var cardStat = dayGroupList[i];
var minutesConfig = i * _configuration.TimelineJsOffsetMinutesPerCard;
var timeOffset = new TimeSpan(0, minutesConfig, 0);
var row = _spreadsheetEntryFactory.GetCompletedCardEntry(cardStat, timeOffset);
_googleClient.Insert(listFeed, row);
}
}
}
IEnumerator RefreshData()
{
dataIsReady = false;
sheet = GDocService.GetSpreadsheet( "0Ak-N8rbAmu7WdGRFdllybTBIaU1Ic0FxYklIbk1vYlE" );
int counter = 0;
foreach ( ListEntry row in sheet.Entries ) {
Texture2D newTexture = new Texture2D( 256, 256, TextureFormat.DXT1, true);
WWW www = new WWW( row.Elements[3].Value );
yield return www;
www.LoadImageIntoTexture( newTexture );
cachedTextures.Add( row.Elements[3].Value, newTexture );
counter++;
if ( counter >= debugLimit ) {
break;
}
}
dataIsReady = true;
}
private void AddTitleCard(BoardStatsAnalysis boardStatsAnalysis, ListFeed listFeed)
{
var titleRow = _spreadsheetEntryFactory.GetTitleCardEntry(boardStatsAnalysis);
_googleClient.Insert(listFeed, titleRow);
}
private void ReadGSFile()
{
SpreadsheetsService service = new SpreadsheetsService(Constants.googleSheetsAppName);
GOAuth2RequestFactory requestFactory = new GOAuth2RequestFactory(null, Constants.googleSheetsAppName, parameters);
service.RequestFactory = requestFactory;
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed feed = service.Query(query);
SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];
WorksheetFeed wsFeed = spreadsheet.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = service.Query(listQuery);
}
private bool CheckFileGS(string FileName, GoogleSheetsAccountSettings accountForTestGS)
{
bool result = false;
SpreadsheetsService service = new SpreadsheetsService(Constants.googleSheetsAppName);
GOAuth2RequestFactory requestFactory = new GOAuth2RequestFactory(null, Constants.googleSheetsAppName, parameters);
service.RequestFactory = requestFactory;
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed feed = service.Query(query);
SpreadsheetEntry spreadsheet;
for (int i = 0; i < feed.Entries.Count; i++)
{
if (feed.Entries[i].Title.Text == FileName)
{
spreadsheet = (SpreadsheetEntry)feed.Entries[i];
WorksheetFeed wsFeed = spreadsheet.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = service.Query(listQuery);
result = true;
break;
}
else
{
result = false;
}
}
//if (listFeed != null)
//{
// //ShowMapping();
//}
return result;
}
public void Insert(ListFeed listFeed, ListEntry row)
{
_service.Insert(listFeed, row);
}
/// <summary>
/// Sets the list view on the List tab
/// </summary>
/// <param name="feed">The feed providing the data</param>
void SetListListView(ListFeed feed)
{
this.listListView.Items.Clear();
this.listListView.Columns.Clear();
this.editUriTable.Clear();
this.listListView.Columns.Add("", 80, HorizontalAlignment.Center);
AtomEntryCollection entries = feed.Entries;
for (int i=0; i < entries.Count; i++)
{
ListEntry entry = entries[i] as ListEntry;
ListViewItem item = new ListViewItem();
item.Text = (i+1).ToString();
if (entry != null)
{
ListEntry.CustomElementCollection elements = entry.Elements;
for (int j=0; j < elements.Count; j++)
{
item.SubItems.Add(elements[j].Value);
if (listListView.Columns.Count - 2 < j)
{
listListView.Columns.Add(elements[j].LocalName, 80, HorizontalAlignment.Center);
}
}
listListView.Items.Add(item);
this.editUriTable.Add(item.Text, entry);
}
}
}
public void Connect(string googleUserName, string googlePassword, string spreadSheetName, int sheetIndex)
{
_spreadsheetManager.Connect(googleUserName, googlePassword, spreadSheetName, sheetIndex);
_listFeed = _spreadsheetManager.GetAllRows();
}
public ListEntry Insert(ListFeed listFeed, ListEntry listEntry)
{
Debug.WriteLine("Try ListInsert");
return Service.Insert(listFeed, listEntry);
/*
ListEntry retVal = null;
try
{
retVal = Service.Insert(listFeed, listEntry);
}
catch (Google.GData.Client.GDataRequestException ex)
{
Debug.WriteLine("ListEntry.Insert fail:" + ex.ToString());
return null;
}
return retVal;*/
}
private void InsertRow(string pPlayerOne, string pPlayerTwo, string pBetAmount, ListFeed pFeed)
{
DateTime tDateTime = DateTime.Today;
string tDate = tDateTime.Day + "/" + tDateTime.Month + "/" + tDateTime.Year;
int tBetAmount = ConvertBetToInt(pBetAmount);
int tCommission = (int)(tBetAmount * 0.10);
int tAdminFee;
if (tBuyinMode == true)
{
tAdminFee = (int)(tCommission * 0.10);
}
else
{
tAdminFee = (int)(tCommission * 0.30);
}
ListEntry tNewRow = new ListEntry();
ListEntry.Custom tElementDate = new ListEntry.Custom();
tElementDate.LocalName = "date";
tElementDate.Value = tDate;
ListEntry.Custom tElementPlayer1 = new ListEntry.Custom();
tElementPlayer1.LocalName = "nameofplayer1";
tElementPlayer1.Value = pPlayerOne;
ListEntry.Custom tElementPlayer2 = new ListEntry.Custom();
tElementPlayer2.LocalName = "nameofplayer2";
tElementPlayer2.Value = pPlayerTwo;
ListEntry.Custom tElementPlayer1Bet = new ListEntry.Custom();
tElementPlayer1Bet.LocalName = "player1bet";
tElementPlayer1Bet.Value = tBetAmount.ToString();
ListEntry.Custom tElementPlayer2Bet = new ListEntry.Custom();
tElementPlayer2Bet.LocalName = "player2bet";
tElementPlayer2Bet.Value = tBetAmount.ToString();
ListEntry.Custom tElementCommission = new ListEntry.Custom();
tElementCommission.LocalName = "commission";
tElementCommission.Value = tCommission.ToString();
ListEntry.Custom tElementAdminFee = new ListEntry.Custom();
tElementAdminFee.LocalName = "commisionforadmin";
tElementAdminFee.Value = tAdminFee.ToString();
tNewRow.Elements.Add(tElementAdminFee);
tNewRow.Elements.Add(tElementCommission);
tNewRow.Elements.Add(tElementDate);
tNewRow.Elements.Add(tElementPlayer1);
tNewRow.Elements.Add(tElementPlayer1Bet);
tNewRow.Elements.Add(tElementPlayer2);
tNewRow.Elements.Add(tElementPlayer2Bet);
var tResult = pFeed.Insert(tNewRow) as ListEntry;
}
private static IEnumerable<SelectListItem> GetExpenditureTypes(ListFeed listFeed)
{
var expenditureTypes = new List<SelectListItem>();
foreach (ListEntry r in listFeed.Entries)
{
if (!r.Elements[0].Value.Contains("Total"))
expenditureTypes.Add(new SelectListItem
{
Text = r.Elements[0].Value,
Value = r.Elements[0].Value
});
}
return expenditureTypes;
}
public void loadLogFeed()
{
// Get the Loot Log List worksheet
WorksheetEntry worksheet = (WorksheetEntry)spreadsheet.Worksheets.Entries.ToList().Find(new Predicate<AtomEntry>(findLootWorkSheet));
;
// 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());
logFeed = GDriveManager.getService().Query(listQuery);
}
private void LoadRows(ListFeed listFeed)
{
foreach (ListEntry row in listFeed.Entries)
{
//no blank rows with google data or data will stop
_rows.Add(new SheetRow
{
Scene = GetCellText(row, ColumnHeader.Scene),
Moment = GetCellText(row, ColumnHeader.Moment),
Line = GetCellText(row, ColumnHeader.Line),
Duration = GetCellText(row, ColumnHeader.Duration),
Location = GetCellText(row, ColumnHeader.Location),
SFX = GetCellText(row, ColumnHeader.SFX)
});
if (GetCellText(row, ColumnHeader.Scene) == "SCRIPT TOTAL DURATION")
{
//all done last line
break;
}
}
}
