public string AddBookRead(int id, string resume, DateTime start, DateTime end)
{
string response;
Conexao conexao = new Conexao();
conexao.Conectar();
try
{
ExecutaSP executaSP = new ExecutaSP("BOOK_SP_INS_BOOK_READ", conexao.VoltaConexaoAberta());
executaSP.addParam("@ID", id);
executaSP.addParam("@RESUME", resume);
executaSP.addParam("@START", start);
executaSP.addParam("@END", end);
executaSP.Executa();
executaSP.Confirma();
response = "Ok";
return(response);
}
catch (Exception ex)
{
response = ex.ToString();
return(response);
}
}
public void UpdBook(Book book, BookRead bookRead)
{
Conexao conexao = new Conexao();
conexao.Conectar();
ExecutaSP executa = new ExecutaSP("BOOK_SP_UPD_BOOK", conexao.VoltaConexaoAberta());
try
{
executa.addParam("@ID", book.Id);
executa.addParam("@NAME", book.Name);
executa.addParam("@INDICATION", book.Indication);
executa.addParam("@SAGA", book.Saga);
executa.addParam("@RESUME", bookRead.Resume);
executa.addParam("@DATESTART", bookRead.DateStart);
executa.addParam("@DATEEND", bookRead.DateEnd);
executa.Executa();
executa.Confirma();
}
catch (Exception ex)
{
}
}
public void AddBook(Book book)
{
Conexao conexao = new Conexao();
conexao.Conectar();
ExecutaSP executa = new ExecutaSP("BOOK_SP_INS_BOOK", conexao.VoltaConexaoAberta());
try
{
executa.addParam("@NAME", book.Name);
executa.addParam("@IDAUT", book.IdAuthor);
executa.addParam("@IDGEN", book.IdGenre);
executa.addParam("@INDICATION", book.Indication);
executa.addParam("@SAGA", book.Saga.ToString());
executa.addParam("@DATE", book.DateCreate);
executa.Executa();
executa.Confirma();
}
catch (Exception ex)
{
}
}