public List <ExtensaoModel> ListaExtensoes()
{
string strSQL = "SELECT * FROM EXTENSAO";
List <ExtensaoModel> extensoes = new List <ExtensaoModel>();
m_dbHelper.Connection.Open();
using (SQLiteCommand cmd = new SQLiteCommand(strSQL, m_dbHelper.Connection))
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
//Read the data and store them in the list
while (reader.Read())
{
ExtensaoModel extensao = new ExtensaoModel
(
reader.GetString(0)
);
extensoes.Add(extensao);
}
}
}
m_dbHelper.Connection.Close();
return(extensoes);
}
public void InsereExtensao(ExtensaoModel _extensao, SQLiteTransaction _dbTransaction = null)
{
string strSQL = string.Format("INSERT INTO EXTENSAO (EXTENSAO) VALUES ('{0}')",
_extensao);
m_dbHelper.Connection.Open();
using (SQLiteCommand cmd = new SQLiteCommand(strSQL, m_dbHelper.Connection))
{
cmd.ExecuteNonQuery();
}
m_dbHelper.Connection.Close();
}
public void InsereSerie(ExtensaoModel _extensao)
{
m_udtExtensaoDAL.InsereExtensao(_extensao);
}
