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