protected void btn_add_Click(object sender, EventArgs e)
{
//DataTable datatable = CateNewsGroupID();
//try
//{
// CateNewsGroupPermissionBSO catenewPermissionBSO = new CateNewsGroupPermissionBSO();
// DataTable table1 = catenewPermissionBSO.GetCateNewsGroupPermissionByRoles(Convert.ToInt32(hddRoles.Value), Language.language);
// if (table1.Rows.Count > 0)
// catenewPermissionBSO.DeleteCateNewsGroupPermissionRoles(Convert.ToInt32(hddRoles.Value), Language.language);
// CateNewsGroupPermission _cateNewsGroupPermission = new CateNewsGroupPermission();
// if (datatable.Rows.Count > 0)
// {
// foreach (DataRow subrow in datatable.Rows)
// {
// _cateNewsGroupPermission.CateNewsGroupID = Convert.ToInt32(subrow["CateNewsGroupID"].ToString());
// _cateNewsGroupPermission.RolesID = Convert.ToInt32(hddRoles.Value);
// _cateNewsGroupPermission.Permission = "";
// _cateNewsGroupPermission.UserName = Session["Admin_UserName"].ToString();
// _cateNewsGroupPermission.Created = DateTime.Now;
// _cateNewsGroupPermission.Language = Language.language;
// catenewPermissionBSO.CreateCateNewsGroupPermission(_cateNewsGroupPermission);
// error.Text = "<div class='alert alert-sm alert-success bg-gradient'>Cập nhật thành công !</div>";
// //// initControl(_cateNewsGroupPermission.RolesID);
// }
// }
//}
//catch (Exception ex)
//{
// error.Text = ex.Message.ToString();
//}
commonBSO commonBSO = new commonBSO();
commonBSO.CreateDataView("DELETE FROM tblRoleCate WHERE GroupId=" + hddRoles.Value);
foreach (ListItem item in chklist.Items)
{
if (item.Selected && item.Text.Contains("---"))
{
RoleCate roleCate = new RoleCate();
roleCate.CateId = Convert.ToInt32(item.Value);
roleCate.GroupId = Convert.ToInt32(hddRoles.Value);
new RoleCateService().Insert(roleCate);
}
}
error.Text = "<div class='alert alert-sm alert-success bg-gradient'>Cập nhật thành công !</div>";
}
private void ViewCateAll()
{
CateNewsGroupBSO catenewsGroupBSO = new CateNewsGroupBSO();
DataTable dtGroupCate = catenewsGroupBSO.GetCateNewsGroupAll(Language.language, Session["Admin_UserName"].ToString());
commonBSO commonBSO = new commonBSO();
DataTable dtRole = commonBSO.CreateDataView("SELECT * FROM tblRoleCate WHERE GroupId=" + hddRoles.Value);//Lay danh danh chuyen muc nhom quyen dc truy cap
CateNewsBSO catenewsBSO = new CateNewsBSO();
for (int i = 0; i < dtGroupCate.Rows.Count; i++)
{
ListItem item = new ListItem(dtGroupCate.Rows[i]["CateNewsGroupName"].ToString(), dtGroupCate.Rows[i]["CateNewsGroupID"].ToString());
chklist.Items.Add(item);
DataTable dtCateAll = commonBSO.CreateDataView("SELECT * FROM tblCateNews WHERE GroupCate=" + dtGroupCate.Rows[i]["GroupCate"]);
if (dtCateAll != null && dtCateAll.Rows.Count > 0)
{
BindCate(0, dtCateAll, dtRole, 1);
}
//commonBSO.FillToCheckBoxList(chklist, table, "CateNewsGroupName", "CateNewsGroupID");
}
}
protected void btn_search_Click(object sender, EventArgs e)
{
int cId = Convert.ToInt32(ddlRoles.SelectedValue);
DataTable dataTable = new DataTable();
commonBSO commonBSO = new commonBSO();
string SQL = "";
SQL = "SELECT * FROM tblAdmin as a INNER JOIN tblAdminRoles as b ON a.Admin_Username = b.Admin_UserName Where a.Admin_Username not in ('administrator','Administrator')";
if (txtKeyword.Text != "")
{
SQL += " and a.Admin_Username like '%' + '" + Tool.safeString(txtKeyword.Text) + "' + '%'";
}
if (cId != 0)
{
SQL += " and b.RolesID=" + cId;
}
SQL += " Order by a.Admin_Username ASC";
dataTable = commonBSO.CreateDataView(SQL);
commonBSO.FillToGridView(grvAdmin, dataTable);
}
private string BindMenu(string strMenuSub, int iCate)
{
if (Session["Admin_Username"] != null)
{
DataTable table = new DataTable();
commonBSO common = new commonBSO();
String SQL = "";
string AdminName = Session["Admin_Username"].ToString();
AdminRolesBSO adminRolesBSO = new AdminRolesBSO();
string strRoles = adminRolesBSO.GetRoles(AdminName);
RolesBSO rolesBSO = new RolesBSO();
DataTable table1 = rolesBSO.GetRolesbyStrRolesID(strRoles);
string strModules = "";
if (table1.Rows.Count > 0)
{
foreach (DataRow row in table1.Rows)
{
strModules += row["Roles_Modules"].ToString();
}
strModules = strModules.Remove(strModules.LastIndexOf(",")).Replace(",", "','");
}
if (AdminName.Equals("administrator"))
{
SQL = "SELECT * FROM tblModules Where [IsMenu] =1 And [Modules_Parent] = " + iCate + " Order by [Modules_Order] ASC";
table = common.CreateDataView(SQL);
}
else
{
SQL = "SELECT * FROM tblModules Where [IsMenu] =1 And [Modules_Parent] = " + iCate + " And Slug in ('" + strModules + "') Order by [Modules_Order] ASC";
table = common.CreateDataView(SQL);
}
//strMenuSub += "<ul>";
//strMenuSub += "<li class='sidebar-label pt20'><a href='" + ResolveUrl("~/") + "Admin/home/Default.aspx'>Trang chủ</a></li>";
if (table.Rows.Count > 0)
{
foreach (DataRow dataRow in table.Rows)
{
strMenuSub += "<li class='sidebar-label pt20'>";
//strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Modules_Url"] + "/Default.aspx'>" + dataRow["Modules_Name"].ToString() + "</a>";
//if (checkActive(Request["dll"].ToString(), dataRow["Slug"].ToString()))
//{
//strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>" + dataRow["Modules_Name"].ToString() + "</a>";
strMenuSub += dataRow["Modules_Name"].ToString();
//strMenuSub += "<span class='closed opened'></span>";
//strMenuSub += "<div style='display: block;'>";
//}
//else
//{
// strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>" + dataRow["Modules_Name"].ToString() + "</a>";
// //strMenuSub += "<span class='closed'></span>";
// //strMenuSub += "<div style='display: none;'>";
//}
strMenuSub += "</li>";
strMenuSub += GetSubMenu("", Convert.ToInt32(dataRow["Modules_ID"].ToString()), Session["Admin_Username"].ToString(), strModules);
//strMenuSub += "</div>";
}
}
//strMenuSub += "</ul>";
}
else
{
Response.Redirect("~/Default.aspx");
}
return(strMenuSub);
}
private string GetSubMenu2(string strMenuSub, int iCate, string AdminName, string strModules)
{
DataTable datatable = new DataTable();
commonBSO common = new commonBSO();
String SQL = "";
string strMenu = "";
if (AdminName.Equals("administrator"))
{
SQL = "SELECT * FROM tblModules Where [IsMenu] =1 And [Modules_Parent] = " + iCate + " Order by [Modules_Order] ASC";
datatable = common.CreateDataView(SQL);
}
else
{
SQL = "SELECT * FROM tblModules Where [IsMenu] =1 And [Modules_Parent] = " + iCate + " And Slug in ('" + strModules + "') Order by [Modules_Order] ASC";
datatable = common.CreateDataView(SQL);
}
if (datatable.Rows.Count > 0)
{
strMenuSub += "<ul class='nav sub-nav'>";
foreach (DataRow dataRow in datatable.Rows)
{
if (checkActive(Request["dll"].ToString(), dataRow["Slug"].ToString()))
{
strMenuSub += "<li class='active'>";
}
else
{
strMenuSub += "<li>";
}
strMenu = GetSubMenu2("", Convert.ToInt32(dataRow["Modules_ID"].ToString()), AdminName, strModules);
if (strMenu != "")
{
strMenuSub += "<a class='accordion-toggle' href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>";
strMenuSub += "<span class='glyphicons glyphicons-globe'></span>";
strMenuSub += dataRow["Modules_Name"].ToString();
strMenuSub += "<span class='caret'></span>";
strMenuSub += "</a>";
strMenuSub += GetSubMenu2("", Convert.ToInt32(dataRow["Modules_ID"].ToString()), AdminName, strModules);
}
else
{
//strMenuSub += "<span class='closed opened'></span>";
strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>";
strMenuSub += dataRow["Modules_Name"].ToString();
strMenuSub += "</a>";
//strMenuSub += "<span class='caret'></span>";
//strMenuSub += "<div style='display: block;'>";
}
//}
//else
//{
// //strMenuSub += "<span class='closed opened'></span>";
// strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>";
// strMenuSub += dataRow["Modules_Name"].ToString();
// //strMenuSub += "<span class='caret'></span>";
// strMenuSub += "</a>";
// //strMenuSub += "<div style='display: block;'>";
//}
//strMenuSub += "<span class='closed'></span>";
//strMenuSub += "<a href='" + ResolveUrl("~/") + "Admin/" + dataRow["Slug"] + "/Default.aspx'>" + dataRow["Modules_Name"].ToString() + "</a>";
//strMenuSub += "<div style='display: none;'>";
//strMenuSub += GetSubMenu2("", Convert.ToInt32(dataRow["Modules_ID"].ToString()), AdminName, strModules);
//strMenuSub += "</div>";
strMenuSub += "</li>";
}
strMenuSub += "</ul>";
}
return(strMenuSub);
}
private void ViewNewsGroupDetail(int Id)
{
CateNewsGroupBSO cateNewsgroupBSO = new CateNewsGroupBSO();
NewsGroupBSO newsgroupBSO = new NewsGroupBSO();
NewsGroup newsgroup = newsgroupBSO.GetNewsGroupById(Id);
if (newsgroup == null)
{
Response.Redirect("~/Default.aspx");
}
commonBSO commonBSO = new commonBSO();
//Kiem tra neu phan quyen truy cap chuyen muc nay
DataTable dtCheckRole = commonBSO.CreateDataView("SELECT Id FROM tblRoleCate WHERE CateId=" + newsgroup.CateNewsID);
if (dtCheckRole != null && dtCheckRole.Rows.Count > 0)
{
UserValidation m_UserValidation = new UserValidation();
if (m_UserValidation.IsSigned())
{
DataTable dtGroupRole = new AdminRolesBSO().GetAdminRolesByUserName(m_UserValidation.UserName);
if (dtGroupRole != null && dtGroupRole.Rows.Count > 0)
{
DataTable dtRoleCate = commonBSO.CreateDataView("SELECT Id FROM tblRoleCate WHERE GroupId IN (SELECT RolesID FROM tblAdminRoles WHERE Admin_UserName = '******') AND CateId=" + newsgroup.CateNewsID);
if (dtRoleCate != null && dtRoleCate.Rows.Count > 0)
{
//Da dang nhap va co quyen xem
}
else
{
//Da dang nhap nhung khong co quyen truy cap, chuyen ve trang thong bao;
content_notice.Visible = true;
content_news.Visible = false;
}
}
}
else
{
//Yeu cau dang nhap
Response.Redirect(ResolveUrl("~") + "Dang-nhap.aspx?RetUrl=" + Request.RawUrl);
}
}
ltlTitle.Text = newsgroup.Title;
//LabelDate.Text = newsgroup.PostDate.ToString("dd/MM/yyyy");// Convert.ToString(newsgroup.PostDate);
ltlDescribe.Text = newsgroup.ShortDescribe;
FullDescirbe.Text = newsgroup.FullDescribe;
LabelAuthor.Text = newsgroup.Author;
lblAproved.Text = newsgroup.PostDate.ToString("dd/MM/yyyy hh:mm");
txtNewsGroupID.Value = Convert.ToString(newsgroup.NewsGroupID);
newsgroupBSO.NewsGroupClickUpdate(Id);
NewsGroupFollow(newsgroup.PostDate, newsgroup.NewsGroupID, newsgroup.CateNewsID);
NewsGroupRelation(newsgroup.NewsGroupID);
;
//CateNewsBSO catenewsBSO = new CateNewsBSO();
//CateNews catenews = catenewsBSO.GetCateNewsById(newsgroup.CateNewsID);
//CateNewsGroup cateNewsGroup = cateNewsgroupBSO.GetCateNewsGroupByGroupCate(catenews.GroupCate, Language.language);
//title_name.Text = "<a href='" + ResolveUrl("~/") + "c3/" + catenewsBSO.GetSlugByCateId(catenews.CateNewsID) + "/" + GetString(catenews.CateNewsName) + "-" + catenews.GroupCate + "-" + catenews.CateNewsID + ".aspx'>" + catenews.CateNewsName + "</a>";
//string cate = "<a href='" + ResolveUrl("~/") + "c2/" + cateNewsgroupBSO.GetSlugById(cateNewsGroup.CateNewsGroupID) + "/" + GetString(cateNewsGroup.CateNewsGroupName) + "-" + catenews.GroupCate + ".aspx' class='content_Text_Cat'>";
//string s1 = "";
//while (catenews.ParentNewsID != 0)
//{
// int pId = catenews.ParentNewsID;
// catenews = catenewsBSO.GetCateNewsById(pId);
// s1 = "<img src='" + ResolveUrl("~/") + "images/icon_arrows1.png'><a href='" + ResolveUrl("~/") + "c3/" + catenewsBSO.GetSlugByCateId(catenews.CateNewsID) + "/" + GetString(catenews.CateNewsName) + "-" + catenews.GroupCate + "-" + catenews.CateNewsID + ".aspx' class='content_Text_Cat'>" + catenews.CateNewsName + "</a>" + s1;
//}
//cate += cateNewsGroup.CateNewsGroupName.ToString(); //Sửa lại
//cate += "</a>";
//cate += s1;
//title_cate.Text = "<a href='" + ResolveUrl("~/") + "Default.aspx' class='content_Text_Cat'>" + Resources.resource.T_home + "</a><img src='" + ResolveUrl("~/") + "images/icon_arrows1.png'> ";
//title_cate.Text += cate;
if (!String.IsNullOrEmpty(Request["error"]))
{
error.Text = "<div class='error_register_text'>" + Resources.resource.T_Comment_Error1 + "</div>";
}
if (!newsgroup.IsComment)
{
btnComment.Visible = false;
CommentPanel.Visible = false;
}
else
{
btnComment.Visible = true;
CommentPanel.Visible = true;
GetNewsCommentById(Id);
}
//ViewRegister(Id);
ltlFb_like.Text = "<div class='fb-like' data-href='" + Variables.sDomain + "/d4/news/" + GetString(newsgroup.Title) + "-" + newsgroup.GroupCate + "-" + newsgroup.NewsGroupID + ".aspx' data-send='true' data-width='100%' data-height='65' data-show-faces='true'></div>";
ltlFb_comment.Text = "<div class='fb-comments' data-href='" + Variables.sDomain + "/d4/news/" + GetString(newsgroup.Title) + "-" + newsgroup.GroupCate + "-" + newsgroup.NewsGroupID + ".aspx' data-num-posts='10' data-width='100%'></div>";
Page.Title = newsgroup.Title;
HtmlMeta _desrip = new HtmlMeta();
_desrip.Name = "description";
_desrip.Content = Tool.StripTagsCharArray(newsgroup.ShortDescribe) + " , " + newsgroup.Title + " , " + (newsgroup.Tags) + " , " + newsgroup.Keyword;
Page.Header.Controls.Add(_desrip);
System.Web.UI.HtmlControls.HtmlMeta _keyWords = new HtmlMeta();
_keyWords.Name = "keywords";
_keyWords.Content = GetString(newsgroup.Keyword) + " ; " + newsgroup.Title;
Page.Header.Controls.Add(_keyWords);
}
