void GetListMembers()
{
condition = "";
if (!tbEmail.Text.Equals(""))
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(email, MembersColumns.vMemberEmail));
}
if (!tbKey.Text.Equals(""))
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(tbKey.Text, MembersColumns.vMemberAccount, MembersColumns.vMemberName));
}
order = " dMemberCreatedate DESC ";
DataSet ds = new DataSet();
ds = Members.GetMembersPaggingCondition(p, DdlListShowItem.SelectedValue, condition, order);
DataTable dt = new DataTable();
dt = ds.Tables[0];
RpListMembers.DataSource = dt;
RpListMembers.DataBind();
dt = ds.Tables[1];
string key = tbKey.Text + "&email=" + tbEmail.Text;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.Member, TypePage.Item,
"", key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
}
void GetNew(string order)
{
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app));
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
GroupsTSql.GetGroupsByVglang(language));
}
condition += " AND IIENABLE = '1' ";
if (tbKeySearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn);
}
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " VISEOMETALANG desc ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(app, "QuanLyBaiVietDaXuatBan",
ddlCateSearch.SelectedValue, key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
void GetNews(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, "");
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
"VIAPP = '" + app + "1'",
GroupsTSql.GetGroupsByVglang(language));
}
condition += " AND IIENABLE <> '2' ";
if (tbKeySearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.ViauthorColumn);
}
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.Contact + "2", TypePage.Item,
ddlCateSearch.SelectedValue, key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
void GetPhotoAlbum(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
if (!igid.Equals(""))
{
ddl_group_ontab.SelectedValue = igid;
conditionItems = GroupsItemsTSql.GetItemsInGroupCondition(ddl_group_ontab.SelectedValue, "");
}
else
{
conditionItems = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
GroupsTSql.GetGroupsByVglang(language));
}
conditionItems = DataExtension.AndConditon(conditionItems, ItemsTSql.GetItemsByViapp(app));
conditionItems += " AND IIENABLE = '2' ";
if (txt_key.Text.Length > 0 && !txt_key.Text.Equals(strdisplay))
{
SearchCondition = " AND " + SearchTSql.GetSearchMathedCondition(txt_key.Text, ItemsColumns.VititleColumn);
}
if (txt_key.Text.Equals(strdisplay))
{
txt_key.Text = "";
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, NumberShowItem, conditionItems + SearchCondition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.PhotoAlbum, TypePage.RecycleItem,
ddl_group_ontab.SelectedValue, txt_key.Text,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
//-------------------------------------------------------------------------------------
#region Partial Views
//
// GET: /Transporter/OutstandingReport
public ActionResult OutstandingReport(PagingModel pm, CustomSearchModel csm, bool givecsm = false)
{
if (givecsm)
{
ViewBag.ViewName = "OutstandingPallets";
return(PartialView("_OutstandingPalletsCustomSearch", new CustomSearchModel("OutstandingPallets")));
}
List <OutstandingPalletsModel> model = GetOutstandingPallets(pm, csm);
PagingExtension paging = PagingExtension.Create(model, model.Count, pm.Skip, pm.Take, pm.Page);
return(PartialView("_OutstandingReport", paging));
}
void GetCategories(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
fields = "*";
condition = DataExtension.AndConditon(
MembersTSql.GetMembersByVproperty(app),
MembersColumns.ImemberisapprovedColumn + "<>2");
if (txtKeySearch.Text.Length > 0 && !txtKeySearch.Text.Equals("Nhập địa chỉ email cần tìm"))
{
condition = DataExtension.AndConditon(condition, TatThanhJsc.TSql.SearchTSql.GetSearchMathedCondition(txtKeySearch.Text, MembersColumns.VmemberaccountColumn, MembersColumns.VmembernameColumn));
}
#region OrderBy
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = MembersColumns.VmemberaccountColumn;
}
}
#endregion
DataTable dt = new DataTable();
DataSet ds = Members.GetMembersPaggingCondition(p, NumberShowItem, condition, orderBy);
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin("", TypePage.Item,
"", key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
dt = ds.Tables[0];
rp_mn_users.DataSource = dt;
rp_mn_users.DataBind();
}
void GetBookings(string order)
{
string condition = DataExtension.AndConditon(
SubitemsTSql.GetByApp(app),
SubitemsTSql.GetByLang(language),
SubitemsColumns.IsenableColumn + "<>2"
);
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, SubitemsColumns.VstitleColumn, SubitemsColumns.VsemailColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = SubitemsColumns.DscreatedateColumn + " desc ";
}
}
DataSet ds = new DataSet();
ds = Subitems.GetSubItemsPagging(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.Hotel, TypePage.Booking,
ddlCateSearch.SelectedValue, "",
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
//
// GET: /Finance/Billing
public ActionResult Billing(PagingModel pm, CustomSearchModel csm, bool givecsm = false)
{
using (PSPBillingService bservice = new PSPBillingService())
{
if (givecsm)
{
ViewBag.ViewName = "Billing";
return(PartialView("_BillingCustomSearch", new CustomSearchModel("Billing")));
}
List <PSPBillingCustomModel> model = bservice.List1(pm, csm);
int total = (model.Count < pm.Take && pm.Skip == 0) ? model.Count : bservice.Total1(pm, csm);
PagingExtension paging = PagingExtension.Create(model, total, pm.Skip, pm.Take, pm.Page);
return(PartialView("_Billing", paging));
}
}
//
// GET: /Transporter/PODManagement
public ActionResult PODManagement(PagingModel pm, CustomSearchModel csm, bool givecsm = false)
{
if (givecsm)
{
ViewBag.ViewName = "PODManagement";
return(PartialView("_PODManagementCustomSearch", new CustomSearchModel("PODManagement")));
}
using (ClientLoadService service = new ClientLoadService())
{
List <ClientLoadCustomModel> model = service.ListOutstandingShipments(pm, csm);
int total = (model.Count < pm.Take && pm.Skip == 0) ? model.Count : service.Total1(pm, csm);
PagingExtension paging = PagingExtension.Create(model, total, pm.Skip, pm.Take, pm.Page);
return(PartialView("_PODManagement", paging));
}
}
//
// GET: /Transporter/MyNotifications
public ActionResult MyNotifications(PagingModel pm, CustomSearchModel csm, bool givecsm = false)
{
if (givecsm)
{
ViewBag.ViewName = "Notifications";
return(PartialView("_MyNotificationsCustomSearch", new CustomSearchModel("MyNotifications")));
}
using (BroadcastService service = new BroadcastService())
{
csm.IncludeUserBroadCasts = true;
List <BroadcastCustomModel> model = service.List1(pm, csm);
int total = (model.Count < pm.Take && pm.Skip == 0) ? model.Count : service.Total1(pm, csm);
PagingExtension paging = PagingExtension.Create(model, total, pm.Skip, pm.Take, pm.Page);
return(PartialView("_MyNotifications", paging));
}
}
void GetComments()
{
DdlListShowItem.SelectedValue = NumberShowItem;
condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByVskey(app),
SubitemsTSql.GetSubitemsByVslang(language));
orderBy = SubitemsColumns.DscreatedateColumn + " desc ";
DataSet ds = new DataSet();
ds = TatThanhJsc.Database.Subitems.GetSubItemsPagging(p.ToString(), NumberShowItem, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.FileLibrary2, TypePage.Comment,
"", "",
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
private void GetList()
{
condition = LogsTSql.GetLogsByvlType("");
orderby = LogsColumns.dlCreateDateColumn + " desc";
DataSet ds = Logs.GetLogsPagging(p, ni, condition, orderby);
ltrPagging.Text = "<div class='AdminPagging'>" + PagingExtension.SpilitPages(
int.Parse(ds.Tables[1].Rows[0]["TotalRows"].ToString()),
int.Parse(ni), int.Parse(p),
LinkAdmin.UrlAdmin(CodeApplications.Systemwebsite, "logs", "", "", ni),
"currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS") + "</div>";
DataTable dt = new DataTable();
dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ltrList.Text += @"
<div class='item'>
" + dt.Rows[i][LogsColumns.vlDescColumn] + @" - <span><a target='_blank' href='" + dt.Rows[i][LogsColumns.vlUrlColumn] + @"'>" + dt.Rows[i][LogsColumns.vlUrlColumn] + @"</a></span>
</div>";
}
}
void GetList()
{
condition = DataExtension.AndConditon(
ItemsTSql.GetItemsByViapp(app),
ItemsColumns.IienableColumn + "<>2",
ItemsTSql.GetItemsByVilang(language)
);
orderBy = ItemsColumns.IienableColumn + "," + ItemsColumns.DicreatedateColumn + " desc";
DataSet ds = new DataSet();
ds = TatThanhJsc.Database.Items.GetItemsPagging(p, NumberShowItem, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.TrainTicket, TypePage.Cart,
"", "",
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
string GetList()
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.TourModul.CodeApplications.Tour),
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"));
if (diemden.Length > 0)
{
condition += " AND VIAUTHOR = '" + diemden + "' ";
ltrDiemDen.Text = LanguageItemExtension.GetnLanguageItemTitleByName("tới địa điểm ") + "<strong>" + LayDiemDen(diemden) + "</strong>";
}
if (thoigian.Length > 0)
{
condition += " AND VIURL = '" + thoigian + "' ";
ltrThoiGian.Text = LanguageItemExtension.GetnLanguageItemTitleByName("với thời lượng ") + "<strong>" + LayThoiGianTour(thoigian) + "</strong>";
}
string orderby = ItemsColumns.DicreatedateColumn + " desc ";
DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby);
ltrTotalResult.Text = NumberExtension.FormatNumber(ds.Tables[1].Rows[0]["TotalRows"].ToString());
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
DataTable dtPager = ds.Tables[1];
if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0)
{
string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "?go=search&diemden=" + diemden + "&thoigian=" + thoigian, "hientai", "trangkhac", "dau", "cuoi", "truoc", "sau");
if (split.Length > 0)
{
int totalPage = 0;
try
{
double totalrow = double.Parse(dtPager.Rows[0]["TotalRows"].ToString());
totalPage = (int)(totalrow / rows);
if (totalPage < (totalrow / rows))
{
totalPage++;
}
}
catch { }
ltrPagging.Text = split;
}
else
{
if (dt.Rows.Count < 1)
{
ltrPagging.Text = "";
}
else
{
ltrPagging.Text = "";
}
}
}
else
{
ltrPagging.Text = "";
}
if (dt.Rows.Count > 0)
{
string link = "";
string price = "", salePrice = "";
string time = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
price = dt.Rows[i][ItemsColumns.FipriceColumn].ToString() == "0" ? "" : NumberExtension.FormatNumber(dt.Rows[i][ItemsColumns.FipriceColumn].ToString()) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
salePrice = dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString() == "0" ? LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ") : NumberExtension.FormatNumber(dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString()) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
time = LayThoiGianTour(dt.Rows[i][ItemsColumns.ViurlColumn].ToString());
s += @"
<div class='col'>
<div class='item item-post'>
<div class='item-img'>
<a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='imgc'>
" + ImagesExtension.GetImage(TatThanhJsc.TourModul.FolderPic.Tour, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
<div class='item-date'>
<div>
<i class='fa fa-calendar' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Time") + @": " + time + @"</span>
</div>
<div>
<i class='fa fa-plane' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Departure") + @": " + dt.Rows[i][ItemsColumns.VISEOMETAPARAMSColumn] + @"</span>
</div>
</div>
</div>
<div class='item-body'>
<h3>
<a href='" + link + @"' class='title item-title' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h3>
<div class='item-price'>
<span class='real'>" + salePrice + @"</span>
<span class='throught'>" + price + @"</span>
</div>
<a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i>
</a>
</div>
</div>
</div>";
}
}
}
return(s);
}
void GetNew(string order)
{
if (!modul.Equals(""))
{
condition = DataExtension.AndConditon(
"VGAPP = '" + modul + "'",
GroupsTSql.GetGroupsByVglang(language));
}
else
{
condition = DataExtension.AndConditon(
DataExtension.OrConditon(
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.AboutUsModul.CodeApplications.AboutUs),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.AdvertisingModul.CodeApplications.Advertising),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ProductModul.CodeApplications.Product),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.DealModul.CodeApplications.Deal),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.FileLibraryModul.CodeApplications.FileLibrary),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ServiceModul.CodeApplications.Service),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.NewsModul.CodeApplications.News),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.PhotoAlbumModul.CodeApplications.PhotoAlbum),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.VideoModul.CodeApplications.Video),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.QAModul.CodeApplications.QA),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.CustomerReviewsModul.CodeApplications.CustomerReviews)
),
GroupsTSql.GetGroupsByVglang(language));
}
#region Hiển thị bài đã duyệt theo trạng thái phân quyền
string userRole = CookieExtension.GetCookies("RolesUser");
if (HorizaMenuConfig.ShowDuyetTin2)
{
if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole))
{
#region Với tài khoản cấp 2 (trưởng ban biên tập)
condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' ";
#endregion
}
else if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap3, userRole))
{
#region Với tài khoản cấp 3 (tổng biên tập)
condition += " AND IIENABLE = '1' ";
#endregion
}
}
else if (HorizaMenuConfig.ShowDuyetTin1)
{
if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap3, userRole))
{
#region Với tài khoản cấp 3 (tổng biên tập)
condition += " AND IIENABLE = '1' ";
#endregion
}
}
#endregion
if (!title.Equals(""))
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(title, ItemsColumns.VititleColumn);
}
if (!DateFrom.Equals(""))
{
DateTime dFrom = DateTime.ParseExact(DateFrom, "dd/MM/yyyy", null);
condition += " AND DICREATEDATE >= '" + dFrom.ToString("yyyy-MM-dd HH:mm:ss") + "'";
}
if (!DateTo.Equals(""))
{
DateTime dTo = DateTime.ParseExact(DateTo, "dd/MM/yyyy", null).AddDays(1);
condition += " AND DICREATEDATE < '" + dTo.ToString("yyyy-MM-dd HH:mm:ss") + "'";
}
if (!user.Equals(""))
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(user, ItemsColumns.ViUrl);
}
condition += " AND VISEOMETACANONICAL <> '' ";
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
string key = "modul=" + modul + "&user="******"&title=" + title + "&DateFrom=" + DateFrom + "&DateTo=" + DateTo + "&NumberShowItem=" + NumberShowItem;
string linkSearch = UrlExtension.WebisteUrl + "/admin.aspx?uc=DuyetTin&suc=BaiVietDaDuyet&" + key;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
linkSearch, "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
void GetList()
{
#region Condition, orderby
string condition = "";
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
else
{
condition = GroupsTSql.GetGroupsByIgid(igidFirst);
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
if (key.Length > 0)
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(key, ItemsColumns.VititleColumn, ItemsColumns.VikeyColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn));
}
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
#endregion
DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
DataTable dtPager = ds.Tables[1];
#region Lấy ra danh sách bài viết
if (dt.Rows.Count > 0)
{
string link = "";
string price = "", salePrice = "";
string time = "";
int point = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
price = dt.Rows[i][ItemsColumns.FipriceColumn].ToString();
salePrice = dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString();
if (price == "0" || price == "")
{
price = "";
salePrice = LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ");
}
else if (salePrice == "0" || salePrice == "")
{
salePrice = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
price = "";
}
else
{
price = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
salePrice = NumberExtension.FormatNumber(salePrice) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
}
time = LayThoiGianTour(dt.Rows[i][ItemsColumns.ViurlColumn].ToString());
if (i < point)
{
ltrList1.Text += @"
<div class='item item-post item-big'>
<div class='item-img'>
<a href='" + link + @"' class='imgc' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
<div class='item-date'>
<div>
<i class='fa fa-calendar' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Time") + @": " + time + @"</span>
</div>
<div>
<i class='fa fa-plane' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Departure") + @": " + dt.Rows[i][ItemsColumns.VISEOMETAPARAMSColumn] + @"</span>
</div>
</div>
</div>
<div class='item-body'>
<h3>
<a href='" + link + @"' class='title item-title' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h3>
<p class='item-text'>" + dt.Rows[i][ItemsColumns.VidescColumn].ToString() + @"</p>
<div class='item-price'>
<span class='real'>" + salePrice + @"</span>
<span class='throught'>" + price + @"</span>
</div>
<a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i>
</a>
</div>
</div>";
}
else
{
ltrList2.Text += @"
<div class='col'>
<div class='item item-post'>
<div class='item-img'>
<a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
<div class='item-date'>
<div>
<i class='fa fa-calendar' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Time") + @": " + time + @"</span>
</div>
<div>
<i class='fa fa-plane' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Departure") + @": " + dt.Rows[i][ItemsColumns.VISEOMETAPARAMSColumn] + @"</span>
</div>
</div>
</div>
<div class='item-body'>
<h3>
<a href='" + link + @"' class='title item-title' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h3>
<div class='item-price'>
<span class='real'>" + salePrice + @"</span>
<span class='throught'>" + price + @"</span>
</div>
<a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i>
</a>
</div>
</div>
</div>";
}
}
}
#endregion
#region Xuất ra phân trang
if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0)
{
string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "", "hientai", "trangkhac", "dau", "cuoi", "truoc", "sau");
if (split.Length > 0)
{
int totalPage = 0;
try
{
double totalrow = double.Parse(dtPager.Rows[0]["TotalRows"].ToString());
totalPage = (int)(totalrow / rows);
if (totalPage < (totalrow / rows))
{
totalPage++;
}
}
catch { }
ltrPaging.Text +=
PagingExtension02.XuLyPhanTrang(split, dtPager.Rows[0]["TotalRows"].ToString(),
(title != "" ? title : go), LanguageItemExtension.GetnLanguageItemTitleByName("Trang đầu"),
LanguageItemExtension.GetnLanguageItemTitleByName("Trang cuối"),
LanguageItemExtension.GetnLanguageItemTitleByName("Trước"),
LanguageItemExtension.GetnLanguageItemTitleByName("Sau"));
}
else
{
if (dt.Rows.Count < 1)
{
ltrNoResult.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>";
pnInfo.Visible = false;
}
}
}
else
{
ltrNoResult.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>";
pnInfo.Visible = false;
}
#endregion
}
}
void GetNew(string order)
{
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app));
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
GroupsTSql.GetGroupsByVglang(language));
}
#region Hiển thị bài đã duyệt theo trạng thái phân quyền
string userRole = CookieExtension.GetCookies("RolesUser");
condition += " AND VIURL = '" + userId + "' ";
if (HorizaMenuConfig.ShowDuyetTin2)
{
if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap1, userRole))
{
#region Với tài khoản cấp 1 (phóng viên, biên tập viên)
condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap1 + "' ";
#endregion
}
else if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole))
{
#region Với tài khoản cấp 2 (tổng biên tập)
condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' ";
#endregion
}
}
else if (HorizaMenuConfig.ShowDuyetTin1)
{
if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole))
{
#region Với tài khoản cấp 1 (phóng viên, biên tập viên)
condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' ";
#endregion
}
}
#endregion
if (tbKeySearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn);
}
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(app, "QuanLyBaiVietChoPheDuyet",
ddlCateSearch.SelectedValue, key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
void GetFileLibrary(string order)
{
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, "");
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
GroupsTSql.GetGroupsByVglang(language));
}
#region Điều chỉnh bộ lọc với tính năng duyệt tin
if (FileLibraryConfig.KeyDuyetTin)
{
if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2)
{
string userId = CookieExtension.GetCookies("UserId");
condition += " AND IIENABLE = '0' ";
condition += " AND VIURL = '" + userId + "' ";
}
}
else
{
condition += " AND IIENABLE <> '2' ";
}
#endregion
if (tbKeySearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn);
}
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text;
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.FileLibrary, TypePage.Item,
ddlCateSearch.SelectedValue, key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
//Genric Method to GetAll Record as Queryable with Paging
public IQueryable <T> All <T>(int page, int pageSize) where T : class, new()
{
return(PagingExtension.Page(All <T>(), page, pageSize));
}
void GetCustomerReviews(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
if (!igid.Equals(""))
{
ddl_group_ontab.SelectedValue = igid;
conditionItems = GroupsItemsTSql.GetItemsInGroupCondition(ddl_group_ontab.SelectedValue, ItemsTSql.GetItemsByViapp(app));
}
else
{
conditionItems = DataExtension.AndConditon(
"VGAPP = '" + appcate + "'",
GroupsTSql.GetGroupsByVglang(language), ItemsTSql.GetItemsByViapp(app), ItemsTSql.GetItemsByVilang(language));
}
conditionItems = DataExtension.AndConditon(conditionItems, ItemsTSql.GetItemsByViapp(app));
#region Lọc với tính năng duyệt tin
if (CustomerReviewsConfig.KeyDuyetTin)
{
pnStatus.Visible = false;
keyHide = "dn";
string userId = CookieExtension.GetCookies("userId");
if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2)
{
conditionItems += " AND VIURL = '" + userId + "' ";
}
}
#endregion
conditionItems += " AND IIENABLE = '2' ";
if (txt_key.Text.Length > 0 && !txt_key.Text.Equals(strdisplay))
{
SearchCondition = " AND " + SearchTSql.GetSearchMathedCondition(txt_key.Text, ItemsColumns.VititleColumn);
}
if (txt_key.Text.Equals(strdisplay))
{
txt_key.Text = "";
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = " DCREATEDATE DESC ";
}
}
DataSet ds = new DataSet();
ds = GroupsItems.GetAllDataPagging(p, NumberShowItem, conditionItems + SearchCondition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.CustomerReviews, TypePage.RecycleItem,
ddl_group_ontab.SelectedValue, txt_key.Text,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
void GetList()
{
#region Condition, orderby
string condition = "";
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
else
{
condition = GroupsTSql.GetGroupsByVgapp(app);
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
if (key.Length > 0)
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(key, ItemsColumns.VititleColumn, ItemsColumns.VikeyColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn));
}
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
#endregion
DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
DataTable dtPager = ds.Tables[1];
#region Lấy ra danh sách bài viết
if (dt.Rows.Count > 0)
{
string link = "";
string bigPost = "", smallPost = "";
string price = "", salePrice = "";
int point = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
price = dt.Rows[i][ItemsColumns.FipriceColumn].ToString();
salePrice = dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString();
if (price == "0" || price == "")
{
price = "";
salePrice = LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ");
}
else if (salePrice == "0" || salePrice == "")
{
salePrice = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
price = "";
}
else
{
price = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
salePrice = NumberExtension.FormatNumber(salePrice) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
}
if (i < point)
{
bigPost += @"
<div class='blog'>
<div class='item item-row'>
<div class='item-img'>
<a href='" + link + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<h3>
<a href='" + link + @"' class='title item-title fSize-20'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h3>
<div class='item-text'>
" + StringExtension.LayChuoi(dt.Rows[i][ItemsColumns.VicontentColumn].ToString(), "", 1) + @"
</div>
<div class='item-price'>
<span class='real'>" + salePrice + @"</span>
<span class='throught'>" + price + @"</span>
</div>
<a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i>
</a>
</div>
</div>
</div>";
}
else
{
smallPost += @"
<div class='col-12 col-sm-12 col-md-6 col-lg-6 col-xl-3'>
<div class='item item-post'>
<div class='item-img'>
<a href='" + link + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<h3>
<a href='" + link + @"' class='title item-title'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h3>
<div class='item-price'>
<span class='real'>" + salePrice + @"</span>
<span class='throught'>" + price + @"</span>
</div>
<a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i>
</a>
</div>
</div>
</div>";
}
ltrList.Text = @"
<div class='sublist sublist-1'>
<div class='sublist-body'>
<div class='slick-slider' data-slick='{'slidesToShow': 1, 'slidesToScroll': 1, 'autoplay': true, 'dots': false, 'arrows':true}'>
" + bigPost + @"
</div>
</div>
</div>
<div class='sublist sublist-2'>
<div class='sublist-body'>
<div class='row'>
" + smallPost + @"
</div>
</div>
</div>";
}
}
#endregion
#region Xuất ra phân trang
if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0)
{
string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "", "hientai", "trangkhac", "dau", "cuoi", "truoc", "sau");
if (split.Length > 0)
{
int totalPage = 0;
try
{
double totalrow = double.Parse(dtPager.Rows[0]["TotalRows"].ToString());
totalPage = (int)(totalrow / rows);
if (totalPage < (totalrow / rows))
{
totalPage++;
}
}
catch { }
ltrPaging.Text +=
PagingExtension02.XuLyPhanTrang(split, dtPager.Rows[0]["TotalRows"].ToString(),
(title != "" ? title : go), LanguageItemExtension.GetnLanguageItemTitleByName("Đầu"),
LanguageItemExtension.GetnLanguageItemTitleByName("Cuối"),
LanguageItemExtension.GetnLanguageItemTitleByName("Trước"),
LanguageItemExtension.GetnLanguageItemTitleByName("Sau"));
}
else
{
if (dt.Rows.Count < 1)
{
ltrList.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>";
}
}
}
else
{
ltrList.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>";
}
#endregion
}
}
