using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Geax.Model;
using MySql.Data;
using MySql.Data.MySqlClient;


namespace Geax.DAL
{
    public class ClienteDAL
    {
        public static void cadastra(Clientes obj)
        {
            using (var conn = new MySqlConnection("server=127.0.0.1;Database=xpto;User ID=root;Password='';"))
            {
                try
                {
                    String InsertCliente = ("INSERT INTO tab_cliente (nome,cpf,rg,endereco,telefone,email) VALUES(@nome, @cpf, @rg, @endereco, @telefone, @email)");

                    MySqlCommand cmd = new MySqlCommand();
                    cmd.CommandText = InsertCliente;
                    cmd.Connection = conn;
                    cmd.Parameters.AddWithValue("@nome", obj.Nome);
                    cmd.Parameters.AddWithValue("@cpf", obj.Cpf);
                    cmd.Parameters.AddWithValue("@rg", obj.Rg);
                    cmd.Parameters.AddWithValue("@endereco", obj.Endreco);
                    cmd.Parameters.AddWithValue("@telefone", obj.Telefone);
                    cmd.Parameters.AddWithValue("@email", obj.Email);

                    cmd.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    throw e;
                }
            }
        }
   }
}