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