public IActionResult AccessServer([FromBody] RegisterUser value)
{
string userMail = value.Email;
// Server process
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "wonseoksample.database.windows.net";
builder.UserID = "jws786";
builder.Password = "******";
builder.InitialCatalog = "mySampleDatabase";
StringBuilder sb = new StringBuilder();
GameAccesse.GenerateLocation();
int sx, sy, sz;
sx = GameAccesse.Getsx();
sy = GameAccesse.Getsy();
sz = GameAccesse.Getsz();
string InsertCommand = "( 1, '" + userMail + "' ," + sx.ToString() + ", " + sy.ToString() + ", " + sz.ToString() + ")";
if (CheckExist(value.Email))
{
sb.Append("UPDATE dbo.GameStatus SET STARTX=" + sx.ToString() + ", STARTY=" + sy.ToString() + ", STARTZ=" + sz.ToString() + " WHERE EMAIL='" + value.Email + "'");
}
else
{
sb.Append("INSERT INTO dbo.GameStatus VALUES " + InsertCommand);
}
String sql = sb.ToString();
Console.WriteLine("SQL : " + sql);
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
Console.WriteLine("Game acceess starts ....");
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine("It has problem!");
return(BadRequest());
}
}
}
}
return(Json("OK!"));
}
