public override object Get(int id)
{
PatientVisitUnscheduled acc = _context.PatientVisitUnscheduleds.Include("Patient")
.Include("Patient.User")
.Include("Specialty")
.Include("RoomTest")
.Where(p => p.Id == id &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault <PatientVisitUnscheduled>();
if (acc == null)
{
return(new BO.ErrorObject {
ErrorMessage = "No record found for this Id.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
else
{
var res = Convert <BO.PatientVisitUnscheduled, PatientVisitUnscheduled>(acc);
return((object)res);
}
}
public HttpResponseMessage Post([FromBody] PatientVisitUnscheduled data)
{
return(requestHandler.CreateGbObject(Request, data));
}
public override object SaveReferralPatientVisitUnscheduled <T>(T entity)
{
BO.ReferralVisitUnscheduled ReferralVisitUnscheduledBO = (BO.ReferralVisitUnscheduled)(object) entity;
BO.PatientVisitUnscheduled PatientVisitUnscheduledBO = ReferralVisitUnscheduledBO.PatientVisitUnscheduled;
PatientVisitUnscheduled PatientVisitUnscheduledDB = new PatientVisitUnscheduled();
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
var ReferralDB = _context.Referrals.Where(p => p.PendingReferralId == ReferralVisitUnscheduledBO.PendingReferralId &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault();
if (ReferralDB != null)
{
dbContextTransaction.Rollback();
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Referral already exists for the pending referral.", ErrorLevel = ErrorLevel.Error
});
}
else
{
ReferralDB = new Referral();
var PendingReferralDB = _context.PendingReferrals.Include("PatientVisit")
.Where(p => p.Id == ReferralVisitUnscheduledBO.PendingReferralId &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault();
if (PendingReferralDB == null)
{
dbContextTransaction.Rollback();
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Pending Referral dosent exists.", ErrorLevel = ErrorLevel.Error
});
}
else
{
PendingReferralDB.IsReferralCreated = true;
ReferralDB.PendingReferralId = PendingReferralDB.Id;
ReferralDB.FromCompanyId = PendingReferralDB.FromCompanyId;
ReferralDB.FromLocationId = PendingReferralDB.FromLocationId;
ReferralDB.FromDoctorId = PendingReferralDB.FromDoctorId;
ReferralDB.FromUserId = null;
ReferralDB.ForSpecialtyId = PendingReferralDB.ForSpecialtyId;
ReferralDB.ForRoomId = PendingReferralDB.ForRoomId;
ReferralDB.ForRoomTestId = PendingReferralDB.ForRoomTestId;
ReferralDB.ToCompanyId = null;
ReferralDB.ToLocationId = null;
ReferralDB.ToDoctorId = null;
ReferralDB.ToRoomId = null;
ReferralDB.ScheduledPatientVisitId = null;
ReferralDB.DismissedBy = null;
if (PendingReferralDB.PatientVisit != null && PendingReferralDB.PatientVisit.CaseId.HasValue == true)
{
ReferralDB.CaseId = PendingReferralDB.PatientVisit.CaseId.Value;
}
else
{
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid CaseId.", ErrorLevel = ErrorLevel.Error
});
}
ReferralDB = _context.Referrals.Add(ReferralDB);
_context.SaveChanges();
#region Patient Visit Unscheduled
if (PatientVisitUnscheduledBO == null || (PatientVisitUnscheduledBO != null && PatientVisitUnscheduledBO.ID > 0))
{
dbContextTransaction.Rollback();
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Unscheduled Patient Visit can only be added while referral.", ErrorLevel = ErrorLevel.Error
});
}
else
{
bool Add_patientVisitUnscheduledDB = false;
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds.Where(p => p.Id == PatientVisitUnscheduledBO.ID &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault();
if (PatientVisitUnscheduledDB == null && PatientVisitUnscheduledBO.ID <= 0)
{
PatientVisitUnscheduledDB = new PatientVisitUnscheduled();
Add_patientVisitUnscheduledDB = true;
}
else
{
dbContextTransaction.Rollback();
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Unscheduled Patient Visit doesn't exists.", ErrorLevel = ErrorLevel.Error
});
}
PatientVisitUnscheduledDB.CaseId = PatientVisitUnscheduledBO.CaseId.Value;
PatientVisitUnscheduledDB.PatientId = PatientVisitUnscheduledBO.PatientId.Value;
PatientVisitUnscheduledDB.EventStart = PatientVisitUnscheduledBO.EventStart;
PatientVisitUnscheduledDB.MedicalProviderName = PatientVisitUnscheduledBO.MedicalProviderName;
PatientVisitUnscheduledDB.DoctorName = PatientVisitUnscheduledBO.DoctorName;
PatientVisitUnscheduledDB.Notes = PatientVisitUnscheduledBO.Notes;
PatientVisitUnscheduledDB.SpecialtyId = PatientVisitUnscheduledBO.SpecialtyId;
PatientVisitUnscheduledDB.RoomTestId = PatientVisitUnscheduledBO.RoomTestId;
PatientVisitUnscheduledDB.ReferralId = ReferralDB.Id;
PatientVisitUnscheduledDB.CreateByUserID = PatientVisitUnscheduledBO.CreateByUserID;
PatientVisitUnscheduledDB.CreateDate = DateTime.UtcNow;
if (Add_patientVisitUnscheduledDB == true)
{
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds.Add(PatientVisitUnscheduledDB);
}
_context.SaveChanges();
dbContextTransaction.Commit();
}
#endregion
}
}
if (PatientVisitUnscheduledDB != null)
{
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds
.Include("Patient").Include("Patient.User").Include("Patient.User.UserCompanies")
.Include("Specialty")
.Include("RoomTest")
.Where(p => p.Id == PatientVisitUnscheduledDB.Id &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault <PatientVisitUnscheduled>();
}
}
var res = Convert <BO.PatientVisitUnscheduled, PatientVisitUnscheduled>(PatientVisitUnscheduledDB);
return((object)res);
}
public override T Convert <T, U>(U entity)
{
if (entity is PatientVisitUnscheduled)
{
PatientVisitUnscheduled PatientVisitUnscheduledDB = entity as PatientVisitUnscheduled;
if (PatientVisitUnscheduledDB == null)
{
return(default(T));
}
BO.PatientVisitUnscheduled PatientVisitUnscheduledBO = new BO.PatientVisitUnscheduled();
PatientVisitUnscheduledBO.ID = PatientVisitUnscheduledDB.Id;
PatientVisitUnscheduledBO.CaseId = PatientVisitUnscheduledDB.CaseId;
PatientVisitUnscheduledBO.PatientId = PatientVisitUnscheduledDB.PatientId;
PatientVisitUnscheduledBO.EventStart = PatientVisitUnscheduledDB.EventStart;
PatientVisitUnscheduledBO.MedicalProviderName = PatientVisitUnscheduledDB.MedicalProviderName;
PatientVisitUnscheduledBO.DoctorName = PatientVisitUnscheduledDB.DoctorName;
PatientVisitUnscheduledBO.Notes = PatientVisitUnscheduledDB.Notes;
PatientVisitUnscheduledBO.SpecialtyId = PatientVisitUnscheduledDB.SpecialtyId;
PatientVisitUnscheduledBO.RoomTestId = PatientVisitUnscheduledDB.RoomTestId;
PatientVisitUnscheduledBO.ReferralId = PatientVisitUnscheduledDB.ReferralId;
PatientVisitUnscheduledBO.Status = "Completed";
PatientVisitUnscheduledBO.IsDeleted = PatientVisitUnscheduledDB.IsDeleted;
PatientVisitUnscheduledBO.CreateByUserID = PatientVisitUnscheduledDB.CreateByUserID;
PatientVisitUnscheduledBO.UpdateByUserID = PatientVisitUnscheduledDB.UpdateByUserID;
if (PatientVisitUnscheduledDB.Patient != null)
{
BO.Patient PatientBO = new BO.Patient();
using (PatientRepository patientRepo = new PatientRepository(_context))
{
PatientBO = patientRepo.Convert <BO.Patient, Patient>(PatientVisitUnscheduledDB.Patient);
PatientVisitUnscheduledBO.Patient = PatientBO;
}
}
if (PatientVisitUnscheduledDB.Specialty != null)
{
BO.Specialty SpecialtyBO = new BO.Specialty();
using (SpecialityRepository specialtyRepo = new SpecialityRepository(_context))
{
SpecialtyBO = specialtyRepo.Convert <BO.Specialty, Specialty>(PatientVisitUnscheduledDB.Specialty);
PatientVisitUnscheduledBO.Specialty = SpecialtyBO;
}
}
if (PatientVisitUnscheduledDB.RoomTest != null)
{
BO.RoomTest RoomTestBO = new BO.RoomTest();
using (RoomTestRepository roomTestRepo = new RoomTestRepository(_context))
{
RoomTestBO = roomTestRepo.Convert <BO.RoomTest, RoomTest>(PatientVisitUnscheduledDB.RoomTest);
PatientVisitUnscheduledBO.RoomTest = RoomTestBO;
}
}
if (PatientVisitUnscheduledDB.Case != null)
{
BO.Case CaseBO = new BO.Case();
using (CaseRepository caseRepo = new CaseRepository(_context))
{
CaseBO = caseRepo.Convert <BO.Case, Case>(PatientVisitUnscheduledDB.Case);
PatientVisitUnscheduledBO.Case = CaseBO;
if (PatientVisitUnscheduledDB.Case.PatientAccidentInfoes != null && PatientVisitUnscheduledDB.Case.PatientAccidentInfoes.Count > 0)
{
List <BO.PatientAccidentInfo> PatientAccidentInfoBOList = new List <BO.PatientAccidentInfo>();
using (PatientAccidentInfoRepository patientAccidentInfoRepo = new PatientAccidentInfoRepository(_context))
{
foreach (PatientAccidentInfo eachPatientInsuranceInfo in PatientVisitUnscheduledDB.Case.PatientAccidentInfoes)
{
if (eachPatientInsuranceInfo.IsDeleted.HasValue == false || (eachPatientInsuranceInfo.IsDeleted.HasValue == true && eachPatientInsuranceInfo.IsDeleted.Value == false))
{
PatientAccidentInfoBOList.Add(patientAccidentInfoRepo.Convert <BO.PatientAccidentInfo, PatientAccidentInfo>(eachPatientInsuranceInfo));
}
}
PatientVisitUnscheduledBO.Case.PatientAccidentInfoes = PatientAccidentInfoBOList;
}
}
}
}
return((T)(object)PatientVisitUnscheduledBO);
}
return(default(T));
}
public override object Save <T>(T entity)
{
BO.PatientVisitUnscheduled PatientVisitUnscheduledBO = (BO.PatientVisitUnscheduled)(object) entity;
PatientVisitUnscheduled PatientVisitUnscheduledDB = new PatientVisitUnscheduled();
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
bool IsEditMode = false;
IsEditMode = (PatientVisitUnscheduledBO != null && PatientVisitUnscheduledBO.ID > 0) ? true : false;
#region Patient Visit Unscheduled
if (PatientVisitUnscheduledBO != null &&
((PatientVisitUnscheduledBO.ID <= 0 && PatientVisitUnscheduledBO.PatientId.HasValue == true && PatientVisitUnscheduledBO.CaseId.HasValue == true) ||
(PatientVisitUnscheduledBO.ID > 0)))
{
bool Add_patientVisitUnscheduledDB = false;
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds.Where(p => p.Id == PatientVisitUnscheduledBO.ID &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault();
if (PatientVisitUnscheduledDB == null && PatientVisitUnscheduledBO.ID <= 0)
{
PatientVisitUnscheduledDB = new PatientVisitUnscheduled();
Add_patientVisitUnscheduledDB = true;
}
else if (PatientVisitUnscheduledDB == null && PatientVisitUnscheduledBO.ID > 0)
{
dbContextTransaction.Rollback();
return(new BO.ErrorObject {
errorObject = "", ErrorMessage = "Unscheduled Patient Visit doesn't exists.", ErrorLevel = ErrorLevel.Error
});
}
PatientVisitUnscheduledDB.CaseId = IsEditMode == true && PatientVisitUnscheduledBO.CaseId.HasValue == false ? PatientVisitUnscheduledDB.CaseId : (PatientVisitUnscheduledBO.CaseId.HasValue == false ? PatientVisitUnscheduledDB.CaseId : PatientVisitUnscheduledBO.CaseId.Value);
PatientVisitUnscheduledDB.PatientId = IsEditMode == true && PatientVisitUnscheduledBO.PatientId.HasValue == false ? PatientVisitUnscheduledDB.PatientId : (PatientVisitUnscheduledBO.PatientId.HasValue == false ? PatientVisitUnscheduledDB.PatientId : PatientVisitUnscheduledBO.PatientId.Value);
PatientVisitUnscheduledDB.EventStart = PatientVisitUnscheduledBO.EventStart;
PatientVisitUnscheduledDB.MedicalProviderName = PatientVisitUnscheduledBO.MedicalProviderName;
PatientVisitUnscheduledDB.DoctorName = PatientVisitUnscheduledBO.DoctorName;
PatientVisitUnscheduledDB.Notes = PatientVisitUnscheduledBO.Notes;
PatientVisitUnscheduledDB.SpecialtyId = PatientVisitUnscheduledBO.SpecialtyId;
PatientVisitUnscheduledDB.RoomTestId = PatientVisitUnscheduledBO.RoomTestId;
if (IsEditMode == false)
{
PatientVisitUnscheduledDB.ReferralId = PatientVisitUnscheduledBO.ReferralId;
PatientVisitUnscheduledDB.CreateByUserID = PatientVisitUnscheduledBO.CreateByUserID;
PatientVisitUnscheduledDB.CreateDate = DateTime.UtcNow;
}
else
{
PatientVisitUnscheduledDB.UpdateByUserID = PatientVisitUnscheduledBO.UpdateByUserID;
PatientVisitUnscheduledDB.UpdateDate = DateTime.UtcNow;
}
if (Add_patientVisitUnscheduledDB == true)
{
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds.Add(PatientVisitUnscheduledDB);
}
_context.SaveChanges();
}
#endregion
dbContextTransaction.Commit();
if (PatientVisitUnscheduledDB != null)
{
PatientVisitUnscheduledDB = _context.PatientVisitUnscheduleds
.Include("Patient").Include("Patient.User").Include("Patient.User.UserCompanies")
.Include("Specialty")
.Include("RoomTest")
.Where(p => p.Id == PatientVisitUnscheduledDB.Id &&
(p.IsDeleted.HasValue == false || (p.IsDeleted.HasValue == true && p.IsDeleted.Value == false)))
.FirstOrDefault <PatientVisitUnscheduled>();
}
}
var res = Convert <BO.PatientVisitUnscheduled, PatientVisitUnscheduled>(PatientVisitUnscheduledDB);
return((object)res);
}
