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");
}
}
