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)));
}
}
