/*---------------------------------------------------------------------------------------------------------------------------------- * UserPrivileges *---------------------------------------------------------------------------------------------------------------------------------*/ private questStatus create(FMSEntities dbContext, GroupPrivilege groupPrivilege, out GroupPrivilegeId groupPrivilegeId) { // Initialize groupPrivilegeId = null; // Perform create try { Quest.Services.Dbio.FMS.GroupPrivileges _groupPrivileges = new Quest.Services.Dbio.FMS.GroupPrivileges(); _groupPrivileges.PrivilegeId = groupPrivilege.Privilege.Id; _groupPrivileges.GroupId = groupPrivilege.Group.Id; _groupPrivileges.Created = DateTime.Now; dbContext.GroupPrivileges.Add(_groupPrivileges); dbContext.SaveChanges(); if (_groupPrivileges.Id == 0) { return(new questStatus(Severity.Error, "GroupPrivilege not created")); } groupPrivilegeId = new GroupPrivilegeId(_groupPrivileges.Id); } catch (System.Exception ex) { return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.InnerException != null ? ex.InnerException.Message : ex.Message))); } return(new questStatus(Severity.Success)); }
private questStatus update(FMSEntities dbContext, GroupPrivilege groupPrivilege) { // Initialize questStatus status = null; try { // Read the record. GroupPrivilegeId groupPrivilegeId = new GroupPrivilegeId(groupPrivilege.Id); Quest.Services.Dbio.FMS.GroupPrivileges _groupPrivileges = null; status = read(dbContext, groupPrivilegeId, out _groupPrivileges); if (!questStatusDef.IsSuccess(status)) { return(status); } // Update the record. BufferMgr.TransferBuffer(groupPrivilege, _groupPrivileges); dbContext.SaveChanges(); } catch (System.Exception ex) { return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.InnerException != null ? ex.InnerException.Message : ex.Message))); } return(new questStatus(Severity.Success)); }
/// <summary> /// Creates a/an GroupPrivilege. /// </summary> /// <param name="entity"></param> /// <returns>Returns the GroupPrivilege that was created in the database.</returns> public GroupPrivilege CreateGroupPrivilege(GroupPrivilege entity) { try { return(repo.Create <GroupPrivilege>(entity)); } catch (Exception ex) { repo.LogError(ex); throw ex; } }
public questStatus Update(DbMgrTransaction trans, GroupPrivilege groupPrivilege) { // Initialize questStatus status = null; // Update groupPrivilege status = _dbGroupPrivilegesMgr.Update(trans, groupPrivilege); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Read(GroupPrivilegeId groupPrivilegeId, out GroupPrivilege groupPrivilege) { // Initialize groupPrivilege = null; questStatus status = null; // Read groupPrivilege status = _dbGroupPrivilegesMgr.Read(groupPrivilegeId, out groupPrivilege); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Update(DbMgrTransaction trans, GroupPrivilege groupPrivilege) { // Initialize questStatus status = null; bool bCreateTransaction = trans == null; // Perform update in this transaction. status = update((FMSEntities)trans.DbContext, groupPrivilege); if (!questStatusDef.IsSuccess(status)) { RollbackTransaction(trans); return(status); } return(new questStatus(Severity.Success)); }
public questStatus List(QueryOptions queryOptions, out List <GroupPrivilege> groupPrivilegeList, out QueryResponse queryResponse) { // Initialize questStatus status = null; groupPrivilegeList = null; queryResponse = null; using (FMSEntities dbContext = new FMSEntities()) { using (DbContextTransaction tx = dbContext.Database.BeginTransaction(IsolationLevel.ReadUncommitted)) { try { PropertyInfo[] dbProperties = typeof(Quest.Services.Dbio.FMS.GroupPrivileges).GetProperties().ToArray(); List <Quest.Services.Dbio.FMS.GroupPrivileges> _groupPrivilegesList = dbContext.GroupPrivileges.Where(BuildWhereClause(queryOptions, dbProperties)) .OrderBy(BuildSortString(queryOptions.SortColumns)) .Skip(queryOptions.Paging.PageSize * (queryOptions.Paging.PageNumber - 1)) .Take(queryOptions.Paging.PageSize).ToList(); if (_groupPrivilegesList == null) { return(new questStatus(Severity.Warning)); } groupPrivilegeList = new List <GroupPrivilege>(); foreach (Quest.Services.Dbio.FMS.GroupPrivileges _groupPrivileges in _groupPrivilegesList) { GroupPrivilege groupPrivilege = new GroupPrivilege(); BufferMgr.TransferBuffer(_groupPrivileges, groupPrivilege); groupPrivilegeList.Add(groupPrivilege); } status = BuildQueryResponse(_groupPrivilegesList.Count, queryOptions, out queryResponse); if (!questStatusDef.IsSuccess(status)) { return(status); } } catch (System.Exception ex) { return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.InnerException != null ? ex.InnerException.Message : ex.Message))); } } } return(new questStatus(Severity.Success)); }
public questStatus Create(DbMgrTransaction trans, GroupPrivilege groupPrivilege, out GroupPrivilegeId groupPrivilegeId) { // Initialize questStatus status = null; groupPrivilegeId = null; // Create groupPrivilege status = _dbGroupPrivilegesMgr.Create(trans, groupPrivilege, out groupPrivilegeId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Update(GroupPrivilege groupPrivilege) { // Initialize questStatus status = null; // Perform update. using (FMSEntities dbContext = new FMSEntities()) { status = update(dbContext, groupPrivilege); if (!questStatusDef.IsSuccess(status)) { return(status); } } return(new questStatus(Severity.Success)); }
public static GroupPrivilege GetUserPrivilegeForGroup(int groupId, int userId, string appType) { var groupPrivilege = new GroupPrivilege(); var sql = "SELECT * FROM " + TblGroupsForUsers + " WHERE UserID = '" + userId + "' AND AppType = '" + appType + "' ; COMMIT;"; var reader = GetReader(sql); if (reader != null) { while (reader.Read()) { Enum.TryParse(reader.GetString(8), out groupPrivilege); } reader.Close(); } return(groupPrivilege); }
public questStatus Create(DbMgrTransaction trans, GroupPrivilege groupPrivilege, out GroupPrivilegeId groupPrivilegeId) { // Initialize questStatus status = null; groupPrivilegeId = null; // Data rules. groupPrivilege.Created = DateTime.Now; // Create the groupPrivilege in this transaction. status = create((FMSEntities)trans.DbContext, groupPrivilege, out groupPrivilegeId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Read(DbMgrTransaction trans, GroupPrivilegeId groupPrivilegeId, out GroupPrivilege groupPrivilege) { // Initialize questStatus status = null; groupPrivilege = null; // Perform read Quest.Services.Dbio.FMS.GroupPrivileges _groupPrivileges = null; status = read((FMSEntities)trans.DbContext, groupPrivilegeId, out _groupPrivileges); if (!questStatusDef.IsSuccess(status)) { return(status); } groupPrivilege = new GroupPrivilege(); BufferMgr.TransferBuffer(_groupPrivileges, groupPrivilege); return(new questStatus(Severity.Success)); }
private void ui_listBox_groups_SelectedIndexChanged(object sender, EventArgs e) { //ui_listBox_symbolsInGroup.Items.Clear(); ui_buttonX_delGroup.Enabled = true; ui_buttonX_editGroup.Enabled = true; ui_buttonX_join.Enabled = true; if (ui_listBox_groups.SelectedItems.Count <= 0) { return; } var privilege = new GroupPrivilege(); int groupId = 0; for (int i = 0; i < ui_listBox_groups.SelectedItems.Count; i++) { var groupName = ui_listBox_groups.SelectedItems[i].ToString(); groupId = _groups.Find(a => a.GroupName == groupName).GroupId; privilege = ClientDatabaseManager.GetUserPrivilegeForGroup(groupId, _userID, ApplicationType.DataNet.ToString()); if (privilege != GroupPrivilege.Creator) { ui_buttonX_delGroup.Enabled = false; ui_buttonX_editGroup.Enabled = false; ui_buttonX_join.Enabled = false; } } /* * if (ui_listBox_groups.SelectedItems.Count == 1 && privilege != GroupPrivilege.UseGroup) * { * var symbolsForCurrGroup = DatabaseManager.GetSymbolsInGroup(groupId); * * foreach (var symbolModel in symbolsForCurrGroup) * { * ui_listBox_symbolsInGroup.Items.Add(symbolModel.SymbolName); * } * }*/ }
/*================================================================================================================================== * Properties *=================================================================================================================================*/ #endregion #region Public Methods /*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus Create(GroupPrivilege groupPrivilege, out GroupPrivilegeId groupPrivilegeId) { // Initialize questStatus status = null; groupPrivilegeId = null; // Data rules. groupPrivilege.Created = DateTime.Now; // Create the groupPrivilege using (FMSEntities dbContext = new FMSEntities()) { status = create(dbContext, groupPrivilege, out groupPrivilegeId); if (!questStatusDef.IsSuccess(status)) { return(status); } } return(new questStatus(Severity.Success)); }
public void PrintNodesRecursive(TreeViewNode oParentNode, int group) { var x = oParentNode.Text; foreach (TreeViewNode SubNode in oParentNode.Nodes) { using (CultureDataContext db = new CultureDataContext()) { foreach (TreeViewNode item in SubNode.Nodes) { if (item.Checked) { if (item.Text == "عرض") { var optionsByPage = db.SystemPageFunctions.FirstOrDefault(p => p.SystemPageFunction_PageID.Equals(Convert.ToInt32(SubNode.Name.Replace('p', ' ').Trim())) && p.SystemPageFunction_FunctionID == (int)FunctionsEnum.Show); GroupPrivilege a = new GroupPrivilege { GroupPrivilege_PageFunctionID = optionsByPage.SystemPageFunction_ID, GroupPrivilege_GroupID = group }; db.GroupPrivileges.InsertOnSubmit(a); } else if (item.Text == "اضافة") { var optionsByPage = db.SystemPageFunctions.FirstOrDefault(p => p.SystemPageFunction_PageID.Equals(Convert.ToInt32(SubNode.Name.Replace('p', ' ').Trim())) && p.SystemPageFunction_FunctionID == (int)FunctionsEnum.Add); GroupPrivilege a = new GroupPrivilege { GroupPrivilege_PageFunctionID = optionsByPage.SystemPageFunction_ID, GroupPrivilege_GroupID = group }; db.GroupPrivileges.InsertOnSubmit(a); } else if (item.Text == "تعديل") { var optionsByPage = db.SystemPageFunctions.FirstOrDefault(p => p.SystemPageFunction_PageID.Equals(Convert.ToInt32(SubNode.Name.Replace('p', ' ').Trim())) && p.SystemPageFunction_FunctionID == (int)FunctionsEnum.Edit); GroupPrivilege a = new GroupPrivilege { GroupPrivilege_PageFunctionID = optionsByPage.SystemPageFunction_ID, GroupPrivilege_GroupID = group }; db.GroupPrivileges.InsertOnSubmit(a); } else if (item.Text == "حذف") { var optionsByPage = db.SystemPageFunctions.FirstOrDefault(p => p.SystemPageFunction_PageID.Equals(Convert.ToInt32(SubNode.Name.Replace('p', ' ').Trim())) && p.SystemPageFunction_FunctionID == (int)FunctionsEnum.Delete); GroupPrivilege a = new GroupPrivilege { GroupPrivilege_PageFunctionID = optionsByPage.SystemPageFunction_ID, GroupPrivilege_GroupID = group }; db.GroupPrivileges.InsertOnSubmit(a); } else if (item.Text == "فهرسة") { var optionsByPage = db.SystemPageFunctions.FirstOrDefault(p => p.SystemPageFunction_PageID.Equals(Convert.ToInt32(SubNode.Name.Replace('p', ' ').Trim())) && p.SystemPageFunction_FunctionID == (int)FunctionsEnum.Index); GroupPrivilege a = new GroupPrivilege { GroupPrivilege_PageFunctionID = optionsByPage.SystemPageFunction_ID, GroupPrivilege_GroupID = group }; db.GroupPrivileges.InsertOnSubmit(a); } } } db.SubmitChanges(); } } ++z; if (z < tvPermissions.Nodes.Count) { TreeViewNode MainNode = tvPermissions.Nodes[z]; PrintNodesRecursive(MainNode, group); } }
public static GroupPrivilege GetUserPrivilegeForGroup(int groupId, int userId, string appType) { var groupPrivilege = new GroupPrivilege(); var sql = "SELECT * FROM " + TblGroupsForUsers + " WHERE UserID = '" + userId + "' AND AppType = '" + appType + "' AND GroupID = " + groupId + " ; COMMIT;"; var reader = GetReader(sql); if (reader != null) { while (reader.Read()) { Enum.TryParse(reader.GetString(8), out groupPrivilege); } reader.Close(); } return groupPrivilege; }
public GroupPrivilegeDTO MapGroupPrivilegeToDTO(GroupPrivilege groupPrivilege) { var mappedDTO = AutoMapper.Mapper.Map <GroupPrivilegeDTO>(groupPrivilege); return(mappedDTO); }
private void ui_listBox_groups_SelectedIndexChanged(object sender, EventArgs e) { ui_listBox_symbolsInGroup.Items.Clear(); ui_buttonX_delGroup.Enabled = true; ui_buttonX_editGroup.Enabled = true; ui_buttonX_join.Enabled = true; if (ui_listBox_groups.SelectedItems.Count <= 0) return; var privilege = new GroupPrivilege(); int groupId = 0; for (int i = 0; i < ui_listBox_groups.SelectedItems.Count; i++) { var groupName = ui_listBox_groups.SelectedItems[i].ToString(); groupId = _groups.Find(a => a.GroupName == groupName).GroupId; privilege = DataNetClientDataManager.GetUserPrivilegeForGroup(groupId, _userID, ApplicationType.DataNet.ToString()); if (privilege != GroupPrivilege.Creator) { ui_buttonX_delGroup.Enabled = false; ui_buttonX_editGroup.Enabled = false; ui_buttonX_join.Enabled = false; } } if (ui_listBox_groups.SelectedItems.Count == 1 && privilege != GroupPrivilege.UseGroup) { var symbolsForCurrGroup = DataNetClientDataManager.GetSymbolsInGroup(groupId); foreach (var symbolModel in symbolsForCurrGroup) { ui_listBox_symbolsInGroup.Items.Add(symbolModel.SymbolName); } } }