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