// 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()); }