public void AddPermission(string permissionId) { Data.UserPermissionJoin j = new Data.UserPermissionJoin(); j.UserId = UserId; j.PermissionId = permissionId; j.Insert(); Refresh(); }
public static UserPermissionJoin SelectById(string userId, string permissionId) { UserPermissionJoin result = null; using (DataTable data = new DataTable()) { SqlConnection connection = null; SqlCommand command = null; try { connection = ConnectionFactory.GetConnection(); command = new SqlCommand("SELECT * FROM [" + ConnectionFactory.TableNamePrefix + "UserPermissionJoin] WHERE [UserId] = @UserId, [PermissionId] = @PermissionId", connection); command.Parameters.Add(new SqlParameter("UserId", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, DataUtils.HandleNullables(userId))); command.Parameters.Add(new SqlParameter("PermissionId", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, DataUtils.HandleNullables(permissionId))); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(data); if (data.Rows.Count > 0) result = new UserPermissionJoin(data.Rows[0]); } catch (Exception e) { DataUtils.AddDataToException(ref e, command); throw; } finally { if (connection != null) connection.Close(); } } return result; }