using System.Data.SqlClient;

 namespace Database_1._0
 {
public partial class Form1 : Form
{
    SqlConnection cn = new SqlConnection(@"DataSource=LocalDB)MSSQLLocalDB;AttachDbFilename=C:UsersLuisdocumentsvisual studio 2015ProjectsDatabase_1._0Database_1._0DB.mdf;Integrated Security=True");
    SqlCommand cmd = new SqlCommand();
    SqlDataReader dr;

    DateTime dateTime = DateTime.UtcNow.Date;
    string user = "1614258779876465426";
    string pass = "3Cp5CeXrfghdfght";
    string frecuencyCode = "ANNUAL";

    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        cmd.Connection = cn;
    }

    private void logo_Click(object sender, EventArgs e)
    {
        MessageBox.Show("Database_1._0 nWritten by: Luis", "About");
    }

    private void button1_Click(object sender, EventArgs e)
    {

        cn.Open();
        using (SieteWS SieteWS = new SieteWS())
        {
            Respuesta respuesta = SieteWS.SearchSeries(user, pass, frecuencyCode);
            foreach (internetSeriesInfo seriesInfo in respuesta.SeriesInfos)
            {

                cmd.CommandText = "INSERT INTO [dbo].[Serie] ([SerieID], [SerieName], [SerieFrecuency]) VALUES (@SerieID, @SerieName, @SerieFrecuency)";
                cmd.Parameters.AddWithValue("@SerieID", seriesInfo.seriesId);
                cmd.Parameters.AddWithValue("@SerieName", seriesInfo.spanishTitle);
                cmd.Parameters.AddWithValue("@SerieFrecuency", seriesInfo.frequency);
                cmd.ExecuteNonQuery();
                cn.Close();
            }
         }
     }
}
}