/// <summary> /// Gets the User rights from the u_UserRights table according to MenuTag /// </summary> /// <param name="objURight">Object of a u_UserRights class in smartOffice_Models</param> /// <returns>DataTable filled with User rights</returns> public DataTable GetUserRightsToMenuTag(u_UserRights objURight) { try { if (objURight.User.strUserID == "") { strQuery = "select t.menuId as [Menu ID],t.description as [Menu Name],t.menuRights as [Menu Rights],t.mainOrder,t.subOrder from u_MenuTag t"; } else { strQuery = "select u.roleId as [Role ID],url.description as [Role Name], ur.userId as [User ID]," + "ur.menuId as [Menu ID],ur.menuRights as [Menu Rights],m.description as [Menu Name] " + "from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId " + "inner join u_User u on u.userId=ur.userId " + "right outer join u_UserRoles url on url.roleId=u.roleId " + "where ur.userId='" + objURight.User.strUserID + "' and ur.menuId='" + objURight.MenuTag.strMenuID + "'"; } DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text); return(dtURights); } catch (Exception ex) { throw ex; } }
public static u_UserRights_DL GetUserRightObj(string formID, string user) { u_UserRights objUserRight = new u_UserRights(); objUserRight.User = new u_User(); objUserRight.MenuTag = new u_MenuTag(); objUserRight.User.strUserID = Globals.g_strUser; objUserRight.MenuTag.strMenuID = formID.Trim(); u_UserRights_DL objURightDL = new u_UserRights_DL(); u_UserRights_DL dtAllMenuItems = objURightDL.GetUserRightsForOneMenu(objUserRight); return(dtAllMenuItems); }
/// <summary> /// Update the Data in the u_UserRights table in the database /// </summary> /// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param> /// <returns>If Updated Successfully,returns true, else false</returns> public bool UpdateRights(u_UserRights objUserRight) { try { strQuery = "update u_UserRights set menuRights='" + objUserRight.strMenuRights + "' " + "where userId='" + objUserRight.User.strUserID + "' and " + "menuId=(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')"; u_DBConnection.ExecuteNonQuery(strQuery); return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Save the Data in the u_UserRights table in the database /// </summary> /// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param> /// <returns>If saved Successfully,returns true, else false</returns> public bool SaveUserRights(u_UserRights objUserRight) { try { strQuery = "insert into u_UserRights(userId,menuId,menuRights) " + "values('" + objUserRight.User.strUserID + "',(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')," + "'" + objUserRight.strMenuRights + "')"; u_DBConnection.ExecuteNonQuery(strQuery); return(true); } catch (Exception ex) { throw ex; } }
//select ur.menuRights as [Menu Rights] from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_User u on u.userId=ur.userId right outer join u_UserRoles url on url.roleId=u.roleId where ur.userId='Admin' and ur.menuId = 'A0003' /// <summary> /// Gets the User rights from the u_UserRoleRights table /// </summary> /// <param name="objURight">Object of a u_UserRights class in smartOffice_Models</param> /// <returns>DataTable filled with User Role rights</returns> public DataTable GetUserRoleRightsToUserID(u_UserRights objURight) { try { strQuery = "select ur.roleId as [Role ID],ur.menuId as [Menu ID],ur.menuRights as [Menu Rights],m.description as [Menu Name],url.description as [Role Name] " + "from u_UserRoleRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_UserRoles url on url.roleId=ur.roleId " + "where ur.roleId=(select roleId from u_User where userId='" + objURight.User.strUserID + "')"; DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text); return(dtURights); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get MenuRights for each userId and MenuID /// </summary> /// <param name="UserID">Logged user id</param> /// <returns>DataTable filled with menu rights</returns> public static DataTable CheckMenuaccess(string UserID) { try { u_UserRights objUserRight = new u_UserRights(); objUserRight.User = new u_User(); objUserRight.MenuTag = new u_MenuTag(); u_UserRights_BL objUserRghtsBL = new u_UserRights_BL(); objUserRight.User.strUserID = UserID; objUserRight.MenuTag.strMenuID = g_MenuId; DataTable dt = objUserRghtsBL.GetUserRightsToMenuTag(objUserRight); return(dt); } catch (Exception ex) { throw ex; } }
public u_UserRights_DL GetUserRightsForOneMenu(u_UserRights objURight) { try { strQuery = "select ur.menuRights as [Menu Rights] from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_User u on u.userId=ur.userId" + " right outer join u_UserRoles url on url.roleId=u.roleId where ur.userId='" + objURight.User.strUserID.Trim() + "' and ur.menuId = '" + objURight.MenuTag.strMenuID.Trim() + "'"; DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text); return(CreateUserRights_DL(dtURights)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Check whether user enterd UserID and menuID is exist or not /// </summary> /// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param> /// <returns>If exist in the database,returns true, else false</returns> public bool ExistingUserRights(u_UserRights objUserRight) { try { strQuery = "select menuRights from u_UserRights where userId='" + objUserRight.User.strUserID + "'" + " and menuId=(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')"; DataRow drUserRight = u_DBConnection.ReturnDataRow(strQuery); if (drUserRight != null) { return(true); } return(false); } catch (Exception ex) { throw ex; } }
/*FunctionButtonStatus Was created by Asanga Chandrakumara on 12:18 PM 6/24/2015*/ /// <summary> /// THis function will enable and disable the button status as required /// </summary> /// <param name="typex">Enumaration to function type</param> public void FunctionButtonStatus(xEnums.PerformanceType typex) { u_UserRights objUserRight = new u_UserRights(); objUserRight.User = new u_User(); objUserRight.MenuTag = new u_MenuTag(); objUserRight.User.strUserID = Globals.g_strUser; objUserRight.MenuTag.strMenuID = formID.Trim(); u_UserRights_DL objURightDL = new u_UserRights_DL(); u_UserRights_DL dtAllMenuItems = objURightDL.GetUserRightsForOneMenu(objUserRight); switch (typex) { case xEnums.PerformanceType.Save: if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; btn_cancel.Enabled = false; btn_save.Enabled = false; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = dtAllMenuItems.boolModify; btn_print.Enabled = dtAllMenuItems.boolPrint; } else { btn_cancel.Enabled = false; btn_save.Enabled = false; btn_new.Enabled = true; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = dtAllMenuItems.boolModify; btn_print.Enabled = dtAllMenuItems.boolPrint; } break; case xEnums.PerformanceType.Delete: //when press the delete button if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; } else { btn_cancel.Enabled = false; btn_save.Enabled = false; btn_new.Enabled = true; btn_delete.Enabled = false; btn_edit.Enabled = false; btn_print.Enabled = false; } break; case xEnums.PerformanceType.Existing: //enter existing item to system if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; } else { btn_cancel.Enabled = true; btn_save.Enabled = false; btn_new.Enabled = false; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = dtAllMenuItems.boolModify; btn_print.Enabled = dtAllMenuItems.boolPrint; } break; case xEnums.PerformanceType.Edit: //enter existing item to system and press edit if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; btn_cancel.Enabled = true; btn_save.Enabled = true; btn_new.Enabled = dtAllMenuItems.boolCreate; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = false; btn_print.Enabled = dtAllMenuItems.boolPrint; } else { btn_cancel.Enabled = true; btn_save.Enabled = true; btn_new.Enabled = false; btn_delete.Enabled = false; btn_edit.Enabled = false; btn_print.Enabled = false; } break; case xEnums.PerformanceType.Exit: break; case xEnums.PerformanceType.New: if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; } else { btn_cancel.Enabled = true; btn_save.Enabled = true; btn_new.Enabled = false; btn_delete.Enabled = false; btn_edit.Enabled = false; btn_print.Enabled = false; } break; case xEnums.PerformanceType.Default: if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = dtAllMenuItems.boolModify; btn_print.Enabled = dtAllMenuItems.boolPrint; btn_save.Enabled = false; btn_cancel.Enabled = false; } else { btn_cancel.Enabled = false; btn_save.Enabled = false; btn_new.Enabled = true; btn_delete.Enabled = dtAllMenuItems.boolDelete; btn_edit.Enabled = dtAllMenuItems.boolModify; btn_print.Enabled = dtAllMenuItems.boolPrint; } break; case xEnums.PerformanceType.Cancel: if (dtAllMenuItems.boolCreate == false) { btn_new.Enabled = false; } else { btn_cancel.Enabled = false; btn_save.Enabled = false; btn_new.Enabled = true; btn_delete.Enabled = false; btn_edit.Enabled = false; btn_print.Enabled = false; } break; } }
/// <summary> /// This will disable menues if they don't have acccess to incoming user searched by the Menu ID /// So when ever you change the text of the form will not effect to this method /// just put the tlStrpMenuItem_ +menu ID to the menu name and all done /// </summary> public void MenuStripItemsVisible() { u_UserRights objUserRight = new u_UserRights(); objUserRight.User = new u_User(); objUserRight.MenuTag = new u_MenuTag(); u_UserRights_BL objUserRghtsBL = new u_UserRights_BL(); objUserRight.User.strUserID = Globals.g_strUser; objUserRight.MenuTag.strMenuID = Globals.g_MenuId; u_UserRights_DL objURightDL = new u_UserRights_DL(); DataTable dtAllMenuItems = objURightDL.GetUserRights(objUserRight); //DataTable dtAllMenuItems = objUserRghtsBL.GetUserRights(objUserRight); if (Globals.g_strUser.Trim().ToUpper() != "ADMIN") { if (dtAllMenuItems.Rows.Count != 0) { for (int i = 0; i < dtAllMenuItems.Rows.Count; i++) { if (Convert.ToBoolean(dtAllMenuItems.Rows[i]["dtAccess"].ToString()) == false) { string strEditUIName = (dtAllMenuItems.Rows[i]["Code"].ToString()).Replace(" ", ""); string strtlStrpMenuItemName = strEditUIName; List <ToolStripMenuItem> myItems = GetItems(this.menuStrip); foreach (var item in myItems) { item.ForeColor = Color.FromArgb(126, 26, 29); item.Text = item.Text.ToUpper(); if (item.Name == strtlStrpMenuItemName) { item.Enabled = false; } } foreach (ToolStripItem ctrl in this.toolStrip.Items) { ctrl.Text = ctrl.Text.ToUpper(); if (ctrl.Name.Trim().ToUpper() == "T" + strtlStrpMenuItemName.Trim().ToUpper()) { ctrl.Enabled = false; } } foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items) { ctrl.Text = ctrl.Text.ToUpper(); ctrl.ForeColor = Color.FromArgb(126, 26, 29); if (ctrl.Name.Trim().ToUpper() == "C" + strtlStrpMenuItemName.Trim().ToUpper()) { ctrl.Enabled = false; } } } else { string strEditUIName = (dtAllMenuItems.Rows[i]["Code"].ToString()).Replace(" ", ""); string strtlStrpMenuItemName = strEditUIName; List <ToolStripMenuItem> myItems = GetItems(this.menuStrip); foreach (var item in myItems) { item.ForeColor = Color.FromArgb(126, 26, 29); item.Text = item.Text.ToUpper(); if (item.Name == strtlStrpMenuItemName) { item.Enabled = true; } } foreach (ToolStripItem ctrl in this.toolStrip.Items) { ctrl.Text = ctrl.Text.ToUpper(); if (ctrl.Name.Trim().ToUpper() == "T" + strtlStrpMenuItemName.Trim().ToUpper()) { ctrl.Enabled = true; } } foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items) { ctrl.Text = ctrl.Text.ToUpper(); ctrl.ForeColor = Color.FromArgb(126, 26, 29); if (ctrl.Name.Trim().ToUpper() == "C" + strtlStrpMenuItemName.Trim().ToUpper()) { ctrl.Enabled = true; } } } } } else { //implement locking system List <ToolStripMenuItem> myItems = GetItems(this.menuStrip); foreach (var item in myItems) { item.ForeColor = Color.FromArgb(126, 26, 29); item.Text = item.Text.ToUpper(); item.Enabled = false; } foreach (ToolStripItem ctrl in this.toolStrip.Items) { if (ctrl.Name.Trim().ToUpper() == "shutdown_ToolBar".Trim().ToUpper()) { } else { ctrl.Text = ctrl.Text.ToUpper(); ctrl.Enabled = false; } } foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items) { ctrl.Text = ctrl.Text.ToUpper(); ctrl.ForeColor = Color.FromArgb(126, 26, 29); ctrl.Enabled = false; } } } else { // if login user is administrator } }