public List <RoleWisePermission> RoleWisePermission_GetAll() { DbDataReader oDbDataReader = null; try { List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>(); DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetAll", CommandType.StoredProcedure); oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand); while (oDbDataReader.Read()) { RoleWisePermission oRoleWisePermission = new RoleWisePermission(); BuildEntity(oDbDataReader, oRoleWisePermission); lstRoleWisePermission.Add(oRoleWisePermission); } return(lstRoleWisePermission); } catch (Exception ex) { throw ex; } finally { if (!oDbDataReader.IsClosed) { oDbDataReader.Close(); oDbDataReader.Dispose(); } } }
private void cmbRole_SelectedValueChanged(object sender, EventArgs e) { if (cmbRole.SelectedIndex > -1 && FirstLoadDone) { List <RoleWisePermission> lst = new RoleWisePermissionDAO().RoleWisePermission_GetByRoleId(Convert.ToInt32(cmbRole.SelectedValue)); foreach (DataGridViewRow row in dgvPageList.Rows) { int pageId = Convert.ToInt32(row.Cells["cPageId"].Value); if (lst.Count > 0) { RoleWisePermission rwp = lst.Where(p => p.PageId == pageId).FirstOrDefault(); if (rwp != null) { row.Cells[0].Value = rwp.PermissionId; row.Cells[1].Value = rwp.PageId; row.Cells[3].Value = rwp.CanSelect; } else { row.Cells[0].Value = 0; row.Cells[1].Value = pageId; row.Cells[3].Value = false; } } else { row.Cells[0].Value = 0; row.Cells[1].Value = pageId; row.Cells[3].Value = false; } } } }
public RoleWisePermission RoleWisePermission_GetById(Int64 PermissionId) { DbDataReader oDbDataReader = null; try { RoleWisePermission oRoleWisePermission = new RoleWisePermission(); DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetById", CommandType.StoredProcedure); AddParameter(oDbCommand, "@PermissionId", DbType.Int64, PermissionId); oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand); while (oDbDataReader.Read()) { BuildEntity(oDbDataReader, oRoleWisePermission); } return(oRoleWisePermission); } catch (Exception ex) { throw ex; } finally { if (!oDbDataReader.IsClosed) { oDbDataReader.Close(); oDbDataReader.Dispose(); } } }
public List <RoleWisePermission> RoleWisePermission_GetDynamic(string WhereCondition, string OrderByExpression) { DbDataReader oDbDataReader = null; try { List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>(); DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetDynamic", CommandType.StoredProcedure); AddParameter(oDbCommand, "@WhereCondition", DbType.String, WhereCondition); AddParameter(oDbCommand, "@OrderByExpression", DbType.String, OrderByExpression); oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand); while (oDbDataReader.Read()) { RoleWisePermission oRoleWisePermission = new RoleWisePermission(); BuildEntity(oDbDataReader, oRoleWisePermission); lstRoleWisePermission.Add(oRoleWisePermission); } return(lstRoleWisePermission); } catch (Exception ex) { throw ex; } finally { if (!oDbDataReader.IsClosed) { oDbDataReader.Close(); oDbDataReader.Dispose(); } } }
private void btnSave_Click(object sender, EventArgs e) { if (cmbRole.SelectedIndex > -1) { foreach (DataGridViewRow row in dgvPageList.Rows) { RoleWisePermission rwp = new RoleWisePermission(); rwp.PermissionId = Convert.ToInt32(row.Cells[0].Value); rwp.RoleId = Convert.ToInt32(cmbRole.SelectedValue); rwp.PageId = Convert.ToInt32(row.Cells[1].Value); rwp.CanSelect = Convert.ToBoolean(row.Cells[3].Value); rwp.AssignedBy = MDIParent.userId; rwp.CompanyId = 1; if (rwp.PermissionId == 0) { new RoleWisePermissionDAO().Add(rwp); } else { new RoleWisePermissionDAO().Update(rwp); } } ClearControls(); MessageBox.Show("Saved Successfully.", "POSsible"); } else { if (cmbRole.SelectedIndex < 0) { MessageBox.Show("Please select Role."); return; } } }
public IActionResult RoleWisePermission([FromBody] RoleWisePermissionCommon permission) { if (!ModelState.IsValid) { return(StatusCode(400)); } try { //first delete RoleWisePermission oldPermission = _context.RoleWisePermission.FirstOrDefault(x => x.RoleId == permission.roleWiseUserPermission.RoleId); if (oldPermission != null) { _context.RoleWisePermission.Remove(oldPermission); } List <RoleWiseMenuPermission> oldMenuPermission = _context.RoleWiseMenuPermission.Where(x => x.RoleId == permission.roleWiseMenuPermissions.FirstOrDefault().RoleId).ToList(); if (oldMenuPermission != null) { _context.RoleWiseMenuPermission.RemoveRange(oldMenuPermission); } //then add _context.RoleWisePermission.Add(permission.roleWiseUserPermission); _context.RoleWiseMenuPermission.AddRange(permission.roleWiseMenuPermissions); //finally save all changes _context.SaveChanges(); TempData["StatusMessage"] = "Saved Successfully !!"; return(Ok(permission.roleWiseUserPermission.RoleId)); } catch { ModelState.AddModelError("Error", "Error occour, try again later !!"); return(StatusCode(500)); } }
public IHttpActionResult UpdateRolePermission([FromBody] RoleWisePermission rolePermission) { DataBind data = activities.SaveUpdateRolePermission(rolePermission); AuditTrialReport.SaveAuditReport(User.Identity.Name, "Update", data.dataBefore, data.dataAfter); return(Ok("Successfully updated Role Permission")); }
private static void BuildEntity(DbDataReader oDbDataReader, RoleWisePermission oRoleWisePermission) { DataTable dt = oDbDataReader.GetSchemaTable(); foreach (DataRow item in dt.Rows) { string col = item.ItemArray[0].ToString(); switch (col) { case "PermissionId": oRoleWisePermission.PermissionId = Convert.ToInt64(oDbDataReader["PermissionId"]); break; case "RoleId": oRoleWisePermission.RoleId = Convert.ToInt32(oDbDataReader["RoleId"]); break; case "PageId": oRoleWisePermission.PageId = Convert.ToInt32(oDbDataReader["PageId"]); break; case "CanCreate": oRoleWisePermission.CanCreate = Convert.ToBoolean(oDbDataReader["CanCreate"]); break; case "CanDelete": oRoleWisePermission.CanDelete = Convert.ToBoolean(oDbDataReader["CanDelete"]); break; case "CanUpdate": oRoleWisePermission.CanUpdate = Convert.ToBoolean(oDbDataReader["CanUpdate"]); break; case "CanSelect": oRoleWisePermission.CanSelect = Convert.ToBoolean(oDbDataReader["CanSelect"]); break; case "AssignedBy": oRoleWisePermission.AssignedBy = Convert.ToInt32(oDbDataReader["AssignedBy"]); break; case "CompanyId": oRoleWisePermission.CompanyId = Convert.ToInt32(oDbDataReader["CompanyId"]); break; default: break; } } }
public int Update(RoleWisePermission _RoleWisePermission) { try { DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_Update", CommandType.StoredProcedure); AddParameter(oDbCommand, "@RoleId", DbType.Int32, _RoleWisePermission.RoleId); AddParameter(oDbCommand, "@PageId", DbType.Int32, _RoleWisePermission.PageId); AddParameter(oDbCommand, "@CanCreate", DbType.Boolean, _RoleWisePermission.CanCreate); AddParameter(oDbCommand, "@CanDelete", DbType.Boolean, _RoleWisePermission.CanDelete); AddParameter(oDbCommand, "@CanUpdate", DbType.Boolean, _RoleWisePermission.CanUpdate); AddParameter(oDbCommand, "@CanSelect", DbType.Boolean, _RoleWisePermission.CanSelect); AddParameter(oDbCommand, "@AssignedBy", DbType.Int32, _RoleWisePermission.AssignedBy); AddParameter(oDbCommand, "@CompanyId", DbType.Int32, _RoleWisePermission.CompanyId); AddParameter(oDbCommand, "@PermissionId", DbType.Int64, _RoleWisePermission.PermissionId); return(DbProviderHelper.ExecuteNonQuery(oDbCommand)); } catch (Exception ex) { throw ex; } }
public List <RoleWisePermission> RoleWisePermission_GetPaged(int StartRowIndex, int RowPerPage, string WhereClause, string SortColumn, string SortOrder, ref int rows) { DbDataReader oDbDataReader = null; try { List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>(); DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetPaged", CommandType.StoredProcedure); AddParameter(oDbCommand, "@StartRowIndex", DbType.Int32, StartRowIndex); AddParameter(oDbCommand, "@RowPerPage", DbType.Int32, RowPerPage); AddParameter(oDbCommand, "@WhereClause", DbType.String, WhereClause); AddParameter(oDbCommand, "@SortColumn", DbType.String, SortColumn); AddParameter(oDbCommand, "@SortOrder", DbType.String, SortOrder); oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand); while (oDbDataReader.Read()) { RoleWisePermission oRoleWisePermission = new RoleWisePermission(); BuildEntity(oDbDataReader, oRoleWisePermission); lstRoleWisePermission.Add(oRoleWisePermission); } if ((oDbDataReader.NextResult()) && (oDbDataReader.Read())) { rows = oDbDataReader.GetInt32(0); } return(lstRoleWisePermission); } catch (Exception ex) { throw ex; } finally { if (!oDbDataReader.IsClosed) { oDbDataReader.Close(); oDbDataReader.Dispose(); } } }
public DataBind SaveUpdateRolePermission(RoleWisePermission rolePermissionList) { var RoleObject = db.Roles.Where(s => s.Id == rolePermissionList.RoleId).FirstOrDefault(); if (RoleObject.AspNetRoles.Any()) { List <string> access = new List <string>(); foreach (var rolePermission in RoleObject.AspNetRoles.ToList()) { RoleObject.AspNetRoles.Remove(rolePermission); access.Add(rolePermission.Name); } var data1 = new { RoleName = RoleObject.RoleName, AccessList = access.ToArray() }; dataBind.dataBefore = JsonConvert.SerializeObject(data1); } List <string> access1 = new List <string>(); foreach (var Role in rolePermissionList.PermissionList.Distinct()) { RoleObject.AspNetRoles.Add(db.AspNetRoles.Where(p => p.Id == Role.Id).FirstOrDefault()); access1.Add(Role.Name); } var data2 = new { RoleName = RoleObject.RoleName, AccessList = access1.ToArray() }; dataBind.dataAfter = JsonConvert.SerializeObject(data2); db.SaveChanges(); db.Dispose(); return(dataBind); }
public IHttpActionResult SaveRolePermission([FromBody] RoleWisePermission rolePermission) { activities.SaveUpdateRolePermission(rolePermission); return(Ok("Successfully added Role Permission")); }