/// <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 Company records by PK /// </summary> public static CompanyDO[] GetByPK(Int32 CompanyId) { SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int); _CompanyId.Value = CompanyId; SqlParameter[] _params = new SqlParameter[] { _CompanyId }; string pid = ConfigurationManager.AppSettings["PID"]; SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[Company_GetByPK]", pid), _params, pid); List <CompanyDO> objs = new List <CompanyDO>(); while (sr.Read()) { CompanyDO obj = new CompanyDO(); obj.CompanyId = sr.GetInt32(sr.GetOrdinal("CompanyId")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.PhoneNumber = sr.GetString(sr.GetOrdinal("PhoneNumber")); 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 Company records /// </summary> public CompanyDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[Company_GetAll]", pid), new SqlParameter[] { }, pid); List <CompanyDO> objs = new List <CompanyDO>(); while (sr.Read()) { CompanyDO obj = new CompanyDO(); obj.CompanyId = sr.GetInt32(sr.GetOrdinal("CompanyId")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.PhoneNumber = sr.GetString(sr.GetOrdinal("PhoneNumber")); 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()); }
/// <summary> /// Selects Property records by PK /// </summary> public static PropertyDO[] GetByPK(Int32 PropertyId) { SqlParameter _PropertyId = new SqlParameter("PropertyId", SqlDbType.Int); _PropertyId.Value = PropertyId; SqlParameter[] _params = new SqlParameter[] { _PropertyId }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Property_GetByPK]", _params, "dbo"); List <PropertyDO> objs = new List <PropertyDO>(); while (sr.Read()) { PropertyDO obj = new PropertyDO(); obj.PropertyId = sr.GetInt32(sr.GetOrdinal("PropertyId")); obj.PageId = sr.GetInt32(sr.GetOrdinal("PageId")); obj.ArticleHtml = sr.GetString(sr.GetOrdinal("ArticleHtml")); obj.Lat = sr.GetString(sr.GetOrdinal("Lat")); obj.Long = sr.GetString(sr.GetOrdinal("Long")); obj.PhotoUrl = sr.GetString(sr.GetOrdinal("PhotoUrl")); obj.PhotoCaption = sr.GetString(sr.GetOrdinal("PhotoCaption")); obj.Price = sr.GetString(sr.GetOrdinal("Price")); obj.SoldDate = sr.GetString(sr.GetOrdinal("SoldDate")); obj.Zestimate = sr.GetString(sr.GetOrdinal("Zestimate")); obj.PriceSQFt = sr.GetString(sr.GetOrdinal("PriceSQFt")); obj.Address = sr.GetString(sr.GetOrdinal("Address")); obj.PropertyData = sr.GetString(sr.GetOrdinal("PropertyData")); obj.LotSize = sr.GetString(sr.GetOrdinal("LotSize")); obj.YearBuilt = sr.GetString(sr.GetOrdinal("YearBuilt")); objs.Add(obj); } return(objs.ToArray()); }