private Hearing GetHearing(SqlCommand cmd) { Hearing hearing = null; SqlDataReader dr = GetReader(cmd); if (dr.Read()) { hearing = new Hearing(); hearing.ID = int.Parse(dr["ID"].ToString()); hearing.DocketNumber = dr["docket_no"].ToString(); hearing.Category = dr["category"].ToString(); hearing.OpenMonth = dr["open_month"].ToString(); hearing.OpenYear = dr["open_year"].ToString(); hearing.Petitioner = dr["petitioner"].ToString(); hearing.Respondent = dr["respondent"].ToString(); hearing.HearingOfficer = dr["hearing_officer"].ToString(); hearing.ClosingYear = dr["closing_year"].ToString(); hearing.FileLocation = dr["file_location"].ToString(); hearing.HearingType = dr["hearing_type"].ToString(); hearing.LastUpdate = DateTime.Parse(dr["last_updated"].ToString()); } dr.Close(); return(hearing); }
private Hearing[] GetHearingArray(SqlCommand cmd) { ArrayList hearingArray = new ArrayList(); SqlDataReader dr = null; try { dr = GetReader(cmd); while (dr.Read()) { Hearing hearing = new Hearing(); hearing.ID = int.Parse(dr["ID"].ToString()); hearing.DocketNumber = dr["docket_no"].ToString(); hearing.Category = dr["category"].ToString(); hearing.OpenMonth = dr["open_month"].ToString(); hearing.OpenYear = dr["open_year"].ToString(); hearing.Petitioner = dr["petitioner"].ToString(); hearing.Respondent = dr["respondent"].ToString(); hearing.HearingOfficer = dr["hearing_officer"].ToString(); hearing.ClosingYear = dr["closing_year"].ToString(); hearing.FileLocation = dr["file_location"].ToString(); hearing.HearingType = dr["hearing_type"].ToString(); hearing.LastUpdate = DateTime.Parse(dr["last_updated"].ToString()); hearingArray.Add(hearing); } } catch (Exception ex) { string filePath = @"D:\Websites92\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("Message: " + ex.Message + "<br/>" + Environment.NewLine + "StackTrace: " + ex.StackTrace); if (ex.InnerException != null) { writer.WriteLine(ex.InnerException.Message); } else { writer.WriteLine("No inner exception"); } } } finally { dr.Close(); } if (hearingArray.Count == 0) { return(null); } else { return((Hearing[])hearingArray.ToArray(typeof(Hearing))); } }