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