public static MethodResult GetByPatientName(PatientName patientName) { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); ClientOrderCollection clientOrderCollection = new ClientOrderCollection(); string commandText = $"Select * from tblClientOrder where ClientId in ({clientIdList}) and PanelSetId = 400 "; if (patientName.LastName != null && patientName.FirstName != null) { commandText = commandText + "and PLastName like '" + patientName.LastName + "%' and pFirstName like '" + patientName.FirstName + "%' order by OrderDate desc"; } if (patientName.LastName != null && patientName.FirstName == null) { commandText = commandText + "and PLastName like '" + patientName.LastName + "%' order by OrderDate desc;"; } if (patientName.LastName != null) { JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); ClientOrderCollection.Build(apiResult, clientOrderCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, clientOrderCollection); return(methodResult); } else { MethodResult methodResult = new MethodResult(); methodResult.Success = false; methodResult.Messages.Add("Invalid patient name."); return(methodResult); } }
public static MethodResult GetAll() { string commandText = "Select * from country_code order by name;"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); CountryCodeCollection clientCollection = new CountryCodeCollection(); Build(apiResult.JSONResult, clientCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, clientCollection); return(methodResult); }
public static MethodResult GetByPatientName(PatientName patientName) { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); BillingLogCollection billingLogCollection = new BillingLogCollection(); string commandText = FIELDLIST; commandText += "from tblAccessionOrder ao "; commandText += "join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo "; commandText += "join tblPanelSetOrderCPTCodeBill psoc on pso.ReportNo = psoc.ReportNo "; commandText += "where ao.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); BillingLogCollection.Build(apiResult.JSONResult, billingLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, billingLogCollection); return(methodResult); } else { MethodResult methodResult = new MethodResult(); methodResult.Success = false; methodResult.Messages.Add("Invalid patient name."); return(methodResult); } }
public static MethodResult GetByDateOfBirth(DateTime dateOfBirth) { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); BillingLogCollection billingLogCollection = new BillingLogCollection(); string commandText = FIELDLIST; commandText += "from tblAccessionOrder ao "; commandText += "join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo "; commandText += "join tblPanelSetOrderCPTCodeBill psoc on pso.ReportNo = psoc.ReportNo "; commandText += "where ao.ClientId in (" + clientIdList + ") and ao.PBirthDate = '" + dateOfBirth.ToString("yyyyMMdd") + "';"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); BillingLogCollection.Build(apiResult.JSONResult, billingLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, billingLogCollection); 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 GetByRecentPostedCases() { string clientIdList = AuthenticatedUser.Instance.GetSQLClientIdInList(); BillingLogCollection billingLogCollection = new BillingLogCollection(); string commandText = FIELDLIST; commandText += "from tblAccessionOrder ao "; commandText += "join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo "; commandText += "join tblPanelSetOrderCPTCodeBill psoc on pso.ReportNo = psoc.ReportNo "; commandText += $"where ao.ClientId in ({clientIdList}) "; commandText += $"and psoc.PostDate >= '{DateTime.Today.AddDays(-45).ToString("yyyy-MM-dd")}' order by ao.AccessionDate desc;"; JObject jsonRequest = APIRequestHelper.CreateSubmitSQLCommandMessage(commandText); APIResult apiResult = APIRequestHelper.SubmitAPIRequestMessage(jsonRequest); BillingLogCollection.Build(apiResult.JSONResult, billingLogCollection); MethodResult methodResult = new MethodResult(); methodResult.AddResult(apiResult.JSONResult, billingLogCollection); return(methodResult); }
public MethodResult IsOkToInsert() { MethodResult result = new MethodResult(); bool success = true; if (string.IsNullOrEmpty(this.PFirstName) == true) { success = false; } if (string.IsNullOrEmpty(this.PLastName) == true) { success = false; } if (this.PBirthdate.HasValue == false) { success = false; } if (success == false) { result.AddResult("We can't save your order because the First Name, Last Name and Birthdate cannot be blank. Would you like to continue without saving?", false); } return(result); }
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); }