public Boolean update(Childe childe)
{
Boolean result = false;
MySqlConnection connection = null;
MySqlCommand mysqlCmd = null;
MySqlDataAdapter mysqlAdapter = null;
int codigop;
codigop = this.poblacionCod(childe.Poblacion);
String sql;
sql = "UPDATE nino SET carnet='" + childe.Carnet + "',nombre='" + childe.Name + "',apellidos='" + childe.Apellidos + "', direccion='" + childe.Direccion + "', sexo='" + childe.Sexo + "', anio_nac='" + childe.Anionac + "', codigo_poblacion=" + codigop
+ " WHERE carnet =" + childe.Carnet;
try
{
connection = dataSource.getConnection();
connection.Open();
mysqlCmd = new MySqlCommand(sql, connection);
mysqlAdapter = new MySqlDataAdapter(mysqlCmd);
mysqlCmd.ExecuteNonQuery();
result = true;
}
catch (Exception e)
{
Console.Write(e);
result = false;
}
finally
{
if (mysqlCmd != null)
{
mysqlCmd.Dispose();
}
if (mysqlAdapter != null)
{
mysqlAdapter.Dispose();
}
if (connection != null)
{
connection.Close();
}
}
return(result);
}
//Añadir el niño
public Boolean add(Childe childe)
{
Boolean result = true;
DataSet dataNino = new DataSet();
MySqlConnection connection = null;
MySqlCommand mysqlCmd = null;
MySqlDataAdapter mysqlAdapter = null;
int codigop;
codigop = this.poblacionCod(childe.Poblacion);
String sql;
sql = "INSERT INTO `nino`(`carnet`, `nombre`, `apellidos`, `direccion`, `sexo`, `anio_nac`, `codigo_poblacion`) VALUES (" + childe.Carnet + ", '" + childe.Name + "', '" + childe.Apellidos + "', '" + childe.Direccion + "', '" + childe.Sexo + "', '" + childe.Anionac + "', " + codigop + ")";
try
{
connection = dataSource.getConnection();
connection.Open();
mysqlCmd = new MySqlCommand(sql, connection);
mysqlAdapter = new MySqlDataAdapter(mysqlCmd);
mysqlCmd.ExecuteNonQuery();
result = true;
}
catch (Exception e)
{
Console.Write(e);
result = false;
}
finally
{
if (mysqlCmd != null)
{
mysqlCmd.Dispose();
}
if (mysqlAdapter != null)
{
mysqlAdapter.Dispose();
}
if (connection != null)
{
connection.Close();
}
}
return(result);
}