private void btUpdate_Click(object sender, RoutedEventArgs e)
        {
            IdDialog updateId = new IdDialog("Please enter Id of the field you wish to update:");

            if (updateId.ShowDialog() == true)
            {
                giftaidConnection.Update(conn, cbStatus.Text.ToString(), Convert.ToInt32(updateId.Id));
            }
            else
            {
            }
        }
        private void btBarcode_Click(object sender, RoutedEventArgs e)
        {
            IdDialog barcodeId = new IdDialog("Please Enter Id of Barcode You wish to generate:");

            try
            {
                Barcode_Generator giftaidBarcodeGenerator = new Barcode_Generator();
                if (File.Exists("Connection.xml"))
                {
                    conn = giftaidConnection.CreateConn("Connection.xml");
                }

                Barcode giftaidBarcode = new Barcode()
                {
                    IncludeLabel   = true,
                    Alignment      = AlignmentPositions.CENTER,
                    LabelPosition  = LabelPositions.BOTTOMCENTER,
                    Width          = 150,
                    Height         = 150,
                    RotateFlipType = RotateFlipType.RotateNoneFlipNone,
                    BackColor      = Color.White,
                    ForeColor      = Color.Black,
                };

                DataSet   ds = new DataSet();
                DataTable dt = new DataTable();

                if (barcodeId.ShowDialog() == true)
                {
                    giftaidConnection.OpenConn(conn);
                    string            sql = "SELECT * FROM giftaid WHERE ID = " + barcodeId.Id + "";
                    NpgsqlDataAdapter da  = new NpgsqlDataAdapter(sql, conn);
                    ds.Reset();
                    da.Fill(ds);
                    dt = ds.Tables[0];

                    giftaidBarcodeGenerator.BarcodePicbox.Image = giftaidBarcode.Encode(TYPE.ITF14, "" + dt.Rows[0][2] + "");
                    giftaidBarcodeGenerator.Show();
                    giftaidConnection.CloseConn(conn);
                }
                else
                {
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Make sure the id of the row entered into the textbox exists in table", "Barcode-Generator", MessageBoxButton.OK, MessageBoxImage.Error);
                giftaidConnection.CloseConn(conn);
            }
        }
        private void btRemove_Click(object sender, RoutedEventArgs e)
        {
            IdDialog removeId = new IdDialog("Please enter Id of the field you wish to remove:");

            if (removeId.ShowDialog() == true)
            {
                try
                {
                    giftaidConnection.Delete(conn, Convert.ToInt32(removeId.Id));
                }
                catch (Exception msg)
                {
                    MessageBox.Show(msg.ToString());
                    giftaidConnection.OpenConn(conn);
                }
            }
        }