public static void Build(JObject jsonResult, DistributionLogCollection distributionLogCollection) { if (jsonResult["result"]["results"] != null) { for (int i = 0; i < jsonResult["result"]["results"].Count(); i++) { DistributionLog distributionLog = new DistributionLog(); distributionLog.FromSql((JObject)jsonResult["result"]["results"][i]); distributionLogCollection.Add(distributionLog); } } }
private void DoCategoryTypeSearch() { if (this.m_CategorySearchType == "Not Acknowledged") { MethodResult methodResult = DistributionLogCollection.GetByNotAcknowledged(); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } else { methodResult.ShowMethodResult(); } } else if (this.m_CategorySearchType == "Recent Cases") { MethodResult methodResult = DistributionLogCollection.GetByRecentCases(); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } else { methodResult.ShowMethodResult(); } } else if (this.m_CategorySearchType == "Detected COVID Cases") { MethodResult methodResult = DistributionLogCollection.GetByDetectedCOVIDCases(); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } else { methodResult.ShowMethodResult(); } } }
private void DoDateOfBirthSearch() { if (this.m_DateOfBirthSearch.HasValue == true) { MethodResult methodResult = DistributionLogCollection.GetByDateOfBirth(this.m_DateOfBirthSearch.Value); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } else { methodResult.ShowMethodResult(); } } else { MessageBox.Show("Please enter a valide Date Of Birth."); } }
private void MenuItemAcknowledge_Click(object sender, RoutedEventArgs e) { if (this.ListViewReportDistributionLog.SelectedItems.Count > 0) { JArray idList = new JArray(); foreach (DistributionLog distributionLog in this.ListViewReportDistributionLog.SelectedItems) { idList.Add(distributionLog.TestOrderReportDistributionId); } JObject jsonRequest = APIRequestHelper.GetAcknowledgeDistributionsMessage(idList); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); MethodResult methodResult = DistributionLogCollection.GetByNotAcknowledged(); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } } }
public static MethodResult GetByPatientName(PatientName patientName) { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); DistributionLogCollection distributionLogCollection = new DistributionLogCollection(); string commandText = FIELDLIST; commandText += "from tblTestOrderReportDistribution tord "; commandText += "join tblPanelSetOrder pso on tord.ReportNo = pso.ReportNo "; commandText += "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo "; commandText += "where tord.ClientId in (" + clientIdList + ") "; if (patientName.LastName != null && patientName.FirstName != null) { commandText = commandText + "and PLastName like '" + patientName.LastName + "%' and pFirstName like '" + patientName.FirstName + "%' order by ao.AccessionDate desc"; } if (patientName.LastName != null && patientName.FirstName == null) { commandText = $"{commandText} and PLastName like '{patientName.LastName}%' order by ao.AccessionDate desc;"; } if (patientName.LastName != null) { JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); DistributionLogCollection.Build(apiResult.JSONResult, distributionLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, distributionLogCollection); return(methodResult); } else { MethodResult methodResult = new MethodResult(); methodResult.Success = false; methodResult.Messages.Add("Invalid patient name."); return(methodResult); } }
public static MethodResult GetByNotAcknowledged() { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); DistributionLogCollection distributionLogCollection = new DistributionLogCollection(); string commandText = FIELDLIST; commandText += "from tblTestOrderReportDistribution tord "; commandText += "join tblPanelSetOrder pso on tord.ReportNo = pso.ReportNo "; commandText += "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo "; commandText += "where tord.ClientId in (" + clientIdList + ") and tord.DistributionType = 'Web Service' and tord.Distributed = 1 and tord.Acknowledged = 0 limit 500;"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); DistributionLogCollection.Build(apiResult.JSONResult, distributionLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, distributionLogCollection); return(methodResult); }
public static MethodResult GetByDateOfBirth(DateTime dateOfBirth) { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); DistributionLogCollection distributionLogCollection = new DistributionLogCollection(); string commandText = FIELDLIST; commandText += "from tblTestOrderReportDistribution tord "; commandText += "join tblPanelSetOrder pso on tord.ReportNo = pso.ReportNo "; commandText += "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo "; commandText += "where tord.ClientId in (" + clientIdList + ") and ao.PBirthDate = '" + dateOfBirth.ToString("yyyyMMdd") + "';"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); DistributionLogCollection.Build(apiResult.JSONResult, distributionLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, distributionLogCollection); return(methodResult); }
private void DoPatientNameSearch() { PatientName patientName = null; bool result = PatientName.TryParse(this.m_PatientNameSearch, out patientName); if (result) { MethodResult methodResult = DistributionLogCollection.GetByPatientName(patientName); if (methodResult.Success == true) { this.m_DistributionLog = (DistributionLogCollection)methodResult.Result; this.NotifyPropertyChanged(string.Empty); } else { methodResult.ShowMethodResult(); } } else { MessageBox.Show("Must have at least 2 characters for a patient name search."); } }
public static MethodResult GetByRecentPostedCases() { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); DistributionLogCollection distributionLogCollection = new DistributionLogCollection(); string commandText = FIELDLIST; commandText += "from tblTestOrderReportDistribution tord "; commandText += "join tblPanelSetOrder pso on tord.ReportNo = pso.ReportNo "; commandText += "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo "; commandText += $"where tord.ClientId in ({clientIdList}) and tord.Distributed = 1 "; commandText += "and tord.DistributionType = 'Web Service' "; commandText += $"and tord.timeOfLastDistribution >= '{DateTime.Today.AddDays(-45).ToString("yyyy-MM-dd")}' order by tord.timeOfLastDistribution desc;"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); DistributionLogCollection.Build(apiResult.JSONResult, distributionLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, distributionLogCollection); return(methodResult); }