// GET: Patient public ActionResult Index(string search) { using (PatientsDBEntities medcard = new PatientsDBEntities()) { return(View(medcard.Patients.Where(x => x.p_idcard.StartsWith(search) || search == null).ToList())); } }
public HttpResponseMessage Delete(int id) { try { using (PatientsDBEntities entities = new PatientsDBEntities()) { var entity = entities.Patients.FirstOrDefault(p => p.Patient_ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id + "not found")); } else { entities.Patients.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (DbEntityValidationException ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// GET: Patient/Delete/5 public ActionResult Delete(int id) { using (PatientsDBEntities medcard = new PatientsDBEntities()) { return(View(medcard.Patients.Where(x => x.id == id).FirstOrDefault())); } }
public List <Patient> GetAllPatients() { using (var db = new PatientsDBEntities()) { return(db.Patients.ToList()); } }
public Patient GetPatient(string id) { using (var db = new PatientsDBEntities()) { var patientID = Int32.Parse(id); return(db.Patients.Where(x => x.Id == patientID).SingleOrDefault()); } }
public static bool Login(string username, string password) { using (PatientsDBEntities entities = new PatientsDBEntities()) { return(entities.Users.Any(user => user.User_Name.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password == password)); } }
public int AddPatient(Patient patient) { using (var db = new PatientsDBEntities()) { db.Patients.Add(patient); db.SaveChanges(); return(patient.Id); } }
public HttpResponseMessage Put(int id, [FromBody] Patient patientDetails) { try { using (PatientsDBEntities entity = new PatientsDBEntities()) { if (patientDetails != null) { var entities = entity.Patients.FirstOrDefault(p => p.Patient_ID == id); entities.Age = patientDetails.Age; entities.BloodPressure = patientDetails.BloodPressure; entities.BMI = patientDetails.BMI; entities.BodyFat = patientDetails.BodyFat; entities.BodyWater = patientDetails.BodyWater; entities.BoneMass = patientDetails.BoneMass; entities.ECG = patientDetails.ECG; entities.EyeTest = patientDetails.EyeTest; entities.Gender = patientDetails.Gender; entities.HaemoglobinCount = patientDetails.HaemoglobinCount; entities.MuscleMass = patientDetails.MuscleMass; entities.Hip = patientDetails.Hip; entities.Height = patientDetails.Height; entities.ECG = patientDetails.ECG; entities.IdealBodyWeight = patientDetails.IdealBodyWeight; entities.Patient_Location = patientDetails.Patient_Location; entities.Patient_Name = patientDetails.Patient_Name; entities.ExaminedOn = patientDetails.ExaminedOn; entities.SkinTest = patientDetails.SkinTest; entities.SPO2 = patientDetails.SPO2; entities.VaccinationHB = patientDetails.VaccinationHB; entities.VaccinationTyphoid = patientDetails.VaccinationTyphoid; entities.Waist = patientDetails.Waist; entities.WaistHeightRatio = patientDetails.WaistHeightRatio; entities.WaistHipRatio = patientDetails.WaistHipRatio; entity.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entities)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with ID: " + patientDetails.Patient_ID + "not found to update")); } } } catch (DbEntityValidationException ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetPatientDetails() { try { using (PatientsDBEntities entity = new PatientsDBEntities()) { var entities = entity.Patients.ToList(); return(Request.CreateResponse(HttpStatusCode.OK, entities)); } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public bool UpdatePatient(Patient _patient) { using (var db = new PatientsDBEntities()) { var patient = db.Patients.Where(x => x.Id == _patient.Id).SingleOrDefault(); patient.Name = _patient.Name; patient.Location = _patient.Location; patient.EntryDate = _patient.EntryDate; db.SaveChanges(); return(true); } }
public ActionResult Delete(int id, Patients patient) { try { // TODO: Add delete logic here using (PatientsDBEntities medcard = new PatientsDBEntities()) { patient = medcard.Patients.Where(x => x.id == id).FirstOrDefault(); medcard.Patients.Remove(patient); medcard.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(int id, Patients patient) { try { using (PatientsDBEntities medcard = new PatientsDBEntities()) { medcard.Entry(patient).State = EntityState.Modified; medcard.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Patients patient) { try { using (PatientsDBEntities medcard = new PatientsDBEntities()) { medcard.Patients.Add(patient); medcard.SaveChanges(); } // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public HttpResponseMessage Post([FromBody] Patient patientDetails) { try { using (PatientsDBEntities entity = new PatientsDBEntities()) { entity.Patients.Add(patientDetails); entity.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, patientDetails); message.Headers.Location = new Uri(Request.RequestUri + patientDetails.Patient_ID.ToString()); return(message); } } catch (DbEntityValidationException e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public HttpResponseMessage GetPatientDetail(int id) { try { using (PatientsDBEntities entity = new PatientsDBEntities()) { var entities = entity.Patients.FirstOrDefault(e => e.Patient_ID == id); if (entities != null) { return(Request.CreateResponse(HttpStatusCode.OK, entities)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Patient with ID: " + id + " is not found")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }