Ejemplo n.º 1
0
        /// <summary>
        /// Creates a new Registration record
        /// </summary>
        public static int Create(RegistrationDO DO)
        {
            SqlParameter _AccessRoleID = new SqlParameter("AccessRoleID", SqlDbType.VarChar);
            SqlParameter _FirstName = new SqlParameter("FirstName", SqlDbType.VarChar);
            SqlParameter _LastName = new SqlParameter("LastName", SqlDbType.VarChar);
            SqlParameter _Title = new SqlParameter("Title", SqlDbType.VarChar);
            SqlParameter _CompanyID = new SqlParameter("CompanyID", SqlDbType.Int);
            SqlParameter _Address1 = new SqlParameter("Address1", SqlDbType.VarChar);
            SqlParameter _City = new SqlParameter("City", SqlDbType.VarChar);
            SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar);
            SqlParameter _Zipcode = new SqlParameter("Zipcode", SqlDbType.VarChar);
            SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar);
            SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar);
            SqlParameter _RegistrationDescription = new SqlParameter("RegistrationDescription", SqlDbType.VarChar);
            SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar);
            SqlParameter _TermsOfUse = new SqlParameter("TermsOfUse", SqlDbType.Bit);
            SqlParameter _ActivationDate = new SqlParameter("ActivationDate", SqlDbType.DateTime);
            SqlParameter _ExpirationDate = new SqlParameter("ExpirationDate", SqlDbType.DateTime);

            _AccessRoleID.Value = DO.AccessRoleID;
            _FirstName.Value = DO.FirstName;
            _LastName.Value = DO.LastName;
            _Title.Value = DO.Title;
            _CompanyID.Value = DO.CompanyID;
            _Address1.Value = DO.Address1;
            _City.Value = DO.City;
            _StateID.Value = DO.StateID;
            _Zipcode.Value = DO.Zipcode;
            _Phone.Value = DO.Phone;
            _Email.Value = DO.Email;
            _RegistrationDescription.Value = DO.RegistrationDescription;
            _UserToken.Value = DO.UserToken;
            _TermsOfUse.Value = DO.TermsOfUse;
            _ActivationDate.Value = DO.ActivationDate;
            _ExpirationDate.Value = DO.ExpirationDate;

            SqlParameter[] _params = new SqlParameter[] {
                _AccessRoleID,
                _FirstName,
                _LastName,
                _Title,
                _CompanyID,
                _Address1,
                _City,
                _StateID,
                _Zipcode,
                _Phone,
                _Email,
                _RegistrationDescription,
                _UserToken,
                _TermsOfUse,
                _ActivationDate,
                _ExpirationDate
            };

            return DataCommon.ExecuteScalar("[dbo].[Registration_Insert]", _params, "dbo");
        }
Ejemplo n.º 2
0
        public ActionResult Register()
        {
            // don't allow users to register twice
            if (RegistrationBLL.IsUserRegistered(myCoalUser.UserToken))
            {
                //myCoalUser.GetInstance().
                return RedirectToAction("RegistrationReceived");
            }

            ViewBag.Message = "Register";
            RegistrationDO reg = new RegistrationDO() { CountryCode = "1" };
            RegistrationVM model = new RegistrationVM() { Registration = reg };
            return View(model);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Deletes a Registration record
        /// </summary>
        public static int Delete(RegistrationDO DO)
        {
            SqlParameter _RegistrationID = new SqlParameter("RegistrationID", SqlDbType.Int);

            _RegistrationID.Value = DO.RegistrationID;

            SqlParameter[] _params = new SqlParameter[] {
                _RegistrationID
            };

            return DataCommon.ExecuteScalar("[dbo].[Registration_Delete]", _params, "dbo");
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Selects Registration records by RegistrationUserToken
        /// </summary>
        public static RegistrationDO[] GetByRegistrationUserToken(String UserToken)
        {
            SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar);

            _UserToken.Value = UserToken;

            SqlParameter[] _params = new SqlParameter[] {
                _UserToken
            };

            SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Registration_GetByRegistrationUserToken]", _params, "dbo");

            List<RegistrationDO> objs = new List<RegistrationDO>();

            while(sr.Read())
            {
                RegistrationDO obj = new RegistrationDO();

                obj.RegistrationID = sr.GetInt32(sr.GetOrdinal("RegistrationID"));
                obj.AccessRoleID = sr.GetString(sr.GetOrdinal("AccessRoleID"));
                obj.FirstName = sr.GetString(sr.GetOrdinal("FirstName"));
                obj.LastName = sr.GetString(sr.GetOrdinal("LastName"));
                obj.Title = sr.GetString(sr.GetOrdinal("Title"));
                obj.CompanyID = sr.GetInt32(sr.GetOrdinal("CompanyID"));
                obj.Address1 = sr.GetString(sr.GetOrdinal("Address1"));
                obj.City = sr.GetString(sr.GetOrdinal("City"));
                obj.StateID = sr.GetString(sr.GetOrdinal("StateID"));
                obj.Zipcode = sr.GetString(sr.GetOrdinal("Zipcode"));
                obj.Phone = sr.GetString(sr.GetOrdinal("Phone"));
                obj.Email = sr.GetString(sr.GetOrdinal("Email"));
                obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken"));
                obj.TermsOfUse = sr.GetBoolean(sr.GetOrdinal("TermsOfUse"));
                if (sr.IsDBNull(sr.GetOrdinal("RegistrationDescription"))) { obj.RegistrationDescription = null; } else { obj.RegistrationDescription = sr.GetString(sr.GetOrdinal("RegistrationDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("ActivationDate"))) { obj.ActivationDate = null; } else { obj.ActivationDate = sr.GetDateTime(sr.GetOrdinal("ActivationDate")); }
                if (sr.IsDBNull(sr.GetOrdinal("ExpirationDate"))) { obj.ExpirationDate = null; } else { obj.ExpirationDate = sr.GetDateTime(sr.GetOrdinal("ExpirationDate")); }

                objs.Add(obj);
            }

            return objs.ToArray();
        }