public void Update(AliasSession session)
{
var sql = @"
update alias_session
set
name = @name,
notes = @notes
where id = @id";
using (var c = BuildConnection())
{
c.Execute(sql, new { session.Id, session.Name, session.Notes });
}
}
public void Delete(AliasSession session)
{
using (var c = BuildConnection())
{
var queries = new string[]
{
@"delete from alias_session where id = @id",
@"delete from alias where id_session = @id"
};
foreach (var sql in queries)
{
c.Execute(sql, new { session.Id });
}
}
}
public void Create(AliasSession session)
{
if (session == null)
{
return;
}
var sql = @"
insert into alias_session (
name,
notes
) values (
@name,
@notes
)";
using (var c = BuildConnection())
{
c.Execute(sql, new { name = session.Name, notes = session.Notes });
}
}
public static AliasSessionModel AsModel(this AliasSession src) => Mapper.Map <AliasSession, AliasSessionModel>(src);
