/// <summary>
/// Get an object from database based on the property Id.
/// </summary>
/// <param name="patient"></param>
/// <returns>An object of type Patient.</returns>
public Patient GetPatientById(int id)
{
Patient patient = null;
using (HolmuskHealthCareEntities context = new HolmuskHealthCareEntities())
{
patient = context.Patients.FirstOrDefault <Patient>();
}
return(patient);
}
/// <summary>
/// Get list of object from database.
/// </summary>
/// <returns>An enumerable collection of object having type as Patient.</returns>
public IEnumerable <Patient> GetPatients()
{
List <Patient> patients = null;
using (HolmuskHealthCareEntities context = new HolmuskHealthCareEntities())
{
patients = context.Patients.ToList();
}
return(patients);
}
/// <summary>
/// Delete an object in database.
/// </summary>
/// <param name="patient"></param>
/// <returns>An object of type Patient.</returns>
public Patient DeletePatient(Patient patient)
{
using (HolmuskHealthCareEntities context = new HolmuskHealthCareEntities())
{
var existingPatient = context.Patients.Where(p => p.Id == patient.Id).FirstOrDefault <Patient>();
if (existingPatient != null)
{
existingPatient.IsActive = patient.IsActive;
}
context.SaveChanges();
return(patient);
}
}
/// <summary>
/// Adds an object to database.
/// </summary>
/// <param name="patient"></param>
/// <returns>An object of type Patient.</returns>
public Patient AddPatient(Patient patient)
{
using (HolmuskHealthCareEntities context = new HolmuskHealthCareEntities())
{
var existingPatient = context.Patients.Where(p => p.Name == patient.Name && patient.ContactNumber == patient.ContactNumber && p.BirthDate == patient.BirthDate).FirstOrDefault <Patient>();
if (existingPatient == null)
{
context.Patients.Add(patient);
context.SaveChanges();
}
return(patient);
}
}
/// <summary>
/// Modify an object in database.
/// </summary>
/// <param name="patient"></param>
/// <returns>An object of type Patient.</returns>
public Patient UpdatePatient(Patient patient)
{
using (HolmuskHealthCareEntities context = new HolmuskHealthCareEntities())
{
var existingPatient = context.Patients.Where(p => p.Id == patient.Id).FirstOrDefault <Patient>();
if (existingPatient != null)
{
existingPatient.Name = patient.Name;
existingPatient.Address = patient.Address;
existingPatient.BirthDate = patient.BirthDate;
existingPatient.ContactNumber = patient.ContactNumber;
existingPatient.Gender = patient.Gender;
existingPatient.IsActive = patient.IsActive;
}
context.SaveChanges();
return(patient);
}
}
