private void button5_Click(object sender, EventArgs e)
{
if (textBox2.Text != "")
{
if (MessageBox.Show("Are you sure you want to Print Year wise Patient History??", "Patient History Print??", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
opd opd = new opd();
dbconnect db = new dbconnect();
medicineCount = 0;
opd.getPatientOPDHistory(textBox1.Text, comboBox2.Text + "0101", (Convert.ToInt32(comboBox2.Text) + 1).ToString() + "0101", db);
while (opd.dr.Read())
{
medicine_id = opd.dr[2].ToString().Split(',');
medicineCount += medicine_id.Length;
}
db.dbclose();
try
{
j = 1;
printDocument2.PrinterSettings.PrinterName = comboBox3.SelectedItem.ToString();
printDocument2.Print();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message + "\n\nPrinter Not Connected Properly!! Please Check that and then Print!!");
}
}
}
else
{
MessageBox.Show("Please Select a Patient from the list!!!");
}
}
public void loadPatients(string opd)
{
opd opd2 = new opd();
opd2.loadVisitedPatients(opd);
dataGridView1.DataSource = opd2.table;
}
public void loadPatientsName(string name)
{
opd opd2 = new opd();
opd2.loadVisitedPatientsName(name);
dataGridView1.DataSource = opd2.table;
}
public void loadCount()
{
opd opd = new opd();
opd.patientsVisited();
textBox8.Text = opd.count;
}
public void loadPatients()
{
opd opd = new opd();
opd.loadVisitedPatients();
dataGridView1.DataSource = opd.table;
}
public void ageLoad()
{
opd opd = new opd();
opd.patientAge(textBox1.Text);
age = opd.age;
}
public string getCode(string opd)
{
opd opd2 = new opd();
opd2.getCode(opd);
return(opd2.count);
}
private void registrationReports_Load(object sender, EventArgs e)
{
yearsLoad();
opd opd = new opd();
opd.registrationStats();
label4.Text = opd.count;
label6.Text = opd.token;
label9.Text = opd.opdMax;
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd MMM, yyyy";
dateTimePicker1.Value = DateTime.Today;
monthCalendar1.SelectionRange.Start = DateTime.Today;
printPreviewDialog1.PrintPreviewControl.Zoom = 1.0;
((Form)printPreviewDialog1).StartPosition = FormStartPosition.CenterScreen;
((Form)printPreviewDialog1).Width = 880;
((Form)printPreviewDialog1).Height = 680;
comboBox1.SelectedItem = DateTime.Today.Year.ToString();
foreach (string printer in PrinterSettings.InstalledPrinters)
{
comboBox3.Items.Add(printer);
}
PrinterSettings settings = new PrinterSettings();
comboBox3.SelectedItem = settings.PrinterName;
}
private void button3_Click(object sender, EventArgs e)
{
bool valid = false;
if (!Convert.ToBoolean(textBox8.Text))
{
if (textBox4.Text == DateTime.Today.ToString("yyyy-MM-dd"))
{
valid = true;
}
else
{
MessageBox.Show("You can cancel todays tokens only.");
}
}
else
{
MessageBox.Show("Patient already visited doctor. Token cannot be canceled.");
}
if (valid)
{
opd opd = new opd();
opd.cancelToken(textBox1.Text);
MessageBox.Show("Token canceled sucessfully!");
clearData();
}
}
public void updatePatient()
{
string gender = comboBox2.SelectedItem.ToString();
string cat = comboBox1.SelectedItem.ToString();
string date = textBox4.Text;
string month = textBox5.Text;
if (textBox4.Text.Length == 1)
{
date = "0" + date;
}
if (textBox5.Text.Length == 1)
{
month = "0" + month;
}
string dob = textBox6.Text + "-" + month + "-" + date;
opd opd = new opd();
opd.updatePatient(textBox1.Text, textBox2.Text, dob, gender, textBox3.Text, cat);
MessageBox.Show(opd.message);
if (opd.message == "Details UPDATED Sucessfully!!")
{
loadData();
clearData();
}
}
public void tokens2()
{
opd opd = new opd();
opd.tokenLoad();
label8.Text = opd.token;
label10.Text = opd.amount;
}
public void loadDOB(string ID)
{
opd opd = new opd();
opd.patientAge(ID);
textBox4.Text = opd.dob.Substring(8, 2);
textBox5.Text = opd.dob.Substring(5, 2);
textBox6.Text = opd.dob.Substring(0, 4);
}
public void ageLoad()
{
opd opd = new opd();
opd.patientAge(textBox1.Text);
age = opd.age;
opd.totalPatientVisits(textBox1.Text);
opdCount = opd.visits;
}
private void printDocument2_QueryPageSettings(object sender, System.Drawing.Printing.QueryPageSettingsEventArgs e)
{
opd opd = new opd();
opd.dailyOPDCount(dateTimePicker1.Value.Date.ToString("yyyy-MM-dd"));
int patients = Convert.ToInt32(opd.count);
e.PageSettings.PaperSize = new System.Drawing.Printing.PaperSize("A4 (210 x 297 mm)", 827, (55 + (patients * 5) + 13) * 4);
e.PageSettings.Margins = new System.Drawing.Printing.Margins(0, 0, 0, 0);
}
private void printDocument4_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Graphics g = e.Graphics;
g.PageUnit = GraphicsUnit.Millimeter;
Font messageFont = new Font("Times New Roman", 14, System.Drawing.GraphicsUnit.Point);
g.DrawString("INSTITUTE DISPENSARY", messageFont, Brushes.Black, 75, 9);
g.DrawString("INDIAN INSTITUTE OF TECHNOLOGY ROORKEE, SAHARANPUR CAMPUS", messageFont, Brushes.Black, 22, 15);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("MONTHLY DATE WISE REPORT(" + monthCalendar1.SelectionRange.Start.ToString("MMMM, yyyy") + ")", messageFont, Brushes.Black, 55, 23);
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Dated: " + DateTime.Today.ToString("dd MMM, yyyy"), messageFont, Brushes.Black, 160, 30);
Pen blackPen = new Pen(Color.Black, 1);
g.DrawLine(blackPen, 5, 38, 205, 38);
int total = 38;
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 2);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 12);
messageFont = new Font("Times New Roman", 11, System.Drawing.GraphicsUnit.Point);
g.DrawString("Sno.", messageFont, Brushes.Black, 15, total + 8);
g.DrawString("Date", messageFont, Brushes.Black, 45, total + 8);
g.DrawString("Total Patients", messageFont, Brushes.Black, 95, total + 8);
g.DrawString("Amount Collected", messageFont, Brushes.Black, 160, total + 8);
total += 17;
opd opd = new opd();
dbconnect db = new dbconnect();
opd.monthlyReportDatewise(monthCalendar1.SelectionRange.Start.ToString("yyyy-MM-") + "01", monthCalendar1.SelectionRange.Start.AddMonths(1).ToString("yyyy-MM-") + "01", db);
int i = 1;
int amount = 0;
while (opd.dr.Read())
{
messageFont = new Font("Times New Roman", 10, System.Drawing.GraphicsUnit.Point);
g.DrawString(i.ToString(), messageFont, Brushes.Black, 15, total);
g.DrawString(opd.dr[0].ToString(), messageFont, Brushes.Black, 45, total);
g.DrawString(opd.dr[1].ToString(), messageFont, Brushes.Black, 100, total);
g.DrawString(opd.dr[2].ToString(), messageFont, Brushes.Black, 165, total);
messageFont = new Font("Times New Roman", 5, System.Drawing.GraphicsUnit.Point);
g.DrawString("- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -", messageFont, Brushes.Black, 10, total + 4);
total += 6;
amount += Convert.ToInt32(opd.dr[2].ToString());
i++;
}
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Total Amount :" + amount.ToString(), messageFont, Brushes.Black, 139, total + 2);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 5);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("© IMG Labs, IIT Roorkee, SRE", messageFont, Brushes.Black, 87, total + 10);
}
public void loadData(string like)
{
opd opd = new opd();
opd.loadPatients(like);
dataGridView1.DataSource = opd.table;
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dataGridView1.ClearSelection();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.RowIndex;
//MessageBox.Show(i.ToString());
if (i >= 0)
{
dataGridView2.Rows.Clear();
//string query = "SELECT opd.opd, opd.patient_id, patients.name, patients.dob, patients.gender, opd.doctor, patients.category, patients.family_head, opd.symptoms, opd.remarks, opd.medicine_id, opd.medicines, opd.dosage, opd.quantity, opd.storemedicine_id, opd.storequantity FROM opd INNER JOIN patients ON opd.patient_id=patients.patient_id WHERE opd.opd="+opd;
dbconnect db = new dbconnect();
opd opd = new opd();
opd.loadOPDDetails(dataGridView1.Rows[i].Cells[0].Value.ToString(), db);
if (opd.dr.Read())
{
textBox8.Text = opd.dr[0].ToString();
textBox10.Text = opd.dr[1].ToString();
textBox9.Text = opd.dr[2].ToString();
int age = DateTime.Today.Year - Convert.ToInt32(opd.dr[3].ToString().Substring(0, 4));
if (Convert.ToInt32(opd.dr[3].ToString().Substring(5, 2)) > DateTime.Today.Month)
{
age--;
}
textBox1.Text = age.ToString();
textBox2.Text = opd.dr[4].ToString();
textBox5.Text = opd.dr[5].ToString();
textBox3.Text = opd.dr[6].ToString();
textBox4.Text = opd.dr[7].ToString();
textBox6.Text = opd.dr[8].ToString();
textBox13.Text = opd.dr[9].ToString();
medicinesID = new string[0];
medicines = new string[0];
dosage = new string[0];
qty = new string[0];
medicinesID = opd.dr[10].ToString().Split(',');
medicines = opd.dr[11].ToString().Split(',');
dosage = opd.dr[12].ToString().Split(',');
qty = opd.dr[13].ToString().Split(',');
if (opd.dr[14].ToString() != "")
{
medicinesIDStore = opd.dr[14].ToString().Split(',');
qtyStore = opd.dr[15].ToString().Split(',');
}
for (int q = 0; q < medicinesID.Length; q++)
{
dataGridView2.Rows.Add(medicinesID[q], medicines[q], qty[q], dosage[q]);
}
dataGridView2.ClearSelection();
issuedLP = medicinesID.Contains("LP");
}
db.dbclose();
}
}
public void loadPatients(string token)
{
opd opd = new opd();
opd.patientsToVisit(token);
dataGridView1.DataSource = opd.table;
dataGridView1.ClearSelection();
clearData();
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private void printDocument3_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Graphics g = e.Graphics;
g.PageUnit = GraphicsUnit.Millimeter;
Font messageFont = new Font("Times New Roman", 14, System.Drawing.GraphicsUnit.Point);
g.DrawString("INSTITUTE DISPENSARY", messageFont, Brushes.Black, 75, 9);
g.DrawString("INDIAN INSTITUTE OF TECHNOLOGY ROORKEE, SAHARANPUR CAMPUS", messageFont, Brushes.Black, 22, 15);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("ANNUAL REPORT(" + comboBox1.SelectedItem.ToString() + "-" + (Convert.ToInt32(comboBox1.SelectedItem.ToString()) + 1).ToString() + ")", messageFont, Brushes.Black, 75, 25);
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Dated: " + DateTime.Today.ToString("dd MMM, yyyy"), messageFont, Brushes.Black, 160, 30);
Pen blackPen = new Pen(Color.Black, 1);
g.DrawLine(blackPen, 5, 38, 205, 38);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, 38 + 2);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, 38 + 12);
messageFont = new Font("Times New Roman", 13, System.Drawing.GraphicsUnit.Point);
g.DrawString("Sno.", messageFont, Brushes.Black, 10, 46);
g.DrawString("Month", messageFont, Brushes.Black, 30, 46);
g.DrawString("Total Patients", messageFont, Brushes.Black, 90, 46);
g.DrawString("Total Amount", messageFont, Brushes.Black, 155, 46);
DateTime month = new DateTime(Convert.ToInt32(comboBox1.SelectedItem.ToString()), 4, 1);
int total = 60;
int amount = 0;
int patients = 0;
for (int i = 1; i < 13; i++)
{
opd opd = new opd();
opd.annualReport(month.AddMonths(i - 1).ToString("yyyy-MM-dd"), month.AddMonths(i).ToString("yyyy-MM-dd"));
g.DrawString(i.ToString() + ")", messageFont, Brushes.Black, 10, total);
g.DrawString(month.AddMonths(i - 1).ToString("MMMM, yyyy").ToUpper(), messageFont, Brushes.Black, 30, total);
g.DrawString(opd.count, messageFont, Brushes.Black, 95, total);
g.DrawString(opd.token, messageFont, Brushes.Black, 160, total);
total += 10;
amount += Convert.ToInt32(opd.token);
patients += Convert.ToInt32(opd.count);
}
messageFont = new Font("Times New Roman", 13, System.Drawing.GraphicsUnit.Point);
g.DrawString("Total Patients : " + patients.ToString(), messageFont, Brushes.Black, 63, total + 2);
g.DrawString("Total Amount : " + amount.ToString(), messageFont, Brushes.Black, 130, total + 2);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 5);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("© IMG Labs, IIT Roorkee, SRE", messageFont, Brushes.Black, 87, total + 10);
}
public void loadPatients()
{
opd opd = new opd();
opd.patientsToVisit();
dataGridView1.DataSource = opd.table;
dataGridView1.ClearSelection();
loadCount();
clearData();
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
textBox6.Text = dataGridView1.Rows.Count.ToString();
}
public static opd Login(string username, string password)
{
string query = String.Format("select count(*) from ((opd inner JOIN position On opd.pos_id = position.pos_id) inner JOIN user_control On user_control.opd_id = opd.opd_id) where user_control.uct_user = '******'", username);
command.CommandText = query;
try
{
conn.Open();
int countuser = (int)command.ExecuteScalar();
if (countuser == 1)
{
query = String.Format("select user_control.uct_password from ((opd inner JOIN position On opd.pos_id = position.pos_id) inner JOIN user_control On user_control.opd_id = opd.opd_id) where user_control.uct_user = '******'", username);
command.CommandText = query;
string dbpassword = command.ExecuteScalar().ToString();
if (dbpassword == password)
{
query = String.Format("select opd.opd_name,position.pos_name from ((opd FULL OUTER JOIN position On opd.pos_id = position.pos_id) FULL OUTER JOIN user_control On user_control.opd_id = opd.opd_id) FULL OUTER JOIN employee_doctor On employee_doctor.emp_doc_id = user_control.emp_doc_id where user_control.uct_user ='******' ", username);
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string emp_ru_name = reader.GetString(0);
string pos_name = reader.GetString(1);
opd ru = new opd(emp_ru_name, username, password, pos_name);
return(ru);
}
return(null);
}
return(null);
}
else
{
return(null);
}
}
finally
{
conn.Close();
}
return(null);
}
private void button4_Click(object sender, EventArgs e)
{
opd opd = new opd();
dbconnect db = new dbconnect();
opd.dailyReportDoctor(dateTimePicker2.Value.Date.ToString("yyyyMMdd"), db);
opdCount = 0;
medicineCount = 0;
while (opd.dr.Read())
{
medicine_id = opd.dr[9].ToString().Split(',');
medicineCount += medicine_id.Length;
opdCount += 1;
}
//MessageBox.Show(medicineCount.ToString());
db.dbclose();
printPreviewDialog1.ShowDialog();
}
private void button7_Click(object sender, EventArgs e)
{
if (textBox4.Text != "")
{
opd opd = new opd();
dbconnect db = new dbconnect();
opd.duplicatePatientSlip(textBox4.Text, db);
if (opd.dr.Read())
{
//MessageBox.Show(opd.dr[9].ToString());
opd.patientAge(db.dr[0].ToString());
medicine_id = opd.dr[9].ToString().Split(',');
medicines = opd.dr[10].ToString().Split(',');
dosage = opd.dr[11].ToString().Split(',');
quantity = opd.dr[12].ToString().Split(',');
id = db.dr[0].ToString();
symptoms = db.dr[1].ToString();
remarks = db.dr[2].ToString();
doctor = db.dr[3].ToString();
date = db.dr[4].ToString().Substring(6, 2) + "-" + db.dr[4].ToString().Substring(4, 2) + "-" + db.dr[4].ToString().Substring(0, 4);
name = db.dr[5].ToString();
gender = db.dr[7].ToString();
age = opd.age.ToString();
for (int i = 0; i < medicine_id.Length; i++)
{
if (medicine_id[i] == "LP")
{
LP = true;
break;
}
}
if (MessageBox.Show("Are you sure you want to Print Duplicate Patient Slip??", "Duplicat Patient Slip??", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
printDocument1.Print();
// printPreviewDialog1.ShowDialog();
}
}
else
{
MessageBox.Show("Invalid OPD!!");
}
db.dbclose();
}
}
public void issueToken()
{
tokens();
opd opd = new opd();
opd.issueToken(username, (Convert.ToInt32(label8.Text) + 1).ToString(), textBox1.Text, comboBox1.Text, comboBox3.Text, code.ToString());
try
{
//printPreviewDialog1.ShowDialog();
printDocument1.Print();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message + "\n\nPrinter Not Connected Properly!! Please Check that and Issue the token!!");
}
loadData();
clearData();
tokens();
}
private void button1_Click(object sender, EventArgs e)
{
bool details = false;
opd opd = new opd();
dbconnect db = new dbconnect();
opd.getPatientDetailsHistory(textBox1.Text, db);
if (opd.dr.Read())
{
id = textBox1.Text;
name = opd.dr[0].ToString();
gender = opd.dr[1].ToString();
familyHead = opd.dr[2].ToString();
details = true;
}
else
{
MessageBox.Show("Invalid Patient ID!!");
db.dbclose();
}
db.reader_close();
if (details)
{
opdCount = 0;
medicineCount = 0;
opd.patientAge(id);
age = opd.age.ToString();
opd.getPatientOPDHistory(textBox1.Text, db);
while (opd.dr.Read())
{
medicine_id = opd.dr[2].ToString().Split(',');
medicineCount += medicine_id.Length;
opdCount += 1;
}
db.dbclose();
printPreviewDialog1.ShowDialog();
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox2.Text != "")
{
opd opd = new opd();
dbconnect db = new dbconnect();
medicineCount = 0;
opd.getPatientOPDHistory(textBox1.Text, comboBox2.Text + "0101", (Convert.ToInt32(comboBox2.Text) + 1).ToString() + "0101", db);
while (opd.dr.Read())
{
medicine_id = opd.dr[2].ToString().Split(',');
medicineCount += medicine_id.Length;
}
db.dbclose();
j = 1;
printDocument2.PrinterSettings = new System.Drawing.Printing.PrinterSettings();
printPreviewDialog1.Document = printDocument2;
printPreviewDialog1.ShowDialog();
}
else
{
MessageBox.Show("Please Select a Patient from the list!!!");
}
}
private void button6_Click(object sender, EventArgs e)
{
if (textBox2.Text != "")
{
opd opd = new opd();
dbconnect db = new dbconnect();
medicineCount = 0;
opd.getPatientOPDHistory(textBox1.Text, dateTimePicker2.Value.ToString("yyyyMMdd"), dateTimePicker1.Value.ToString("yyyyMMdd"), db);
while (opd.dr.Read())
{
medicine_id = opd.dr[2].ToString().Split(',');
medicineCount += medicine_id.Length;
}
db.dbclose();
j = 1;
printDocument3.PrinterSettings = new System.Drawing.Printing.PrinterSettings();
printPreviewDialog1.Document = printDocument3;
printPreviewDialog1.ShowDialog();
}
else
{
MessageBox.Show("Please Select a Patient from the list!!!");
}
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Graphics g = e.Graphics;
g.PageUnit = GraphicsUnit.Millimeter;
Font messageFont = new Font("Times New Roman", 14, System.Drawing.GraphicsUnit.Point);
int total;
if (j == 1)
{
g.DrawString("INSTITUTE DISPENSARY", messageFont, Brushes.Black, 75, 9);
g.DrawString("INDIAN INSTITUTE OF TECHNOLOGY ROORKEE, SAHARANPUR CAMPUS", messageFont, Brushes.Black, 22, 15);
messageFont = new Font("Times New Roman", 20, System.Drawing.GraphicsUnit.Point);
g.DrawString("DAILY REPORT", messageFont, Brushes.Black, 75, 25);
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Dated: " + dateTimePicker1.Value.Date.ToString("dd MMM, yyyy"), messageFont, Brushes.Black, 160, 30);
Pen blackPen = new Pen(Color.Black, 1);
g.DrawLine(blackPen, 5, 38, 205, 38);
total = 38;
}
else
{
total = 5;
}
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 2);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 12);
messageFont = new Font("Times New Roman", 10, System.Drawing.GraphicsUnit.Point);
g.DrawString("Sno.", messageFont, Brushes.Black, 10, total + 8);
g.DrawString("OPD", messageFont, Brushes.Black, 20, total + 8);
g.DrawString("Booklet No.", messageFont, Brushes.Black, 35, total + 8);
g.DrawString("Patient Name", messageFont, Brushes.Black, 60, total + 8);
g.DrawString("Age", messageFont, Brushes.Black, 115, total + 8);
g.DrawString("Gender", messageFont, Brushes.Black, 125, total + 8);
g.DrawString("Family Head", messageFont, Brushes.Black, 140, total + 8);
g.DrawString("Amt.", messageFont, Brushes.Black, 165, total + 8);
g.DrawString("Doctor", messageFont, Brushes.Black, 178, total + 8);
total += 17;
opd opd = new opd();
dbconnect db = new dbconnect();
opd.dailyReportRegistration(dateTimePicker1.Value.Date.ToString("yyyy-MM-dd"), db);
int i = 1;
while (opd.dr.Read())
{
if (i < j)
{
i++;
continue;
}
if (total >= 270)
{
e.HasMorePages = true;
return;
}
g.DrawString(i + ")", messageFont, Brushes.Black, 10, total);
g.DrawString(opd.dr[0].ToString(), messageFont, Brushes.Black, 20, total);
g.DrawString(opd.dr[1].ToString(), messageFont, Brushes.Black, 35, total);
g.DrawString(opd.dr[2].ToString(), messageFont, Brushes.Black, 60, total);
int age2 = DateTime.Today.Year - Convert.ToInt32(db.dr[3].ToString().Substring(0, 4));
if (Convert.ToInt32(db.dr[3].ToString().Substring(5, 2)) > DateTime.Today.Month)
{
age2--;
}
g.DrawString(age2.ToString(), messageFont, Brushes.Black, 115, total);
g.DrawString(opd.dr[4].ToString(), messageFont, Brushes.Black, 125, total);
g.DrawString(opd.dr[5].ToString(), messageFont, Brushes.Black, 140, total);
int amt = 0;
if (opd.dr[6].ToString() == "general")
{
amt = 1;
totalAmount += 1;
}
g.DrawString(amt.ToString(), messageFont, Brushes.Black, 165, total);
g.DrawString(opd.dr[7].ToString(), messageFont, Brushes.Black, 178, total);
total += 5;
i++;
j++;
e.HasMorePages = false;
}
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Total Amount :" + totalAmount.ToString(), messageFont, Brushes.Black, 139, total + 2);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total + 5);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("© IMG Labs, IIT Roorkee, SRE", messageFont, Brushes.Black, 87, total + 10);
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Graphics g = e.Graphics;
g.PageUnit = GraphicsUnit.Millimeter;
Font messageFont = new Font("Times New Roman", 14, System.Drawing.GraphicsUnit.Point);
g.DrawString("INSTITUTE DISPENSARY", messageFont, Brushes.Black, 75, 9);
g.DrawString("INDIAN INSTITUTE OF TECHNOLOGY ROORKEE, SAHARANPUR CAMPUS", messageFont, Brushes.Black, 22, 15);
messageFont = new Font("Times New Roman", 20, System.Drawing.GraphicsUnit.Point);
g.DrawString("DAILY REPORT", messageFont, Brushes.Black, 75, 25);
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Dated: " + dateTimePicker2.Value.Date.ToString("dd MMM, yyyy"), messageFont, Brushes.Black, 160, 30);
g.DrawString("Doctor: Dr. Manoj Jain", messageFont, Brushes.Black, 15, 30);
Pen blackPen = new Pen(Color.Black, 1);
g.DrawLine(blackPen, 5, 38, 205, 38);
int total = 38;
opd opd = new opd();
dbconnect db = new dbconnect();
opd.dailyReportDoctor(dateTimePicker2.Value.Date.ToString("yyyyMMdd"), db);
int sno = 1;
while (opd.dr.Read())
{
int age = DateTime.Today.Year - Convert.ToInt32(db.dr[4].ToString().Substring(0, 4));
if (Convert.ToInt32(db.dr[4].ToString().Substring(5, 2)) > DateTime.Today.Month)
{
age--;
}
medicine_id = new string[0];
medicines = new string[0];
dosage = new string[0];
quantity = new string[0];
messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
g.DrawString("Patient Name: " + opd.dr[3].ToString(), messageFont, Brushes.Black, 20, total + 4);
g.DrawString("Patient ID: " + opd.dr[0].ToString(), messageFont, Brushes.Black, 55, total + 11);
g.DrawString("Age: " + age + " Years", messageFont, Brushes.Black, 110, total + 4);
g.DrawString("Gender: " + opd.dr[5].ToString(), messageFont, Brushes.Black, 150, total + 4);
g.DrawString("Family Head ID: " + opd.dr[6].ToString(), messageFont, Brushes.Black, 110, total + 11);
g.DrawString(sno + ")", messageFont, Brushes.Black, 10, total + 4);
g.DrawString("OPD: " + opd.dr[7].ToString(), messageFont, Brushes.Black, 20, total + 11);
g.DrawString("Symptoms: " + opd.dr[1].ToString(), messageFont, Brushes.Black, 20, total + 18);
g.DrawString("Remarks: " + opd.dr[2].ToString(), messageFont, Brushes.Black, 110, total + 18);
total += 27;
medicine_id = opd.dr[8].ToString().Split(',');
medicines = opd.dr[9].ToString().Split(',');
dosage = opd.dr[10].ToString().Split(',');
quantity = opd.dr[11].ToString().Split(',');
for (int i = 0; i < medicine_id.Length; i++)
{
g.DrawString((i + 1) + ".", messageFont, Brushes.Black, 20, total);
g.DrawString(medicines[i] + " -- ( " + quantity[i] + " ) -- ( " + dosage[i] + " )", messageFont, Brushes.Black, 27, total);
total += 6;
}
if (sno < opdCount)
{
messageFont = new Font("Times New Roman", 8, FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
g.DrawString("- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ", messageFont, Brushes.Black, 10, total - 1);
total += 3;
}
sno++;
}
db.dbclose();
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("© IMG Labs, IIT Roorkee, SRE", messageFont, Brushes.Black, 87, total + 5);
}
private void printDocument3_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Graphics g = e.Graphics;
g.PageUnit = GraphicsUnit.Millimeter;
Font messageFont = new Font("Times New Roman", 12, System.Drawing.GraphicsUnit.Point);
Pen blackPen = new Pen(Color.Black, 1);
int total;
if (j == 1)
{
g.DrawString("INSTITUTE DISPENSARY", messageFont, Brushes.Black, 75, 5);
g.DrawString("INDIAN INSTITUTE OF TECHNOLOGY ROORKEE, SAHARANPUR CAMPUS", messageFont, Brushes.Black, 22, 10);
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("PATIENT MEDICAL HISTORY", messageFont, Brushes.Black, 65, 15);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("(From " + dateTimePicker2.Value.ToString("dd MMM, yyyy") + " To " + dateTimePicker1.Value.ToString("dd MMM, yyyy") + ")", messageFont, Brushes.Black, 77, 20);
g.DrawLine(blackPen, 5, 26, 205, 26);
messageFont = new Font("Times New Roman", 10, System.Drawing.GraphicsUnit.Point);
g.DrawString("Patient Name: " + textBox2.Text, messageFont, Brushes.Black, 10, 27);
g.DrawString("Patient ID: " + textBox1.Text, messageFont, Brushes.Black, 10, 33);
g.DrawString("Age: " + textBox4.Text + " Years", messageFont, Brushes.Black, 120, 27);
g.DrawString("Gender: " + comboBox2.Text, messageFont, Brushes.Black, 160, 27);
if (textBox3.Text != "")
{
g.DrawString("Family Head ID: " + textBox3.Text, messageFont, Brushes.Black, 120, 33);
}
g.DrawString("Dated: " + DateTime.Today.ToString("dd MMM, yyyy"), messageFont, Brushes.Black, 160, 20);
g.DrawLine(blackPen, 5, 39, 205, 39);
total = 40;
}
else
{
total = 5;
}
opd opd = new opd();
dbconnect db = new dbconnect();
opd.getPatientOPDHistory(textBox1.Text, dateTimePicker2.Value.ToString("yyyyMMdd"), dateTimePicker1.Value.ToString("yyyyMMdd"), db);
int sno = 1;
while (opd.dr.Read())
{
if (sno < j)
{
sno++;
continue;
}
if (total >= 275)
{
e.HasMorePages = true;
return;
}
messageFont = new Font("Times New Roman", 10, System.Drawing.GraphicsUnit.Point);
medicine_id = new string[0];
medicines = new string[0];
dosage = new string[0];
quantity = new string[0];
if (m == 0)
{
g.DrawString(j + ")", messageFont, Brushes.Black, 10, total + 1);
g.DrawString("OPD: " + opd.dr[0].ToString(), messageFont, Brushes.Black, 20, total + 1);
g.DrawString("Doctor: " + opd.dr[8].ToString(), messageFont, Brushes.Black, 55, total + 1);
g.DrawString("Symptoms: " + opd.dr[6].ToString(), messageFont, Brushes.Black, 105, total + 1);
g.DrawString("Visit Date: " + opd.dr[1].ToString().Substring(0, 4) + "-" + opd.dr[1].ToString().Substring(4, 2) + "-" + opd.dr[1].ToString().Substring(6, 2), messageFont, Brushes.Black, 20, total + 6);
g.DrawString("Remarks: " + opd.dr[7].ToString(), messageFont, Brushes.Black, 70, total + 6);
total += 12;
}
medicine_id = opd.dr[2].ToString().Split(',');
medicines = opd.dr[3].ToString().Split(',');
dosage = opd.dr[4].ToString().Split(',');
quantity = opd.dr[5].ToString().Split(',');
for (int i = 0; i < medicine_id.Length; i++)
{
if (i < m - 1)
{
continue;
}
m++;
if (total >= 275)
{
e.HasMorePages = true;
return;
}
g.DrawString((i + 1) + ".", messageFont, Brushes.Black, 20, total);
g.DrawString(medicines[i] + " -- ( " + quantity[i] + " ) -- ( " + dosage[i] + " )", messageFont, Brushes.Black, 27, total);
total += 4;
//m++;
}
m = 0;
if (sno < Convert.ToInt32(opdCount))
{
messageFont = new Font("Times New Roman", 8, FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
g.DrawString("- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ", messageFont, Brushes.Black, 10, total - 1);
total += 1;
}
j++;
sno++;
}
db.dbclose();
messageFont = new Font("Times New Roman", 15, System.Drawing.GraphicsUnit.Point);
g.DrawString("----------------------------------------------------------------------------------------------------------", messageFont, Brushes.Black, 7, total);
messageFont = new Font("Times New Roman", 8, System.Drawing.GraphicsUnit.Point);
g.DrawString("© IMG Labs, IIT Roorkee, SRE", messageFont, Brushes.Black, 87, total + 5);
}
