public void Bnsubmit_Click(object sender, RoutedEventArgs e)
{
Lbstatus.Content = "";
if (TbUID.Text.ToString() != "" || Tbquantity.Text.ToString() != "")
{
UID uid = new UID();
uid.Uid = TbUID.Text.Replace('/', '-');
if (CbQuantityOff.IsChecked == true)
{
uid.Quantity = "0";
}
uid.Quantity = Tbquantity.Text.Replace(',', '.');
uid.Source = System.Configuration.ConfigurationManager.AppSettings["Source"];
uid.Event_date_UMS = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds().ToString();
Lbstatus.Content = SQLiteDBConnection.UpSert(uid);
if (Lbstatus.Content.ToString().StartsWith("Row added, UID: "))
{
TbUID.Text = "";
Tbquantity.Text = "0";
TbUID.Focus();
}
}
else
{
Lbstatus.Content = "UID is empty";
logger.Info("UID is empty");
TbUID.Focus();
}
}
public void TestUpsert()
{
UID uid = new UID();
uid.Uid = "79879";
uid.Quantity = "10";
uid.Source = "source";
uid.Event_date_UMS = "576540000";
string status = SQLiteDBConnection.UpSert(uid);
string status2 = SQLiteDBConnection.StartTrigger();
Assert.AreEqual("Row added", status);
Assert.AreEqual("Entry date updated", status2);
}
