public CommandResponse AdicionarExecucao(AgendamentoExecucao obj)
{
try
{
using (_contexto.Connection)
{
_contexto.GetConnection();
var param = new DynamicParameters();
param.Add(name: "IdExecucao", value: obj.IdExecucao, direction: System.Data.ParameterDirection.Input);
param.Add(name: "IdProcesso", value: obj.IdProcesso, direction: System.Data.ParameterDirection.Input);
param.Add(name: "MensagemStatus", value: obj.MensagemStatus, direction: System.Data.ParameterDirection.Input);
param.Add(name: "Inicio", value: obj.Inicio, direction: System.Data.ParameterDirection.Input);
param.Add(name: "Fim", value: obj.Fim, direction: System.Data.ParameterDirection.Input);
param.Add(name: "Status", value: obj.Status, direction: System.Data.ParameterDirection.Input);
_contexto.Connection.Execute(AgentamentoExecucoesQueries.InsertExecucao(), param);
return(new CommandResponse(true, $"Execucao adicionada com sucesso"));
}
}
catch (SQLiteException ex)
{
return(new CommandResponse(false, $"Erro : {ex.Message}"));
}
}
public AgendamentoInfo ObterAgendamento(string Id)
{
try
{
using (_contexto.Connection)
{
_contexto.GetConnection();
var agendamento = _contexto
.Connection
.Query <AgendamentoInfo>(AgendamentoInfoQueries.SelectAgendamentoInfoPorId(Id.ToString()), new { Id = Id }).FirstOrDefault();
agendamento.AtualizaEmail(_contexto
.Connection
.Query <EmailInfo>(EmailInfoQueries.SelectEmailInfoPorId(Id.ToString()), new { Id = Id }).FirstOrDefault());
return(agendamento);
}
}
catch (SQLiteException ex)
{
throw ex;
}
}
public CommandResponse AdicionarRegra(RegrasForunsBrasil regra)
{
try
{
using (_context.Connection)
{
_context.GetConnection();
var param = new DynamicParameters();
param.Add(name: "IdEstado", value: regra.IdEstado, direction: System.Data.ParameterDirection.Input);
param.Add(name: "IdComarca", value: regra.IdComarca, direction: System.Data.ParameterDirection.Input);
if (regra.IdCidade == 0)
{
param.Add(name: "IdCidade", value: null, direction: System.Data.ParameterDirection.Input);
}
else
{
param.Add(name: "IdCidade", value: regra.IdCidade, direction: System.Data.ParameterDirection.Input);
}
param.Add(name: "Regra", value: regra.Regra, direction: System.Data.ParameterDirection.Input);
param.Add(name: "Status", value: regra.Status, direction: System.Data.ParameterDirection.Input);
var t = _context.Connection.Execute(RegrasForunsQueries.InsertRegra(), param);
return(new CommandResponse(true, $"{regra.Regra} adicionada com sucesso"));
}
}
catch (SQLiteException ex)
{
return(new CommandResponse(false, $"Erro : {ex.Message}"));
}
}
public UsuarioAplicacao ObterUsuario(UsuarioAplicacao usr)
{
string query = string.Format("Select * from Usuario where NomeUsuario = '{0}' and SenhaUsuario = '{1}'", usr.NomeUsuario, usr.SenhaUsuario);
try
{
using (_context.Connection)
{
_context.GetConnection();
return(_context
.Connection
.Query <UsuarioAplicacao>(query, new { }).FirstOrDefault());
};
}
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}"));
}
}
public IEnumerable <T> ObterTodos <T>(string nomeTabela) where T : EntidadeBase <T>
{
try
{
var query = RegrasForunsQueries.SelectGeneric(nomeTabela);
using (_context.Connection)
{
_context.GetConnection();
return(_context
.Connection
.Query <T>(query, new { }));
}
}
catch (SQLiteException ex)
{
throw ex;
}
}