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