public static void UpdateOrder(UpdateOrder u)
 {
     using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
     {
         cnn.Execute("update Orders set status = @status where ID = @ID", u);
     }
 }
Example #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     if ((string)orderListBox.SelectedItem != "")
     {
         UpdateOrder u = new UpdateOrder();
         u.ID     = orderListBox.SelectedIndex;
         u.status = "Completed";
         DataBase.UpdateOrder(u);
         FillOrderData();
         RefreshOrderList();
     }
     else
     {
         MessageBox.Show("Please select not completed order at first!");
     }
 }