public bool UpdateBoard(BoardsDto board)
{
using (var db = GetConnection())
{
var result = db.Execute(@"update boards
Set [Title] = @title
,[DescriptionFromUser] = @DescriptionFromUser
Where id = @id", board);
return(result == 1);
}
}
public bool Create(BoardsDto board)
{
using (var db = GetConnection())
{
db.Open();
var records = db.Execute(@"INSERT INTO [dbo].[Board]
([Name]
,[PropertyId])
VALUES
(@Name
,@PropertyId)", board);
return(records == 1);
}
}
public BoardsDto AddNewBoard(BoardsDto input)
{
using (var db = GetConnection())
{
db.Open();
var result = db.Execute(@"Insert into boards
([Title]
,[DescriptionFromUser])
Values
(@Title
,@DescriptionFromUser)", input);
var createdBoard = db.QueryFirstOrDefault <BoardsDto>(@"select
top 1 *
from boards
order by Id DESC");
return(createdBoard);
}
}
public bool Put([FromBody] BoardsDto board)
{
return(_repo.UpdateBoard(board));
}
public BoardsDto Post([FromBody] BoardsDto input)
{
return(_repo.AddNewBoard(input));
}
