public RoleSearchDocument(Role role)
{
Role = role;
DatabaseID = role.ID;
Title = role.Name;
Description = String.Empty;
Type = "Role";
UniqueID = string.Format("{0}_{1}", Type, role.ID);
}
public bool Create(Role role)
{
using (var cn = Connection)
{
const string sql = "INSERT INTO `roles` (`Name`) VALUES (@name);";
var success = cn.Execute(sql, new { name = role.Name }) > 0;
return success;
}
}
public bool Update(Role role)
{
using (var cn = Connection)
{
const string sql = "UPDATE `roles` SET `Name`= @name WHERE `id` = @id;";
return cn.Execute(sql, new { name = role.Name, id = role.ID }) > 0;
}
}