public static IQueryable <Patient> GetPatients(Patient searchCrit)
{
DataClassesClinicDataContext dc = new DataClassesClinicDataContext();
var res = from el in dc.Patients
where
(String.IsNullOrEmpty(searchCrit.LastName) || el.LastName.StartsWith(searchCrit.LastName))
&&
((searchCrit.IdPatient == 0) || el.IdPatient == searchCrit.IdPatient)
// && inne ...
select el;
return(res);
}
public static void NewPatientData(Patient pat)
{
using (DataClassesClinicDataContext dc = new DataClassesClinicDataContext())
{
var res = new Patient();
res.LastName = pat.LastName;
res.FirstName = pat.FirstName;
res.PESEL = pat.PESEL;
dc.Patients.InsertOnSubmit(res);
dc.SubmitChanges();
}
}
public static IQueryable GetVisits(Visit searchCrit)
{
DataClassesClinicDataContext dc = new DataClassesClinicDataContext();
var res = from vis in dc.Visits
select
new
{
vis.IdVisit,
FirstName = vis.Patient.FirstName,
LastName = vis.Patient.LastName,
vis.Description,
vis.Diagnosis
};
return(res);
}
/// <summary>
/// nie musi być void
/// </summary>
/// <param name="pat"></param>
public static void UpdatePatientData(Patient pat)
{
using (DataClassesClinicDataContext dc = new DataClassesClinicDataContext())
{
var res = (from el in dc.Patients
where el.IdPatient == pat.IdPatient
select el).SingleOrDefault();
if (res == null)
{
return;
}
res.LastName = pat.LastName;
res.FirstName = pat.FirstName;
dc.SubmitChanges();
}
}
public static IQueryable GetDoctors(Doctor searchCrit)
{
DataClassesClinicDataContext dc = new DataClassesClinicDataContext();
var res = from doc in dc.Doctors
select
new
{
//FirstName = vis.Patient.FirstName,
//LastName = vis.Patient.LastName,
doc.Id_Doc,
doc.Name,
doc.Surname,
};
return(res);
}