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); } }
public static void Upload(MainProduct mainProduct) { var httpWebReq = (HttpWebRequest)WebRequest.Create(ConfigurationManager.AppSettings["UploadURL"]); var encoding = new UTF8Encoding(); var postDataString = mainProduct.ToString(); var data = encoding.GetBytes(postDataString); httpWebReq.ContentLength = Encoding.UTF8.GetByteCount(postDataString); httpWebReq.Accept = ConfigurationManager.AppSettings["Http_Accept"]; httpWebReq.UserAgent = ConfigurationManager.AppSettings["Http_UserAgent"]; httpWebReq.ContentType = ConfigurationManager.AppSettings["Http_ContentType"]; httpWebReq.Referer = ConfigurationManager.AppSettings["Http_Referer"]; httpWebReq.Headers["Accept-Encoding"] = ConfigurationManager.AppSettings["Http_AcceptEncoding"]; httpWebReq.Headers["Accept-Language"] = ConfigurationManager.AppSettings["Http_AcceptLanguage"]; httpWebReq.Headers["Cookie"] = ConfigurationManager.AppSettings["Http_Cookie"]; httpWebReq.Method = "POST"; using (var stream = httpWebReq.GetRequestStream()) { stream.Write(data, 0, data.Length); } var response = (HttpWebResponse)httpWebReq.GetResponse(); if (response == null) { throw new Exception("Upload to PAYEAR.COM is failed"); } var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd(); var jObject = JObject.Parse(responseString); var responseMessage = (bool)jObject["success"]; if (responseMessage == false) { throw new Exception("Upload to PAYEAR.COM is failed"); } var mainProductID = (string)jObject["data"]; // Sub product foreach (var subProduct in mainProduct.SubProducts) { Upload(mainProductID, subProduct); } }
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); } }
public static void Upload(MainProduct mainProduct) { var httpWebReq = (HttpWebRequest)WebRequest.Create(ConfigurationManager.AppSettings["UploadURL"]); var encoding = new UTF8Encoding(); var postDataString = mainProduct.ToString(); var data = encoding.GetBytes(postDataString); httpWebReq.ContentLength = Encoding.UTF8.GetByteCount(postDataString); httpWebReq.Accept = ConfigurationManager.AppSettings["Http_Accept"]; httpWebReq.UserAgent = ConfigurationManager.AppSettings["Http_UserAgent"]; httpWebReq.ContentType = ConfigurationManager.AppSettings["Http_ContentType"]; httpWebReq.Referer = ConfigurationManager.AppSettings["Http_Referer"]; httpWebReq.Headers["Accept-Encoding"] = ConfigurationManager.AppSettings["Http_AcceptEncoding"]; httpWebReq.Headers["Accept-Language"] = ConfigurationManager.AppSettings["Http_AcceptLanguage"]; httpWebReq.Headers["Cookie"] = ConfigurationManager.AppSettings["Http_Cookie"]; httpWebReq.Method = "POST"; using (var stream = httpWebReq.GetRequestStream()) { stream.Write(data, 0, data.Length); } var response = (HttpWebResponse)httpWebReq.GetResponse(); if (response == null) throw new Exception("Upload to PAYEAR.COM is failed"); var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd(); var jObject = JObject.Parse(responseString); var responseMessage = (bool)jObject["success"]; if (responseMessage == false) throw new Exception("Upload to PAYEAR.COM is failed"); var mainProductID = (string)jObject["data"]; // Sub product foreach (var subProduct in mainProduct.SubProducts) { Upload(mainProductID, subProduct); } }