public void Update(Role role)
{
using (var conn = db.GetOpenConnection())
{
conn.Execute(@"UPDATE Role SET Name = @name WHERE RoleID = @id", new { name = role.Name, id = role.Id });
}
}
public int Insert(Role role)
{
using(var conn = db.GetOpenConnection())
{
return conn.Execute(@"INSERT INTO Role (Name) VALUES (@name)", new {name = role.Name });
}
}
public Role GetRoleByName(string roleName)
{
var roleId = GetRoleId(roleName);
Role role = null;
if (roleId > 0)
{
role = new Role(roleName, roleId);
}
return role;
}
public void Delete(Role role)
{
throw new NotImplementedException();
}
public User()
{
Role = new Role();
}
