/// <summary> /// Updates a DemoRegistration record and returns the number of records affected /// </summary> public static int Update(DemoRegistrationDO DO, DalapiTransaction Transaction) { SqlParameter _DemoRegistrationId = new SqlParameter("DemoRegistrationId", SqlDbType.Int); SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar); SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar); SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar); SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar); SqlParameter _Submitted = new SqlParameter("Submitted", SqlDbType.DateTime); SqlParameter _Code = new SqlParameter("Code", SqlDbType.VarChar); _DemoRegistrationId.Value = DO.DemoRegistrationId; _CompanyName.Value = DO.CompanyName; _Name.Value = DO.Name; _Email.Value = DO.Email; _Phone.Value = DO.Phone; _Submitted.Value = DO.Submitted; _Code.Value = DO.Code; SqlParameter[] _params = new SqlParameter[] { _DemoRegistrationId, _CompanyName, _Name, _Email, _Phone, _Submitted, _Code }; string pid = ConfigurationManager.AppSettings["PID"]; return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Update]", pid), _params, pid, Transaction)); }
/// <summary> /// Creates a new DemoRegistration record /// </summary> public int Create(DemoRegistrationDO DO, DalapiTransaction Transaction) { SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar); SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar); SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar); SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar); SqlParameter _Submitted = new SqlParameter("Submitted", SqlDbType.DateTime); SqlParameter _Code = new SqlParameter("Code", SqlDbType.VarChar); _CompanyName.Value = DO.CompanyName; _Name.Value = DO.Name; _Email.Value = DO.Email; _Phone.Value = DO.Phone; _Submitted.Value = DO.Submitted; _Code.Value = DO.Code; SqlParameter[] _params = new SqlParameter[] { _CompanyName, _Name, _Email, _Phone, _Submitted, _Code }; return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Insert]", pid), _params, pid, Transaction)); }
/// <summary> /// Deletes a DemoRegistration record /// </summary> public int Delete(DemoRegistrationDO DO, DalapiTransaction Transaction) { SqlParameter _DemoRegistrationId = new SqlParameter("DemoRegistrationId", SqlDbType.Int); _DemoRegistrationId.Value = DO.DemoRegistrationId; SqlParameter[] _params = new SqlParameter[] { _DemoRegistrationId }; return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Delete]", pid), _params, pid, Transaction)); }
/// <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()); }
/// <summary> /// Updates a DemoRegistration record and returns the number of records affected /// </summary> public static int Update(DemoRegistrationDO DO) { return(Update(DO, null)); }
/// <summary> /// Creates a new DemoRegistration record /// </summary> public static int Create(DemoRegistrationDO DO) { return(Create(null)); }
/// <summary> /// Deletes a DemoRegistration record /// </summary> public static int Delete(DemoRegistrationDO DO) { return(Delete(DO, null)); }