public List <BibliotecaModel> ListBibliotecas()
{
string strSQL = "SELECT * FROM BIBLIOTECA";
List <BibliotecaModel> diretorios = new List <BibliotecaModel>();
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())
{
BibliotecaModel diretorio = new BibliotecaModel
(
reader.GetString(0)
);
diretorios.Add(diretorio);
}
}
}
m_dbHelper.Connection.Close();
return(diretorios);
}
public IActionResult Create(BibliotecaModel biblioteca)
{
if (ModelState.IsValid)
{
bibliotecas.Add(biblioteca);
return(RedirectToAction(nameof(Index)));
}
return(View(biblioteca));
}
public void Fill(int ID)
{
Libro libroAEditar = BibliotecaModel.GetLibro(ID);
this.LibroID = libroAEditar.LibroID;
this.Titulo = libroAEditar.Titulo;
this.Autor = libroAEditar.Autor;
this.Genero = libroAEditar.Genero;
}
public void Create()
{
Libro libroNuevo = new Libro();
libroNuevo.LibroID = BibliotecaModel.GetID();
libroNuevo.Titulo = this.Titulo;
libroNuevo.Autor = this.Autor;
libroNuevo.Genero = this.Genero;
BibliotecaModel.Create(libroNuevo);
}
public void InsereBiblioteca(BibliotecaModel _pasta)
{
string strSQL = string.Format("INSERT INTO BIBLIOTECA (DIRETORIO) VALUES ('{0}')",
_pasta.Diretorio);
m_dbHelper.Connection.Open();
using (SQLiteCommand cmd = new SQLiteCommand(strSQL, m_dbHelper.Connection))
{
cmd.ExecuteNonQuery();
}
m_dbHelper.Connection.Close();
}
public ActionResult Inicializar()
{
BibliotecaModel.Inicializar();
return(RedirectToAction("Index"));
}
public LibrosIndexViewModel()
{
this.Libros = BibliotecaModel.GetListLibros();
}
public void InsereBiblioteca(BibliotecaModel _biblioteca)
{
m_udtBibliotecaDAL.InsereBiblioteca(_biblioteca);
}
