public static IList FetchHistory()
{
// initialize
History item = new History();
PropertyInfo[] p = item.GetType().GetProperties();
List<History> list = new List<History>();
string qryString = "SELECT * FROM HISTORY_LOG";
User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
IDBManager dbmgr = new DBManager(user.plantDBStr);
dbmgr.ConnectionString = user.plantDBStr;
try
{
dbmgr.Open();
dbmgr.ExecuteReader(CommandType.Text, qryString);
while (dbmgr.DataReader.Read())
{
item = new History();
item = (History)FetchObject(item, p, dbmgr);
list.Add(item);
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
dbmgr.Dispose();
}
return list;
}
