private string GetGroupsAdv(string position, string cssImage)
{
string s = "";
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn);
string orderby = GroupsColumns.IgorderColumn;
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(app),
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgparams(position),
GroupsTSql.GetGroupsByVglang(lang)
);
DataTable dt = new DataTable();
dt = Groups.GetGroups("", fields, condition, orderby);
if (dt.Rows.Count > 0)
{
s += @"
<div class='blog socical-top'>
<ul>
" + GetListAdv(dt.Rows[0][GroupsColumns.IgidColumn].ToString(), cssImage) + @"
</ul>
</div>";
}
return(s);
}
private string GetGroups(string position)
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgapp(appGroup),
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByVgparams(position)
);
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.IgtotalitemsColumn, GroupsColumns.VGSEOMETACANONICALColumn);
DataTable dt = Groups.GetGroups("", fields, condition, GroupsColumns.IgorderColumn);
string list = "";
string cate = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(),
dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
if (list.Length < 1)
{
list = GetList(dt.Rows[i][GroupsColumns.VGSEOMETACANONICALColumn].ToString(),
dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
}
cate = GetCate(dt.Rows[i][GroupsColumns.VGSEOMETACANONICALColumn].ToString());
s += @"
<div class='section " + (i % 2 == 0 ? "stfirst" : "") + @" tour-cat'>
<div class='container'>
<div class='list'>
<h2>
<a href='" + UrlExtension.WebisteUrl + StringExtension.LayChuoi(cate, "", 3) + RewriteExtension.Extensions + @"' class='title list-title txtCenter fSize-34 fSize-sm-26 nb-color-m1' title='" + StringExtension.LayChuoi(cate, "", 1) + @"'><span>" + StringExtension.LayChuoi(cate, "", 1) + @"</span></a>
</h2>
<p class='list-text hed txtCenter'>" + StringExtension.LayChuoi(cate, "", 2) + @"</p>
<div class='list-body'>
<div class='wap clearfix'>
" + list + @"
</div>
</div>
</div>
</div>
</div>
<div class='container'>
<hr>
</div>";
}
return(s);
}
/// <summary>
/// Lấy danh sách các nhóm
/// </summary>
/// <returns></returns>
private string GetGroups(string position)
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgapp(appGroup),
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByVgparams(position)
);
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn,
GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.IgtotalitemsColumn, GroupsColumns.VgdescColumn);
DataTable dt = Groups.GetGroups("", fields, condition, GroupsColumns.IgorderColumn);
string list = "";
string link = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(),
dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
if (list.Length < 1)
{
list = GetLastest(dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
}
link = UrlExtension.WebisteUrl + rewrite + RewriteExtension.Extensions;
s += @"
<div class='section stlast customer_say'>
<div class='container'>
<div class='list'>
<h2>
<a href='" + link + @"' class='title list-title txtCenter fSize-34 nb-color-m1' title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</a>
</h2>
<p class='list-text hed txtCenter'>" + dt.Rows[i][GroupsColumns.VgdescColumn] + @"</p>
<div class='list-body'>
<div class='slick-slider' data-slick='{""slidesToShow"": 3, ""slidesToScroll"": 1, ""autoplay"": true, ""dots"": false, ""arrows"":true, ""responsive"": [{""breakpoint"":1025,""settings"":{""slidesToShow"": 2}},{""breakpoint"":768,""settings"": {""slidesToShow"": 1}}]}'>
" + list + @"
</div>
</div>
</div>
</div>
</div>";
}
return(s);
}
/// <summary>
/// Lấy danh sách các nhóm
/// </summary>
/// <returns></returns>
private string GetGroups(string position)
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgapp(appGroup),
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByVgparams(position)
);
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn,
GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.IgtotalitemsColumn);
DataTable dt = Groups.GetGroups("", fields, condition, GroupsColumns.IgorderColumn);
string list = "";
string link = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(),
dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
if (list.Length > 0)
{
link = UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn].ToString().ToLower() +
RewriteExtension.Extensions;
}
else//Nếu không có tin --> lấy tự động tin mới
{
link = UrlExtension.WebisteUrl + rewrite + RewriteExtension.Extensions;
list = GetLastest(dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString());
}
s += @"
<h2 class='ttl-comp03 fade-up'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<div class='list-carpark'>
" + list + @"
</div>
";
}
return(s);
}
private string GetGroupsAdv(string position, string cssImage)
{
string s = "";
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn);
string orderby = GroupsColumns.IgorderColumn;
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(app),
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgparams(position),
GroupsTSql.GetGroupsByVglang(lang)
);
DataTable dt = new DataTable();
dt = Groups.GetGroups("", fields, condition, orderby);
for (int i = 0; i < dt.Rows.Count; i++)
{
s += GetListAdv(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), cssImage);
}
return(s);
}
private string GetGroupsAdv(string position, string cssImage)
{
string s = "";
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VgdescColumn);
string orderby = GroupsColumns.IgorderColumn;
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(app),
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgparams(position),
GroupsTSql.GetGroupsByVglang(lang)
);
DataTable dt = new DataTable();
dt = Groups.GetGroups("", fields, condition, orderby);
if (dt.Rows.Count > 0)
{
s += @"
<div class='section about-us'>
<div class='container'>
<div class='list'>
<h2>
<a href='#' class='title list-title txtCenter fSize-34 fSize-sm-26 nb-color-m1'>" + dt.Rows[0][GroupsColumns.VgnameColumn].ToString() + @"</a>
</h2>
<p class='list-text hed txtCenter'>" + dt.Rows[0][GroupsColumns.VgdescColumn].ToString() + @"</p>
<div class='list-body'>
<div class='row'>
" + GetListAdv(dt.Rows[0][GroupsColumns.IgidColumn].ToString(), cssImage) + @"
</div>
</div>
</div>
</div>
</div>";
}
return(s);
}
private void GetAllTag()
{
condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(app),
GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByIgenable("1")
);
if (ddlTagModul.SelectedValue.Length > 0)
{
condition = DataExtension.AndConditon(condition, GroupsTSql.GetGroupsByVgparams(ddlTagModul.SelectedValue));
}
fields = DataExtension.GetListColumns(GroupsColumns.VgnameColumn, GroupsColumns.IgidColumn);
orderby = GroupsColumns.VgnameColumn;
DataTable dt = new DataTable();
dt = Groups.GetGroups("", fields, condition, orderby);
cblListTag.DataSource = dt;
cblListTag.DataTextField = GroupsColumns.VgnameColumn;
cblListTag.DataValueField = GroupsColumns.IgidColumn;
cblListTag.DataBind();
}
private void LoadListSlider(string position, string cssImage)
{
//get data
// lấy danh sách group có vị trí xác định
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn);
string orderBy = GroupsColumns.IgorderColumn;
string condition = DataExtension.AndConditon(GroupsTSql.GetByApp(app),
GroupsTSql.GetByLang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgparams(position),
GroupsTSql.GetByLang(lang));
DataTable dt = Groups.GetGroups("1", fields, condition, orderBy);
if (dt.Rows.Count.Equals(0))
{
return;
}
string igid = "";
// items info
string title = "";
string img = "";
string href = "";
string viparams = "";
string target = "";
string content = "";
string strList = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
igid = dt.Rows[i][GroupsColumns.IgidColumn].ToString();
// getListItem
DataTable dataItems = GroupsItems.GetAllData("1", " * ",
GroupsItemsTSql.GetItemsInGroupCondition(igid,
ItemsTSql.GetItemsByIienable("1")),
GroupsItemsColumns.IorderColumn);
if (dt.Rows.Count.Equals(0))
{
continue;
}
else
{
string s = "";
for (int j = 0; j < dataItems.Rows.Count; j++)
{
title = dataItems.Rows[j][ItemsColumns.VititleColumn].ToString();
viparams = dataItems.Rows[j][ItemsColumns.ViparamsColumn].ToString();
if (viparams.Equals("1"))
{
target = "target='_blank'";
}
else
{
target = "";
}
href = dataItems.Rows[j][ItemsColumns.ViurlColumn].ToString();
img = ImagesExtension.SetTypeImageAdvertising("1", pic, dataItems.Rows[j][ItemsColumns.ViimageColumn].ToString(), title, "", "", cssImage, false);
content = dataItems.Rows[j][ItemsColumns.VISEOTITLEColumn].ToString();
ltrAdv.Text = @"
<a href='" + href + "' title='" + title + @"' class='logo'>
" + img + @"
</a>";
}
}
}
//// render
//ltrAdv.Text = "<ul class='khoi1170'>" + strList + "</ul>";
}
/// <summary>
/// Lấy danh sách các nhóm
/// </summary>
/// <returns></returns>
private string GetGroups(string position)
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgapp(appGroup),
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByVgparams(position)
);
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn,
GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.IgtotalitemsColumn, GroupsColumns.VgdescColumn, GroupsColumns.VgimageColumn, GroupsColumns.VGSEOMETACANONICALColumn);
DataTable dt = Groups.GetGroups("", fields, condition, GroupsColumns.IgorderColumn);
string link = "";
string linkCate = "";
if (dt.Rows.Count > 0)
{
link = UrlExtension.WebisteUrl + rewrite + RewriteExtension.Extensions;
s += @"
<div class='section facilities'>
<div class='container'>
<div class='list'>
<h2>
<a href='" + link + @"' class='title list-title txtCenter fSize-34 fSize-sm-26 nb-color-m1'>" + LanguageItemExtension.GetnLanguageItemTitleByName("Accommodation facilities") + @"</a>
</h2>
<p class='list-text hed txtCenter'>" + LanguageItemExtension.GetnLanguageItemTitleByName("If you want to travel to Quang Ninh and especially want to go to Ha Long, here are the most useful Ha Long travel experiences: How to travel to Ha Long? Where to Ha Long to go, eat, play what? Hotels in Ha Long") + @"</p>
<div class='list-body clearfix'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
linkCate = LayLinkCate(dt.Rows[i][GroupsColumns.VGSEOMETACANONICALColumn].ToString());
s += @"
<div class='col " + (i == 0 ? "bigTwo" : i == 3 ? "bigOne" : "") + @"'>
<div class='item " + (i == 3 ? "item-bign" : "") + @"'>
<div class='item-img'>
<a href='" + linkCate + @"' title='" + dt.Rows[i][GroupsColumns.VgnameColumn].ToString() + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(), dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<h3>
<a href='" + linkCate + @"' class='title item-title' title='" + dt.Rows[i][GroupsColumns.VgnameColumn].ToString() + @"'>" + dt.Rows[i][GroupsColumns.VgnameColumn].ToString() + @"</a>
</h3>
</div>
</div>
</div>";
}
s += @"
</div>
</div>
</div>
</div>";
}
return(s);
}
