//null or doctor
public static tblClinicDoctor isDoctor(tblUser e)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicDoctor result = (from x in context.tblClinicDoctors 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 void DeleteDoctor(tblClinicDoctor doctor)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
tblClinicDoctor toDelete = (from u in context.tblClinicDoctors where u.doctorId == doctor.doctorId select u).First();
context.tblClinicDoctors.Remove(toDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public static tblClinicDoctor AddDoctor(tblClinicDoctor doctor)
{
try
{
using (MedicalInstitutionEntities4 context = new MedicalInstitutionEntities4())
{
if (doctor.doctorId == 0)
{
//add
tblClinicDoctor newDoctor = new tblClinicDoctor();
newDoctor.account = doctor.account;
newDoctor.admissionOfPatients = doctor.admissionOfPatients;
newDoctor.department = doctor.department;
newDoctor.managerId = doctor.managerId;
newDoctor.shift = doctor.shift;
newDoctor.userId = doctor.userId;
context.tblClinicDoctors.Add(newDoctor);
context.SaveChanges();
doctor.doctorId = newDoctor.doctorId;
return(doctor);
}
else
{
tblClinicDoctor doctorToEdit = (from x in context.tblClinicDoctors where x.doctorId == doctor.doctorId select x).FirstOrDefault();
doctorToEdit.account = doctor.account;
doctorToEdit.admissionOfPatients = doctor.admissionOfPatients;
doctorToEdit.department = doctor.department;
doctorToEdit.managerId = doctor.managerId;
doctorToEdit.userId = doctor.userId;
doctorToEdit.shift = doctor.shift;
context.SaveChanges();
return(doctor);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}