/// <summary> /// Selects Page records by PK /// </summary> public static PageDO[] GetByPK(Int32 PageId) { SqlParameter _PageId = new SqlParameter("PageId", SqlDbType.Int); _PageId.Value = PageId; SqlParameter[] _params = new SqlParameter[] { _PageId }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Page_GetByPK]", _params, "dbo"); List <PageDO> objs = new List <PageDO>(); while (sr.Read()) { PageDO obj = new PageDO(); obj.PageId = sr.GetInt32(sr.GetOrdinal("PageId")); obj.Url = sr.GetString(sr.GetOrdinal("Url")); obj.DownloadDate = sr.GetDateTime(sr.GetOrdinal("DownloadDate")); obj.Html = sr.GetString(sr.GetOrdinal("Html")); objs.Add(obj); } return(objs.ToArray()); }
/// <summary> /// Selects DemoRegistration records by PK /// </summary> public static DemoRegistrationDO[] GetByPK(Int32 DemoRegistrationId) { SqlParameter _DemoRegistrationId = new SqlParameter("DemoRegistrationId", SqlDbType.Int); _DemoRegistrationId.Value = DemoRegistrationId; SqlParameter[] _params = new SqlParameter[] { _DemoRegistrationId }; string pid = ConfigurationManager.AppSettings["PID"]; SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[DemoRegistration_GetByPK]", pid), _params, pid); List <DemoRegistrationDO> objs = new List <DemoRegistrationDO>(); while (sr.Read()) { DemoRegistrationDO obj = new DemoRegistrationDO(); obj.DemoRegistrationId = sr.GetInt32(sr.GetOrdinal("DemoRegistrationId")); obj.CompanyName = sr.GetString(sr.GetOrdinal("CompanyName")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.Email = sr.GetString(sr.GetOrdinal("Email")); obj.Submitted = sr.GetDateTime(sr.GetOrdinal("Submitted")); if (sr.IsDBNull(sr.GetOrdinal("Phone"))) { obj.Phone = null; } else { obj.Phone = sr.GetString(sr.GetOrdinal("Phone")); } if (sr.IsDBNull(sr.GetOrdinal("Code"))) { obj.Code = null; } else { obj.Code = sr.GetString(sr.GetOrdinal("Code")); } objs.Add(obj); } return(objs.ToArray()); }
/// <summary> /// Gets all Page records /// </summary> public static PageDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Page_GetAll]", new SqlParameter[] { }, "dbo"); List <PageDO> objs = new List <PageDO>(); while (sr.Read()) { PageDO obj = new PageDO(); obj.PageId = sr.GetInt32(sr.GetOrdinal("PageId")); obj.Url = sr.GetString(sr.GetOrdinal("Url")); obj.DownloadDate = sr.GetDateTime(sr.GetOrdinal("DownloadDate")); obj.Html = sr.GetString(sr.GetOrdinal("Html")); objs.Add(obj); } return(objs.ToArray()); }
/// <summary> /// Gets all DemoRegistration records /// </summary> public DemoRegistrationDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[DemoRegistration_GetAll]", pid), new SqlParameter[] { }, pid); List <DemoRegistrationDO> objs = new List <DemoRegistrationDO>(); while (sr.Read()) { DemoRegistrationDO obj = new DemoRegistrationDO(); obj.DemoRegistrationId = sr.GetInt32(sr.GetOrdinal("DemoRegistrationId")); obj.CompanyName = sr.GetString(sr.GetOrdinal("CompanyName")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.Email = sr.GetString(sr.GetOrdinal("Email")); obj.Submitted = sr.GetDateTime(sr.GetOrdinal("Submitted")); if (sr.IsDBNull(sr.GetOrdinal("Phone"))) { obj.Phone = null; } else { obj.Phone = sr.GetString(sr.GetOrdinal("Phone")); } if (sr.IsDBNull(sr.GetOrdinal("Code"))) { obj.Code = null; } else { obj.Code = sr.GetString(sr.GetOrdinal("Code")); } objs.Add(obj); } return(objs.ToArray()); }