public SVHBillingDocument(YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData)
{
this.m_SVHBillingData = svhBillingData;
this.m_DispatcherPriority = DispatcherPriority.SystemIdle;
this.LoadTemplate();
this.InjectData();
}
private void BillingPage_ShowPatientDetailPage(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.m_AccessionOrder.SvhMedicalRecord) == false)
{
YellowstonePathology.Business.Patient.Model.SVHBillingDataCollection svhBillingDataCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetSVHBillingDataCollection(this.m_AccessionOrder.SvhMedicalRecord);
if (svhBillingDataCollection.Count > 0)
{
YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingDate = svhBillingDataCollection.GetMostRecent();
YellowstonePathology.UI.Billing.PatientDetailPage patientDetailPage = new PatientDetailPage(svhBillingDate);
patientDetailPage.Back += new Billing.PatientDetailPage.BackEventHandler(PatientDetailPage_Back);
patientDetailPage.Next += new Billing.PatientDetailPage.NextEventHandler(PatientDetailPage_Next);
if (this.m_BillingWindowPrimary.PageNavigator.HasDualMonitors() == false)
{
this.m_BillingWindowSecondary = new BillingWindowSecondary();
this.m_BillingWindowSecondary.Show();
}
this.m_BillingWindowSecondary.PageNavigator.Navigate(patientDetailPage);
}
else
{
System.Windows.MessageBox.Show("No additional data to show.");
}
}
else
{
System.Windows.MessageBox.Show("The Medical Record Number is blank. No additional data to show.");
}
}
private void ButtonPatientDetails_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(this.m_TypingUI.AccessionOrder.SvhMedicalRecord) == false)
{
YellowstonePathology.Business.Patient.Model.SVHBillingDataCollection svhBillingDataCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetSVHBillingDataCollection(this.m_TypingUI.AccessionOrder.SvhMedicalRecord);
if (svhBillingDataCollection.Count > 0)
{
YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingDate = svhBillingDataCollection.GetMostRecent();
YellowstonePathology.UI.Billing.PatientDetailPage patientDetailPage = new Billing.PatientDetailPage(svhBillingDate);
patientDetailPage.Back += new Billing.PatientDetailPage.BackEventHandler(PatientDetailPage_Return);
patientDetailPage.Next += new Billing.PatientDetailPage.NextEventHandler(PatientDetailPage_Return);
Login.Receiving.LoginPageWindow loginPageWindow = new Login.Receiving.LoginPageWindow();
loginPageWindow.PageNavigator.Navigate(patientDetailPage);
loginPageWindow.ShowDialog();
}
else
{
System.Windows.MessageBox.Show("No additional data to show.");
}
}
else
{
System.Windows.MessageBox.Show("The Medical Record Number is blank. No additional data to show.");
}
}
public PatientDetailPage(string masterAccessionNo, YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData)
{
this.m_MasterAccessionNo = masterAccessionNo;
this.m_SVHBillingData = svhBillingData;
InitializeComponent();
DataContext = this;
}
public SVHBillingDocument(YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData)
{
this.m_SVHBillingData = svhBillingData;
this.m_DispatcherPriority = DispatcherPriority.SystemIdle;
this.LoadTemplate();
this.InjectData();
}
public static YellowstonePathology.Business.Patient.Model.SVHBillingDataCollection GetSVHBillingDataCollection(string mrn)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from tblSVHBillingData where MRN = @MRN";
cmd.Parameters.Add("@MRN", SqlDbType.VarChar).Value = mrn;
cmd.CommandType = CommandType.Text;
YellowstonePathology.Business.Patient.Model.SVHBillingDataCollection result = new YellowstonePathology.Business.Patient.Model.SVHBillingDataCollection();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData = new YellowstonePathology.Business.Patient.Model.SVHBillingData();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(svhBillingData, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(svhBillingData);
}
}
}
return result;
}
public static List<YellowstonePathology.Business.Patient.Model.SVHBillingData> GetPatientImportDataList(string reportNo)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select svb.* " +
"from tblAccessionOrder ao " +
"join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo " +
"join tblSVHBillingData svb on ao.SVHMedicalRecord = svb.MRN " +
"where pso.ReportNo = @ReportNo " +
"order by FileDate desc";
cmd.Parameters.Add("@ReportNo", SqlDbType.VarChar).Value = reportNo;
List<YellowstonePathology.Business.Patient.Model.SVHBillingData> result = new List<YellowstonePathology.Business.Patient.Model.SVHBillingData>();
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData = new YellowstonePathology.Business.Patient.Model.SVHBillingData();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(svhBillingData, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(svhBillingData);
}
}
}
return result;
}
public PatientDetailPage(YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData)
{
this.m_SVHBillingData = svhBillingData;
InitializeComponent();
DataContext = this;
}
public PatientDetailPage(YellowstonePathology.Business.Patient.Model.SVHBillingData svhBillingData)
{
this.m_SVHBillingData = svhBillingData;
InitializeComponent();
DataContext = this;
}
