public async Task UpdateTextResponse(Label_TextResponse textResponse)
{
if (textResponse != null)
{
await db.QueryAsync <Label_TextResponse>("UPDATE [TextResponseLabels] SET Label = ? WHERE CPQID = ? AND QID = ?",
textResponse.Label, textResponse.CPQID, textResponse.QID);
Console.WriteLine("\n CPQID:" + textResponse.CPQID + "\n textResponseID: " + textResponse.CPQID + "\n Text: " + textResponse.QID);
}
else
{
Console.WriteLine("\n textbox null");
}
}
public async Task DeleteTextResponse(Label_TextResponse textResponse)
{
await db.QueryAsync <Label_TextResponse>("DELETE FROM [TextResponseLabels] WHERE CPQID = ? AND QID = ?",
textResponse.CPQID, textResponse.QID);
}
public async Task AppendTextResponse(Label_TextResponse textResponse)
{
await db.InsertAsync(textResponse);
}