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