private void button3_Click(object sender, EventArgs e)
{
if (int.Parse(listView1.SelectedItems[0].SubItems[6].Text) > Sqlite.ClientBalance(listView1.SelectedItems[0].SubItems[1].Text))
{
MessageBox.Show("Not enough balance");
return;
}
SQLiteConnection scn = new SQLiteConnection(@"data source = main.db");
scn.Open();
SQLiteCommand sq;
sq = new SQLiteCommand("update Trips set Status='Paid' where Tripno = '" + listView1.SelectedItems[0].Text + "'", scn);
sq.ExecuteNonQuery();
filter.PerformClick();
}
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 button6_Click(object sender, EventArgs e)
{
Sqlite.ExportToExcel(listView1);
}
private void listView1_ColumnClick(object sender, ColumnClickEventArgs e)
{
Sqlite.ColumnSorter(e.Column, listView1);
}
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 button6_Click(object sender, EventArgs e)
{
Sqlite.ExportToExcel(truckdetails);
}
private void Trips_Load(object sender, EventArgs e)
{
clientname.Items.AddRange(Sqlite.LoadClients());
clientname.SelectedIndex = 0;
}
private void button2_Click_1(object sender, EventArgs e)
{
MessageBox.Show(Sqlite.ClientBalance(clientname.Text).ToString());
}