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