private int AdvCateHotdeal_Insert(AdvCateHotdeal objCat) { DataTable tbl = new DataTable(); tbl = sqldbLandingPage.RunQueryAndReturn("CMS_LandingPageSeo_Insert_AdvCateHotdeal", CommandType.StoredProcedure, new System.Data.SqlClient.SqlParameter[] { SqlDb.CreateParamteterSQL("@Name", (object)objCat.Name, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("@Order", (object)objCat.Order, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("@DetailUrl", (object)objCat.DetailUrl, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("@IdType", (object)objCat.IdType, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("@CategoryId", (object)objCat.CategoryId, SqlDbType.NVarChar), }, true); if (tbl != null && tbl.Rows.Count > 0) { return(Common.Obj2Int(tbl.Rows[0]["Id"])); } return(0); }
private AdvCateHotdeal GetCateFromAPI(string KeySearch, int CampaignId) { AdvCateHotdeal objAdvCate = new AdvCateHotdeal(); string strAPI = "http://172.22.1.108/api/MLAPI/suggest.htm?restoreResults=2&original=true&keyword=" + System.Uri.EscapeDataString(KeySearch); WebClient client = new WebClient(); string value = string.Empty; client.Headers.Add("Accept-Language", " en-US"); client.Headers.Add("Accept-Encoding", "gzip, deflate"); client.Headers.Add("Accept", " text/html, application/xhtml+xml, */*"); client.Headers.Add("User-Agent", "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"); client.Encoding = Encoding.UTF8; value = client.DownloadString(strAPI); var result = JsonConvert.DeserializeObject <GetCategoryResult>(value); objAdvCate.Name = result.results[0].categoryName; objAdvCate.Order = 1; objAdvCate.DetailUrl = ""; objAdvCate.IdType = CampaignId; objAdvCate.CategoryId = result.results[0].categoryId; return(objAdvCate); }
private void AutoCreateLandingPage() { int Count = 0; if (tblLandingPage != null && tblLandingPage.Rows.Count > 0) { foreach (DataRow row in tblLandingPage.Rows) { string KeySearch = row["KeySearch"].ToString(); if (!string.IsNullOrEmpty(KeySearch)) { try { string NameCheck = string.Format("{0} {1}", "Top", KeySearch); string LinkLandingPage = row["LinkLandingpage"].ToString(); string UrlCampaign = LinkLandingPage.Replace(@"http://websosanh.vn/", "").Replace(".htm", "").Trim(); if (Check_Exist_LandingPage(UrlCampaign, NameCheck) == false) { Campaign objCamp = new Campaign(); objCamp.Name = string.Format("{0} {1}", "Top", KeySearch); objCamp.UrlCampaign = UrlCampaign; objCamp.IsActive = true; objCamp.Order = 1; objCamp.BackgroundColor = "#f0f2f9"; objCamp.Repeat = 1; objCamp.MetaTitle = objCamp.Name; objCamp.IsIndex = true; objCamp.IsFollow = true; objCamp.IsFlashSale = true; objCamp.Type = 2; objCamp.BannerImagePath = ""; objCamp.BannerUrl = ""; objCamp.BackgroundImage = ""; int CampaignId = Campaign_Insert(objCamp); AdvCateHotdeal objCat = new AdvCateHotdeal(); objCat = GetCateFromAPI(KeySearch, CampaignId); int AdvIdCate = AdvCateHotdeal_Insert(objCat); var lstProduct = Get_List_Product_Insert(KeySearch, AdvIdCate, "[SEO]" + objCamp.Name, DateTime.Now, DateTime.Now.AddDays(30)); foreach (var item in lstProduct) { Insert_AdvProductHotdeal(item); } Count++; this.Invoke(new Action(() => { lblA.Text = Count.ToString(); richTextBox1.AppendText(string.Format("\nĐã tạo landing page: {0}, Đường dẫn: {1}, có: {2} sản phẩm", NameCheck, LinkLandingPage, lstProduct.Count.ToString())); })); } else { this.Invoke(new Action(() => { richTextBox1.AppendText(string.Format("\nLanding Page: {0} đã tồn tại hoặc có lỗi khi tạo", LinkLandingPage)); })); } } catch (Exception ex) { } } } } MessageBox.Show("Done!"); }