/// <summary> /// Method to Delete UserRights /// </summary> /// <param name="argEn">UserRights Entity is an Input.UserGroup as Input Property.</param> /// <returns>Returns Boolean</returns> public bool Delete(UserRightsEn argEn) { bool lbRes = false; string sqlCmd = "DELETE FROM UR_UserRights WHERE UserGroupId =@UserGroupID"; try { if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Insertion Failed! No Row has been updated..."); } } } catch (Exception ex) { throw ex; } return(lbRes); }
/// <summary> /// Method to Insert UserGroupsMenu /// </summary> /// <param name="argEn">UserGroups Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool InsertUserGroupMenu(UserGroupsEn argEn) { List <UserRightsEn> loEnList = new List <UserRightsEn>(); string sqlCmd = "select * from UR_MenuMaster "; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { UserRightsEn loItem = new UserRightsEn(); loItem.MenuID = GetValue <int>(loReader, "MenuID"); loItem.UserGroup = argEn.UserGroupId; loItem.LastUser = argEn.LastUpdatedBy; loItem.LastDtTm = argEn.LastUpdatedDtTm; loEnList.Add(loItem); } loReader.Close(); } UserRightsDAL userRights = new UserRightsDAL(); userRights.InsertUserRights(loEnList); } } catch (Exception ex) { throw ex; } return(true); }
/// <summary> /// Method to Get UserRights Entity /// </summary> /// <param name="argEn">UserRights Entity is an Input.</param> /// <returns>Returns UserRights Entity</returns> public UserRightsEn GetItem(UserRightsEn argEn) { UserRightsEn loItem = new UserRightsEn(); string sqlCmd = "Select * FROM UR_UserRights "; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { if (loReader != null) { loReader.Read(); loItem = LoadObject(loReader); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loItem); }
/// <summary> /// Method to Get List of Active UserRights /// </summary> /// <param name="argEn">UserRights Entity as an Input.</param> /// <returns>Returns List of UserRights</returns> public List <UserRightsEn> GetList(UserRightsEn argEn) { List <UserRightsEn> loEnList = new List <UserRightsEn>(); string sqlCmd = "select * from UR_UserRights"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { UserRightsEn loItem = LoadObject(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Get List of All UserRights by UserGroupID /// </summary> /// <param name="UserGroupID">UserGroupID as an Input.</param> /// <returns>Returns List of UserRights</returns> /// edited by Hafiz @ 30/9/2016 /// remove "UR_MenuMaster.MenuID <> 114 AND" public List <UserRightsEn> GetUserMenu(int UserGroupID) { List <UserRightsEn> loEnList = new List <UserRightsEn>(); string sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " + "UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsOthers, UR_UserRights.IsPrint," + "UR_UserRights.DefaultMode,UR_UserRights.UserGroupId FROM UR_MenuMaster INNER JOIN " + "UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " + "UR_MenuMaster.Status = true AND " + "UR_UserRights.UserGroupId =" + UserGroupID + " order by UR_MenuMaster.MenuName desc"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { UserRightsEn loItem = LoadObject(loReader); loItem.MenuName = GetValue <string>(loReader, "MenuName"); loItem.PageName = GetValue <string>(loReader, "PageName"); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
private UserRightsEn LoadURMenu(IDataReader argReader) { UserRightsEn loItem = new UserRightsEn(); loItem.MenuID = GetValue <int>(argReader, "MenuID"); loItem.MenuName = GetValue <string>(argReader, "MenuName"); loItem.PageName = GetValue <string>(argReader, "PageName"); return(loItem); }
/// <summary> /// Method to Get UserRights Entity /// </summary> /// <param name="argEn">UserRights Entity is an Input.</param> /// <returns>Returns UserRights Entity</returns> public UserRightsEn GetItem(UserRightsEn argEn) { try { UserRightsDAL loDs = new UserRightsDAL(); return(loDs.GetItem(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Get List of All UserRights by UserGroupID /// </summary> /// <param name="argEn">UserGroupID as an Input.</param> /// <returns>Returns List of UserRights</returns> public List <UserRightsEn> GetList(UserRightsEn argEn) { try { UserRightsDAL loDs = new UserRightsDAL(); return(loDs.GetList(argEn)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Check Validation /// </summary> /// <param name="argEn">UserRights Entity as Input.</param> /// <returns>Returns a Boolean</returns> public bool IsValid(UserRightsEn argEn) { try { //if (argEn.UserGroup == null || argEn.UserGroup.ToString().Length <= 0) if (argEn.UserGroup.ToString().Length <= 0) { throw new Exception("UserGroup Is Required!"); } //if (argEn.MenuID == null || argEn.MenuID.ToString().Length <= 0) if (argEn.MenuID.ToString().Length <= 0) { throw new Exception("MenuID Is Required!"); } //if (argEn.IsAdd == null || argEn.IsAdd.ToString().Length <= 0) if (argEn.IsAdd.ToString().Length <= 0) { throw new Exception("IsAdd Is Required!"); } //if (argEn.IsEdit == null || argEn.IsEdit.ToString().Length <= 0) if (argEn.IsEdit.ToString().Length <= 0) { throw new Exception("IsEdit Is Required!"); } //if (argEn.IsDelete == null || argEn.IsDelete.ToString().Length <= 0) if (argEn.IsDelete.ToString().Length <= 0) { throw new Exception("IsDelete Is Required!"); } //if (argEn.IsView == null || argEn.IsView.ToString().Length <= 0) if (argEn.IsView.ToString().Length <= 0) { throw new Exception("IsView Is Required!"); } //if (argEn.IsPrint == null || argEn.IsPrint.ToString().Length <= 0) if (argEn.IsPrint.ToString().Length <= 0) { throw new Exception("IsPrint Is Required!"); } //if (argEn.IsAddModeDefault == null || argEn.IsAddModeDefault.ToString().Length <= 0) if (argEn.IsAddModeDefault.ToString().Length <= 0) { throw new Exception("IsAddModeDefault Is Required!"); } return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Insert UserRights /// </summary> /// <param name="argEn">UserRights Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Insert(UserRightsEn argEn) { bool lbRes = false; string sqlCmd; try { //Checking for Duplicates sqlCmd = "INSERT INTO UR_UserRights(UserGroupId,MenuID,IsAdd,IsEdit,IsDelete,IsView,IsPrint,IsPost,IsOthers,DefaultMode,LastUpdatedBy,LastUpdatedDtTm) VALUES (@UserGroupId,@MenuID,@IsAdd,@IsEdit,@IsDelete,@IsView,@IsPrint,@IsPost,@IsOthers,@DefaultMode,@LastUpdatedBy,@LastUpdatedDtTm) "; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup); _DatabaseFactory.AddInParameter(ref cmd, "@MenuID", DbType.Int32, argEn.MenuID); _DatabaseFactory.AddInParameter(ref cmd, "@IsAdd", DbType.Boolean, argEn.IsAdd); _DatabaseFactory.AddInParameter(ref cmd, "@IsEdit", DbType.Boolean, argEn.IsEdit); _DatabaseFactory.AddInParameter(ref cmd, "@IsDelete", DbType.Boolean, argEn.IsDelete); _DatabaseFactory.AddInParameter(ref cmd, "@IsView", DbType.Boolean, argEn.IsView); _DatabaseFactory.AddInParameter(ref cmd, "@IsPrint", DbType.Boolean, argEn.IsPrint); _DatabaseFactory.AddInParameter(ref cmd, "@IsPost", DbType.Boolean, argEn.IsPost); _DatabaseFactory.AddInParameter(ref cmd, "@IsOthers", DbType.Boolean, argEn.IsOthers); _DatabaseFactory.AddInParameter(ref cmd, "@DefaultMode", DbType.Boolean, argEn.IsAddModeDefault); _DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedBy", DbType.String, argEn.LastUser); _DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedDtTm", DbType.DateTime, Helper.DateConversion(argEn.LastDtTm)); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Insertion Failed! No Row has been updated..."); } } } catch (Exception ex) { throw ex; } return(lbRes); }
private UserRightsEn LoadObjectUser(IDataReader argReader) { UserRightsEn loItem = new UserRightsEn(); loItem.MenuID = GetValue <int>(argReader, "MenuID"); loItem.MenuName = GetValue <string>(argReader, "MenuName"); loItem.PageName = GetValue <string>(argReader, "PageName"); loItem.IsAdd = GetValue <bool>(argReader, "IsAdd"); loItem.IsEdit = GetValue <bool>(argReader, "IsEdit"); loItem.IsDelete = GetValue <bool>(argReader, "IsDelete"); loItem.IsView = GetValue <bool>(argReader, "IsView"); loItem.IsPrint = GetValue <bool>(argReader, "IsPrint"); loItem.IsPost = GetValue <bool>(argReader, "IsPost"); loItem.IsOthers = GetValue <bool>(argReader, "IsOthers"); loItem.IsAddModeDefault = GetValue <bool>(argReader, "DefaultMode"); return(loItem); }
/// <summary> /// Method to Delete UserRights /// </summary> /// <param name="argEn">UserRights Entity is an Input.UserGroup as Input Property.</param> /// <returns>Returns Boolean</returns> public bool Delete(UserRightsEn argEn) { bool flag; using (TransactionScope ts = new TransactionScope()) { try { UserRightsDAL loDs = new UserRightsDAL(); flag = loDs.Delete(argEn); ts.Complete(); } catch (Exception ex) { throw ex; } } return(flag); }
protected void LoadUserRights() { UsersBAL usersBal = new UsersBAL(); UserRightsEn userRightsEn = new UserRightsEn(); userRightsEn = usersBal.GetUserRights(Convert.ToInt32(Request.QueryString["Menuid"]), Convert.ToInt32(Session[Helper.UserGroupSession])); if (userRightsEn.IsAdd) { ibtnSave.Enabled = true; } else { ibtnNew.Enabled = false; ibtnNew.ImageUrl = "../images/gAdd.png"; ibtnNew.ToolTip = "Access Denied"; ibtnDelete.Enabled = false; ibtnDelete.ImageUrl = "../images/gdelete.png"; ibtnDelete.ToolTip = "Access Denied"; ibtnFirst.Enabled = false; ibtnLast.Enabled = false; ibtnPrevs.Enabled = false; ibtnNext.Enabled = false; ibtnFirst.ToolTip = "Access Denied"; ibtnLast.ToolTip = "Access Denied"; ibtnPrevs.ToolTip = "Access Denied"; ibtnNext.ToolTip = "Access Denied"; ibtnFirst.ImageUrl = "../images/gnew_first.png"; ibtnLast.ImageUrl = "../images/gnew_last.png"; ibtnPrevs.ImageUrl = "../images/gnew_Prev.png"; ibtnNext.ImageUrl = "../images/gnew_next.png"; ibtnSave.Enabled = false; ibtnSave.ImageUrl = "../images/gsave.png"; ibtnSave.ToolTip = "Access Denied"; } if (userRightsEn.IsEdit) { Session["EditFlag"] = true; } else { Session["EditFlag"] = false; } ibtnView.Enabled = userRightsEn.IsView; if (userRightsEn.IsView) { ibtnView.ImageUrl = "../images/find.png"; ibtnView.Enabled = true; } else { ibtnView.ImageUrl = "../images/gfind.png"; ibtnView.ToolTip = "Access Denied"; } ibtnPrint.Enabled = userRightsEn.IsPrint; if (userRightsEn.IsPrint) { ibtnPrint.Enabled = true; ibtnPrint.ImageUrl = "../images/print.png"; ibtnPrint.ToolTip = "Print"; } else { ibtnPrint.Enabled = false; ibtnPrint.ImageUrl = "../images/gprint.png"; ibtnPrint.ToolTip = "Access Denied"; } if (userRightsEn.IsOthers) { ibtnOthers.Enabled = true; ibtnOthers.ImageUrl = "../images/others.png"; ibtnOthers.ToolTip = "Others"; } else { ibtnOthers.Enabled = false; ibtnOthers.ImageUrl = "../images/gothers.png"; ibtnOthers.ToolTip = "Access Denied"; } if (userRightsEn.IsPost) { ibtnPosting.Enabled = true; ibtnPosting.ImageUrl = "../images/posting.png"; ibtnPosting.ToolTip = "Posting"; } else { ibtnPosting.Enabled = false; ibtnPosting.ImageUrl = "../images/gposting.png"; ibtnPosting.ToolTip = "Access Denied"; } }
/// <summary> /// Method to Get List of All UserRights by UserID /// </summary> /// <param name="UserGroupID">UserID as an Input.</param> /// <returns>Returns List of UserRights</returns> public List <UserRightsEn> GetMenuByUser(int UserID) { List <UserRightsEn> loEnList = new List <UserRightsEn>(); string sqlCmd = null; //Create Instances - Start MenuMasterEn MenuDetails = new MenuMasterEn(); List <MenuMasterEn> MenuList = new List <MenuMasterEn>(); //Create Instances - Stop if (UserID > 0) { //sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " + //"UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsPrint," + //"UR_UserRights.DefaultMode FROM UR_MenuMaster INNER JOIN " + //"UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " + //"UR_MenuMaster.Status = true AND UR_MenuMaster.MenuID <> 114 AND " + //"UR_UserRights.UserId =" + UserID + " order by UR_MenuMaster.MenuName desc"; //sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " + sqlCmd = "SELECT UR_MenuMaster.MenuID " + "FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " + "AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE UserId = " + UserID + ") " + "ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder"; } else { sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " + "FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " + "ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder"; } try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { if (UserID > 0) { UserRightsEn loItem = new UserRightsEn(); loItem.MenuID = GetValue <int>(loReader, "MenuID"); //loItem.MenuName = GetValue<string>(loReader, "MenuName"); //loItem.PageName = GetValue<string>(loReader, "PageName"); loEnList.Add(loItem); } else { UserRightsEn loMenuItem = LoadURMenu(loReader); loMenuItem.MenuID = GetValue <int>(loReader, "MenuID"); loMenuItem.MenuName = GetValue <string>(loReader, "MenuName"); loMenuItem.PageName = GetValue <string>(loReader, "PageName"); //loMenuItem.IsAdd = false; //loMenuItem.IsEdit = false; //loMenuItem.IsDelete = false; //loMenuItem.IsView = false; //loMenuItem.IsPrint = false; //loMenuItem.IsPost = false; //loMenuItem.IsAddModeDefault = false; loEnList.Add(loMenuItem); } } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Update UserRights /// </summary> /// <param name="argEn">UserRights Entity is an Input.</param> /// <returns>Returns Boolean</returns> public bool Update(UserRightsEn argEn) { bool lbRes = false; int iOut = 0; string sqlCmd = "Select count(*) as cnt From UR_UserRights WHERE UserGroupId = @UserGroupId"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader dr = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { if (dr.Read()) { iOut = clsGeneric.NullToInteger(dr["cnt"]); } if (iOut > 0) { throw new Exception("Record Already Exist"); } } if (iOut == 0) { sqlCmd = "UPDATE UR_UserRights SET UserGroupId = @UserGroupId, MenuID = @MenuID, IsAdd = @IsAdd, IsEdit = @IsEdit, IsDelete = @IsDelete, IsView = @IsView, IsPrint = @IsPrint, IsPost = @IsPost, IsOthers = @IsOthers, DefaultMode = @DefaultMode, LastUpdatedBy = @LastUpdatedBy, LastUpdatedDtTm = @LastUpdatedDtTm WHERE "; if (!FormHelp.IsBlank(sqlCmd)) { DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString); _DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup); _DatabaseFactory.AddInParameter(ref cmd, "@MenuID", DbType.Int32, argEn.MenuID); _DatabaseFactory.AddInParameter(ref cmd, "@IsAdd", DbType.Boolean, argEn.IsAdd); _DatabaseFactory.AddInParameter(ref cmd, "@IsEdit", DbType.Boolean, argEn.IsEdit); _DatabaseFactory.AddInParameter(ref cmd, "@IsDelete", DbType.Boolean, argEn.IsDelete); _DatabaseFactory.AddInParameter(ref cmd, "@IsView", DbType.Boolean, argEn.IsView); _DatabaseFactory.AddInParameter(ref cmd, "@IsPrint", DbType.Boolean, argEn.IsPrint); _DatabaseFactory.AddInParameter(ref cmd, "@IsPost", DbType.Boolean, argEn.IsPost); _DatabaseFactory.AddInParameter(ref cmd, "@IsOthers", DbType.Boolean, argEn.IsOthers); _DatabaseFactory.AddInParameter(ref cmd, "@DefaultMode", DbType.Boolean, argEn.IsAddModeDefault); _DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedBy", DbType.String, argEn.LastUser); _DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedDtTm", DbType.DateTime, argEn.LastDtTm); _DbParameterCollection = cmd.Parameters; int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd, DataBaseConnectionString, sqlCmd, _DbParameterCollection); if (liRowAffected > -1) { lbRes = true; } else { throw new Exception("Update Failed! No Row has been updated..."); } } } } } catch (Exception ex) { throw ex; } return(lbRes); }