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;
}
