public static string GenerateConsentPDF() { //Get Patient Details string HospitalName = "Kamla Eye Clinic"; DBConnection con = new DBConnection(); PatientMaster pm = new PatientMaster(); pm.CMD = "View1"; pm.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); pm.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); string xml1 = Common.ToXML(pm); DataSet ds = con.ExecuteProcedure("SP_PatientRegistration", xml1); string patientname = ds.Tables[0].Rows[0]["title"] + " " + ds.Tables[0].Rows[0]["fname"] + " " + ds.Tables[0].Rows[0]["mname"] + " " + ds.Tables[0].Rows[0]["lname"]; //Get Consent Details ConsentMaster obj = new ConsentMaster(); obj.CMD = "View1"; obj.consentid = Convert.ToInt32(HttpContext.Current.Session["consentid"]); obj.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); obj.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); string xml = Common.ToXML(obj); DataSet d = con.ExecuteProcedure("SP_Consent", xml); using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); sb.Append("<div style='font-family:verdana'>"); sb.Append("<table width='700px'>"); sb.Append("<tr style='font-size:30px' align='center'><td colspan=2>"); sb.Append(HospitalName); sb.Append("</td></tr>"); sb.Append("<tr><td colspan='2'></td></tr>"); sb.Append("<tr style='font-size:20px' align='center'><td colspan=2>"); sb.Append("Consent Form"); sb.Append("</td></tr>"); sb.Append("<tr><td colspan='2'></td></tr>"); sb.Append("<tr style='font-size:18px'><td style='font-weight:bold'>Consent Date #:"); sb.Append(d.Tables[0].Rows[0]["create_dt"]); sb.Append("</td><td style='font-weight:bold'>Consent Id #:"); sb.Append(d.Tables[0].Rows[0]["consentid"]); sb.Append("</td></tr></table><br/>"); sb.Append("<table border='0' width='700px' style='font-size:22px; border-collapse: collapse;'>"); sb.Append("<tr><td>Patient Name:</td><td>"); sb.Append(patientname); sb.Append("</td></tr><tr><td>Age:</td><td>"); sb.Append(ds.Tables[0].Rows[0]["age"]); sb.Append("</td></tr><tr><td>Patient Signature:</td><td>____________________________</td></tr>"); sb.Append("<tr><td>Visitors Name:</td><td>"); sb.Append(d.Tables[0].Rows[0]["visitorname"]); sb.Append("</td></tr><tr><td>Witness Signature:</td><td>____________________________</td></tr>"); DateTime dt = Convert.ToDateTime(d.Tables[0].Rows[0]["create_dt"].ToString()); sb.Append("<tr><td>Date:</td><td>"); sb.Append(dt.ToLongDateString()); sb.Append("</td></tr><tr><td>Time:</td><td>"); sb.Append(dt.ToShortTimeString()); sb.Append("</td></tr><tr><td>Place:</td><td>"); sb.Append(d.Tables[0].Rows[0]["place"]); sb.Append("</td></tr></table>"); sb.Append("<br/><br/><br/>"); sb.Append("<table border='0' width='700px' style='font-size:22px; border-collapse: collapse;'>"); sb.Append("<tr><td>Sergeon Doctor's Name:</td><td>DR.RAJENDRA JAIN</td></tr>"); sb.Append("<tr><td>Sergeon Doctor's Address:</td><td>G-4, Indira Complex, 60 feet Road, Bhayandar(West), Dist. Thane</td></tr>"); sb.Append("<tr><td>Doctor's Signature:</td><td>____________________________</td></tr>"); sb.Append("</table>"); sb.Append("<br/><br/><br/>"); sb.Append("<table border='0' width='700px' style='font-size:22px; border-collapse: collapse;'>"); sb.Append("<tr><td colspan='2'>If required your physician will afurnish any additional information you require to be certain you are fully informed about the operation and the lens.</td></tr>"); sb.Append("<tr><td colspan='2'>_______________________________________________________________________</td></tr>"); sb.Append("<tr><td colspan='2'>_______________________________________________________________________</td></tr>"); sb.Append("<tr><td colspan='2'>_______________________________________________________________________</td></tr>"); sb.Append("<tr><td colspan='2'>_______________________________________________________________________</td></tr>"); sb.Append("</table>"); return(sb.ToString()); } } }
public static string GenerateTreatmentPDF() { string HospitalName = "Kamla Eye Clinic"; //Get Treatment Details Treatment obj = new Treatment(); obj.CMD = "View1"; obj.treatmentid = Convert.ToInt32(HttpContext.Current.Session["treatmentid"]); obj.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); obj.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); string xml = Common.ToXML(obj); DBConnection con = new DBConnection(); DataSet d = con.ExecuteProcedure("SP_Treatment", xml); //Get Patient Details PatientMaster pm = new PatientMaster(); pm.CMD = "View1"; pm.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); pm.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); string xml1 = Common.ToXML(pm); DataSet ds = con.ExecuteProcedure("SP_PatientRegistration", xml1); string patientname = ds.Tables[0].Rows[0]["title"] + " " + ds.Tables[0].Rows[0]["fname"] + " " + ds.Tables[0].Rows[0]["mname"] + " " + ds.Tables[0].Rows[0]["lname"]; using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); //Generate Invoice (Treatment) Header. sb.Append("<div style='font-family:verdana'>"); sb.Append("<table width='700px'>"); sb.Append("<tr style='font-size:30px'><td colspan=2>"); sb.Append(HospitalName); sb.Append("</td></tr>"); sb.Append("<tr style='font-size:14px'><td>Treatment Date #:"); sb.Append(d.Tables[0].Rows[0]["create_dt"]); sb.Append("</td><td>Treatment Id #:"); sb.Append(d.Tables[0].Rows[0]["treatmentid"]); sb.Append("</td></tr></table><br/>"); sb.Append("<table border='1' width='700px' style='font-size:13px; border-collapse:collapse;'>"); sb.Append("<tr><td colspan ='4' style='background-color:#ddd; font-weight:bold'> PATIENT DETAILS </td></tr>"); sb.Append("<tr><td>Patient Name:</td><td>"); sb.Append(patientname); sb.Append("</td><td>Patient Id:</td><td>"); sb.Append(ds.Tables[0].Rows[0]["patientid"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Patient Age:</td><td >"); sb.Append(ds.Tables[0].Rows[0]["age"]); sb.Append("</td><td>Consultant</td><td>"); sb.Append(d.Tables[0].Rows[0]["dfname"] + " " + d.Tables[0].Rows[0]["dlname"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Address:</td>"); sb.Append("<td>-</td>"); sb.Append("<td>Contact No :</td><td>"); sb.Append(ds.Tables[0].Rows[0]["contact"]); sb.Append("</td></tr>"); sb.Append("</table><br/>"); //Generate Treatment sb.Append("<table border='0' width='700px' style='font-size:13px; border-collapse: collapse;'>"); sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); // Investigations sb.Append("<td colspan ='5'> Investigations :</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[3].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[3].Rows[i]["diseasename"]); if (i == d.Tables[3].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Presenting Complains sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Presenting Complains :</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[5].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[5].Rows[i]["complentsname"]); if (i == d.Tables[5].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Provisional Diagnosis sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Provisional Diagnosis :</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[6].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[6].Rows[i]["disgnosisname"]); if (i == d.Tables[6].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Previous Disease sb.Append("<tr style='background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Previous Disease and Duration:</td></tr>"); sb.Append("<tr style ='font-weight:bold'><td>Sr.No#</td><td>Disease#</td><td>From Date#</td><td>To Date#</td></tr>"); sb.Append("<tr><td colspan='5'></td></tr>"); for (int i = 0; i <= d.Tables[8].Rows.Count - 1; i++) { sb.Append("<td>"); sb.Append(i + 1); sb.Append("</td><td>"); sb.Append(d.Tables[8].Rows[i]["historyname"]); sb.Append("</td><td>"); sb.Append(d.Tables[8].Rows[i]["from_dt"]); sb.Append("</td><td>"); sb.Append(d.Tables[8].Rows[i]["to_dt"]); sb.Append("</td>"); } sb.Append("</tr>"); //Tn And Vn Details sb.Append("<tr style = 'background-color:#ddd; font-weight:bold' >"); sb.Append("<td colspan ='5'> Tn And Vn :</td></tr>"); sb.Append("<tr><td></td><td><u>cgl</u></td><td>cgl</td><td>Using glasses</td><td>cph</td></tr>"); sb.Append("<tr><td colspan='5'></td></tr>"); for (int i = 0; i <= d.Tables[10].Rows.Count - 1; i++) { sb.Append("<tr><td>Vn-RE</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_re_clg"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_re_clg_v"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_re_ug"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_re_cph"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Vn-LE</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_le_clg"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_le_clg_v"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_le_ug"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_le_cph"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Tn-RE</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_re_clg"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_re_clg_t"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["vn_ug_add"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_re_cph"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Tn-LE</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_le_clg"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_le_clg_t"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(d.Tables[10].Rows[0]["tn_le_cph"]); sb.Append("</td></tr>"); } //S/L sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> S/L :</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[7].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[7].Rows[i]["checkupname"]); if (i == d.Tables[7].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Fundus (F) sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Fundus (F) :</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[4].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[4].Rows[i]["fundusname"]); if (i == d.Tables[4].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Medicine sb.Append("<tr style='background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Previous Disease and Duration:</td></tr>"); sb.Append("<tr style ='font-weight:bold' align='center'><td>Sr.No #</td><td>Medicine #</td><td>Quantity #</td><td>Timeing #</td></tr>"); sb.Append("<tr><td colspan='5'></td></tr>"); for (int i = 0; i <= d.Tables[1].Rows.Count - 1; i++) { sb.Append("<tr align='center'><td>"); sb.Append(i + 1); sb.Append("</td><td>"); sb.Append(d.Tables[1].Rows[i]["particular"]); sb.Append("</td><td>"); sb.Append(d.Tables[1].Rows[i]["quantity"]); sb.Append("</td><td>"); sb.Append(" "); sb.Append(d.Tables[1].Rows[i]["m"]); sb.Append(" "); sb.Append(d.Tables[1].Rows[i]["a"]); sb.Append(" "); sb.Append(d.Tables[1].Rows[i]["e"]); sb.Append(" "); sb.Append(d.Tables[1].Rows[i]["n"]); sb.Append(" "); sb.Append("</td></tr>"); } //Advice sb.Append("<tr style = 'background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'> Advice:</td></tr>"); sb.Append("<tr><td colspan ='5'>"); for (int i = 0; i <= d.Tables[9].Rows.Count - 1; i++) { if (i != 0) { sb.Append(" "); } sb.Append(i + 1); sb.Append(". "); sb.Append(d.Tables[9].Rows[i]["advicename"]); if (i == d.Tables[9].Rows.Count - 1) { sb.Append("."); } } sb.Append("</td></tr>"); //Reports sb.Append("<tr style='background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan ='5'>Reports:</td></tr>"); sb.Append("<tr style ='font-weight:bold' align='center'><td>Sr.No#</td><td>Report#</td><td>date#</td></tr>"); sb.Append("<tr align='center'><td colspan='5'><td>"); for (int i = 0; i <= d.Tables[0].Rows.Count - 1; i++) { if (d.Tables[0].Rows[i]["isBloodTest"].ToString() == "Y") { sb.Append("</tr align='center'><td>"); sb.Append("1"); sb.Append("</td><td>"); sb.Append("Blood Test"); sb.Append("</td><td>"); sb.Append(d.Tables[0].Rows[i]["bloodtest_dt"]); sb.Append("</td></tr>"); } if (d.Tables[0].Rows[i]["isXRay"].ToString() == "Y") { sb.Append("</tr align='center'><td>"); sb.Append("2"); sb.Append("</td><td>"); sb.Append("X-Ray"); sb.Append("</td><td>"); sb.Append(d.Tables[0].Rows[i]["xray_dt"]); sb.Append("</td></tr>"); } } sb.Append("</td></tr>"); //Tn And Vn Details sb.Append("<tr style = 'background-color:#ddd; font-weight:bold' >"); sb.Append("<td colspan ='5'> Eye Vision :</td></tr>"); sb.Append("<tr><td colspan='5'>"); sb.Append("<table border='1'width='700px' style='border-collapse:collapse;'>"); sb.Append("<tr align='center'><td>Eye</td><td colspan = '3'>Right</td><td colspan ='3'>Left</td></tr>"); for (int i = 0; i <= d.Tables[2].Rows.Count - 1; i++) { sb.Append("<tr align='center'><td>Vn</td><td colspan ='3'>6/"); sb.Append(d.Tables[2].Rows[0]["right_vn"]); sb.Append("</td><td colspan ='3'>6/"); sb.Append(d.Tables[2].Rows[0]["left_vn"]); sb.Append("</td></tr>"); sb.Append("<tr align='center'><td></td><td>Sph.</td><td>Cyl.</td><td>Axis.</td><td>Sph.</td><td>Cyl.</td><td>Axis.</td></tr>"); sb.Append("<tr align='center'><td>Dist.</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_dist_sph"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_dist_cyl"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_dist_axis"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_dist_sph"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_dist_cyl"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_dist_axis"]); sb.Append("</td></tr>"); sb.Append("<tr align='center'><td>Near.</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_near_sph"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_near_cyl"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["right_near_axis"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_near_sph"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_near_cyl"]); sb.Append("</td><td>"); sb.Append(d.Tables[2].Rows[0]["left_near_axis"]); sb.Append("</td></tr>"); } sb.Append("</table></td></tr>"); sb.Append("<tr><td colspan='5'></td></tr>"); //Followup sb.Append("<tr style='background-color:#ddd; font-weight:bold'>"); sb.Append("<td colspan='2'>Follow-up Date :</td><td colspan='3'>"); for (int i = 0; i <= d.Tables[0].Rows.Count - 1; i++) { if (d.Tables[0].Rows[0]["isFollowup"].ToString() == "Y") { sb.Append(d.Tables[0].Rows[i]["followup_dt"]); } else { sb.Append("-"); } } sb.Append("</td></tr></table>"); sb.Append("<br><span style='font-size:11px'>## This is computer generated print there no need of signaure.</span>"); return(sb.ToString()); } } }
public static string GenerateDischargePDF() { //Get Patient Details string HospitalName = "Kamla Eye Clinic"; DBConnection con = new DBConnection(); PatientMaster pm = new PatientMaster(); pm.CMD = "View1"; pm.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); pm.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); string xml1 = Common.ToXML(pm); DataSet ds = con.ExecuteProcedure("SP_PatientRegistration", xml1); string patientname = ds.Tables[0].Rows[0]["title"] + " " + ds.Tables[0].Rows[0]["fname"] + " " + ds.Tables[0].Rows[0]["mname"] + " " + ds.Tables[0].Rows[0]["lname"]; //Get Discharge Details Discharge obj = new Discharge(); obj.CMD = "View1"; obj.dischargeid = Convert.ToInt32(HttpContext.Current.Session["dischargeid"]); obj.patientid = Convert.ToInt32(HttpContext.Current.Session["patientid"]); obj.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"]); string xml = Common.ToXML(obj); DataSet d = con.ExecuteProcedure("SP_Discharge", xml); using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); //Generate Header. sb.Append("<div style='font-family:verdana'>"); sb.Append("<table width='700px'>"); sb.Append("<tr style='font-size:30px' align='center'><td colspan=2>"); sb.Append(HospitalName); sb.Append("</td></tr>"); sb.Append("<tr><td colspan='2'></td></tr>"); sb.Append("<tr style='font-size:20px' align='center'><td colspan=2>"); sb.Append("Discharge Card"); sb.Append("</td></tr>"); sb.Append("<tr><td colspan='2'></td></tr>"); sb.Append("<tr style='font-size:18px'><td style='font-weight:bold'>Discharge Date #:"); sb.Append(d.Tables[0].Rows[0]["discharge_dt"]); sb.Append("</td><td style='font-weight:bold'>Discharge Id #:"); sb.Append(d.Tables[0].Rows[0]["dischargeid"]); sb.Append("</td></tr></table><br/>"); sb.Append("<table border='1' width='700px' style='font-size:18px; border-collapse:collapse;'>"); sb.Append("<tr><td colspan ='4' style='background-color:#ddd; font-weight:bold'> PATIENT DETAILS </td></tr>"); sb.Append("<tr><td>Patient Name:</td><td style='font-weight:bold'>"); sb.Append(patientname); sb.Append("</td><td>Patient Id:</td><td style='font-weight:bold'>"); sb.Append(ds.Tables[0].Rows[0]["patientid"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Patient Age:</td><td >"); sb.Append(ds.Tables[0].Rows[0]["age"]); sb.Append("</td><td>Consultant</td><td>"); sb.Append(d.Tables[0].Rows[0]["doctorincharge"]); sb.Append("</td></tr>"); sb.Append("<tr><td>Address:</td>"); sb.Append("<td>-</td>"); sb.Append("<td>Contact No :</td><td>"); sb.Append(ds.Tables[0].Rows[0]["contact"]); sb.Append("</td></tr>"); sb.Append("</table><br/>"); //Generate Discharge card sb.Append("<table border='1' width='700px' style='font-size:18px; border-collapse: collapse;'>"); sb.Append("<tr><td colspan ='2' style='background-color:#ddd; font-weight:bold'>DISCHARGE SUMMARY</td></tr>"); DateTime dt = Convert.ToDateTime(d.Tables[1].Rows[0]["otdate"]); sb.Append("<tr><td>ADMIT DATE:</td><td>"); sb.Append(dt.ToShortDateString()); sb.Append("</td></tr>"); sb.Append("<tr><td>ADMIT TIME:</td><td>"); sb.Append(dt.ToShortTimeString()); sb.Append("</td></tr>"); DateTime ddt = Convert.ToDateTime(d.Tables[0].Rows[0]["discharge_dt"]); sb.Append("<tr><td>DISCHARGE DATE:</td><td>"); sb.Append(ddt.ToShortDateString()); sb.Append("</td></tr>"); sb.Append("<tr><td>DISCHARGE TIME:</td><td>"); sb.Append(ddt.ToShortTimeString()); sb.Append("</td></tr>"); sb.Append("<tr><td>EYE:</td><td>"); sb.Append(d.Tables[0].Rows[0]["eye"]); sb.Append("</td></tr></table><br/>"); //Pre Operative Medicine sb.Append("<table border='1' width='700px' style='font-size:18px; border-collapse: collapse;'>"); sb.Append("<tr><td colspan='2' style='background-color:#ddd; font-weight:bold'>PRE OPERATIVE MEDICINE</td></tr>"); sb.Append("<tr style ='font-size:18px'>"); sb.Append("<td>"); sb.Append("<ol Start='1'>"); sb.Append("<li>MOXISURGE E/D</li>"); sb.Append("<li>SUNEPHRINE-H</li>"); sb.Append("<li>BROMVUE</li>"); sb.Append("<ol>"); sb.Append("</td>"); sb.Append("<td style ='font-size:14px'>"); sb.Append("<ul>"); sb.Append("<li>000</li>"); sb.Append("<li>(2Hrs. BEFORE SURGERY)</li>"); sb.Append("<li>EVERY 10 MIN. ALTERNATE</li>"); sb.Append("</ul>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("<ol Start='4'>"); sb.Append("<li>TAB RANTAC 150MG 1-1</li>"); sb.Append("<li>TAB ZOXAN 500MG 1-1</li>"); sb.Append("<li>TAB I MEG-3</li>"); sb.Append("</ol>"); sb.Append("</td>"); sb.Append("<td style ='font-size:14px'>"); sb.Append("<ul>"); sb.Append("<li>(1 DAY BEFORE SURGERY)</li>"); sb.Append("<li>AFTER FOOD</li>"); sb.Append("<li>(1 DAY BEFORE SURGERY)</li>"); sb.Append("</ul>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); //Post Operative Medicine sb.Append("<br/>"); sb.Append("<table border='1' width='700px' style='font-size:18px; border-collapse: collapse;'>"); sb.Append("<tr><td colspan='2' style='background-color:#ddd; font-weight:bold'>POST OPERATIVE MEDICINE</td></tr>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("<ol Start='1'>"); sb.Append("<li>PREOMET E/D 00</li>"); sb.Append("<li>MOXISURGE E/D 00</li>"); sb.Append("<li>BROMVUE</li>"); sb.Append("<li>TAB RANTAC 150MG 1-1</li>"); sb.Append("<li>TAB ZOXAN 500MG 1-1</li>"); sb.Append("<li>TAB I MEG-3 OD</li>"); sb.Append("<li>TAB SHREELOC / ANP PLUS</li>"); sb.Append("</ol>"); sb.Append("</td>"); sb.Append("<td>"); sb.Append("<ul>"); sb.Append("<li>35 DAYS</li>"); sb.Append("<li>10 DAYS</li>"); sb.Append("<li>10 DAYS</li>"); sb.Append("<li>2 DAYS</li>"); sb.Append("<li>2 DAYS</li>"); sb.Append("<li>9 DAYS</li>"); sb.Append("<li>1 SOS</li>"); sb.Append("</ul>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("<br><span style='font-size:11px'>## This is computer generated print there no need of signaure.</span>"); return(sb.ToString()); } } }
public static string GenerateBillPDF(int billid, int patientid, int hid, DateTime billdate) { //Dummy data for Invoice (Bill). string HospitalName = "Kamla Eye Clinic"; int billNo = billid; PatientBill obj = new PatientBill(); DBConnection cn = new DBConnection(); obj.CMD = "View1"; obj.hid = hid; obj.billid = billid; obj.patientid = patientid; string xml = Common.ToXML(obj); DataSet dataset = cn.ExecuteProcedure("Sp_PatientFinalBill", xml); PatientMaster pm = new PatientMaster(); pm.CMD = "View1"; pm.hid = hid; pm.patientid = patientid; string xml1 = Common.ToXML(pm); DataSet ds = cn.ExecuteProcedure("SP_PatientRegistration", xml1); string patientname = ds.Tables[0].Rows[0]["title"] + " " + ds.Tables[0].Rows[0]["fname"] + " " + ds.Tables[0].Rows[0]["mname"] + " " + ds.Tables[0].Rows[0]["lname"]; using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); //Generate Invoice (Bill) Header. sb.Append("<div style='font-family:verdana'>"); sb.Append("<table width='600px'>"); sb.Append("<tr style='font-size:30px' colspan=2 align='center'><td>"); sb.Append(HospitalName); sb.Append("</td></tr>"); sb.Append("<tr style='font-size:14px'><td>Bill Date #:"); sb.Append(billdate); sb.Append("</td><td>Bill No #:"); sb.Append(billNo); sb.Append("</td></tr></table><br/>"); sb.Append("<table border='1' width='650px' style='font-size:13px; border-collapse: collapse;'>"); sb.Append("<tr><td colspan = '4' style = 'background-color:#ddd; font-weight:bold'>PATIENT & HOSPITAL DETAILS</td></tr>"); sb.Append("<tr><td>Patient Name:</td><td>"); sb.Append(patientname); sb.Append("</td><td>Hospital No:</td><td>"); sb.Append(hid); sb.Append("</td></tr>"); sb.Append("<tr><td> Patient Age:</td><td> "); sb.Append(ds.Tables[0].Rows[0]["age"]); sb.Append("</td><td>Bed No:</td><td>"); sb.Append("-"); sb.Append("</td></tr>"); sb.Append("<tr><td> Address:</td><td>"); sb.Append("-"); sb.Append("</td><td>Admission Date:</td><td>"); sb.Append("-"); sb.Append("</td></tr>"); sb.Append("<tr><td> Consultant :</td><td>"); sb.Append("-"); sb.Append("</td><td>Discharge Date:</td><td>"); sb.Append("-"); sb.Append("</td></tr>"); sb.Append("</table><br/>"); //Generate Invoice (Bill) Items Grid. sb.Append("<table border='1' width='650px' style='font-size:13px; border-collapse: collapse;'>"); sb.Append("<tr style='background-color:#ddd; font-weight:bold'><td>SR#</td><td>PARTICULARS#</td><td>QUANTITY#</td><td>RATE#</td><td>AMOUNT#</td></tr>"); decimal totalamt = 0; for (int i = 0; i <= dataset.Tables[0].Rows.Count - 1; i++) { sb.Append("<tr>"); sb.Append("<td>"); sb.Append(dataset.Tables[0].Rows[i]["srno"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(dataset.Tables[0].Rows[i]["particularname"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(dataset.Tables[0].Rows[i]["qty"]); sb.Append("</td>"); sb.Append("<td>"); sb.Append(Convert.ToDecimal(dataset.Tables[0].Rows[i]["charges"])); sb.Append("</td>"); sb.Append("<td>"); sb.Append(Convert.ToDecimal(dataset.Tables[0].Rows[i]["subtotal"])); sb.Append("</td>"); sb.Append("</tr>"); totalamt = totalamt + Convert.ToDecimal(dataset.Tables[0].Rows[i]["subtotal"]); } sb.Append("<tr>"); sb.Append("<td colspan = 3>"); sb.Append("<table style = 'font-size:13px'>"); sb.Append("<tr><td>COMMENTS/INSTRUCTIONS</td><tr>"); sb.Append("<tr><td>1</td></tr>"); sb.Append("<tr><td>2</td></tr>"); sb.Append("<tr><td>3</td></tr>"); sb.Append("<tr><td>4</td></tr>"); sb.Append("<tr><td>5</td></tr>"); sb.Append("</table></td>"); sb.Append("<td style = 'background-color:#ddd; font-weight:bold'>Total:</td>"); sb.Append("<td style = 'background-color:#ddd; font-weight:bold'>"); sb.Append(totalamt); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table><br/><span style='font-size:11px'>## This is computer generated print there no need of signaure.</span>"); sb.Append("</div>"); return(sb.ToString()); ////Export HTML String as PDF. //StringReader sr = new StringReader(sb.ToString()); //Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); //HTMLWorker htmlparser = new HTMLWorker(pdfDoc); //PdfWriter writer = PdfWriter.GetInstance(pdfDoc, HttpContext.Current.Response.OutputStream); //pdfDoc.Open(); //htmlparser.Parse(sr); //pdfDoc.Close(); //HttpContext.Current.Response.ContentType = "application/pdf"; //HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + billNo + ".pdf"); //HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); //HttpContext.Current.Response.Write(pdfDoc); //HttpContext.Current.Response.End(); } } }