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();
}
}
}
