private void SetUpPermission(string pageName) { tblTab objTab = new tblTab(); DataTable objPermissionDt = new DataTable(); objPermissionDt = objTab.LoadPermissionForTab(pageName, Convert.ToInt32(Session[appFunctions.Session.RoleID.ToString()])); if (objPermissionDt.Rows.Count > 0) { if ((bool)objPermissionDt.Rows[0]["appIsView"] == false) { Response.Redirect("PageNotFound.aspx", true); } else { if ((bool)objPermissionDt.Rows[0]["appIsAdd"] == true) { HasAdd = true; } if ((bool)objPermissionDt.Rows[0]["appIsEdit"] == true) { HasEdit = true; } if ((bool)objPermissionDt.Rows[0]["appIsDelete"] == true) { HasDelete = true; } } } }
private void SetValuesToControls() { objTab = new tblTab(); objTab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objTab.RowCount > 0) { txtTabName.Text = objTab.AppTabName; ddlParent.SelectedValue = objTab.AppParentID.ToString(); if (objTab.AppWebPageName != "#") { txtWebPageName.Text = objTab.AppWebPageName; } else { txtWebPageName.Text = ""; } ChkIsActive.Checked = objTab.AppIsActive; chkIsAdd.Checked = objTab.AppIsAdd; chkIsEdit.Checked = objTab.AppIsEdit; chkIsDelete.Checked = objTab.AppIsDelete; chkIsMenu.Checked = objTab.AppIsMenu; if (objTab.AppIsShowOnDashboard == true) { chkIsShowOnDashboard.Checked = true; if ((objTab.AppIconPath.ToString() != null)) { imgIconPreview.ImageUrl = (strImagePath) + objTab.AppIconPath; } RegexpImageValid.Enabled = false; reImage.Enabled = false; } else { chkIsShowOnDashboard.Checked = false; RegexpImageValid.Enabled = false; reImage.Enabled = true; } if (!string.IsNullOrEmpty(objTab.AppAddPage)) { txtAddPage.Text = objTab.AppAddPage; chkHasAddOption.Checked = true; } else { txtAddPage.Text = objTab.AppAddPage; chkHasAddOption.Checked = false; } } }
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "") { objtab = new tblTab(); string strWhereCondition = ""; if (!string.IsNullOrEmpty(hdnCurrentTabID.Value)) { strWhereCondition = "appParentID = " + hdnCurrentTabID.Value.ToString(); } else { strWhereCondition = "appParentID = 0"; } objDataTable = objtab.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim(), strWhereCondition); //'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(); } objtab = null; }
protected void Page_Load(object sender, System.EventArgs e) { if (!Page.IsPostBack) { btnSaveAndAddnew.Visible = HasAdd; btnClear.Visible = HasAdd; SetUpDrowDown(); objEncrypt = new clsEncryption(); if ((Request.QueryString.Get("ID") != null)) { try { hdnPKID.Value = objEncrypt.Decrypt(Request.QueryString.Get("ID"), appFunctions.strKey); } catch (Exception ex) { noIdFoundRedirect("Tab.aspx"); } objEncrypt = null; SetValuesToControls(); } if ((Request.QueryString.Get("PID") != null)) { try { intParentId = Convert.ToInt32(objEncrypt.Decrypt(Request.QueryString.Get("PID"), appFunctions.strKey)); } catch (Exception ex) { noIdFoundRedirect("Tab.aspx"); } ddlParent.SelectedValue = intParentId.ToString(); objTab = new tblTab(); objTab.LoadByPrimaryKey(intParentId); objTab.Query.AddResultColumn(tblTab.ColumnNames.AppAddPage); objTab.Query.Load(); ////Set Value To Controls //txtAddPage.Text = objTab.AppAddPage; objTab.Where.WhereClauseReset(); objTab = null; } } }
private bool Delete(int intPKID) { bool retval = false; objtab = new tblTab(); var _with1 = objtab; if (_with1.LoadByPrimaryKey(intPKID)) { _with1.MarkAsDeleted(); _with1.Save(); } retval = true; objtab = null; return(retval); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //tblUser objUser = new tblUser(); //dgvGridView.DataSource = objUser.RecentUsers(Session[appFunctions.Session.UserID.ToString()].ToString(), Convert.ToBoolean(Session[appFunctions.Session.IsSuperAdmin.ToString()].ToString())); //dgvGridView.DataBind(); //objUser = null; ViewState["SortOrder"] = appFunctions.Enum_SortOrderBy.Asc; ViewState["SortColumn"] = ""; DataTable objPermissionDT = new DataTable(); if ((bool)Session[appFunctions.Session.IsSuperAdmin.ToString()]) { tblTab objTab = new tblTab(); objTab.Query.AddOrderBy(tblTab.ColumnNames.AppDisplayOrder, MyGeneration.dOOdads.WhereParameter.Dir.ASC); objTab.Query.AddOrderBy(tblTab.ColumnNames.AppParentID, MyGeneration.dOOdads.WhereParameter.Dir.ASC); objTab.Where.AppIsShowOnDashboard.Value = true; objTab.Query.Load(); objPermissionDT = objTab.DefaultView.Table; } else { tblPermission objPermission = new tblPermission(); try { objPermissionDT = objPermission.LoadTabsForRole(Convert.ToInt32(Session[appFunctions.Session.RoleID.ToString()].ToString()), true); } catch { Response.Redirect("UserPannel.aspx"); } } rptDashBoardLinks.DataSource = objPermissionDT; rptDashBoardLinks.DataBind(); //string dashBoardString = ""; //foreach (DataRow dr in objPermissionDT.Rows) //{ // dashBoardString += "<div class='col-md-2 col-sm-3 col-xs-3' align='Center'>"; // dashBoardString += "<a href='" + dr["appWebPageName"].ToString() + "'>"; // if (dr["appIconPath"].ToString() != "") // { // dashBoardString += "<img src='" + dr["appIconPath"].ToString() + "' height='100px' width='100px' alt='" + dr["appTabName"] + "'/>"; // } // else // { // dashBoardString += "<img src='Images/NoImg.png' height='100px' width='100px' alt='" + dr["appTabName"] + "'/>"; // } // dashBoardString += "<div style='text=align:center;Width:100px;line-height:20Px;height:40Px;'>" + dr["appTabName"].ToString() + "</div>"; // dashBoardString += "</a>"; // dashBoardString += "</div>"; //} //DashBord.InnerHtml = dashBoardString; LoadDataGridInquiry(); } }
private bool SaveData() { objTab = new tblTab(); if (!string.IsNullOrEmpty(hdnPKID.Value)) { objTab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objTab.AddNew(); objTab.AppCreatedDate = System.DateTime.Now; objTab.AppCreatedBy = (int)Session[appFunctions.Session.UserID.ToString()]; } objTab.AppTabName = txtTabName.Text; if (objTab.s_AppParentID != ddlParent.SelectedValue.ToString()) { objTab.AppDisplayOrder = objClsCommon.GetNextDisplayOrder("tblTab", tblTab.ColumnNames.AppDisplayOrder, " appParentID = " + ddlParent.SelectedValue); } objTab.AppParentID = Convert.ToInt32(ddlParent.SelectedValue); if (!string.IsNullOrEmpty(txtWebPageName.Text) & txtWebPageName.Text != "#") { tblTab objTemp = new tblTab(); objTemp.Where.AppWebPageName.Value = txtWebPageName.Text; objTemp.Query.AddResultColumn(tblTab.ColumnNames.AppTabID); objTemp.Query.Load(); if (objTemp.RowCount > 0) { if (objTemp.AppTabID != Convert.ToInt32(hdnPKID.Value)) { DInfo.ShowMessage("The Specified Web Page is already allocated to another tab", Enums.MessageType.Error); } } objTab.AppWebPageName = txtWebPageName.Text; } else { objTab.AppWebPageName = "#"; } objTab.AppIsActive = ChkIsActive.Checked; objTab.AppIsAdd = chkIsAdd.Checked; objTab.AppIsEdit = chkIsEdit.Checked; objTab.AppIsDelete = chkIsDelete.Checked; if (chkHasAddOption.Checked == true) { objTab.AppAddPage = txtAddPage.Text; } else { objTab.AppAddPage = ""; } if (chkIsShowOnDashboard.Checked == true) { objTab.AppIsShowOnDashboard = true; if ((FileUploadIcon.HasFile)) { //string fileName = System.IO.Path.GetFileNameWithoutExtension(FileUploadIcon.FileName).ToString(); //string extension = System.IO.Path.GetExtension(FileUploadIcon.FileName).ToString(); //FileUploadIcon.SaveAs(Server.MapPath(strImagePath) + fileName + fileAppend + extension); //try //{ // System.IO.File.Delete(Server.MapPath(".") + Server.MapPath(strImagePath) + objTab.AppIconPath); //} //catch (Exception ex) //{ //} //objTab.AppIconPath = fileName + fileAppend + extension; string strError = ""; string Time = Convert.ToString(DateTime.Now.Month) + Convert.ToString(DateTime.Now.Day) + Convert.ToString(DateTime.Now.Year) + Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second); string strPath = objClsCommon.FileUpload_Images(FileUploadIcon.PostedFile, txtTabName.Text.Trim().Replace(" ", "_") + "_" + Time, "Uploads/TabImages/", ref strError, 0, objTab.AppIconPath); if (strError == "") { objTab.AppIconPath = strPath; } else { DInfo.ShowMessage(strError, Enums.MessageType.Error); return(false); } } } else { objTab.AppIsShowOnDashboard = false; objTab.AppIconPath = ""; } ////If IsMenu Is True if (chkIsMenu.Checked == true) { ////Make All Others IsMenu To False tblTab objTemp = new tblTab(); objTemp.updateIsMenu(); objTab.AppIsMenu = true; } else { objTab.AppIsMenu = false; } objTab.Save(); objTab = null; return(true); }
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { clsEncryption objEncrypt = new clsEncryption(); int intHiddenPKID = 0; if (!string.IsNullOrEmpty(hdnPKID.Value)) { intHiddenPKID = Convert.ToInt32(hdnPKID.Value); } objCommon = new clsCommon(); hdnPKID.Value = e.CommandArgument.ToString(); if (e.CommandName == "ListChildMenus") { Response.Redirect("Tab.aspx?ID=" + objEncrypt.Encrypt(hdnPKID.Value, appFunctions.strKey), true); } //else if (e.CommandName == "Edit") //{ // Response.Redirect("TabDetail.aspx?ID=" + objEncrypt.Encrypt(hdnPKID.Value, appFunctions.strKey), true); //} else if (e.CommandName == "Up") { LinkButton inkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent; if (drCurrent.RowIndex > 0) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1]; objCommon.SetDisplayOrder("tblTab", tblTab.ColumnNames.AppTabID, tblTab.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[5], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[5]); hdnPKID.Value = intHiddenPKID.ToString(); LoadDataGrid(false, false); objCommon = null; } hdnPKID.Value = intHiddenPKID.ToString(); } else if (e.CommandName == "Down") { LinkButton lnkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent; if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1]; objCommon.SetDisplayOrder("tblTab", tblTab.ColumnNames.AppTabID, tblTab.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[5], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[5]); hdnPKID.Value = intHiddenPKID.ToString(); LoadDataGrid(false, false); objCommon = null; } hdnPKID.Value = intHiddenPKID.ToString(); } else if (e.CommandName == "IsActive") { objtab = new tblTab(); objtab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objtab.AppIsActive == true) { objtab.AppIsActive = false; } else if (objtab.AppIsActive == false) { objtab.AppIsActive = true; } objtab.Save(); LoadDataGrid(false, false, "", ""); } else if (e.CommandName == "IsAdd") { objtab = new tblTab(); objtab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objtab.AppIsAdd == true) { objtab.AppIsAdd = false; } else if (objtab.AppIsAdd == false) { objtab.AppIsAdd = true; } objtab.Save(); LoadDataGrid(false, false, "", ""); } else if (e.CommandName == "IsEdit") { objtab = new tblTab(); objtab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objtab.AppIsEdit == true) { objtab.AppIsEdit = false; } else if (objtab.AppIsEdit == false) { objtab.AppIsEdit = true; } objtab.Save(); LoadDataGrid(false, false, "", ""); } else if (e.CommandName == "IsDelete") { objtab = new tblTab(); objtab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objtab.AppIsDelete == true) { objtab.AppIsDelete = false; } else if (objtab.AppIsDelete == false) { objtab.AppIsDelete = true; } objtab.Save(); LoadDataGrid(false, false, "", ""); } else if (e.CommandName == "IsDashbord") { objtab = new tblTab(); objtab.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); if (objtab.AppIsShowOnDashboard == true) { objtab.AppIsShowOnDashboard = false; } else if (objtab.AppIsShowOnDashboard == false) { objtab.AppIsShowOnDashboard = true; } objtab.Save(); LoadDataGrid(false, false, "", ""); } } }
protected void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { ViewState["SortOrder"] = appFunctions.Enum_SortOrderBy.Asc; ViewState["SortColumn"] = ""; ifError = false; btnAdd.Visible = HasAdd; btnDelete.Visible = HasDelete; dgvGridView.Columns[0].Visible = HasDelete; dgvGridView.Columns[1].Visible = HasEdit; dgvGridView.Columns[4].Visible = HasEdit; dgvGridView.Columns[5].Visible = HasEdit; dgvGridView.Columns[6].Visible = HasEdit; dgvGridView.Columns[7].Visible = HasEdit; dgvGridView.Columns[8].Visible = HasEdit; if ((Session[appFunctions.Session.ShowMessage.ToString()] != null)) { if (!string.IsNullOrEmpty(Session[appFunctions.Session.ShowMessage.ToString()].ToString())) { DInfo.ShowMessage(Session[appFunctions.Session.ShowMessage.ToString()].ToString(), (Enums.MessageType)Session[appFunctions.Session.ShowMessageType.ToString()]); Session[appFunctions.Session.ShowMessage.ToString()] = ""; Session[appFunctions.Session.ShowMessageType.ToString()] = ""; } } objCommon = new clsCommon(); objCommon.FillRecordPerPage(ref ddlPerPage); // objCommon.FillDropDownList(ddlParents, "tblTab", tblTab.ColumnNames.AppTabName, tblTab.ColumnNames.AppTabID, "--Select Parent--", tblTab.ColumnNames.AppDisplayOrder, appFunctions.Enum_SortOrderBy.Asc, "appParentId = 0") if ((Request.QueryString.Get("ID") != null)) { objEncrypt = new clsEncryption(); hdnCurrentTabID.Value = objEncrypt.Decrypt(Request.QueryString.Get("ID"), appFunctions.strKey); intSiteMapId = Convert.ToInt32(hdnCurrentTabID.Value); } if (intSiteMapId != -1) { DataTable dt = new DataTable(); objEncrypt = new clsEncryption(); dynamic objTempTab = new tblTab(); dt = objTempTab.GetSiteMap(intSiteMapId); strSiteMapData = dt.Rows[0][0].ToString(); dt = objTempTab.GetMenuType(intSiteMapId); String[] SplitSiteMapString = strSiteMapData.Split('/'); if (SplitSiteMapString.Length > 1) { strSiteMap = "<a href='Tab.aspx'>Parent Tabs </a>"; } else { strSiteMap = "Parent Tabs"; } for (int i = SplitSiteMapString.Length - 2; i >= 0; i += -1) { String[] SplittedItems = SplitSiteMapString.GetValue(i).ToString().Split(','); //If i = 0 Then // strSiteMap = "<a href=TabsList.aspx?Id=" + objEncrypt.Encrypt(dt.Rows(0).Item("appTabID"), appFunctions.strKey) + "&type=mtype>" + dt.Rows(0).Item("appTabName") + "</a>" //End If //If i <> SplitSiteMapString.Length - 2 Then // strSiteMap += " > " //End If if (i == 0) { strSiteMap += " > " + SplittedItems.GetValue(0); } else { strSiteMap += " > <a href='Tab.aspx?Id=" + objEncrypt.Encrypt(SplittedItems.GetValue(1).ToString(), appFunctions.strKey) + "'>" + SplittedItems.GetValue(0) + "</a>"; } } litSiteMap.Text = strSiteMap; } LoadDataGrid(true, false); txtSearch.Focus(); objCommon = null; } }