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