public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView GetMaterialTrackingLogView(string slideOrderId, string materialTrackingBatchId) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView result = null; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from tblMaterialTrackingLog where MaterialId = @MaterialId and MaterialTrackingBatchId = @MaterialTrackingBatchId"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.Add("@MaterialId", System.Data.SqlDbType.VarChar).Value = slideOrderId; cmd.Parameters.Add("@MaterialTrackingBatchId", System.Data.SqlDbType.VarChar).Value = materialTrackingBatchId; 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.MaterialTrackingLogView(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr); propertyWriter.WriteProperties(); } } } return(result); }
private void MenuItemDelete_Click(object sender, RoutedEventArgs e) { if (this.ListViewMaterialTrackingLog.SelectedItems.Count > 0) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView materialTrackingLogView = (YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView) this.ListViewMaterialTrackingLog.SelectedItem; YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog materialTrackingLog = this.m_MaterialTrackingBatch.MaterialTrackingLogCollection.Get(materialTrackingLogView.MaterialTrackingLogId); this.m_MaterialTrackingBatch.MaterialTrackingLogCollection.Remove(materialTrackingLog); this.m_MaterialTrackingLogViewCollection.Remove(materialTrackingLogView); } }
private void MenuItemDelete_Click(object sender, RoutedEventArgs e) { if (this.ListViewMaterialTrackingLog.SelectedItems.Count > 0) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView materialTrackingLogView = (YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView) this.ListViewMaterialTrackingLog.SelectedItem; YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog materialTrackingLog = this.m_MaterialTrackingLogCollection.Get(materialTrackingLogView.MaterialTrackingLogId); this.m_MaterialTrackingLogCollection.Remove(materialTrackingLog); this.m_MaterialTrackingLogViewCollection.Remove(materialTrackingLogView); YellowstonePathology.Business.Persistence.DocumentGateway.Instance.DeleteDocument(materialTrackingLog, this.m_PageNavigator.PrimaryMonitorWindow); } }
public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection GetMaterialTrackingLogViewCollectionByBatchIdMasterAccessionNo(string materialTrackingBatchId, string masterAccessionNo) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection result = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from ViewMaterialTrackingLog where MaterialTrackingBatchId = @MaterialTrackingBatchId and MasterAccessionNo = @MasterAccessionNo"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.Add("@MaterialTrackingBatchId", System.Data.SqlDbType.VarChar).Value = materialTrackingBatchId; cmd.Parameters.Add("@MasterAccessionNo", System.Data.SqlDbType.VarChar).Value = masterAccessionNo; 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.MaterialTrackingLogView materialTrackingLogView = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLogView, dr); propertyWriter.WriteProperties(); result.Add(materialTrackingLogView); } } } return result; }
public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection GetMaterialTrackingLogViewCollectionByBatchIdMasterAccessionNo(string materialTrackingBatchId, string masterAccessionNo) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection result = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select * from ViewMaterialTrackingLog where ViewMaterialTrackingLog.MaterialTrackingBatchId = " + "@MaterialTrackingBatchId and ViewMaterialTrackingLog.MasterAccessionNo = @MasterAccessionNo;"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@MaterialTrackingBatchId", materialTrackingBatchId); cmd.Parameters.AddWithValue("@MasterAccessionNo", masterAccessionNo); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView materialTrackingLogView = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLogView, dr); propertyWriter.WriteProperties(); result.Add(materialTrackingLogView); } } } return(result); }
public static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection GetMaterialTrackingLogViewCollectionByBatchId(string materialTrackingBatchId) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection result = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogViewCollection(); string sql = "SELECT " + "mtb.MaterialTrackingBatchId AS MaterialTrackingBatchId, " + "mtl.MaterialTrackingLogId AS MaterialTrackingLogId, " + "ao.MasterAccessionNo AS MasterAccessionNo, " + "ao.ClientAccessionNo AS ClientAccessionNo, " + "ao.PLastName AS PLastName, " + "ao.PFirstName AS PFirstName, " + "mtl.MaterialType AS MaterialType, " + " mtl.MaterialId AS MaterialId, " + "mtl.LogDate AS LogDate, " + "(CASE " + "WHEN " + "(mtl.MaterialType = 'Slide') " + "THEN " + "(SELECT " + "tblSlideOrder.Label " + "FROM " + "tblSlideOrder " + "WHERE " + "(tblSlideOrder.SlideOrderId = mtl.MaterialId)) " + "ELSE 'None' " + "END) AS `MaterialLabel`, " + "mtl.LoggedBy AS `LoggedBy` " + "FROM " + "tblMaterialTrackingBatch mtb " + "JOIN tblMaterialTrackingLog mtl ON mtb.MaterialTrackingBatchId = mtl.MaterialTrackingBatchId " + "Left JOIN tblAccessionOrder ao ON mtl.MasterAccessionNo = ao.MasterAccessionNo " + "where mtb.MaterialTrackingBatchId = @MaterialTrackingBatchId order by mtl.LogDate desc"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = sql; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@MaterialTrackingBatchId", materialTrackingBatchId); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView materialTrackingLogView = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogView(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLogView, dr); propertyWriter.WriteProperties(); result.Add(materialTrackingLogView); } } } return(result); }