protected string LinkUpdate(string iid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminOther(CodeApplications.other, CodeApplications.SupportOnline, TypePage.UpdateItem, "", iid, NumberShowItem, p, ""));
}
else
{
return(LinkAdmin.GoAdminOther(CodeApplications.other, CodeApplications.SupportOnline, TypePage.UpdateItem, "", iid, "", "", ""));
}
}
protected string LinkUpdate(string isid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminItem(CodeApplications.Tour, "UpdateComment", isid, NumberShowItem, p));
}
else
{
return(LinkAdmin.GoAdminItem(CodeApplications.Tour, "UpdateComment", isid));
}
}
private string LinkUpdateCate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(typeModul, typePageUpdate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(typeModul, typePageUpdate, igid, igparentid));
}
}
protected string LinkUpdate(string iid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminItem(app, TypePage.UpdateItem, iid, NumberShowItem, p));
}
else
{
return(LinkAdmin.GoAdminItem(app, TypePage.UpdateItem, iid));
}
}
protected string LinkUpdate(string iid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminItem(CodeApplications.Destination, TypePage.UpdateItem, iid, NumberShowItem, p) + "&app=" + app);
}
else
{
return(LinkAdmin.GoAdminItem(CodeApplications.Destination, TypePage.UpdateItem, iid) + "&app=" + app);
}
}
private string LinkUpdateCreate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Hotel, TypePage.UpdateFacilityRoom, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Hotel, TypePage.UpdateFacilityRoom, igid, igparentid));
}
}
private string LinkUpdateCate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(typePage, TypePage.UpdateProperty, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(typePage, TypePage.UpdateProperty, igid, igparentid));
}
}
private string LinkUpdateCate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory("other&uco=" + app, TypePage.UpdateCate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory("other&uco=" + app, TypePage.UpdateCate, igid, igparentid));
}
}
private string LinkUpdateCreate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Cruises, TypePage.UpdateProperty, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Cruises, TypePage.UpdateProperty, igid, igparentid));
}
}
protected string LinkUpdate(string iid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminItem(CodeApplications.Contact, TypePage.UpdateItem, iid, NumberShowItem, p));
}
else
{
return(LinkAdmin.GoAdminItem(CodeApplications.Contact, TypePage.UpdateItem, iid));
}
}
private string LinkUpdateFilter(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.TrainTicket, typePageUpdate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.TrainTicket, typePageUpdate, igid, igparentid));
}
}
protected string LinkUpdate(string iid)
{
if (!NumberShowItem.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminItem(app, "QuanLyDonDatDichVu", iid, NumberShowItem, p));
}
else
{
return(LinkAdmin.GoAdminItem(app, "QuanLyDonDatDichVu", iid));
}
}
private string LinkUpdateColor(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Deal, typePageUpdate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Deal, typePageUpdate, igid, igparentid));
}
}
protected string LinkCreate()
{
string igidUpdate = "";
if (!ddlCateSearch.SelectedValue.Equals(""))
{
igidUpdate = ddlCateSearch.SelectedValue;
}
return(LinkAdmin.GoAdminOther(CodeApplications.other, CodeApplications.SupportOnline, TypePage.CreateItem,
igidUpdate, "", "", "", ""));
}
private string LinkUpdateProperty(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Product, typePageUpdate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Product, typePageUpdate, igid, igparentid));
}
}
private string LinkUpdateCate(string igid, string igparentid)
{
if (igparentid.Equals(""))
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Website, TypePage.UpdateCate, igid));
}
else
{
return(LinkAdmin.GoAdminCategory(CodeApplications.Website, TypePage.UpdateCate, igid, igparentid));
}
}
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 (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 = "&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 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();
}
private string LinkRedrect()
{
if (!ni.Equals("") && !p.Equals(""))
{
return(LinkAdmin.GoAdminOther(CodeApplications.other, CodeApplications.SupportOnline, TypePage.Item, ddl_group_product.SelectedValue, "", ni, p, ""));
}
else
{
return(LinkAdmin.GoAdminOther(CodeApplications.other, CodeApplications.SupportOnline, TypePage.Item,
ddl_group_product.SelectedValue, "", "", "", ""));
}
}
void GetNews(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
condition = DataExtension.AndConditon(
"VIAPP = 'QLDDDV'",
ItemsTSql.GetByLang(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.Service, "QuanLyDonDatDichVu",
"", key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
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();
}
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string c = e.CommandName.Trim();
string p = e.CommandArgument.ToString().Trim();
fields = "*";
DataTable dt = new DataTable();
dt = Members.GetMembersCondition("", MembersColumns.ImemberisapprovedColumn, MembersTSql.GetMembersByImid(p), "");
switch (c)
{
#region Delete
case "delete":
Members.DeleteMembersByIMID(p);
GetCategories("");
break;
#endregion
#region Edit Status
case "EditStatus":
string[] fieldsEditStatus = { "iMemberIsLockedOut" };
string[] valuesEditStatus = { "" };
if (dt.Rows[0]["iMemberIsLockedOut"].ToString().Equals("0"))
{
valuesEditStatus[0] = "1";
Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition);
}
else
{
valuesEditStatus[0] = "0";
Members.UpdateMembersCondition(DataExtension.UpdateTransfer(fieldsEditStatus, valuesEditStatus), condition);
}
GetCategories("");
break;
#endregion
#region edit
case "editPassword":
Response.Redirect(LinkAdmin.GoAdminItem(CodeApplications.Member, TypePage.UpdateItem, p));
break;
#endregion
}
}
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();
}
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();
}
private string LinkRedrect()
{
return(LinkAdmin.GoAdminSubModul(CodeApplications.CustomerReviews, TypePage.Cate, ddlParentCate.SelectedValue));
}
protected void lnk_create_account_Click(object sender, EventArgs e)
{
Response.Redirect(LinkAdmin.GoAdminSubModul(CodeApplications.Language, "CreateLanguageKey"));
}
private string LinkRedrect()
{
return(LinkAdmin.GoAdminSubModul(CodeApplications.FileLibrary, TypePage.Cate, DdlGroupFileLibrary.SelectedValue));
}
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();
}