public bool CheckUserName(string username)
{
using (HospitalEntities5 context = new HospitalEntities5())
{
vwDoctor docUser = (from d in context.vwDoctors where d.Username == username select d).FirstOrDefault();
vwPatient patientUser = (from d in context.vwPatients where d.Username == username select d).FirstOrDefault();
if (docUser != null || patientUser != null)
{
return(false);
}
return(true);
}
}
public vwRequest GetOpenRequestByPatient(int patientId)
{
using (HospitalEntities5 context = new HospitalEntities5())
{
if (context.vwRequests == null)
{
return(null);
}
else
{
vwRequest patientRequest = (from r in context.vwRequests where r.PatientId == patientId where r.IsApproved == null select r).FirstOrDefault();
return(patientRequest);
}
}
}
public List <vwDoctor> GetAllDoctors()
{
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
List <vwDoctor> list = new List <vwDoctor>();
list = (from p in context.vwDoctors select p).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public vwRequest AddRequest(vwRequest request)
{
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
if (request.RequestId == 0)
{
Request newRequest = new Request();
newRequest.Date = request.Date;
newRequest.Reason = request.Reason;
newRequest.Company = request.Company;
newRequest.IsUrgent = request.IsUrgent;
newRequest.IsApproved = request.IsApproved;
newRequest.PatientId = request.PatientId;
newRequest.DoctorId = request.DoctorId;
context.Requests.Add(newRequest);
context.SaveChanges();
request.RequestId = newRequest.RequestId;
return(request);
}
else
{
Request editRequest = (from p in context.Requests where p.RequestId == request.RequestId select p).First();
editRequest.Date = request.Date;
editRequest.Reason = request.Reason;
editRequest.Company = request.Company;
editRequest.IsUrgent = request.IsUrgent;
editRequest.IsApproved = request.IsApproved;
editRequest.PatientId = request.PatientId;
editRequest.DoctorId = request.DoctorId;
editRequest.RequestId = request.RequestId;
context.SaveChanges();
return(request);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwRequest> GetAllRequestByDoctor(int doctorId)
{
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
List <vwRequest> list = new List <vwRequest>();
list = (from p in context.vwRequests where p.DoctorId == doctorId select p).OrderByDescending(x => x.IsApproved == null).ThenByDescending(x => x.IsUrgent).ThenByDescending(x => x.Date).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public List <vwRequest> GetAllRequestByPatient(int patientId)
{
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
List <vwRequest> list = new List <vwRequest>();
list = (from p in context.vwRequests where p.PatientId == patientId select p).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
public Doctor LoginDoctor(string username, string password)
{
password = HashPasswordHelper.HashPassword(password);
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
Doctor doctor = (from d in context.Doctors
where d.Username.Equals(username) where d.DoctorPassword.Equals(password) select d).First();
return(doctor);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public Patient AddPatient(Patient patient)
{
bool uniqueUser = CheckUserName(patient.Username);
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
if (patient.PatientId == 0)
{
if (uniqueUser)
{
Patient newPatient = new Patient();
newPatient.Fullname = patient.Fullname;
newPatient.PatientJMBG = patient.PatientJMBG;
newPatient.NumInsurce = patient.NumInsurce;
newPatient.Username = patient.Username;
newPatient.PatientPassword = HashPasswordHelper.HashPassword(patient.PatientPassword);
context.Patients.Add(newPatient);
context.SaveChanges();
patient.PatientId = newPatient.PatientId;
}
return(patient);
}
else
{
Patient editPatient = (from p in context.Patients where p.PatientId == patient.PatientId select p).First();
editPatient.Fullname = patient.Fullname;
editPatient.PatientJMBG = patient.PatientJMBG;
editPatient.NumInsurce = patient.NumInsurce;
editPatient.Username = patient.Username;
editPatient.DoctorId = patient.DoctorId;
editPatient.PatientId = patient.PatientId;
context.SaveChanges();
return(patient);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public Doctor AddDoctor(Doctor doctor)
{
bool uniqueUser = CheckUserName(doctor.Username);
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
if (doctor.DoctorId == 0)
{
if (uniqueUser)
{
Doctor newDoctor = new Doctor();
newDoctor.FullName = doctor.FullName;
newDoctor.DoctorJMBG = doctor.DoctorJMBG;
newDoctor.BankAccount = doctor.BankAccount;
newDoctor.Username = doctor.Username;
newDoctor.DoctorPassword = HashPasswordHelper.HashPassword(doctor.DoctorPassword);
context.Doctors.Add(newDoctor);
context.SaveChanges();
doctor.DoctorId = newDoctor.DoctorId;
}
return(doctor);
}
else
{
Doctor editDoctor = (from p in context.Doctors where p.DoctorId == doctor.DoctorId select p).First();
editDoctor.FullName = doctor.FullName;
editDoctor.DoctorJMBG = doctor.DoctorJMBG;
editDoctor.BankAccount = doctor.BankAccount;
editDoctor.Username = doctor.Username;
editDoctor.DoctorPassword = doctor.DoctorPassword;
editDoctor.DoctorId = doctor.DoctorId;
context.SaveChanges();
return(doctor);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void DeleteRequest(int requestId)
{
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
Request resultToDelete = (from r in context.Requests where r.RequestId == requestId select r).First();
if (resultToDelete.IsApproved != null)
{
context.Requests.Remove(resultToDelete);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public Patient LoginPatient(string username, string password)
{
password = HashPasswordHelper.HashPassword(password);
try
{
using (HospitalEntities5 context = new HospitalEntities5())
{
Patient patient = (from p in context.Patients
where p.Username.Equals(username)
where p.PatientPassword.Equals(password)
select p).First();
return(patient);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
