public ActionResult ShowPDFReport(string fromDate, string toDate, string DiseaseID)
 {
     DatabaseConnection aConnection=new DatabaseConnection();
     List<DeseaseWiseReport> aDeseaseWiseReports= aConnection.GetDiseaseWiseData(DiseaseID, fromDate, toDate);
     ViewBag.Report = aDeseaseWiseReports;
     return View();
 }
        public ActionResult GetDiseaseReportData(string deseaseID, string myPicker1, string myPicker2)
        {
            DatabaseConnection aDataConnection = new DatabaseConnection();
            List<DeseaseWiseReport> aDeseaseWiseReport = new List<DeseaseWiseReport>();
            Desease aDesease = new Desease();

            //DateTime myPicker;

            aDeseaseWiseReport = aDataConnection.GetDiseaseWiseData(deseaseID, myPicker1, myPicker2);

            return Json(aDeseaseWiseReport, JsonRequestBehavior.AllowGet);
        }