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