private void button7_Click(object sender, EventArgs e)
{
//SELECT patients.name, token.* FROM patients INNER JOIN token ON patients.patient_id=token.patient_id WHERE patient_id='"+textBox4.Text+"' AND date='"+DateTime.Today.ToString("yyyy-MM-dd")+"'
//SELECT * FROM token WHERE patient_id='"+textBox4.Text+"' AND date='"+DateTime.Today.ToString("yyyy-MM-dd")+"'
string query2 = "SELECT name, dob FROM patients WHERE patient_id='" + textBox4.Text + "'";
dbconnect db2 = new dbconnect();
db2.command_reader(query2, db2.con);
// MessageBox.Show(db.reader);
if (db2.dr.Read())
{
name = db2.dr[0].ToString();
age = DateTime.Today.Year - Convert.ToInt32(db2.dr[1].ToString().Substring(0, 4));
//MessageBox.Show(age.ToString());
if (Convert.ToInt32(db2.dr[1].ToString().Substring(5, 2)) > DateTime.Today.Month)
{
age--;
}
}
string query = "SELECT * FROM token WHERE patient_id='" + textBox4.Text + "' AND date='" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
dbconnect db = new dbconnect("opd");
db.command_reader(query, db.con);
// MessageBox.Show(db.reader);
if (db.dr.Read())
{
opd = db.dr[0].ToString();
token = db.dr[2].ToString();
doc = db.dr[7].ToString();
code = db.dr[8].ToString();
cat = db.dr[6].ToString();
printPreviewDialog1.ShowDialog();
textBox4.Text = "";
}
else
{
MessageBox.Show("No token was issued for following Patient today.");
}
}
public void loadToken(string token)
{
string query = "SELECT * FROM token WHERE token_no=" + token + " AND date='" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
dbconnect db = new dbconnect();
db.command_reader(query, db.con);
if (db.dr.Read())
{
textBox1.Text = db.dr[0].ToString();
textBox3.Text = db.dr[4].ToString();
textBox4.Text = db.dr[3].ToString();
textBox5.Text = db.dr[6].ToString();
textBox6.Text = db.dr[7].ToString();
textBox7.Text = db.dr[1].ToString();
textBox8.Text = db.dr[9].ToString();
}
else
{
MessageBox.Show("Enter todays valid Token No.");
}
db.dbclose();
}
public void loadOPD(string opd)
{
string query = "SELECT * FROM token WHERE opd=" + opd;
dbconnect db = new dbconnect();
db.command_reader(query, db.con);
if (db.dr.Read())
{
textBox2.Text = db.dr[2].ToString();
textBox3.Text = db.dr[4].ToString();
textBox4.Text = db.dr[3].ToString().Substring(0, 10);
textBox5.Text = db.dr[6].ToString();
textBox6.Text = db.dr[7].ToString();
textBox7.Text = db.dr[1].ToString();
textBox8.Text = db.dr[9].ToString();
}
else
{
MessageBox.Show("Enter Valid OPD.");
}
db.dbclose();
}
