public static void SendNewRegistrationEmail(RegisterModel model)
{
string subj = "Welcome to Rocket League Wars";
string body = String.Empty;
StringBuilder sbBody = new StringBuilder();
sbBody.Append("Hello, ");
sbBody.Append(model.UserName + "!");
sbBody.Append("<br> <br>");
sbBody.Append("Thanks for joining. The Admin Team will now assign you to a team. You will be emailed when this happens.");
sbBody.Append("<br> <br>");
sbBody.Append("Thanks,");
sbBody.Append("<br>");
sbBody.Append("RocketLeagueWars.com");
body = sbBody.ToString();
MailMessage email = new MailMessage();
email.IsBodyHtml = true;
email.Subject = subj;
email.Body = body;
email.From = GetSupportEmail();
email.To.Add(model.Email.Trim());
SmtpClient smtp = new SmtpClient();
smtp.Port = 587;
smtp.Credentials = new NetworkCredential(GetSupportEmailUsername(), GetSupportEmailPassword());
smtp.Host = GetSupportEmailHost();
smtp.Send(email);
InsertEmailTrackingRow(smtp, AccountLogic.GetUserID(model.UserName));
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the user
try
{
int userID = AccountLogic.Register(model);
if (userID > 0)
{
EmailLogic.SendNewRegistrationEmail(model);
Session["Username"] = model.UserName;
return RedirectToAction("Index", "Home");
}
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public static int Register(RegisterModel user)
{
int result = 0;
string sql = @"insert into Users (Username, Email, Password) values (@Username, @Email, @Password)
select scope_identity()";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DSN"].ConnectionString))
{
SqlCommand command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@Username", user.UserName);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@Password", PasswordHash.CreateHash(user.Password));
conn.Open();
object userID = command.ExecuteScalar();
if (userID != null)
{
result = Convert.ToInt32(userID);
}
conn.Close();
}
return result;
}
