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