VacunasController

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace ControlVacunasDAL

{

    public class Vacuna

    {
        public int Id { get; set; }

        public string Name { get; set; }

        public string Administracion { get; set; }

        public string Dose { get; set; }


        public void Save()

        {

            var connection = new DBConnection().getConnection();

            string sql = $"INSERT INTO Mstr_Vacunas (vac_nombre,vac_Dosis, vac_Via_administracion)  VALUES ('{Name}', '{Dose}', '{Administracion}');";
            SqlCommand command;

            try

            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                command.ExecuteNonQuery();

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

    }

        public static List<Vacuna> getAllVacunas()
        {
            var connection = new DBConnection().getConnection();

            string sql = $"SELECT * FROM Hist_Historial_Vacunas;";
            SqlCommand command;
            List<Vacuna> allVacunas = new List<Vacuna>();

            try
            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    Vacuna vacuna = new Vacuna();
                    vacuna.Id = Convert.ToInt32(reader.GetValue(0).ToString());
                    vacuna.Name = reader.GetValue(1).ToString();
                    vacuna.Dose = reader.GetValue(2).ToString();
                    vacuna.Administracion = reader.GetValue(3).ToString();

                    allVacunas.Add(vacuna);

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            return allVacunas;
        }


    }
}