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 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);
}
}
