using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.Globalization;

public partial class cadArtigos : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Btlimpar_Click(object sender, EventArgs e)
    {
        titulo.Text = string.Empty;
        autor.Text = string.Empty;
        texto.Text = string.Empty;
        dia.Text = string.Empty;
        mes.Text = string.Empty;
        ano.Text = string.Empty;
        publicar.Checked = false;
    }
    protected void BtSalvar_Click(object sender, EventArgs e)
    {
        string conexao = "Server=localhost;Database=Stonehenge;Uid=root;Pwd='';Connect Timeout=30;";
        MySqlConnection conn;
        conn = new MySqlConnection(conexao);
        string pbl = publicar.Checked ? "1" : "0";
        //DateTime dt = new DateTime(int.Parse(ano.Text),int.Parse(mes.Text),int.Parse(dia.Text),0,0,0);
        //CultureInfo ci = new CultureInfo("en-US");
        DateTime dt = new DateTime();
        string dt1 = dia.Text + "/" + mes.Text + "/" + ano.Text;
        dt = DateTime.Parse(dt1);
        //Response.Write(dt.Date);
        String data=String.Format("{0:u}", dt);
        string comando = "INSERT INTO artigo ";
        comando += "(autor,titulo,texto,data,publicar)";
        comando += "VALUES (\"" + autor.Text + "\",\"" + titulo.Text + "\",";
        comando += "\"" + texto.Text + "\",'"  + data+  "',";
        comando += pbl + ")";
        MySqlCommand cmd = new MySqlCommand(comando);
        cmd.Connection = conn;
        conn.Open();
        cmd.ExecuteNonQuery();
    }
}