private void button2_Click(object sender, EventArgs e) { Billing bill = new Billing(); bill.Show(); this.Dispose(); }
private void button2_Click_1(object sender, EventArgs e) { Billing trans = new Billing(); trans.Show(); }
private void button1_Click(object sender, EventArgs e) { Billing billing = new Billing(); billing.ShowDialog(); }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { string pname = "", service = "", date = "", status = ""; int ctr = 0, pno = 0, ctr1 = 0, age = 0, appno = 0; bool check = true; pname = dataGridView1.CurrentRow.Cells[1].Value.ToString(); service = dataGridView1.CurrentRow.Cells[4].Value.ToString(); date = dataGridView1.CurrentRow.Cells[2].Value.ToString(); appno = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value); Maintenance mainte = new Maintenance(); Billing bill = new Billing(); connection.Open(); string query2 = "SELECT * from appointmenttbl where appointno = '" + appno + "'"; MySqlCommand cmd2 = new MySqlCommand(query2, connection); MySqlDataReader dataReader2 = cmd2.ExecuteReader(); while (dataReader2.Read()) { pno = dataReader2.GetInt32("pno"); status = dataReader2.GetString("appointstatus"); } connection.Close(); if (status.Equals("cancelled")) { MessageBox.Show("This appointment was already cancelled"); check = false; } else if (status.Equals("done")) { MessageBox.Show("This appointment was already done"); check = false; } connection.Open(); string query = "SELECT * from patienttbl where CONCAT(plname,', ',pfname,' ',pminitial) = '" + pname + "'"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { ctr = 1; } connection.Close(); connection.Open(); string query1 = "SELECT * FROM billingtbl b,patienttbl p,balancetbl ba where CONCAT(p.plname,', ',p.pfname,' ',p.pminitial) = '" + pname + "' and b.servicename = '" + service + "' and p.pno = b.pnum and b.pnum = ba.pno and ba.tbal > 0"; MySqlCommand cmd1 = new MySqlCommand(query1, connection); MySqlDataReader dataReader1 = cmd1.ExecuteReader(); while (dataReader1.Read()) { ctr1 = 1; } connection.Close(); if (check == true) { if (ctr == 0) { MessageBox.Show("The patient were added through call only, Please make a record immediately"); this.Hide(); mainte.Show(); mainte.panel1.BringToFront(); mainte.panel66.SendToBack(); mainte.button1.Hide(); mainte.button29.Show(); mainte.label144.Text = pno.ToString(); mainte.button27.Show(); mainte.button23.Hide(); } if (ctr == 1 && ctr1 == 1) { this.Hide(); mainte.Show(); mainte.panel66.Show(); mainte.panel1.SendToBack(); mainte.pbackbtn.Hide(); mainte.button2.Hide(); mainte.button28.Show(); mainte.txtname2.Text = pname; mainte.txtpno2.Text = pno.ToString(); mainte.tabPage10.Show(); mainte.tabControl3.SelectTab("tabPage10"); for (int x = 0; x < mainte.transactionview.Rows.Count; x++) { if (service == mainte.transactionview.Rows[x].Cells[3].Value.ToString()) { mainte.transactionview.Rows[x].Cells[1].Value = date; } } } else if (ctr == 1 && ctr1 == 0) { mainte.Show(); mainte.panel66.Show(); mainte.panel1.SendToBack(); mainte.pbackbtn.Hide(); mainte.button2.Hide(); mainte.button28.Show(); mainte.txtname2.Text = pname; mainte.txtpno2.Text = pno.ToString(); mainte.tabPage8.Show(); mainte.tabControl3.SelectTab("tabPage8"); mainte.label184.Text = service; mainte.label185.Text = date; this.Hide(); } } }