public static void DeletePatient(tblClinicPatient patient)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicPatient toDelete = (from u in context.tblClinicPatients where u.patientId == patient.patientId select u).First();
context.tblClinicPatients.Remove(toDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
//null or return patient
public static tblClinicPatient isPatient(tblUser e)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicPatient result = (from x in context.tblClinicPatients where x.userId == e.userId select x).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public static tblClinicPatient AddPatient(tblClinicPatient patient)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
if (patient.patientId == 0)
{
//add
tblClinicPatient newPatient = new tblClinicPatient();
newPatient.expiryDate = patient.expiryDate;
newPatient.cardNumber = patient.cardNumber;
newPatient.userId = patient.userId;
context.tblClinicPatients.Add(newPatient);
context.SaveChanges();
patient.patientId = newPatient.patientId;
return(patient);
}
else
{
tblClinicPatient patientToEdit = (from x in context.tblClinicPatients where x.patientId == patient.patientId select x).FirstOrDefault();
patientToEdit.expiryDate = patient.expiryDate;
patientToEdit.hasVirus = patient.hasVirus;
patientToEdit.userId = patient.userId;
patientToEdit.cardNumber = patient.cardNumber;
patientToEdit.doctorId = patient.doctorId;
context.SaveChanges();
return(patient);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
