public RoleNRightManagementController() { _mainMenuBAL = new MainMenuBAL(); _roleBAL = new RolesBAL(); _rolesNRightsBAL = new RolesNRightsBAL(); _manageRoleNRightsViewModel = new ManageRoleNRightsViewModel(); result = new Result(); }
public ActionResult SaveRoleNRights(ManageRoleNRightsViewModel manageRoleNRightsViewModel) { result = _rolesNRightsBAL.SaveRoleNRights(manageRoleNRightsViewModel); return(RedirectToAction("ManageRoleNRights", new { RoleID = manageRoleNRightsViewModel.RoleID })); }
public Result SaveRoleNRights(ManageRoleNRightsViewModel manageRoleNRightsViewModel) { Result result = new Result(); DBOperations dbOps = new DBOperations(); try { foreach (var item in manageRoleNRightsViewModel.RolesNRightsViewMdoels) { int res; NpgsqlParameter[] aParams1 = new NpgsqlParameter[1]; aParams1[0] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer); aParams1[0].Value = item.RNRID; long count = (long)dbOps.ExecuteScalar(AppConstants.QueryConstants.CheckRolesNRights, aParams1); if (count > 0) { NpgsqlParameter[] aParams = new NpgsqlParameter[6]; aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer); aParams[0].Value = manageRoleNRightsViewModel.RoleID; aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer); aParams[1].Value = item.ActionID; aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean); aParams[2].Value = item.IsActive; aParams[3] = new NpgsqlParameter("LastModifiedBy", NpgsqlTypes.NpgsqlDbType.Integer); aParams[3].Value = 0; aParams[4] = new NpgsqlParameter("LastModifiedOn", NpgsqlTypes.NpgsqlDbType.Date); aParams[4].Value = DateTime.Now; aParams[5] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer); aParams[5].Value = item.RNRID; res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateRolesNRights, aParams); } else { NpgsqlParameter[] aParams = new NpgsqlParameter[5]; aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer); aParams[0].Value = manageRoleNRightsViewModel.RoleID; aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer); aParams[1].Value = item.ActionID; aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean); aParams[2].Value = item.IsActive; aParams[3] = new NpgsqlParameter("CreatedBy", NpgsqlTypes.NpgsqlDbType.Integer); aParams[3].Value = 0; aParams[4] = new NpgsqlParameter("CreatedOn", NpgsqlTypes.NpgsqlDbType.Date); aParams[4].Value = DateTime.Now; res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddRolesNRights, aParams); } if (res > 0) { result.Status = Status.Success; result.Values = res.ToString(); } else { result.Status = Status.Failure; } } } catch (Exception Ex) { dbOps.Abort(); result.Status = Status.Failure; } return(result); }