Пример #1
0
        public IActionResult GetHistoric(int id)
        {
            string         sql            = $"SELECT * from historicoGoles WHERE id = {id}";
            HistoricoGoles historicoGoles = new HistoricoGoles();

            try
            {
                using (SqlConnection cnn = new SqlConnection(AfaDB.cnnString))
                {
                    using (SqlCommand cmd = new SqlCommand(sql, cnn))
                    {
                        SqlDataReader dr = cmd.ExecuteReader();

                        while (dr.Read())
                        {
                            historicoGoles.id        = dr.GetFieldValue <int>(dr.GetOrdinal("id"));
                            historicoGoles.jugadorId = dr.GetFieldValue <int>(dr.GetOrdinal("jugadorId"));
                            historicoGoles.cantGoles = dr.GetFieldValue <int>(dr.GetOrdinal("cantGoles"));
                        }
                    }
                    return(new OkObjectResult(historicoGoles));
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                return(new NotFoundResult());
            }
        }
Пример #2
0
        public IActionResult Post(HistoricoGoles historicoGoles)
        {
            string sql = $"INSERT INTO historicoGoles (id,  jugadorId, cantGoles)";

            sql += "VALUES(@id, @jugadorId, @cantGoles)";

            try
            {
                using (SqlConnection cnn = new SqlConnection(AfaDB.cnnString))
                {
                    using (SqlTransaction trn = cnn.BeginTransaction())
                    {
                        try
                        {
                            using (SqlCommand cmd = new SqlCommand(sql, cnn))
                            {
                                cmd.Transaction = trn;

                                cmd.Parameters.Add(new SqlParameter("@id", historicoGoles.id));
                                cmd.Parameters.Add(new SqlParameter("@nombre", historicoGoles.jugadorId));
                                cmd.Parameters.Add(new SqlParameter("@ciudad", historicoGoles.cantGoles));


                                var rowsAffected = cmd.ExecuteNonQuery();
                                trn.Commit();
                                return(new OkObjectResult(historicoGoles));
                            }
                        }
                        catch (Exception ex)
                        {
                            trn.Rollback();
                            Console.WriteLine(ex.StackTrace);
                            return(new NotFoundResult());
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                return(new NotFoundResult());
            }
        }
Пример #3
0
        public IActionResult Update(HistoricoGoles historicoGoles, int id)
        {
            string sql = $"UPDATE historicoGoles SET  jugadorId = {historicoGoles.jugadorId}, cantGoles = {historicoGoles.cantGoles}";

            try
            {
                using (SqlConnection cnn = new SqlConnection(AfaDB.cnnString))
                {
                    using (SqlCommand cmd = new SqlCommand(sql, cnn))
                    {
                        cmd.ExecuteNonQuery();
                        return(new OkObjectResult(historicoGoles));
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                return(new NotFoundResult());
            }
        }