private void Pay_Load(object sender, EventArgs e)
{
tempFileNo = fileno.Text;
tempPayer = payer.Text;
payer.Items.AddRange(Sqlite.LoadClients());
fileno.Items.AddRange(Sqlite.LoadFiles(payer.Text));
//SQLiteConnection scn = new SQLiteConnection(@"data source = main.db");
//scn.Open();
//SQLiteCommand sq = new SQLiteCommand("select received, remarks from pay where fileno = '" + fileno.Text + "' and receivecheck = '1'", scn);
//SQLiteDataReader dr = sq.ExecuteReader();
//while (dr.Read())
//{
// receive.Text = dr["received"].ToString();
// remarks.Text = dr["remarks"].ToString();
//}
//scn.Close();
}
private void ReceivingServices_Load(object sender, EventArgs e)
{
fileno.Items.AddRange(Sqlite.LoadFiles());
payer.Items.AddRange(Sqlite.LoadClients());
}
private void payer_SelectedIndexChanged(object sender, EventArgs e)
{
fileno.Items.AddRange(Sqlite.LoadFiles(payer.Text));
}
private void OfficePay_Load(object sender, EventArgs e)
{
payer.Items.AddRange(Sqlite.LoadClients());
fileno.Items.AddRange(Sqlite.LoadFiles());
}