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!");
}
