public BLModel.PatientAndRequestModel getPatientAndPeerReviewRequestByReferralId(int _referralID)
{
SPImpl _spImpl = new SPImpl();
var varRequestdetails = _spImpl.getRequestByReferralIdForPeerReview(_referralID).ToList();
return(new BLModel.PatientAndRequestModel
{
Patients = _spImpl.getPatientByReferralId(_referralID),
RequestDetail = varRequestdetails
});
}
public void deleteClientThirdPartyAdministrator(int _id)
{
int _clientID = _clientTPARepo.GetById(_id).ClientID;
int cnt = _clientRepo.GetAll(cl => cl.ClientID == _clientID && cl.ClaimAdministratorType.StartsWith(Global.GlobalConst.TableAbbreviation.Tpa)).Count();
if (cnt > 0)
{
SPImpl _SPImpl = new SPImpl();
_SPImpl.UpdateClaimAdministratorResetDetailsByClientID(_clientID);
}
_clientTPARepo.Delete(_id);
}
public BLModel.PatientAndRequestModel getPatientAndRequestForNotificationByReferralId(int _referralID, int _skip, int _take)
{
SPImpl _spImpl = new SPImpl();
var varRequestdetails = _spImpl.getRequestForNotificationByReferralId(_referralID).Skip(_skip).Take(_take).ToList();
return(new BLModel.PatientAndRequestModel
{
Patients = _spImpl.getPatientByReferralId(_referralID),
RequestDetail = varRequestdetails,
RequestCount = _spImpl.getRequestForNotificationByReferralId(_referralID).Count()
});
}
public BLModel.PatientAndRequestModel getPatientAndRequestByReferralId(int _referralID)
{
SPImpl _spImpl = new SPImpl();
var varRequestdetails = _spImpl.getRequestByReferralId(_referralID).ToList();
return(new BLModel.PatientAndRequestModel
{
Patients = _spImpl.getPatientByReferralId(_referralID),
RequestDetail = varRequestdetails,
RemainingDecision = varRequestdetails.Count(s => (s.RFAStatus != "SendToClinical" && s.RFAStatus != "Peer Review") && s.DecisionID == 0),
TimeExtensionPNCount = _rFAReferralFileRepo.GetAll(rk => rk.RFAReferralID == _referralID && rk.RFAFileTypeID == Global.GlobalConst.FileTypes.TimeExtensionPN).Count()
});
}
public int updateClientManagedCareCompanyByClientID(ClientManagedCareCompany _clientManagedCareCompany)
{
if (_clientMMCRepo.GetAll(mmc => mmc.ClientID == _clientManagedCareCompany.ClientID).Count() == 0)
{
return(_clientMMCRepo.Add(_clientManagedCareCompany).ClientCompanyID);
}
else
{
SPImpl _spImpl = new SPImpl();
_spImpl.UpdateClientManagedCareCompanyByClientID(_clientManagedCareCompany);
return(2);
}
}
public IEnumerable <BLModel.RFARequest> getRFARequestByReferralID(int _rfaReferralId)
{
//return
IEnumerable <BLModel.RFARequest> _BLRFARequest = _rfaRequestRepo.GetAll(hp => hp.RFAReferralID == _rfaReferralId).Select(icr => new BLModel.RFARequest().InjectFrom(icr)).Cast <BLModel.RFARequest>().ToList();
SPImpl _SPImpl = new SPImpl();
foreach (var bLRFARequest in _BLRFARequest)
{
_SPImpl = new SPImpl();
bLRFARequest.RFACPT_NDC = _SPImpl.getRequestCPTNDCCodesByRFARequestID(bLRFARequest.RFARequestID);
bLRFARequest.RFARequestedTreatment = _SPImpl.getRequestedTreatmentByRFARequestID(bLRFARequest.RFARequestID);
}
return(_BLRFARequest);
}
public BLModel.Paged.ICDCode getICDCodesByNumberOrDescription(string _searchtext, string ICDTab, int skip, int take)
{
SPImpl _spimpl = new SPImpl();
string _icdType = "";
if (ICDTab == DLModel.Constant.Constant.ConstantValue.ICD9)
{
_icdType = DLModel.Constant.Constant.ConstantValue.ICD9Type;
}
else if (ICDTab == DLModel.Constant.Constant.ConstantValue.ICD10)
{
_icdType = DLModel.Constant.Constant.ConstantValue.ICD10Type;
}
return(new BLModel.Paged.ICDCode
{
ICDCodeDetails = _spimpl.getICDCodesByNumberOrDescription(_searchtext, _icdType, ICDTab, skip, take),
TotalCount = _spimpl.getICDCodesByNumberOrDescriptionCount(_searchtext, DLModel.Constant.Constant.ConstantValue.ICD9Type, ICDTab)
});
}
public void SaveRequestIMRRecord(string[] _arrRequestID, int UserID)
{
int refID = _rfaRequestRepo.GetById(int.Parse(_arrRequestID[0])).RFAReferralID.Value;
//MMCDbContext _MMCDbContext = new MMCDbContext();
//var _checkTotalReferralCnt = (from rfa in _MMCDbContext.rfaReferrals
// join req in _MMCDbContext.rfaRequests
// on rfa.RFAReferralID equals req.RFAReferralID
// join rfapl in _MMCDbContext.rfaProcessLevels
// on rfa.RFAReferralID equals rfapl.RFAReferralID
// where (rfa.RFAReferralID.Equals(refID) && (req.DecisionID == 2 || req.DecisionID == 3) && (rfapl.ProcessLevel == GlobalConst.ProcessLevel.Billing || rfapl.ProcessLevel == GlobalConst.ProcessLevel.FileStorage))
// select new { req.RFARequestID }).Count();
MMCDbContext _MMCDbContext = new MMCDbContext();
var _checkTotalReferralCnt = (from rfa in _MMCDbContext.rfaReferrals
join req in _MMCDbContext.rfaRequests
on rfa.RFAReferralID equals req.RFAReferralID
where (rfa.RFAReferralID.Equals(refID) && (req.DecisionID == 2 || req.DecisionID == 3 || req.DecisionID == 8 || req.DecisionID == 9 || req.DecisionID == 10)) // && (rfapl.ProcessLevel == GlobalConst.ProcessLevel.Billing || rfapl.ProcessLevel == GlobalConst.ProcessLevel.FileStorage))
select new { req.RFARequestID }).Count();
int Flag = 0;
string RFARequestIDs = "";
if (_arrRequestID.Count() == _checkTotalReferralCnt)
{
Flag = 1;
}
for (int i = 0; i < _arrRequestID.Count(); i++)
{
RFARequestIDs += _arrRequestID[i].ToString() + "#";
}
SPImpl _spImpl = new SPImpl();
_spImpl.CreateRFARefferalByRFARefferalID(refID, RFARequestIDs.Substring(0, RFARequestIDs.Length - 1), Flag);
}
public int updateDecisionByRequestID(RFARequest rfaRequest)
{
MMCDbContext mmcDBcontext = new MMCDbContext();
try
{
var qry = from p in mmcDBcontext.rfaRequests where p.RFARequestID == rfaRequest.RFARequestID select p;
foreach (var q in qry)
{
q.DecisionID = rfaRequest.DecisionID;
q.RFAStatus = rfaRequest.RFAStatus;
q.RFANotes = rfaRequest.RFANotes;
// q.RFARequestedTreatment = rfaRequest.RFARequestedTreatment;
if (rfaRequest.DecisionID != 1)
{
q.RFAClinicalReasonforDecision = rfaRequest.RFAClinicalReasonforDecision;
q.RFAGuidelinesUtilized = rfaRequest.RFAGuidelinesUtilized;
q.RFARelevantPortionUtilized = rfaRequest.RFARelevantPortionUtilized;
if (rfaRequest.RFAClinicalReasonforDecision != null)
{
SPImpl _spImpl = new SPImpl();
_spImpl.updateRFAReferralRequestRFAClinicalReasonforDecisionByID(q.RFAReferralID.Value, q.RFAClinicalReasonforDecision);
}
}
else
{
q.RFAClinicalReasonforDecision = null;
q.RFAGuidelinesUtilized = null;
q.RFARelevantPortionUtilized = null;
}
q.DecisionDate = rfaRequest.DecisionDate;
}
mmcDBcontext.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public BLModel.Paged.PatientClaimDiagnose getPatientClaimDiagnoseByPatientClaimId(int _patientClaimID, int _skip, int _take)
{
//MMCDbContext _MMCDbContext = new MMCDbContext();
//var _patientClaimDiagnoses = (from patclm in _MMCDbContext.patientClaims
// join pcd in _MMCDbContext.patientClaimDiagnoses
// on patclm.PatientClaimID equals pcd.PatientClaimID
// join icd in _MMCDbContext.iCD9Codes
// on pcd.icdICD9Number.Trim() equals icd.icdICD9Number.Trim()
// where patclm.PatientClaimID == _patientClaimID && icd.ICD9Type.Equals(DLModel.Constant.Constant.ConstantValue.ICD9Type)
// select new { pcd.icdICD9Number, pcd.PatientClaimDiagnosisID, pcd.PatientClaimID, icd.ICD9Description }).OrderByDescending(icd => icd.PatientClaimDiagnosisID).ToList();
//return new BLModel.Paged.PatientClaimDiagnose
//{
// PatientClaimDiagnoseDetails = _patientClaimDiagnoses.Select(pcd => new BLModel.PatientClaimDiagnose().InjectFrom(pcd)).Cast<BLModel.PatientClaimDiagnose>().Skip(_skip).Take(_take).ToList(),
// TotalCount = _patientClaimDiagnoses.Count()
//};
SPImpl _spimpl = new SPImpl();
return(new BLModel.Paged.PatientClaimDiagnose
{
PatientClaimDiagnoseDetails = _spimpl.getPatientClaimDiagnoseByPatientClaimId(_patientClaimID, _skip, _take),
TotalCount = _spimpl.getPatientClaimDiagnoseByPatientClaimIdCount(_patientClaimID)
});
}
public IEnumerable <BLModel.RequestInitialNotificationLetter> getDeniedRequestDetailsInitialNotificationLetter(int referralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getDeniedRequestDetailsInitialNotificationLetter(referralID));
}
public int getRFANewReferralIDFromRFAOldReferralID(int RFAReferralID, int DecisionID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getRFANewReferralIDFromRFAOldReferralID(RFAReferralID, DecisionID));
}
public IEnumerable <BLModel.NotificationEmailSend> getAdjandPhyEmailByReferralID(int _referralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getAdjandPhyEmailByReferralID(_referralID).ToList());
}
public IEnumerable <BLModel.RequestByReferralID> getAllRequestByReferralID(int ReferralID)
{
SPImpl _smp = new SPImpl();
return(_smp.getRequestByReferralId(ReferralID));
}
public string getDignosisByReferralID(int _referralID)
{
SPImpl _smp = new SPImpl();
return(_smp.getDignosisByReferralID(_referralID));
}
public string getDelayedBodyPartByReferralID(int _referralID)
{
SPImpl _smp = new SPImpl();
return(_smp.getDelayedBodyPartByReferralID(_referralID));
}
public BLModel.StorageModel GetStorageStuctureByID(int _id, char _by)
{
SPImpl _spImp = new SPImpl();
return(_spImp.GetStorageStuctureByID(_id, _by));
}
public void AddEmailRecordAndRFARequestLinkByRFITimeExtension(int RFAReferralID, int RFAReferralFileID, int EmailRecordId)
{
SPImpl _spImpl = new SPImpl();
_spImpl.AddEmailRecordAndRFARequestLinkByRFITimeExtension(RFAReferralID, RFAReferralFileID, EmailRecordId);
}
public IEnumerable <BLModel.IMRDecisionRequestDetails> getIMRDecisionPageRequestDetailsByReferralID(int RFAReferralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getIMRDecisionPageRequestDetailsByReferralID(RFAReferralID));
}
public BLModel.IMRDecisionReferralDetails getIMRDecisionPageDetailsByReferralID(int RFAReferralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getIMRDecisionPageDetailsByReferralID(RFAReferralID));
}
public IEnumerable <BLModel.RFAReferralFile> getIMRLetters(int RFAReferralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getIMRLetters(RFAReferralID));
}
public IEnumerable <BLModel.RFAReferralFile> getMedicalAndLegalDocsByReferralID(int ReferralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getMedicalAndLegalDocsByReferralID(ReferralID));
}
public BLModel.InitialNotificationLetter getInitialNotificationLetterDetails(int referralID)
{
SPImpl _spImpl = new SPImpl();
return(_spImpl.getInitialNotificationLetterDetails(referralID));
}
public void UpdateRFAAdditionalInfoDetailByRequestID(int OldRFAReferralID, int rFARequestID)
{
SPImpl _spImpl = new SPImpl();
_spImpl.UpdateRFAAdditionalInfoDetailByRequestID(OldRFAReferralID, rFARequestID);
}
public string getPatientComorbidConditionsByPatientID(int PatientID)
{
SPImpl _spImp = new SPImpl();
return(_spImp.getPatientComorbidConditionsByPatientID(PatientID));
}
public void AddRFITemplateRecordByRFARequestID(int _rFAReferralFileID, int _userID)
{
SPImpl _spImpl = new SPImpl();
_spImpl.AddRFITemplateRecordByRFARequestID(_rFAReferralFileID, _userID);
}
public IEnumerable <NoOfReferralCount> getNoOfReferralCountAccToProcessLevel()
{
SPImpl _SPImpl = new SPImpl();
return(_SPImpl.getNoOfReferralCountForDifferentProcessLevel());
}
public void AddRFARequestTimeExtensionRecordByRFARequestID(int _rFAReferralFileID, int _userID)
{
SPImpl _spImpl = new SPImpl();
_spImpl.AddRFARequestTimeExtensionRecordByRFARequestID(_rFAReferralFileID, _userID);
}
public IEnumerable <ICDCode> getICDCodesByNumber(string _ICDNumber, string _ICDTab)
{
SPImpl _spImp = new SPImpl();
return(_spImp.getICDCodesByNumber(_ICDNumber, _ICDTab));
}
public string getAcceptedBodyPartsByReferralID(int _referralID)
{
SPImpl _smp = new SPImpl();
return(_smp.getAcceptedBodyPartsByReferralID(_referralID));
}
