string GetInsertedId(string app, string title, string createDate)
{
string condition = DataExtension.AndConditon(
ItemsTSql.GetByApp(app),
ItemsTSql.GetByTitle(title),
ItemsTSql.GetByCreateDate(createDate)
);
DataTable dt = Items.GetItems("1", ItemsColumns.IidColumn, condition, ItemsColumns.IidColumn + " desc");
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][ItemsColumns.IidColumn].ToString());
}
return("");
}
private string GetList(string id, string top)
{
var s = string.Empty;
string fields = "*", condition = "", orderby = "";
int rows = 6;
try
{
rows = int.Parse(top);
}
catch
{
}
condition = DataExtension.AndConditon(
ItemsTSql.GetByEnable("1"),
ItemsTSql.GetByApp(app)
);
condition = GroupsItemsTSql.GetItemsInGroupCondition(id, condition);
orderby = GroupsItemsColumns.IorderColumn;
DataTable dt = GroupsItems.GetAllData(rows.ToString(), fields, condition, orderby);
if (dt.Rows.Count > 0)
{
s = "";
string link = "", titleItem = "", desc = "", img = "", dateIT = "", countView = "", listOrther = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
titleItem = dt.Rows[i][ItemsColumns.VititleColumn].ToString();
img = ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), titleItem, "", true, false, "", false);
desc = dt.Rows[i][ItemsColumns.VidescColumn].ToString();
dateIT = ((DateTime)dt.Rows[i][ItemsColumns.DicreatedateColumn]).ToString("dd/MM/yyyy");
countView = NumberExtension.FormatNumber((int.Parse(dt.Rows[i][ItemsColumns.IitotalviewColumn].ToString())).ToString());
s += @"
<div class='list-news03__item fade-up'>
<div class='list-news03__img img'>
<a class='img__crop' href='" + link + "' title='" + titleItem + @"'> " + img + @"</a>
</div>
<div class='list-news03__content'>
<h3 class='list-news03__ttl'><a href='" + link + "' title='" + titleItem + @"'>" + titleItem + @"</a></h3>
</div>
</div>";
}
}
return(s);
}
void LoadContactDetailContent(string iid)
{
top = "";
fields = "*";
condition = DataExtension.AndConditon(ItemsTSql.GetItemsByIid(iid),
ItemsTSql.GetByApp("QLDDKTV"));
orderby = "";
DataTable dt = TatThanhJsc.Database.GroupsItems.GetAllData(top, fields, condition, orderby);
if (dt.Rows.Count > 0)
{
ltrHoten.Text = dt.Rows[0][ItemsColumns.ViauthorColumn].ToString();
ltrEmail.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.ViparamsColumn].ToString(), "", 1);
ltrNoiDung.Text = dt.Rows[0][ItemsColumns.VicontentColumn].ToString();
ltrGuiLuc.Text = ((DateTime)dt.Rows[0][ItemsColumns.DicreatedateColumn]).ToString("dd/MM/yyyy hh:mm:ss tt");
}
}
void GetParentCate()
{
DataTable dt = new DataTable();
fields = "*";
condition = DataExtension.AndConditon(
ItemsTSql.GetByLang(language),
ItemsTSql.GetByApp(appCate),
" IIENABLE <> 2 ");
orderBy = ItemsColumns.VititleColumn;
dt = Items.GetItems("", fields, condition, orderBy);
ddlCateSearch.Items.Add(new ListItem("Chọn tour cần xem bình luận", ""));
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlCateSearch.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString()));
}
ddlCateSearch.SelectedValue = iid;
}
void GetBookings(string order)
{
string condition = DataExtension.AndConditon(
ItemsTSql.GetByApp(app),
ItemsTSql.GetByLang(language),
ItemsColumns.IienableColumn + "<>2"
);
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = ItemsColumns.DicreatedateColumn + " desc ";
}
}
DataSet ds = new DataSet();
ds = Items.GetItemsPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.Tour, TypePage.Booking + "02",
ddlCateSearch.SelectedValue, "",
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
