public CommandResponse RemoverCusta(long IdEstado) { try { using (_context.Connection) { _context.GetConnection(); _context.Connection.Execute(CustasQueries.DeleteCustas(IdEstado)); return(new CommandResponse(true, $"Custa Removida com sucesso")); } } catch (SQLiteException ex) { return(new CommandResponse(false, $"Erro : {ex.Message}")); } }
public CommandResponse EditarCusta(EstadosVsCustas custa) { try { using (_context.Connection) { _context.GetConnection(); _context.Connection.Execute(CustasQueries.UpdateCustas(custa)); return(new CommandResponse(true, $"Custa Atualizada com sucesso")); } } catch (SQLiteException ex) { return(new CommandResponse(true, $"Erro : {ex.Message}")); } }
public IEnumerable <CustasQueryResult> ObterTodosDetalhado() { try { using (_context.Connection) { _context.GetConnection(); return(_context .Connection .Query <CustasQueryResult>(CustasQueries.SelectCustasDetalhado(), new { })); } } catch (SQLiteException ex) { throw ex; } }
public CommandResponse AdicionarCusta(EstadosVsCustas custa) { try { using (_context.Connection) { _context.GetConnection(); var param = new DynamicParameters(); param.Add(name: "IdEstado", value: custa.IdEstado, direction: System.Data.ParameterDirection.Input); param.Add(name: "De", value: custa.De, direction: System.Data.ParameterDirection.Input); param.Add(name: "Ate", value: custa.Ate, direction: System.Data.ParameterDirection.Input); _context.Connection.Execute(CustasQueries.InsertCustas(), param); return(new CommandResponse(true, $"Custa adicionada com sucesso")); } } catch (SQLiteException ex) { return(new CommandResponse(false, $"Erro : {ex.Message}")); } }