//public void private void TripAdd_Load(object sender, EventArgs e) { checkBox1.Checked = Properties.Settings.Default.showcontent; if (checkBox1.Checked) { amount.PasswordChar = '\0'; other.PasswordChar = '\0'; } else { amount.PasswordChar = '*'; other.PasswordChar = '*'; } if (!isNew) { return; } SQLiteConnection scn = new SQLiteConnection(@"data source = main.db"); customername.Items.AddRange(Sqlite.LoadClients()); scn.Open(); SQLiteCommand sq; sq = new SQLiteCommand("select seq from sqlite_sequence where name='Trips'", scn); int lastid = Convert.ToInt32(sq.ExecuteScalar()); invoiceno.Text = (lastid + 1).ToString(); scn.Close(); }
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(); }
private void RecevingsAdd_Load(object sender, EventArgs e) { payer.Items.AddRange(Sqlite.LoadClients()); }
private void Recevings_Load(object sender, EventArgs e) { payer.Items.Add("-"); payer.Items.AddRange(Sqlite.LoadClients()); payer.SelectedIndex = 0; }
private void Bill_Load(object sender, EventArgs e) { clientname.Items.AddRange(Sqlite.LoadClients()); }
private void Trips_Load(object sender, EventArgs e) { clientname.Items.AddRange(Sqlite.LoadClients()); clientname.SelectedIndex = 0; }