public static recordModel convertir(recordjson modeljs)
{
var conectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-proyecto_final_moha_nestor-20180515073549.mdf;Initial Catalog=aspnet-proyecto_final_moha_nestor-20180515073549;Integrated Security=True";
System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection(conectionString);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = $"SELECT Id FROM AspNetUsers WHERE UserName = @iduser";
cmd.Parameters.AddWithValue("@iduser", modeljs.UserName);
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
SqlDataReader rdr = cmd.ExecuteReader();
string userid = "";
while (rdr.Read())
{
userid = (string)rdr["Id"];
}
sqlConnection1.Close();
var modelrecord = new recordModel();
modelrecord.idGame = modeljs.idGame;
modelrecord.idUser = userid;
modelrecord.time = modeljs.time;
modelrecord.score = modeljs.score;
return(modelrecord);
}
public string g2048(recordjson recordjs)
{
if (!ModelState.IsValid)
{
//agregar error de no poderse guardar
return("{\"status\":\"fail\" }");
}
else
{
var record = conversor.convertir(recordjs);
DataSaver.SaveData(record);
return("{\"status\":\"correct\" }");
}
}
