private void CreateWarehouseInfo(GstuSpreadSheet sheet)
{
SpreadsheetManager.Write(new GSTU_Search(associatedSheet, warehouseInfoWorksheet,
"A2"), new ValueRange(warehouseXDim.ToString()), null);
SpreadsheetManager.Write(new GSTU_Search(associatedSheet, warehouseInfoWorksheet,
"B2"), new ValueRange(warehouseYDim.ToString()), null);
}
/// <summary>
/// Adds the new animal to the spreadsheet online at the location defined as start cell, if no start cell defined will write from A1
/// </summary>
void WriteToSheet()
{
List <string> list = new List <string>();
list.Add(animal.name);
list.Add(animal.health.ToString());
list.Add(animal.attack.ToString());
list.Add(animal.defence.ToString());
SpreadsheetManager.Write(new GSTU_Search(animal.associatedSheet, animal.associatedWorksheet, "G10"), new ValueRange(list), null);
}
private void UpdateWarehouseData(GstuSpreadSheet sheet)
{
//Begin wiping old data--------------------------------------------------------------------------------------------------
BatchRequestBody updateRequest = new BatchRequestBody();
foreach (var warehouseUUID in sheet.columns["UUID"])
{
if (warehouseUUID.value != "UUID")
{
updateRequest.Add(sheet[warehouseUUID.value, "Box Dim"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet,
""));
updateRequest.Add(sheet[warehouseUUID.value, "Position"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet,
""));
updateRequest.Add(sheet[warehouseUUID.value, "UUID"].AddCellToBatchUpdate(associatedSheet, warehouseItemsWorksheet,
""));
}
}
updateRequest.Send(associatedSheet, warehouseItemsWorksheet, null);
//End wiping old data-------------------------------------------------------------------------------------------------------
//Begin importing new data--------------------------------------------------------------------------------------------------
List <List <string> > warehouseObjectImportList = new List <List <string> >();
foreach (KeyValuePair <string, WarehouseObject> pair in objectsInWarehouse)
{
List <string> temp = new List <string>()
{
pair.Value.UUID,
pair.Value.objTransform.localScale.ToString(),
pair.Value.objTransform.position.ToString()
};
warehouseObjectImportList.Add(temp);
}
SpreadsheetManager.Write(new GSTU_Search(associatedSheet,
warehouseItemsWorksheet, "A2"), new ValueRange(warehouseObjectImportList), null);
//End importing new data----------------------------------------------------------------------------------------------------
}
public void submit_information()
{
string time = System.DateTime.Now.ToString("h:mm:ss");
list.Add(time);
name_field = _name.text;
print(name_field);
lastName_field = lastName.text;
print(lastName_field);
mail_field = mail.text;
print(mail_field);
enterprise_field = enterprise.text;
print(enterprise_field);
list.Add(name_field);
list.Add(lastName_field);
list.Add(mail_field);
list.Add(enterprise_field);
SpreadsheetManager.Write(new GSTU_Search(associatedSheet, associatedWorkSheet, "A" + k), new ValueRange(list), null);
k++;
list.Clear();
SceneManager.LoadScene(1);
}