public ActionResult Medicine_Setup([Bind(Include = "medicineName,mg_ml")] medicine_tb aMedicineTb) { DataBase_Gateway aGateway = new DataBase_Gateway(); try { if (ModelState.IsValid) { aGateway.insert_data(aMedicineTb); return(View("Index")); } } catch (DataException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(View("Medicine_Setup")); }
public ActionResult DoctorEntry([Bind(Include = "doctorName,degree,specialization")] doctor_tb aDoctorTb) { DataBase_Gateway aGateway = new DataBase_Gateway(); try { if (ModelState.IsValid) { aDoctorTb.centerID = (int)TempData["doc1"]; aDoctorTb.centerName = Convert.ToString(TempData["doc2"]); aGateway.insert_data(aDoctorTb); return(View("Center")); } } catch (DataException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(View("error1")); }
public ActionResult treatment(string vid, string vname, string address, string age, string obs, string docid, string docname, string date, List <temp4> obj) { ViewBag.doc1 = aGateway.get_doctordata(); ViewBag.Med1 = aGateway.get_medicinedata(); ViewBag.dis1 = aGateway.get_diseasedata(); int flag1 = 0; int vid1 = Convert.ToInt32(vid); List <treatment_tb> aTreatmentTbs = new List <treatment_tb>(); List <patient_tb> alisList = aGateway.get_patientdata(); if (alisList.Count > 0) { foreach (var match1 in alisList) { if (match1.voterID == vid1) { patient_tb aPatientTb = new patient_tb(); aPatientTb.voterID = match1.voterID; aPatientTb.patientName = match1.patientName; aPatientTb.address = match1.address; aPatientTb.age = match1.age; aPatientTb.patientService = match1.patientService + 1; aManualDb.get_update_pqury(aPatientTb); flag1 = 1; } else { } } if (flag1 == 0) { patient_tb aPatientTb = new patient_tb(); aPatientTb.voterID = Convert.ToInt32(vid); aPatientTb.patientName = vname; aPatientTb.address = address; aPatientTb.age = Convert.ToInt32(age); aPatientTb.patientService = 1; aGateway.insert_data(aPatientTb); } } else { patient_tb aPatientTb = new patient_tb(); aPatientTb.voterID = Convert.ToInt32(vid); aPatientTb.patientName = vname; aPatientTb.address = address; aPatientTb.age = Convert.ToInt32(age); aPatientTb.patientService = 1; aGateway.insert_data(aPatientTb); } int centerid = (int)TempData["doc1"]; TempData["doc1"] = centerid; //int centerid = 6; string centerName = aGateway.getCenterNamebyCenterId(centerid); if (obj.Count > 0) { foreach (var VAR1 in obj) { treatment_tb aTb = new treatment_tb(); aTb.patientID = Convert.ToInt32(vid); aTb.patientName = vname; aTb.doctorID = Convert.ToInt32(docid); aTb.doctorName = docname; aTb.centerID = centerid; aTb.centerName = centerName; aTb.observation = obs; aTb.date = date; aTb.diseaseID = Convert.ToInt32(VAR1.id); aTb.diseaseName = VAR1.text1; aTb.medicineID = Convert.ToInt32(VAR1.text2); aTb.medicineName = VAR1.text3; aTb.dose = Convert.ToInt32(VAR1.text4); aTb.timeForTake = VAR1.text5; aTb.quantity = Convert.ToInt32(VAR1.text6); aTb.note = VAR1.text7; aTreatmentTbs.Add(aTb); } aGateway.insert_treatment_list(aTreatmentTbs); aManualDb.get_update_minusqury(aTreatmentTbs); } return(View()); }