Esempio n. 1
0
        public List <EmisorDeEmails> Leer()
        {
            EmailDB       db         = new EmailDB();
            SqlConnection connection = new SqlConnection(db.connectionString);

            try
            {
                List <EmisorDeEmails> emisores = new List <EmisorDeEmails>();
                SqlCommand            comando  = new SqlCommand("", connection);
                EProducto             producto;
                comando.CommandText = "SELECT * FROM Emails2";
                connection.Open();
                SqlDataReader dataReader = comando.ExecuteReader();
                while (dataReader.Read())
                {
                    if (Enum.TryParse(dataReader["producto"].ToString(), out producto))
                    {
                        emisores.Add(new EmisorDeEmails(dataReader["mensaje"].ToString(), producto, dataReader["email"].ToString()));
                    }
                }
                return(emisores);
            }
            catch
            {
                throw;
            }
            finally
            {
                connection.Close();
            }
        }
Esempio n. 2
0
        public void Guardar(Emisor emisor)
        {
            EmailDB       db         = new EmailDB();
            SqlConnection connection = new SqlConnection(db.connectionString);

            try
            {
                connection.Open();
                string     query   = $"INSERT INTO mensaje , producto, email values ({emisor.Mensaje}) ({emisor.Producto.ToString()}) ({((EmisorDeEmails)emisor).Email.ToString()})";
                SqlCommand comando = new SqlCommand(query, connection);
                comando.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
            finally
            {
                connection.Close();
            }
        }