public async Task UpdateCheckBoxResponse(Label_CheckBox checkbox) { if (checkbox != null) { await db.QueryAsync <Label_CheckBox>("UPDATE [CheckBoxLabels] SET Value = ? WHERE CPQID = ? AND QID = ?", checkbox.Value, checkbox.CPQID, checkbox.QID); Console.WriteLine("\n CPQID:" + checkbox.CPQID + "\n CheckBoxID: " + checkbox.QID + "\n CheckText: " + checkbox.Label + "\n Value: " + checkbox.Value); } else { Console.WriteLine("\n checkbox null"); } }
public async Task DeleteCheckboxResponse(Label_CheckBox checkbox) { await db.QueryAsync <Label_CheckBox>("DELETE FROM [CheckBoxLabels] WHERE CPQID = ? AND QID = ?", checkbox.CPQID, checkbox.QID); }
//------------------- CREATE ------------------------------- /* * Appends the row to the end of the table */ public async Task AppendCheckBoxResponse(Label_CheckBox checkbox) { await db.InsertAsync(checkbox); }