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