public ActionResult <IEnumerable <Patient> > Get() { List <Patient> patients = new List <Patient>(); using (var DB = new AeffectContext()) { patients = DB.Patient.ToList(); } return(patients); }
public ActionResult <IEnumerable <Patient> > Get2(string search) { List <Patient> patients = new List <Patient>(); using (var DB = new AeffectContext()) { patients = DB.Patient.Where(p => p.FirstName.Contains(search)).ToList(); } return(patients); }
public ActionResult <IEnumerable <State> > Get() { List <State> states = new List <State>(); using (var DB = new AeffectContext()) { states = DB.State.ToList(); } return(states); }
public void Delete(int id) { using (var DB = new AeffectContext()) { Patient deletePt = new Patient() { PatientId = id }; DB.Patient.Attach(deletePt); DB.Patient.Remove(deletePt); DB.SaveChanges(); } }
public void Post([FromBody] AddPtRequest AddPtRequest) //public void Get([FromQuery] string stateID, [FromQuery] string stateName) { Patient patient = new Patient(); patient.PatientId = AddPtRequest.ptId; patient.FirstName = AddPtRequest.firstName; patient.LastName = AddPtRequest.lastName; patient.Dob = AddPtRequest.dob; patient.AddressLine1 = AddPtRequest.address; patient.AddressLine2 = AddPtRequest.address2; patient.City = AddPtRequest.city; patient.State = AddPtRequest.state; patient.Zip = AddPtRequest.zipCode; patient.Account = AddPtRequest.account; patient.MedRecord = AddPtRequest.medRecord; patient.UnitId = AddPtRequest.unitId; using (var DB = new AeffectContext()) { DB.Patient.Add(patient); DB.SaveChanges(); } }