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