private bool SaveData() { objClsCommon = new clsCommon(); if (objClsCommon.IsRecordExists("tblMenuType", tblMenuType.ColumnNames.AppMenuTypeName, tblMenuType.ColumnNames.AppMenuTypeId, txtMenuTypeName.Text, hdnPKID.Value)) { DInfo.ShowMessage("MenuType Name already exists.", Enums.MessageType.Error); return(false); } objClsCommon = null; objMenuType = new tblMenuType(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objMenuType.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objMenuType.AddNew(); objMenuType.AppCreatedDate = System.DateTime.Now; objMenuType.AppCreatedBy = Convert.ToInt32(Session[appFunctions.Session.UserID.ToString()]); } objMenuType.AppMenuTypeName = txtMenuTypeName.Text; objMenuType.s_AppNoOfLevel = txtNoLevel.Text; objMenuType.AppIsActive = ChkIsActive.Checked; objMenuType.s_AppBlockId = ddlBlock.SelectedValue; objMenuType.Save(); iMenuTypeid = objMenuType.AppMenuTypeId; objMenuType = null; objClsCommon = null; return(true); }
protected void ddlMenuType_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMenuType.SelectedIndex != 0) { DataTable dt = new DataTable(); DataRow dr; tblMenuItem objSetMenuItem = new tblMenuItem(); objMenuType = new tblMenuType(); objMenuType.Where.AppMenuTypeId.Value = ddlMenuType.SelectedValue; objMenuType.Query.AddResultColumn(tblMenuType.ColumnNames.AppNoOfLevel); objMenuType.Query.Load(); dt = objSetMenuItem.getMenuItem(Convert.ToInt32(ddlMenuType.SelectedValue), Convert.ToInt32(objMenuType.AppNoOfLevel)); dr = dt.NewRow(); dr["appMenuItemId"] = 0; dr["appMenuItem"] = "-- Select Parent --"; dt.Rows.InsertAt(dr, 0); ddlParent.DataSource = dt; ddlParent.DataValueField = tblMenuItem.ColumnNames.AppMenuItemId; ddlParent.DataTextField = tblMenuItem.ColumnNames.AppMenuItem; ddlParent.DataBind(); objMenuType = null; objSetMenuItem = null; } }
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { hdnPKID.Value = e.CommandArgument.ToString(); if (e.CommandName == "IsActive") { objMenuType = new tblMenuType(); if (objMenuType.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { if (objMenuType.AppIsActive == true) { objMenuType.AppIsActive = false; } else if (objMenuType.AppIsActive == false) { objMenuType.AppIsActive = true; } } objMenuType.Save(); } objMenuType = null; LoadDataGrid(false, false, "", ""); } }
private bool Delete(int intPKID) { bool retval = false; objMenuType = new tblMenuType(); if (objMenuType.LoadByPrimaryKey(intPKID)) { objMenuType.MarkAsDeleted(); objMenuType.Save(); } retval = true; objMenuType = null; return(retval); }
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "") { objMenuType = new tblMenuType(); objDataTable = objMenuType.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim()); //'Reset PageIndex of gridviews if (IsResetPageIndex) { if (dgvGridView.PageCount > 0) { dgvGridView.PageIndex = 0; } } dgvGridView.DataSource = null; dgvGridView.DataBind(); lblCount.Text = 0.ToString(); hdnSelectedIDs.Value = ""; //'Check for data into datatable if (objDataTable.Rows.Count <= 0) { DInfo.ShowMessage("No data found", Enums.MessageType.Information); return; } else { if (ddlPerPage.SelectedItem.Text.ToLower() == "all") { dgvGridView.AllowPaging = false; } else { dgvGridView.AllowPaging = true; dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text); } lblCount.Text = objDataTable.Rows.Count.ToString(); objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort); dgvGridView.DataSource = objDataTable; dgvGridView.DataBind(); } objMenuType = null; }
protected void btnDelete_Click(object sender, System.EventArgs e) { string[] arIDs = hdnSelectedIDs.Value.ToString().TrimEnd(',').Split(','); bool IsDelete = false; bool IsAnyRecordPresent = false; tblMenuItem objMenuItem = new tblMenuItem(); for (int i = 0; i <= arIDs.Length - 1; i++) { objMenuType = new tblMenuType(); if (!string.IsNullOrEmpty(arIDs.GetValue(i).ToString())) { if (objMenuType.GetChildCount(Convert.ToInt32(arIDs.GetValue(i))) > 0) { IsAnyRecordPresent = true; } else { if (Delete(Convert.ToInt32(arIDs.GetValue(i)))) { IsDelete = true; } } objMenuItem.Where.WhereClauseReset(); } objMenuType = null; } if (IsAnyRecordPresent) { LoadDataGrid(false, false); DInfo.ShowMessage("Some Items Cannot Be Deleted As Dependencies exist", Enums.MessageType.Error); } else if (IsDelete) { LoadDataGrid(false, false); DInfo.ShowMessage("MenuType has been deleted successfully", Enums.MessageType.Successfull); } hdnSelectedIDs.Value = ""; }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objMenuType = new tblMenuType(); if (objMenuType.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { txtMenuTypeName.Text = objMenuType.AppMenuTypeName; ddlBlock.SelectedValue = objMenuType.s_AppBlockId; if (objMenuType.AppIsActive) { ChkIsActive.Checked = true; } else { ChkIsActive.Checked = false; } txtNoLevel.Text = objMenuType.s_AppNoOfLevel; } objMenuType = null; } }
public void GenerateAlias(int intId) { DataTable dt; tblMenuType objMenuType = new tblMenuType(); objMenuItem = new tblMenuItem(); objEncrypt = new clsEncryption(); dt = objMenuItem.GetSiteMap(intId); strSiteMap = dt.Rows[0][0].ToString().Trim('/'); if (hdnMenuTypeId.Value == "") { dt = objMenuItem.GetMenuType(intId, false); } else { dt = objMenuItem.GetMenuType(Convert.ToInt32(hdnMenuTypeId.Value), true); } string[] SplitSiteMapString = strSiteMap.Split('/'); objMenuType.Where.AppMenuTypeId.Value = ddlMenuType.SelectedValue; objMenuType.Query.Load(); strSiteMap = "<a href='MasterMenus.aspx'>Menu Items</a>"; if (objMenuType.RowCount > 0) { strSiteMap += " > <a href=MenuItems.aspx?Id=" + objEncrypt.Encrypt(dt.Rows[0]["appMenuTypeId"].ToString(), appFunctions.strKey) + "&type=mtype>" + dt.Rows[0]["appMenuTypeName"].ToString() + "</a>"; } if (objMenuType.AppNoOfLevel > SplitSiteMapString.Length - 1) { for (int i = 0; i <= SplitSiteMapString.Length - 1; i++) { string[] SplittedItems = SplitSiteMapString[i].Split(','); aliasPrefix += SplittedItems[0] + "/"; if (i == SplitSiteMapString.Length - 1) { strSiteMap += " > " + SplittedItems[0]; } else { strSiteMap += "> <a href='MenuItems.aspx?Id=" + objEncrypt.Encrypt(SplittedItems[1].ToString(), appFunctions.strKey) + "'>" + SplittedItems[0].ToString() + "</a>"; } } siteMapLiteral.Text = strSiteMap.ToString(); if (aliasPrefix.Length > 0) { aliasPrefix = aliasPrefix.Substring(0, aliasPrefix.Length - 1); aliasPrefix = aliasPrefix.Substring(0, aliasPrefix.LastIndexOf("/") + 1); } hdnAliasPrefix.Value = aliasPrefix.Replace(" ", "-"); } else { Session[appFunctions.Session.ShowMessage.ToString()] = "You Can't Add Menu Item For This Level As Maximum No. Of Level Is " + objMenuType.AppNoOfLevel.ToString(); Session[appFunctions.Session.ShowMessageType.ToString()] = Enums.MessageType.Error; if (Request.QueryString.Get("PID") != null) { Response.Redirect("MenuItems.aspx?Id=" + Request.QueryString.Get("PID"), true); } else if (Request.QueryString.Get("TID") != null) { Response.Redirect("MenuItems.aspx?Id=" + Request.QueryString.Get("TID") + "&type=mtype", true); } else if (hdnPKID.Value == "") { Response.Redirect("Dashboard.aspx"); } } objMenuItem = null; objMenuType = null; }
public void SetMenu() { tblPermission objPermisssion = new tblPermission(); //Change for manu and sub menu load DataTable DtTab = new DataTable(); objRole = new tblRole(); DtTab = objRole.LoadPermissionTabMenu(Session[appFunctions.Session.RoleID.ToString()].ToString(), 0.ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); for (int i = 0; i <= DtTab.Rows.Count - 1; i++) { if ((bool)DtTab.Rows[i]["AppIsMenu"]) { menuString += "<li><a href='#'>" + DtTab.Rows[i]["AppTabName"]; objMenuType = new tblMenuType(); DataTable menutypeDt = new DataTable(); menutypeDt = objMenuType.LoadMenuTypes(); menuString += "</a> "; //loadmenuChild(menutypeDt, 2, "0", true); menuString += "<ul>"; for (int j = 0; j <= menutypeDt.Rows.Count - 1; j++) { menuString += "<li><a href='MenuItems.aspx?ID=" + objEncrypt.Encrypt(menutypeDt.Rows[j]["appMenuTypeId"].ToString(), appFunctions.strKey) + "&type=mtype'>" + menutypeDt.Rows[j]["appMenuTypeName"].ToString(); menuString += "</a>"; menuString += "</li>"; } menuString += "</ul>"; menuString += "</li>"; } else { DataTable DtChildTab = new DataTable(); objRole = new tblRole(); DtChildTab = objRole.LoadPermissionTabMenu(Session[appFunctions.Session.RoleID.ToString()].ToString(), DtTab.Rows[i]["AppTabID"].ToString(), "", (bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]); menuString += "<li><a href='" + DtTab.Rows[i]["appWebPageName"] + "'>" + DtTab.Rows[i]["AppTabName"]; menuString += "</a> "; loadchildmenu(DtChildTab, 2); //if ((bool)DtTab.Rows[i]["AppIsMenu"] == true) //{ // loadchildmenu(DtTab.Rows(i)("AppTabID").ToString, DtTab.Rows(i)("AppIsMenu"), DtTab.Rows(i)("AppIsTabAdd"), DtTab.Rows(i)("AppIsTabEdit")); //} //else //{ // menuString += "<li><a class='menuLink' id='" + DtTab.Rows(i)("AppTabID").ToString + "' href='" + DtTab.Rows(i)("appWebPageName") + "'>" + DtTab.Rows(i)("AppTabName") + "</a>"; // loadchildmenu(DtTab.Rows(i)("AppTabID").ToString, DtTab.Rows(i)("AppIsMenu"), DtTab.Rows(i)("AppIsTabAdd"), DtTab.Rows(i)("AppIsTabEdit")); //} menuString += "</li>"; } } litMainMenu.Text = menuString; }
public void SetUpBlocks() { tblBlock objBlock = new tblBlock(); StringBuilder blockContent = new StringBuilder(); objBlockDt = objBlock.GetBlockByControlId(); if (Cache["SiteName"] == null) { tblSettings objSettings = new tblSettings(); objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteName); objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteTagLine); objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteFavicon); objSettings.LoadAll(); if (objSettings.RowCount > 0) { Cache["SiteName"] = objSettings.AppSiteName; } } for (int i = 0; i <= objBlockDt.Rows.Count - 1; i++) { blockContent = new StringBuilder(); DataRow dr = objBlockDt.Rows[i]; if (dr["appMenuTypeId"].ToString() != DBNull.Value.ToString() & (bool)dr["appIsShowContent"] == false) { objMenuItem = new tblMenuItem(); objMenuDt = new DataTable(); objMenuDt = objMenuItem.GetChildMenus((int)dr["appMenuTypeId"]); if (string.Compare(dr["appControlId"].ToString(), "divTopMenu") == 0) { blockContent.Append(" <div style=\"background-color: #ED258F;\">"); blockContent.Append(" <div class=\"wrap\">"); blockContent.Append(" <div class=\"menu\">"); blockContent.Append("<ul class=\"megamenu skyblue\">"); LoadTopMenu(ref blockContent, 0); blockContent.Append("</ul></div></div></div>"); } else if (string.Compare(dr["appControlId"].ToString(), "divFooterBlock1") == 0) { objMenuType = new tblMenuType(); if (objMenuType.LoadByPrimaryKey((int)dr["appMenuTypeId"])) { LoadFooterMenu(ref blockContent, 0, objMenuType.AppMenuTypeName); } objMenuType = null; } else if (string.Compare(dr["appControlId"].ToString(), "divFooterBlock2") == 0) { objMenuType = new tblMenuType(); if (objMenuType.LoadByPrimaryKey((int)dr["appMenuTypeId"])) { LoadCategory(ref blockContent); } objMenuType = null; } else if (string.Compare(dr["appControlId"].ToString(), "divCategoryFooter") == 0) { LoadCategoryFooter(ref blockContent); } else if (dr["appMenuTypeId"].ToString() != DBNull.Value.ToString()) { blockContent.Append("<ul>"); SetUpMenu(ref blockContent, 0); blockContent.Append("</ul>"); } } else if ((bool)dr["appIsShowContent"] == true) { blockContent.Append(dr["appContent"]); } StringBuilder strContent = new StringBuilder(); strContent.Append(blockContent); blockContent = new StringBuilder(); blockContent.Append(strContent.ToString().Replace("~GetServerURL()~", PageBase.GetServerURL() + "/")); if ((this.Master.FindControl("ContentPlaceHolder1").FindControl(dr["appControlId"].ToString()) != null)) { ((HtmlContainerControl)this.Master.FindControl("ContentPlaceHolder1").FindControl(dr["appControlId"].ToString())).InnerHtml = blockContent.ToString(); } else if ((this.Master.FindControl(dr["appControlId"].ToString()) != null)) { ((HtmlContainerControl)this.Master.FindControl(dr["appControlId"].ToString())).InnerHtml = blockContent.ToString(); } } }