public static List <PageView> GetPageViews(string Path)
{
try
{
List <PageView> PageViews = new List <PageView>();
DataTable dt = new DataTable();
SiteData.DBAccess DBAccess = new SiteData.DBAccess();
using (SqlCommand dbcmd = new SqlCommand {
CommandType = CommandType.StoredProcedure, CommandText = "GetPageViews"
})
{
dt = DBAccess.OpenDataTable(dbcmd);
PageViews = PopulateClassListFromDataTable <PageView>(dt);
}
return(PageViews);
//System.Xml.Serialization.XmlSerializer Serializer = new System.Xml.Serialization.XmlSerializer(PageViews.GetType());
//if (System.IO.File.Exists(Path))
//{
// Stream PathStream = File.Open(Path, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
// StreamReader objStreamReader = new StreamReader(PathStream);
// PageViews = (List<PageView>)Serializer.Deserialize(objStreamReader);
// objStreamReader.Close();
// PathStream.Close();
// PathStream.Dispose();
// return PageViews;
//}
//return null;
}
catch (Exception ex)
{
string Body = "An error was encountered: " + Environment.NewLine + ex.ToString();
Utils.SendEmail("*****@*****.**", "*****@*****.**", "error encountered", Body);
return(null);
}
}
//todo: add create instance stuff to significantly reduce the codebase.
#endregion
#region PageView Data
public static List <PageView> GetPageViews()
{
try
{
List <PageView> PageViews = new List <PageView>();
DataTable dt = new DataTable();
SiteData.DBAccess DBAccess = new SiteData.DBAccess();
using (SqlCommand dbcmd =
new SqlCommand {
CommandType = CommandType.StoredProcedure, CommandText = "GetPageViews"
})
{
dt = DBAccess.OpenDataTable(dbcmd);
PageViews = PopulateClassListFromDataTable <PageView>(dt);
}
return(PageViews);
}
catch (Exception ex)
{
string Body = "An error was encountered: " + Environment.NewLine + ex.ToString();
Utils.SendEmail("*****@*****.**", "*****@*****.**", "error encountered", Body);
return(null);
}
}
