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