public ActionResult Create(ICollection<MedicineClinic> json)
        {
            DatabaseConnection aConnection=new DatabaseConnection();

            foreach (MedicineClinic medicineClinic in json)
            {
                aConnection.UpdateMedicineHeadOffice(medicineClinic.Medicine_MedicineID,medicineClinic.Quantity);
                int chk =
                    db.MedicineClinics.Where(
                        x =>
                            x.CommunityClinicID == medicineClinic.CommunityClinicID &&
                            x.Medicine_MedicineID == medicineClinic.Medicine_MedicineID).ToList().Count;
                if (chk == 0)
                {
                    db.MedicineClinics.Add(medicineClinic);
                    db.SaveChanges();
                }
                else
                {
                    aConnection.UpdateMedicineDistributionClinic(medicineClinic.CommunityClinicID,medicineClinic.Medicine_MedicineID,medicineClinic.Quantity);

                }
            }

            ViewBag.DistrictID = new List<District>(db.Districts);
            ViewBag.MedicineID = new List<Medicine>(db.Medicines);

            return View();
        }
 public ContentResult GetChartData(string fromDate,string toDate, string DistrictID)
 {
     DatabaseConnection aConnection=new DatabaseConnection();
     List<DiseaseReportViewModel> aViewModels = aConnection.GetChartData(fromDate, toDate, Convert.ToInt32(DistrictID));
     return Content(JsonConvert.SerializeObject(aViewModels));
 }
 public ActionResult GetAllDemographicData(string fromDate,string toDate,string DiseaseName)
 {
     DatabaseConnection aDatabaseConnection=new DatabaseConnection();
        List<DiseaseReportViewModel> aViewModels= aDatabaseConnection.GetAllDemographicData(fromDate, toDate, DiseaseName);
        return Json(aViewModels, JsonRequestBehavior.AllowGet);
 }
 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);
        }
 public ContentResult GetDemographicData(string fromDate, string toDate, string DistrictName,string DiseaseName)
 {
     int DistrictID = db.Districts.Where(x => x.DistrictName == DistrictName).ToList().First().DistrictID;
     DatabaseConnection aConnection = new DatabaseConnection();
     List<DiseaseReportViewModel> aViewModels = aConnection.GetDemographicData(fromDate, toDate, Convert.ToInt32(DistrictID), DiseaseName);
     return Content(JsonConvert.SerializeObject(aViewModels));
 }
        public ActionResult MedicineStock()
        {
            int clinicId = Convert.ToInt32(System.Web.HttpContext.Current.User.Identity.Name.Split('|')[2]);

            string clinicName =
                db.CommunityClinics.Where(
                    x =>
                        x.CommunityClinicID ==clinicId
                        )
                    .ToList()
                    .First()
                    .ClinicName;
            ViewBag.Clinic = clinicName;
            DatabaseConnection aConnection=new DatabaseConnection();
            List<MedicineStockViewModel> aStock=aConnection.GetMedicineStock();

            return View(aStock);
        }