public List <clsRegion> verRegistro()
{
SQLiteConnector.CreateTable();
List <clsRegion> Regiones = new List <clsRegion>();
SQLiteConnection conn = SQLiteConnector.CreateConnection();
SQLiteCommand command;
SQLiteDataReader reader;
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM Region";
try
{
reader = command.ExecuteReader();
while (reader.Read())
{
Regiones.Add(new clsRegion(
reader.GetInt32(0),
reader.GetString(1),
reader.GetString(2)
));
}
}
catch (SQLiteException e)
{
System.Windows.Forms.MessageBox.Show(e.ToString());
}
conn.Close();
return(Regiones);
}
public suportDepartamento()
{
SQLiteConnector.CreateTable();
}
public suportRegion()
{
SQLiteConnector.CreateTable();
}
public suportEmpleado()
{
SQLiteConnector.CreateTable();
}