private void dtAccount_CellClick(object sender, DataGridViewCellEventArgs e) { try { conn.Open(); MySqlCommand comm = new MySqlCommand("SELECT payment.amountPaid, payment.payDate" + " FROM payment INNER JOIN account ON account.accountID = payment.accountID", conn); MySqlDataAdapter adp = new MySqlDataAdapter(comm); DataTable dt = new DataTable(); adp.Fill(dt); comm = new MySqlCommand("SELECT SUM(amountPaid)" + " FROM payment INNER JOIN account ON account.accountID = payment.accountID WHERE account.status = 'active'", conn); adp = new MySqlDataAdapter(comm); dt = new DataTable(); adp.Fill(dt); txtTotalPaid.Text = dt.Rows[0]["SUM(amountPaid)"].ToString(); addP = new addPayment(); payID = int.Parse(dtAccount.Rows[e.RowIndex].Cells["accountID"].Value.ToString()); conn.Close(); checkAddAccount(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); conn.Close(); } refreshPay(); }
private void addP_Click(object sender, EventArgs e) { try { addP = new addPayment(); addP.refToAdmin = this; addP.payActID = payID; addP.cID = this.cID; checkAddAccount(); addP.Show(); } catch (Exception ex) { MessageBox.Show("Please Select an Account"); } }