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