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