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