/// <summary> /// Creates a new Registration record /// </summary> public static int Create(RegistrationDO DO) { SqlParameter _FirstName = new SqlParameter("FirstName", SqlDbType.VarChar); SqlParameter _LastName = new SqlParameter("LastName", SqlDbType.VarChar); SqlParameter _Title = new SqlParameter("Title", SqlDbType.VarChar); SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar); 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 _PhoneExtension = new SqlParameter("PhoneExtension", SqlDbType.VarChar); SqlParameter _CountryCode = new SqlParameter("CountryCode", SqlDbType.VarChar); SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar); SqlParameter _RegistrationDescription = new SqlParameter("RegistrationDescription", SqlDbType.VarChar); SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _RegistrationStatusID = new SqlParameter("RegistrationStatusID", SqlDbType.VarChar); _FirstName.Value = DO.FirstName; _LastName.Value = DO.LastName; _Title.Value = DO.Title; _CompanyName.Value = DO.CompanyName; _Address1.Value = DO.Address1; _City.Value = DO.City; _StateID.Value = DO.StateID; _Zipcode.Value = DO.Zipcode; _Phone.Value = DO.Phone; _PhoneExtension.Value = DO.PhoneExtension; _CountryCode.Value = DO.CountryCode; _Email.Value = DO.Email; _RegistrationDescription.Value = DO.RegistrationDescription; _UserToken.Value = DO.UserToken; _RegistrationStatusID.Value = DO.RegistrationStatusID; SqlParameter[] _params = new SqlParameter[] { _FirstName, _LastName, _Title, _CompanyName, _Address1, _City, _StateID, _Zipcode, _Phone, _PhoneExtension, _CountryCode, _Email, _RegistrationDescription, _UserToken, _RegistrationStatusID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[Registration_Insert]", _params, pid); }
/// <summary> /// Selects Registration records by RegistrationUserToken /// </summary> public static async Task<RegistrationDO[]> GetByRegistrationUserTokenAsync(String UserToken) { SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); _UserToken.Value = UserToken; SqlParameter[] _params = new SqlParameter[] { _UserToken }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Registration_GetByRegistrationUserToken]", _params, pid); List<RegistrationDO> objs = new List<RegistrationDO>(); while(sr.Read()) { RegistrationDO obj = new RegistrationDO(); obj.RegistrationID = sr.GetInt32(sr.GetOrdinal("RegistrationID")); obj.FirstName = sr.GetString(sr.GetOrdinal("FirstName")); obj.LastName = sr.GetString(sr.GetOrdinal("LastName")); obj.Title = sr.GetString(sr.GetOrdinal("Title")); 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.RegistrationStatusID = sr.GetString(sr.GetOrdinal("RegistrationStatusID")); if (sr.IsDBNull(sr.GetOrdinal("CompanyName"))) { obj.CompanyName = null; } else { obj.CompanyName = sr.GetString(sr.GetOrdinal("CompanyName")); } if (sr.IsDBNull(sr.GetOrdinal("PhoneExtension"))) { obj.PhoneExtension = null; } else { obj.PhoneExtension = sr.GetString(sr.GetOrdinal("PhoneExtension")); } if (sr.IsDBNull(sr.GetOrdinal("CountryCode"))) { obj.CountryCode = null; } else { obj.CountryCode = sr.GetString(sr.GetOrdinal("CountryCode")); } if (sr.IsDBNull(sr.GetOrdinal("RegistrationDescription"))) { obj.RegistrationDescription = null; } else { obj.RegistrationDescription = sr.GetString(sr.GetOrdinal("RegistrationDescription")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all Registration records /// </summary> public static RegistrationDO[] GetAll() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Registration_GetAll]", new SqlParameter[] { }, pid); List<RegistrationDO> objs = new List<RegistrationDO>(); while(sr.Read()){ RegistrationDO obj = new RegistrationDO(); obj.RegistrationID = sr.GetInt32(sr.GetOrdinal("RegistrationID")); obj.FirstName = sr.GetString(sr.GetOrdinal("FirstName")); obj.LastName = sr.GetString(sr.GetOrdinal("LastName")); obj.Title = sr.GetString(sr.GetOrdinal("Title")); 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.RegistrationStatusID = sr.GetString(sr.GetOrdinal("RegistrationStatusID")); if (sr.IsDBNull(sr.GetOrdinal("CompanyName"))) { obj.CompanyName = null; } else { obj.CompanyName = sr.GetString(sr.GetOrdinal("CompanyName")); } if (sr.IsDBNull(sr.GetOrdinal("PhoneExtension"))) { obj.PhoneExtension = null; } else { obj.PhoneExtension = sr.GetString(sr.GetOrdinal("PhoneExtension")); } if (sr.IsDBNull(sr.GetOrdinal("CountryCode"))) { obj.CountryCode = null; } else { obj.CountryCode = sr.GetString(sr.GetOrdinal("CountryCode")); } if (sr.IsDBNull(sr.GetOrdinal("RegistrationDescription"))) { obj.RegistrationDescription = null; } else { obj.RegistrationDescription = sr.GetString(sr.GetOrdinal("RegistrationDescription")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a Registration record /// </summary> public static async Task<int> DeleteAsync(RegistrationDO DO) { SqlParameter _RegistrationID = new SqlParameter("RegistrationID", SqlDbType.Int); _RegistrationID.Value = DO.RegistrationID; SqlParameter[] _params = new SqlParameter[] { _RegistrationID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Registration_Delete]", _params, pid); }
public ActionResult Register() { // don't allow users to register twice if (RegistrationBLL.IsUserRegistered(myCoalUser.UserToken)) return RedirectToAction("RegistrationReceived"); EPassPrincipal ePassUser = (EPassPrincipal)System.Web.HttpContext.Current.User; ViewBag.Message = "Register"; RegistrationDO reg = new RegistrationDO() { CountryCode = "1", FirstName = ePassUser.Attributes.FirstName, LastName = ePassUser.Attributes.LastName, Email = ePassUser.Attributes.EMail }; RegistrationVM model = new RegistrationVM() { Registration = reg }; return View(model); }