public void updateRoadInformation() { var googleSheet = new GoogleSheetApi(); const string boothInformationpage = "BoothToRoad"; var values = googleSheet.getSheetData(boothInformationpage, "A2:B"); var roadInformation_tmp = new List <RoadInformation>(); foreach (var row in values) { // Print columns A and E, which correspond to indices 0 and 4. Console.WriteLine("{0}, {1}", row[0], row[1]); roadInformation_tmp.Add(new RoadInformation() { boothNumber = Int32.Parse(row[0].ToString()), address = row[1].ToString() }); } roadInformation = roadInformation_tmp; }
public void updateAgentInformation() { var googleSheet = new GoogleSheetApi(); const string agentInformationpage = "AgentInformation"; var values = googleSheet.getSheetData(agentInformationpage, "A3:D"); var agentInformation_tmp = new List <AgentInformation>(); foreach (var row in values) { // Print columns A and E, which correspond to indices 0 and 4. Console.WriteLine("{0}, {1}, {2}, {3}", row[0], row[1], row[2], row[3]); agentInformation_tmp.Add(new AgentInformation() { boothNumber = Int32.Parse(row[0].ToString()), agentName = row[1].ToString(), phoneNumber = row[2].ToString(), address = row[3].ToString() }); } agentInformation = agentInformation_tmp; }
public void updateContactsInformation() { var googleSheet = new GoogleSheetApi(); const string contactInformationpage = "Contacts"; var values = googleSheet.getSheetData(contactInformationpage, "A3:E"); var contactInformation_tmp = new List <ContactsInformation>(); foreach (var row in values) { // Print columns A and E, which correspond to indices 0 and 4. Console.WriteLine("{0}, {1}, {2}, {3}", row[0], row[1], row[2], row[3]); contactInformation_tmp.Add(new ContactsInformation() { wardNumber = Int32.Parse(row[0].ToString()), position = row[1].ToString(), name = row[2].ToString(), phoneNumber = row[3].ToString(), Notes = row.Count == 5 ? row[4].ToString() : "" }); } contactInformation = contactInformation_tmp; }
public void updateBoothInformation() { var googleSheet = new GoogleSheetApi(); const string boothInformationpage = "ElectionBooths"; var values = googleSheet.getSheetData(boothInformationpage, "A3:E"); var boothInformation_tmp = new List <BoothInformation>(); foreach (var row in values) { // Print columns A and E, which correspond to indices 0 and 4. Console.WriteLine("{0}, {1}, {2}, {3}", row[0], row[1], row[2], row[3]); boothInformation_tmp.Add(new BoothInformation() { boothNumber = Int32.Parse(row[0].ToString()), wardNumber = Int32.Parse(row[1].ToString()), population = Int32.Parse(row[2].ToString()), address = row[3].ToString(), locality = row[4].ToString() }); } boothInformation = boothInformation_tmp; }