public static ReportNoCollection GetReportNumbersByPostDate(DateTime postDate) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select Distinct ReportNo from tblPanelSetOrderCPTCodeBill where PostDate = @PostDate"; cmd.Parameters.Add("@PostDate", SqlDbType.DateTime).Value = postDate; YellowstonePathology.Business.ReportNoCollection reportNoCollection = new ReportNoCollection(); using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.ReportNo reportNo = new ReportNo(dr.GetString(0)); reportNoCollection.Add(reportNo); } } } return reportNoCollection; }
public static ReportNoCollection GetReportNumbers() { SqlCommand cmd = new SqlCommand("gwGetReportNumbers"); cmd.CommandType = CommandType.StoredProcedure; YellowstonePathology.Business.ReportNoCollection reportNoCollection = new ReportNoCollection(); using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.ReportNo reportNo = new ReportNo(dr.GetString(0)); reportNoCollection.Add(reportNo); } } } return reportNoCollection; }