public bool Crear()
{
OdbcConnection oConnection = this.OpenConnection();
OdbcDataAdapter myConsulta;
DataTable dt = new DataTable();
myConsulta = new OdbcDataAdapter("SELECT Nombre, Apellido FROM Personas WHERE dni = " + int.Parse(strDocumento), oConnection);
myConsulta.Fill(dt);
if (dt.Rows.Count > 0)
{
return(false);
}
String strSQL = "Insert into Personas (Nombre, Apellido, ";
strSQL = strSQL + "EstadoCivil, Tipodni, DNI, Calle, Nro, Dpto, Piso, Barrio, CP, idLocalidad, idProvincia) ";
strSQL = strSQL + " values ('" + Nombre + "','" + Apellido.Replace("'", "''") + "',";
strSQL = strSQL + intEstadoCivil + "," + intTipoDocumento + ",'" + strDocumento;
strSQL = strSQL + "','" + strCalle + "','" + strNro + "','" + strDpto + "','" + strPiso + "','" + strBarrio + "','" + strCP + "'," + intLocalidad.ToString() + "," + intProvincia.ToString() + ")";
try
{
OdbcCommand myCommand = new OdbcCommand(strSQL, oConnection);
myCommand.ExecuteNonQuery();
oConnection.Close();
}
catch (Exception e)
{
string p = e.Message;
return(false);
}
return(true);
}
