private async Task ImportCarb(Carb carb, SQLiteConnection conn)
{
await ExecuteNonQuery("INSERT INTO carb(time,amount,import_id) VALUES(@t, @a, @i)",
new []
{
GetParameter("t", carb.Time),
GetParameter("a", carb.Amount),
GetParameter("i", carb.ImportId),
}, conn);
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUnit != -1)
{
str += "&idunit=\"" + IDUnit.ToString() + "\"";
}
if (IDServerMeal != -1)
{
str += "&idmeal=\"" + IDServerMeal.ToString() + "\"";
}
if (IDUser != 0)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (Calories != -1)
{
str += "&calories=\"" + Calories.ToString() + "\"";
}
if (Protein != -1)
{
str += "&protein=\"" + Protein.ToString() + "\"";
}
if (Carb != -1)
{
str += "&carb=\"" + Carb.ToString() + "\"";
}
if (Fat != -1)
{
str += "&fat=\"" + Fat.ToString() + "\"";
}
if (SatFat != -1)
{
str += "&satfat=\"" + SatFat.ToString() + "\"";
}
if (UnSatFat != -1)
{
str += "&unsatfat=\"" + UnSatFat.ToString() + "\"";
}
if (Cholesterol != -1)
{
str += "&cholesterol=\"" + Cholesterol.ToString() + "\"";
}
if (Sugar != -1)
{
str += "&sugar=\"" + Sugar.ToString() + "\"";
}
if (Natrium != -1)
{
str += "&natrium=\"" + Natrium.ToString() + "\"";
}
if (Potassium != -1)
{
str += "&potassium=\"" + Potassium.ToString() + "\"";
}
if (Fiber != -1)
{
str += "&fiber=\"" + Fiber.ToString() + "\"";
}
if (Deleted != -1)
{
str += "&deleted=\"" + Deleted.ToString() + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
