public ActionResult Register() { var model = new RegisterViewModel { UserTypes = new List<SelectListItem> { new SelectListItem { Text = "Select User Type", Value = "0" } }, CallCenters = new List<SelectListItem> { new SelectListItem { Text = "Select a Call Center", Value = "0" } } }; var conString = ConfigurationManager.ConnectionStrings["DisasterDB"].ConnectionString; using (var conn = new SqlConnection(conString)) { var query = "SELECT * FROM [UserTypes]"; var command = new SqlCommand(query, conn); conn.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { model.UserTypes.Add( new SelectListItem { Text = reader["Title"].ToString(), Value = reader["Id"].ToString() } ); } reader.Close(); } using (var conn = new SqlConnection(conString)) { var query = "SELECT * FROM [CallCenter]"; var command = new SqlCommand(query, conn); conn.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { model.CallCenters.Add( new SelectListItem { Text = reader["Name"].ToString(), Value = reader["Id"].ToString() } ); } reader.Close(); } return View(model); }
public ActionResult Register(RegisterViewModel model) { if (ModelState.IsValid) { var conString = ConfigurationManager.ConnectionStrings["DisasterDB"].ConnectionString; var hashPassword = model.Password.GetHashCode(); using (var conn = new SqlConnection(conString)) using (var cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Register"; cmd.Parameters.AddWithValue("@firstName", model.FirstName); cmd.Parameters.AddWithValue("@lastName", model.LastName); cmd.Parameters.AddWithValue("@address", model.Address); cmd.Parameters.AddWithValue("@city", model.City); cmd.Parameters.AddWithValue("@state", model.State); cmd.Parameters.AddWithValue("@country", "United States"); cmd.Parameters.AddWithValue("@zip", Convert.ToInt32(model.Zip)); cmd.Parameters.AddWithValue("@email", model.Email); cmd.Parameters.AddWithValue("@phone", model.Phone); cmd.Parameters.AddWithValue("@userType", Convert.ToInt32(model.UserType)); cmd.Parameters.AddWithValue("@password", hashPassword); cmd.Parameters.AddWithValue("@callcenter", Convert.ToInt32(model.CallCenter)); cmd.ExecuteNonQuery(); } Session["isAuthenticated"] = true; Session["userName"] = model.Email; return RedirectToAction("Index", "Home"); } return View(model); }