public void CreateUserWithChar(NewUserModel newUser, CharacterInfoAPIModel characterInfo) { try { using (SqlConnection conn = new SqlConnection(databaseConnectionString)) { SqlCommand cmd = new SqlCommand("CreateWithChar", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); cmd.Parameters.AddWithValue("@username", newUser.Username); cmd.Parameters.AddWithValue("@password", newUser.Password); cmd.Parameters.AddWithValue("@email", newUser.Email); cmd.Parameters.AddWithValue("@faction", characterInfo.recodedFaction); cmd.Parameters.AddWithValue("@gender", characterInfo.recodedGender); cmd.Parameters.AddWithValue("@race", characterInfo.recodedRace); cmd.Parameters.AddWithValue("@class", characterInfo.recodedClass); var result = cmd.ExecuteNonQuery(); } } catch (SqlException ex) { throw ex; } }
public ActionResult GetCharacter(CharacterInformationModel characterInfo) { APIController API = new APIController(); CharacterInfoAPIModel model = new CharacterInfoAPIModel(); model = API.GetCharacter(characterInfo); if (model == null) { TempData["Error"] = "Character not found"; return(RedirectToAction("CharacterForm")); } model.GetCharacterRecode(); SharedSession["WoWCharacterInfo"] = model; return(View("CharacterDisplay", model)); }
public ActionResult CreateUser(NewUserModel userInfo) { IUserDAL userDAL = new UserDAL(); var currentUser = userDAL.GetUser(userInfo.Username, userInfo.Password); if (currentUser != null) { return(View("TempPage")); } if (SharedSession["WoWCharacterInfo"] != null) { CharacterInfoAPIModel characterInfo = (CharacterInfoAPIModel)SharedSession["WowCharacterInfo"]; userDAL.CreateUserWithChar(userInfo, characterInfo); } else { userDAL.CreateUserNoChar(userInfo); } Session["username"] = userInfo.Username; return(View("TempPage")); }