static void Main() { var spreadsheetManager = new SpreadsheetManager(); spreadsheetManager.Connect(ConfigurationManager.AppSettings["Google_UserName"], ConfigurationManager.AppSettings["Google_Password"], ConfigurationManager.AppSettings["DatabaseName"], 0); var mainProducts = new List <MainProduct>(); foreach (ListEntry mainProductEntry in spreadsheetManager.GetAllRows().Entries) { if (mainProductEntry.Elements[0].Value != "Main") { continue; } if (mainProductEntry.Elements[1].Value == null || mainProductEntry.Elements[2].Value == null) { continue; } var mainProduct = new MainProduct { ID = mainProductEntry.Elements[1].Value, Name = mainProductEntry.Elements[2].Value, Description = mainProductEntry.Elements[3].Value }; var query = "producttype = \"" + mainProduct.ID + "\""; var subProductList = spreadsheetManager.Query(query); foreach (ListEntry subproductEntry in subProductList.Entries) { mainProduct.SubProducts.Add(new SubProduct(subproductEntry.Elements[1].Value, subproductEntry.Elements[2].Value, subproductEntry.Elements[4].Value, subproductEntry.Elements[5].Value)); } mainProduct.Initialize(); mainProducts.Add(mainProduct); } // Upload foreach (var mainproduct in mainProducts) { Uploader.Upload(mainproduct); } }
static void Main() { var spreadsheetManager = new SpreadsheetManager(); spreadsheetManager.Connect(ConfigurationManager.AppSettings["Google_UserName"], ConfigurationManager.AppSettings["Google_Password"], ConfigurationManager.AppSettings["DatabaseName"], 0); var mainProducts = new List<MainProduct>(); foreach (ListEntry mainProductEntry in spreadsheetManager.GetAllRows().Entries) { if (mainProductEntry.Elements[0].Value != "Main") continue; if (mainProductEntry.Elements[1].Value == null || mainProductEntry.Elements[2].Value == null) continue; var mainProduct = new MainProduct { ID = mainProductEntry.Elements[1].Value, Name = mainProductEntry.Elements[2].Value, Description = mainProductEntry.Elements[3].Value }; var query = "producttype = \"" + mainProduct.ID + "\""; var subProductList = spreadsheetManager.Query(query); foreach (ListEntry subproductEntry in subProductList.Entries) { mainProduct.SubProducts.Add(new SubProduct(subproductEntry.Elements[1].Value, subproductEntry.Elements[2].Value, subproductEntry.Elements[4].Value, subproductEntry.Elements[5].Value)); } mainProduct.Initialize(); mainProducts.Add(mainProduct); } // Upload foreach (var mainproduct in mainProducts) { Uploader.Upload(mainproduct); } }