public User GetUser(string id)
{
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "GetUserInfo";
command.CommandType = CommandType.StoredProcedure;
SqlParameter userID = new SqlParameter("@UserName", SqlDbType.NVarChar);
userID.Value = id;
command.Parameters.Add(userID);
connection.Open();
SqlDataReader dr;
dr = command.ExecuteReader();
var user = new User();
if (dr.HasRows)
{
dr.Read();
user.Id = dr.GetString(0);
if (dr.IsDBNull(1)==true)
{
user.ChatName = "User";
}
else if (dr.GetString(1) == "")
{
user.ChatName = "User";
}
else {
user.ChatName = dr.GetString(1);
}
if (dr.IsDBNull(2) == true)
{
user.ActivePlayer = -1;
}
else
{
user.ActivePlayer = dr.GetInt32(2);
}
}
connection.Close();
dr.Close();
return user;
}
public void UpdateDefaultPlayer(User user)
{
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "UpdateDefaultPlayer";
command.CommandType = CommandType.StoredProcedure;
SqlParameter UserName = new SqlParameter("@UserName", SqlDbType.NVarChar);
SqlParameter PlayerID = new SqlParameter("@PlayerID", SqlDbType.Int);
UserName.Value = user.UserName;
PlayerID.Value = user.ActivePlayer;
command.Parameters.Add(UserName);
command.Parameters.Add(PlayerID);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
public void UpdateDefaultPlayer(User user)
{
new StoredUser().UpdateDefaultPlayer(user);
}
public string UpdateDefaultPlayer(User user)
{
var updateUser = new UserRepository();
updateUser.UpdateDefaultPlayer(user);
var Success = user.ActivePlayer;
return "{'UpdatedPlayerID': " + Success + "}";
}