public void GenerateCharityReport(string sCharity)
{
string sql = "SELECT orphanexpense.id,orphanexpense.Amount,orphanexpense.Notes,orphanexpense.Added,orphanexpense.Charity,orphanexpense.ChildID,orphanexpense.Balance,sponsoredOrphan.Name "
+ " from orphanexpense inner join sponsoredorphan on sponsoredorphan.childid=orphanexpense.childid where sponsoredorphan.charity = '"
+ BMS.PurifySQL(sCharity, 50) + "' order by added";
string html = UICommon.GetCharityTableHTML(sql);
var result = Pdf.From(html).Portrait().Content();
Response.Clear();
Response.ContentType = "application/pdf";
string accName = "Charity Report - " + sCharity + ".pdf";
Response.AddHeader("Content-Disposition", "attachment;filename=" + accName);
Response.BinaryWrite(result);
Response.Flush();
Response.End();
}
