Esempio n. 1
0
        private void listView1_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            TripAdd          tadd = new TripAdd();
            SQLiteConnection scn  = new SQLiteConnection(@"data source = main.db");

            scn.Open();
            SQLiteCommand sq;

            sq = new SQLiteCommand("select * from Trips where Tripno = '" + listView1.SelectedItems[0].Text + "'", scn);
            SQLiteDataReader dr = sq.ExecuteReader();

            tadd.truckdetails.Items.Clear();
            while (dr.Read())
            {
                tadd.isNew          = false;
                tadd.invoiceno.Text = listView1.SelectedItems[0].Text;
                tadd.customername.Items.AddRange(Sqlite.LoadClients());
                tadd.customername.Text    = dr["Name"].ToString();
                tadd.from.Text            = dr["Froom"].ToString();
                tadd.to.Text              = dr["Tao"].ToString();
                tadd.comments.Text        = dr["Comments"].ToString();
                tadd.dateTimePicker1.Text = dr["Date"].ToString();
                tadd.status       = dr["Status"].ToString();
                tadd.Qty.Text     = dr["Qty"].ToString();
                tadd.amount.Text  = dr["Amount"].ToString();
                tadd.typebox.Text = dr["Type"].ToString();
                tadd.other.Text   = dr["Other"].ToString();
            }

            sq = new SQLiteCommand("select * from TripDetails where Tripno = '" + listView1.SelectedItems[0].Text + "'", scn);

            dr = sq.ExecuteReader();
            while (dr.Read())
            {
                tadd.truckdetails.Items.Add(new ListViewItem(new[] { dr["Truckno"].ToString(),
                                                                     dr["Weight"].ToString(),
                                                                     dr["Location"].ToString(),
                                                                     dr["Qty"].ToString(),
                                                                     dr["Amount"].ToString() }));
            }
            tadd.ShowTrucksQty();
            tadd.Show();
        }
Esempio n. 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            TripAdd tadd = new TripAdd();

            tadd.Show();
        }