public void InsertLocation(Entities.Location entity)
{
_dbConnection.Execute("INSERT INTO Location VALUES(@Id, @Name, @Path, @Image, @Index)",
new
{
Id = entity.Id,
Name = entity.Name,
Path = entity.Path,
Image = entity.Image,
Index = entity.Index
});
}
public void UpdateLocation(Entities.Location entity)
{
_dbConnection.Execute(
"UPDATE Location SET Name = @Name, Path = @Path, Image = @Image, [Index] = @Index WHERE Id = @Id",
new
{
Id = entity.Id,
Name = entity.Name,
Path = entity.Path,
Image = entity.Image,
Index = entity.Index
});
}