public bool Salvar(AgendamentoInfo agendamentoInfo) { Acessor acessor = new Acessor(); bool sucesso = true; try { using (TransactionScope transacao = new TransactionScope()) { if (ValidaAgendamento(agendamentoInfo)) { if (agendamentoInfo.IsNew) { sucesso = acessor.AgendamentoDal.Inserir(agendamentoInfo); } else if (agendamentoInfo.IsDirty) { sucesso = acessor.AgendamentoDal.Editar(agendamentoInfo); } } transacao.Complete(); } return(sucesso); } catch (Exception exc) { throw new Exception(exc.Message, exc); } finally { acessor = null; } }
public CommandResponse AdicionarAgendamento(AgendamentoInfo obj) { try { _contexto.Connection.Open(); _contexto.BeginTransaction(); var query = AgendamentoInfoQueries.InsertAgendamentoInfo(); var param = new DynamicParameters(); param.Add(name: "IdProcesso", value: obj.IdProcesso.ToString(), direction: ParameterDirection.Input); if (obj.DataInicio != DateTime.MinValue) { param.Add(name: "DataInicio", value: obj.DataInicio, direction: ParameterDirection.Input); } else { param.Add(name: "DataInicio", value: null, direction: ParameterDirection.Input); } param.Add(name: "Descricao", value: obj.Descricao, direction: ParameterDirection.Input); param.Add(name: "NomeAgente", value: obj.NomeAgente, direction: ParameterDirection.Input); param.Add(name: "Periodicidade", value: obj.Periodicidade.ToString(), direction: ParameterDirection.Input); param.Add(name: "FrequenciaPeriodicidade", value: obj.FrequenciaPeriodicidade, direction: ParameterDirection.Input); param.Add(name: "StatusAgendamento", value: obj.StatusAgendamento.ToString(), direction: ParameterDirection.Input); param.Add(name: "HoraInicio", value: obj.HoraInicio.ToString(), direction: ParameterDirection.Input); param.Add(name: "MinutoInicio", value: obj.MinutoInicio.ToString(), direction: ParameterDirection.Input); param.Add(name: "AmPm", value: obj.AmPm, direction: ParameterDirection.Input); param.Add(name: "Ativo", value: obj.Ativo, direction: ParameterDirection.Input); param.Add(name: "DisparoManual", value: obj.DisparoManual, direction: ParameterDirection.Input); param.Add(name: "Path_UltimaExecucao", value: obj.MinutoInicio.ToString(), direction: ParameterDirection.Input); _contexto.Connection.Execute(query, param, _contexto.Transaction); query = EmailInfoQueries.InsertEmailInfoPorId(); param = new DynamicParameters(); param.Add(name: "IdProcesso", value: obj.IdProcesso.ToString(), direction: ParameterDirection.Input); param.Add(name: "Assunto", value: obj.Email.Assunto, direction: ParameterDirection.Input); param.Add(name: "Remetente", value: obj.Email.Remetente, direction: ParameterDirection.Input); param.Add(name: "Destinatario", value: obj.Email.Destinatario, direction: ParameterDirection.Input); param.Add(name: "Destinatario_CC", value: obj.Email.Destinatario_CC, direction: ParameterDirection.Input); param.Add(name: "Destinatario_CO", value: obj.Email.Destinatario_CO, direction: ParameterDirection.Input); _contexto.Connection.Execute(query, param, _contexto.Transaction); _contexto.Transaction.Commit(); _contexto.Dispose(); return(new CommandResponse(true, $"{obj.Descricao} adicionada com sucesso")); } catch (SQLiteException ex) { _contexto.Transaction.Rollback(); _contexto.Dispose(); return(new CommandResponse(false, $"{ex.Message}")); } }
public CommandResponse AtualizarStatusAgendamento(AgendamentoInfo obj) { try { _contexto.Connection.Open(); _contexto.Connection.Execute(AgendamentoInfoQueries.UpdateStatusExecucao(obj)); _contexto.Dispose(); return(new CommandResponse(true, $"{obj.Descricao} atualizado com sucesso")); } catch (SQLiteException ex) { _contexto.Dispose(); return(new CommandResponse(false, $"Erro : {ex.Message}")); } }
private bool ValidaAgendamento(AgendamentoInfo agendamentoInfo) { bool sucesso = true; try { if (agendamentoInfo == null) { throw new Exception("Objeto AgendamentoInfo é nulo"); } } catch { sucesso = false; } return(sucesso); }
public AgendamentoInfo ListarPorCodigo(int age_codigo) { Acessor acessor = new Acessor(); AgendamentoInfo agendamentoInfo = new AgendamentoInfo(); try { return(agendamentoInfo = acessor.AgendamentoDal.ListarPorCodigo(age_codigo)); } catch (Exception exc) { throw new Exception(exc.Message, exc); } finally { acessor = null; } }
public bool Inserir(AgendamentoInfo agendamentoInfo) { List <SqlParameter> lParam = new List <SqlParameter>(); bool sucesso = false; StoredProcedure sp = null; SqlDataReader dr = null; try { lParam.Add(new SqlParameter(paramAGE_TAG_Codigo, agendamentoInfo.AGE_TAG_Codigo)); lParam.Add(new SqlParameter(paramAGE_DataHoraInicio, agendamentoInfo.AGE_DataHoraInicio)); lParam.Add(new SqlParameter(paramAGE_DataHoraFim, agendamentoInfo.AGE_DataHoraFim)); lParam.Add(new SqlParameter(paramAGE_PRT_Codigo, agendamentoInfo.AGE_PRT_Codigo)); using (sp = new StoredProcedure(spInserir, lParam, ConexoesBanco.PlusCondominios)) { dr = sp.GetDataReader(); if (dr.Read()) { agendamentoInfo.AGE_Codigo = int.Parse(dr["AGE_Codigo"].ToString()); sucesso = true; } else { sucesso = false; } } } catch (Exception exc) { sucesso = false; throw new Exception(exc.Message, exc); } finally { lParam = null; dr.Close(); } return(sucesso); }
public CommandResponse AtualizarAgendamentoInfoPorID(AgendamentoInfo obj) { try { _contexto.Connection.Open(); _contexto.BeginTransaction(); _contexto.Connection.Execute(AgendamentoInfoQueries.UpdateAgendamentoInfo(obj), _contexto.Transaction); _contexto.Connection.Execute(EmailInfoQueries.UpdateEmailInfoPorId(obj.Email), _contexto.Transaction); _contexto.Transaction.Commit(); _contexto.Dispose(); return(new CommandResponse(true, $"{obj.Descricao} atualizado com sucesso")); } catch (SQLiteException ex) { _contexto.Transaction.Rollback(); _contexto.Dispose(); return(new CommandResponse(false, $"Erro : {ex.Message}")); } }
public static string UpdateStatusExecucao(AgendamentoInfo ag) { return($"UPDATE AgendamentoInfo SET DataProximaExecucao = '{ag.DataProximaExecucao}',DataUltimaExecucao = '{ag.DataUltimaExecucao}', StatusAgendamento = '{ag.StatusAgendamento}' Where IdProcesso = '{ag.IdProcesso}'"); }
public static string UpdateAgendamentoInfo(AgendamentoInfo ag) { return($"UPDATE AgendamentoInfo SET DataInicio = '{ag.DataInicio}', DataProximaExecucao = '{ag.DataProximaExecucao}',DataUltimaExecucao = '{ag.DataUltimaExecucao}', Descricao = '{ag.Descricao}', NomeAgente = '{ag.NomeAgente}', Periodicidade = '{ag.Periodicidade}',FrequenciaPeriodicidade = {ag.FrequenciaPeriodicidade.Value}, StatusAgendamento = '{ag.StatusAgendamento}', HoraInicio = '{ag.HoraInicio}', MinutoInicio = '{ag.MinutoInicio}', Ativo = {ag.Ativo}, AmPm = '{ag.AmPm}', DisparoManual = {ag.DisparoManual} Where IdProcesso = '{ag.IdProcesso}'"); }