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