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); }