public void Delete(int id)
{
using (SqlHelper sqlh = new SqlHelper(@"
delete from Access.role
where role = @Id"))
{
sqlh.ExecNoQuery();
}
}
/// <summary>
/// Добавляет подроль.
/// </summary>
/// <param name="owner_id">Идентификатор роли.</param>
/// <param name="offer_id">Идентификатор подроли.</param>
public void CreateMemberRole(int owner_id, int offer_id)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
insert into Access.role_member
(
role_owner,
role_offer
)
values
(
@owner_id,
@offer_id
)", new {owner_id, offer_id});
}
}
public void Update(RoleItem role)
{
using (SqlHelper sqlh = new SqlHelper(@"
update Access.role
set
code = @Code,
mem = @Mem
where role = @Id"))
{
sqlh.AddWithValue("@Id", role.Id);
sqlh.AddWithValue("@Code", role.Code);
sqlh.AddWithValue("@Mem", role.Mem);
sqlh.ExecNoQuery();
}
}
/// <summary>
/// Обновляет данные по роли.
/// </summary>
/// <param name="role">Роль.</param>
public void Update(RoleItem role)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
update Access.role
set
code = @Code,
mem = @Mem
where role = @Id", role);
}
}
