public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch GetOpenBatchForFacilityLocation(string facilityId, string locationId) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch result = null; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from tblMaterialTrackingBatch where IsOpen = 1 and FromFacilityId = @FacilityId and FromLocationId = @LocationId"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@FacilityId", SqlDbType.VarChar).Value = facilityId; cmd.Parameters.Add("@LocationId", SqlDbType.VarChar).Value = locationId; using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { result = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr); sqlDataReaderPropertyWriter.WriteProperties(); } } } return(result); }
public MaterialBatchPage(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, bool backButtonVisible, bool nextButtonVisible, bool finishButtonVisible, bool useMasterAccessionNo, string masterAccessionNo, YellowstonePathology.UI.Navigation.PageNavigator pageNavigator) { this.m_PageNavigator = pageNavigator; this.m_MaterialTrackingBatch = materialTrackingBatch; this.m_UserMasterAccessionNo = useMasterAccessionNo; this.m_MasterAccessionNo = masterAccessionNo; if (this.m_UserMasterAccessionNo == true) { this.m_MaterialTrackingLogViewCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogViewCollectionByBatchIdMasterAccessionNo(this.m_MaterialTrackingBatch.MaterialTrackingBatchId, masterAccessionNo); } else { this.m_MaterialTrackingLogViewCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogViewCollectionByBatchId(this.m_MaterialTrackingBatch.MaterialTrackingBatchId); } this.m_BackButtonVisible = backButtonVisible; this.m_NextButtonVisible = nextButtonVisible; this.m_FinishButtonVisible = finishButtonVisible; this.m_LocationList = Business.Gateway.AccessionOrderGateway.GetAllLocations(); InitializeComponent(); DataContext = this; Loaded += new RoutedEventHandler(MaterialBatchPage_Loaded); Unloaded += new RoutedEventHandler(MaterialBatchPage_Unloaded); }
public MaterialBatchPage(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection, bool backButtonVisible, bool nextButtonVisible, bool finishButtonVisible, bool useMasterAccessionNo, string masterAccessionNo, YellowstonePathology.UI.Navigation.PageNavigator pageNavigator) { this.m_FacilityCollection = YellowstonePathology.Business.Facility.Model.FacilityCollection.GetAllFacilities(); this.m_LocationCollection = YellowstonePathology.Business.Facility.Model.LocationCollection.GetAllLocations(); this.m_PageNavigator = pageNavigator; this.m_MaterialTrackingBatch = materialTrackingBatch; this.m_MaterialTrackingLogCollection = materialTrackingLogCollection; this.m_UserMasterAccessionNo = useMasterAccessionNo; this.m_MasterAccessionNo = masterAccessionNo; if (this.m_UserMasterAccessionNo == true) { this.m_MaterialTrackingLogViewCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogViewCollectionByBatchIdMasterAccessionNo(this.m_MaterialTrackingBatch.MaterialTrackingBatchId, masterAccessionNo); } else { this.m_MaterialTrackingLogViewCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogViewCollectionByBatchId(this.m_MaterialTrackingBatch.MaterialTrackingBatchId); } this.m_BackButtonVisible = backButtonVisible; this.m_NextButtonVisible = nextButtonVisible; this.m_FinishButtonVisible = finishButtonVisible; InitializeComponent(); DataContext = this; Loaded += new RoutedEventHandler(MaterialBatchPage_Loaded); Unloaded += new RoutedEventHandler(MaterialBatchPage_Unloaded); }
private void Build(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch) { using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); m_SQLCommand.Connection = cn; using (MySqlDataReader dr = m_SQLCommand.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingBatch, dr); sqlDataReaderPropertyWriter.WriteProperties(); } dr.NextResult(); while (dr.Read()) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog materialTrackingLog = new MaterialTracking.Model.MaterialTrackingLog(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLog, dr); sqlDataReaderPropertyWriter.WriteProperties(); materialTrackingBatch.MaterialTrackingLogCollection.Add(materialTrackingLog); } } } }
private void ShowMaterialBatchPage(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch) { this.m_MaterialBatchPage = new MaterialBatchPage(materialTrackingBatch, true, true, false, this.m_UseMasterAccessionNo, this.m_MasterAccessionNo, this.m_LoginPageWindow.PageNavigator); this.m_MaterialBatchPage.Back += new MaterialBatchPage.BackEventHandler(MaterialBatchPage_Back); this.m_MaterialBatchPage.Next += new MaterialBatchPage.NextEventHandler(MaterialBatchPage_Next); this.m_MaterialBatchPage.ShowTrackingDocument += new MaterialBatchPage.ShowTrackingDocumentEventHandler(MaterialBatchPage_ShowTrackingDocument); this.m_LoginPageWindow.PageNavigator.Navigate(this.m_MaterialBatchPage); }
private void ShowMaterialBatchPage(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection) { YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullMaterialTrackingBatch(materialTrackingBatch, m_LoginPageWindow); this.m_MaterialBatchPage = new MaterialBatchPage(materialTrackingBatch, materialTrackingLogCollection, true, true, false, this.m_UseMasterAccessionNo, this.m_MasterAccessionNo, this.m_LoginPageWindow.PageNavigator); this.m_MaterialBatchPage.Back += new MaterialBatchPage.BackEventHandler(MaterialBatchPage_Back); this.m_MaterialBatchPage.Next += new MaterialBatchPage.NextEventHandler(MaterialBatchPage_Next); this.m_MaterialBatchPage.ShowTrackingDocument += new MaterialBatchPage.ShowTrackingDocumentEventHandler(MaterialBatchPage_ShowTrackingDocument); this.m_LoginPageWindow.PageNavigator.Navigate(this.m_MaterialBatchPage); }
public void PullMaterialTrackingBatch(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, object writer) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from tblMaterialTrackingBatch where MaterialTrackingBatchId = @MaterialTrackingBatchId"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@MaterialTrackingBatchId", SqlDbType.VarChar).Value = materialTrackingBatch.MaterialTrackingBatchId; GenericDocumentBuilder builder = new GenericDocumentBuilder(cmd, typeof(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch)); DocumentId documentId = new DocumentId(materialTrackingBatch, writer); Document document = this.m_Stack.Pull(documentId, builder); }
public MaterialTrackingBatchSummary(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection materialTrackingLogViewCollection) { this.m_MaterialTrackingBatch = materialTrackingBatch; this.m_MaterialTrackingLogViewCollection = materialTrackingLogViewCollection; YellowstonePathology.Document.Xps.PlainHeader header = new YellowstonePathology.Document.Xps.PlainHeader("Yellowstone Pathology Institute - Material Distribution Report"); YellowstonePathology.Document.Xps.NoFooter footer = new YellowstonePathology.Document.Xps.NoFooter(); this.m_ReportDocument = new YellowstonePathology.Document.Xps.ReportDocument(header, footer); int totalMaterialCount = 0; MaterialTrackingSummaryCollection materialTrackingSummaryCollection = new MaterialTrackingSummaryCollection(); List<string> materialTypeList = this.m_MaterialTrackingLogViewCollection.GetDistinctMaterialTypes(); List<string> masterAccessionNoList = this.m_MaterialTrackingLogViewCollection.GetMasterAccessionNoList(); foreach (string masterAccessionNo in masterAccessionNoList) { MaterialTrackingSummary materialTrackingSummary = new MaterialTrackingSummary(masterAccessionNo, false); foreach (string materialType in materialTypeList) { int materialCount = this.m_MaterialTrackingLogViewCollection.GetMaterialCount(masterAccessionNo, materialType); MaterialTrackingSummaryColumn materialTrackingSummaryColumn = new MaterialTrackingSummaryColumn(materialType, materialCount); materialTrackingSummary.ColumnList.Add(materialTrackingSummaryColumn); totalMaterialCount += materialCount; } materialTrackingSummaryCollection.Add(materialTrackingSummary); } this.WriteHeadingsGrid(materialTypeList); foreach (MaterialTrackingSummary materialTrackingSummary in materialTrackingSummaryCollection) { this.WriteReportLine(materialTrackingSummary); } if (materialTrackingSummaryCollection.Count > 0) { materialTrackingSummaryCollection.SetTotals(); this.WriteTotalLine(materialTrackingSummaryCollection[materialTrackingSummaryCollection.Count - 1]); } }
public MaterialTrackingBatchSummary(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection materialTrackingLogViewCollection) { this.m_MaterialTrackingBatch = materialTrackingBatch; this.m_MaterialTrackingLogViewCollection = materialTrackingLogViewCollection; YellowstonePathology.Document.Xps.PlainHeader header = new YellowstonePathology.Document.Xps.PlainHeader("Yellowstone Pathology Institute - Material Distribution Report"); YellowstonePathology.Document.Xps.NoFooter footer = new YellowstonePathology.Document.Xps.NoFooter(); this.m_ReportDocument = new YellowstonePathology.Document.Xps.ReportDocument(header, footer); int totalMaterialCount = 0; MaterialTrackingSummaryCollection materialTrackingSummaryCollection = new MaterialTrackingSummaryCollection(); List <string> materialTypeList = this.m_MaterialTrackingLogViewCollection.GetDistinctMaterialTypes(); List <string> masterAccessionNoList = this.m_MaterialTrackingLogViewCollection.GetMasterAccessionNoList(); foreach (string masterAccessionNo in masterAccessionNoList) { MaterialTrackingSummary materialTrackingSummary = new MaterialTrackingSummary(masterAccessionNo, false); foreach (string materialType in materialTypeList) { int materialCount = this.m_MaterialTrackingLogViewCollection.GetMaterialCount(masterAccessionNo, materialType); MaterialTrackingSummaryColumn materialTrackingSummaryColumn = new MaterialTrackingSummaryColumn(materialType, materialCount); materialTrackingSummary.ColumnList.Add(materialTrackingSummaryColumn); totalMaterialCount += materialCount; } materialTrackingSummaryCollection.Add(materialTrackingSummary); } this.WriteHeadingsGrid(materialTypeList); foreach (MaterialTrackingSummary materialTrackingSummary in materialTrackingSummaryCollection) { this.WriteReportLine(materialTrackingSummary); } if (materialTrackingSummaryCollection.Count > 0) { materialTrackingSummaryCollection.SetTotals(); this.WriteTotalLine(materialTrackingSummaryCollection[materialTrackingSummaryCollection.Count - 1]); } }
private void HyperlinkViewSelectedBatch_Click(object sender, RoutedEventArgs e) { if (this.ListBoxMaterialTrackingBatch.SelectedItem != null) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = (YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch) this.ListBoxMaterialTrackingBatch.SelectedItem; YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = null; if (this.m_UseMasterAccessionNo == true) { materialTrackingLogCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogCollectionByBatchIdMasterAccessionNo(materialTrackingBatch.MaterialTrackingBatchId, this.m_MasterAccessionNo); } else { materialTrackingLogCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetMaterialTrackingLogCollectionByBatchId(materialTrackingBatch.MaterialTrackingBatchId); } this.ViewBatch(this, new CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch, materialTrackingLogCollection)); } else { MessageBox.Show("Please select a batch to view."); } }
public MaterialTrackingBatchEventArgs(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch, YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection) { this.m_MaterialTrackingBatch = materialTrackingBatch; this.m_MaterialTrackingLogCollection = materialTrackingLogCollection; }
private void HyperlinkReceiveMaterialFromBillings_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.FacilityCollection facilityCollection = Business.Facility.Model.FacilityCollection.GetAllFacilities(); YellowstonePathology.Business.Facility.Model.Facility fromFacility = new YellowstonePathology.Business.Facility.Model.YellowstonePathologyInstituteBillings(); YellowstonePathology.Business.Facility.Model.Location fromLocation = new YellowstonePathology.Business.Facility.Model.LocationDefinitions.NullLocation(); YellowstonePathology.Business.Facility.Model.Facility toFacility = new YellowstonePathology.Business.Facility.Model.YellowstonePathologyInstituteCody(); YellowstonePathology.Business.Facility.Model.Location toLocation = new Business.Facility.Model.LocationDefinitions.PamCleggOffice(); string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, "Receive material from Billings", fromFacility, fromLocation, toFacility, toLocation, this.m_MasterAccessionNo); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new Business.MaterialTracking.Model.MaterialTrackingLogCollection(); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch, materialTrackingLogCollection)); }
public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch GetMaterialTrackingBatch() { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch result = null; return(result); }
private void ListBoxMaterialTrackingBatch_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.SaveSlideTrackingLog(); this.m_AccessionSlideOrderViewCollection.Clear(); this.m_SlideTrackingLogCollection.Clear(); if (this.ListBoxMaterialTrackingBatch.SelectedItem != null) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = (YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch) this.ListBoxMaterialTrackingBatch.SelectedItem; this.m_AccessionSlideOrderViewCollection = YellowstonePathology.Business.Gateway.SlideAccessionGateway.GetAccessionSlideOrderViewCollectionByBatchId(materialTrackingBatch.MaterialTrackingBatchId); this.SlideCount = this.m_AccessionSlideOrderViewCollection.Count; this.m_LocationId = this.GetLocationId(materialTrackingBatch.Description); NotifyPropertyChanged("AccessionSlideOrderViewCollection"); } }
private void HyperlinkSendMaterialFromCodyToBillings_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.FacilityCollection facilityCollection = Business.Facility.Model.FacilityCollection.GetAllFacilities(); YellowstonePathology.Business.Facility.Model.Facility fromFacility = new YellowstonePathology.Business.Facility.Model.YellowstonePathologistCody(); YellowstonePathology.Business.Facility.Model.Location fromLocation = new YellowstonePathology.Business.Facility.Model.LocationDefinitions.PamCleggOffice(); YellowstonePathology.Business.Facility.Model.Facility toFacility = new YellowstonePathology.Business.Facility.Model.YellowstonePathologyInstituteBillings(); YellowstonePathology.Business.Facility.Model.Location toLocation = new YellowstonePathology.Business.Facility.Model.LocationDefinitions.NullLocation(); string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, "Send material to Billings", fromFacility, fromLocation, toFacility, toLocation, this.m_MasterAccessionNo); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new Business.MaterialTracking.Model.MaterialTrackingLogCollection(); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch, materialTrackingLogCollection)); }
private void HyperlinkSendMaterial_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.FacilityCollection facilityCollection = Business.Facility.Model.FacilityCollection.GetAllFacilities(); YellowstonePathology.Business.Facility.Model.Facility toFacility = new YellowstonePathology.Business.Facility.Model.NullFacility(); YellowstonePathology.Business.Facility.Model.Location toLocation = new YellowstonePathology.Business.Facility.Model.LocationDefinitions.NullLocation(); YellowstonePathology.Business.Facility.Model.Facility fromFacility = facilityCollection.GetByFacilityId(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.FacilityId); YellowstonePathology.Business.Facility.Model.Location fromLocation = fromFacility.Locations.GetLocation(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.LocationId); string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, null, fromFacility, fromLocation, toFacility, toLocation, this.m_MasterAccessionNo); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new Business.MaterialTracking.Model.MaterialTrackingLogCollection(); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch, materialTrackingLogCollection)); }
private void HyperlinkSendMaterialToDrClegg_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.Facility fromFacility = Business.Facility.Model.FacilityCollection.Instance.GetByFacilityId(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.FacilityId); string fromLocation = YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.HostName; YellowstonePathology.Business.Facility.Model.Facility toFacility = YellowstonePathology.Business.Facility.Model.FacilityCollection.Instance.GetByFacilityId("YPCDY"); string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, "Send material to Dr. Clegg", fromFacility, fromLocation, toFacility, null, this.m_MasterAccessionNo); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch)); }
private static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection BuildMaterialTrackingBatchCollection(SqlCommand cmd) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection materialTrackingBatchCollection = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection(); using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingBatch, dr); propertyWriter.WriteProperties(); materialTrackingBatchCollection.Add(materialTrackingBatch); } } } return(materialTrackingBatchCollection); }
private void HyperlinkReceiveMaterialFromOffsiteStorage_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.Facility fromFacility = YellowstonePathology.Business.Facility.Model.FacilityCollection.Instance.GetByFacilityId("PFFSTSTRG"); YellowstonePathology.Business.Facility.Model.Facility toFacility = Business.Facility.Model.FacilityCollection.Instance.GetByFacilityId(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.FacilityId); string toLocation = YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.HostName; string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, "Receive material from offsite storage.", fromFacility, null, toFacility, toLocation, this.m_MasterAccessionNo); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch)); }
public MaterialTrackingBatchEventArgs(YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch) { this.m_MaterialTrackingBatch = materialTrackingBatch; }
private void HyperlinkDeleteSelectedBatch_Click(object sender, RoutedEventArgs e) { if (this.ListBoxMaterialTrackingBatch.SelectedItem != null) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = (YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch) this.ListBoxMaterialTrackingBatch.SelectedItem; YellowstonePathology.Business.Persistence.DocumentGateway.Instance.DeleteDocument(materialTrackingBatch, Window.GetWindow(this)); this.m_MaterialTrackingBatchCollection.Remove(materialTrackingBatch); this.NotifyPropertyChanged(string.Empty); } else { MessageBox.Show("Please select a batch to delete."); } }
public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch GetOpenBatchForFacilityLocation(string facilityId, string locationId) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch result = null; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from tblMaterialTrackingBatch where IsOpen = 1 and FromFacilityId = @FacilityId and FromLocationId = @LocationId"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@FacilityId", SqlDbType.VarChar).Value = facilityId; cmd.Parameters.Add("@LocationId", SqlDbType.VarChar).Value = locationId; using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { result = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr); sqlDataReaderPropertyWriter.WriteProperties(); } } } return result; }
private static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection BuildMaterialTrackingBatchCollection(SqlCommand cmd) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection materialTrackingBatchCollection = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatchCollection(); using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingBatch, dr); propertyWriter.WriteProperties(); materialTrackingBatchCollection.Add(materialTrackingBatch); } } } return materialTrackingBatchCollection; }
private void HyperlinkReceiveMaterial_Click(object sender, RoutedEventArgs e) { YellowstonePathology.Business.Facility.Model.FacilityCollection facilityCollection = Business.Facility.Model.FacilityCollection.GetAllFacilities(); YellowstonePathology.Business.Facility.Model.Facility fromFacility = new YellowstonePathology.Business.Facility.Model.NullFacility(); YellowstonePathology.Business.Facility.Model.Location fromLocation = new YellowstonePathology.Business.Facility.Model.LocationDefinitions.NullLocation(); YellowstonePathology.Business.Facility.Model.Facility toFacility = facilityCollection.GetByFacilityId(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.FacilityId); YellowstonePathology.Business.Facility.Model.Location toLocation = toFacility.Locations.GetLocation(YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference.LocationId); string objectId = MongoDB.Bson.ObjectId.GenerateNewId().ToString(); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch(objectId, null, fromFacility, fromLocation, toFacility, toLocation, this.m_MasterAccessionNo); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.InsertDocument(materialTrackingBatch, Window.GetWindow(this)); YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new Business.MaterialTracking.Model.MaterialTrackingLogCollection(); this.ViewBatch(this, new YellowstonePathology.UI.CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch, materialTrackingLogCollection)); }
private void HyperlinkViewSelectedBatch_Click(object sender, RoutedEventArgs e) { if (this.ListBoxMaterialTrackingBatch.SelectedItem != null) { string materialTrackingBatchId = ((YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch) this.ListBoxMaterialTrackingBatch.SelectedItem).MaterialTrackingBatchId; YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingBatch materialTrackingBatch = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullMaterialTrackingBatch(materialTrackingBatchId, Window.GetWindow(this)); if (this.m_UseMasterAccessionNo == true) { materialTrackingBatch = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullMaterialTrackingBatchWithMasterAccessionNo(materialTrackingBatchId, this.m_MasterAccessionNo, Window.GetWindow(this)); } else { materialTrackingBatch = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullMaterialTrackingBatch(materialTrackingBatchId, Window.GetWindow(this)); } this.ViewBatch(this, new CustomEventArgs.MaterialTrackingBatchEventArgs(materialTrackingBatch)); } else { MessageBox.Show("Please select a batch to view."); } }