// Update ChoresList
public bool UpdateChoresList(BaseChoresList ChoresList)
{
using (var db = _db.GetConnection())
{
var sql = db.Execute(@"UPDATE [dbo].[ChoresList]
SET [dateAssigned] = @DateAssigned
,[completed] = @completed
,[assignedBy] = @assignedBy
,[assignedTo] = @assignedTo
,[type] = @type
,[familyId] = @familyId
WHERE ChoresList.id = @id", ChoresList);
return(sql == 1);
}
}
// Post new ChoresList
public async Task <BaseChoresList> PostChoresList(BaseChoresList BaseChoresList)
{
using (var db = _db.GetConnection())
{
return(await db.QueryFirstOrDefaultAsync <BaseChoresList>(@"
INSERT INTO [dbo].[ChoresList]
(
[dateAssigned]
,[dateDue]
,[completed]
,[assignedTo]
,[assignedBy]
,[type]
,[familyId])
VALUES
(@dateAssigned
,@dateDue
,@completed
,@assignedTo
,@assignedBy
,@type
,@familyId)", BaseChoresList));
}
}
public async Task <ActionResult <ChoresList> > PostChoresList(BaseChoresList BaseChoresList)
{
return(Ok(await _ChoresList.PostChoresList(BaseChoresList)));
}
public IActionResult UpdateChoresList(BaseChoresList ChoresList)
{
var ChoresLists = _ChoresList.UpdateChoresList(ChoresList);
return(Ok());
}
