public bool campanhaUpdateCanalSms(CampanhaController sms) { try { if (new CampanhaDAO().campanhaUpdateCanalSms(sms)) { LogNegocios Log_N = new LogNegocios(); LogController Log_C = new LogController(); Log_C.TB012_Id = sms.TB012_id; Log_C.TB011_Id = sms.TB041_AlteradoPor; Log_C.TB000_IdTabela = 41; Log_C.TB000_Tabela = "Campanha"; Log_C.TB000_Data = DateTime.Now; Log_C.TB000_Descricao = string.Format(MensagensLog.L0082.ToString(), sms.TB041_id.ToString()); Log_N.LogInsert(Log_C); return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public bool campanhaUpdateCanalSms(CampanhaController sms) { { try { StringBuilder sSql = new StringBuilder(); sSql.Append(" UPDATE "); sSql.Append(" TB041_Campanhas "); sSql.Append(" SET "); sSql.Append(" TB041_Sms = "); sSql.Append(sms.TB041_Sms); sSql.Append(" , "); sSql.Append(" TB041_SmsAssunto = "); sSql.Append("'"); sSql.Append(sms.TB041_SmsAssunto.TrimEnd()); sSql.Append("'"); sSql.Append(" , "); sSql.Append(" TB041_SmsConteudo = "); sSql.Append("'"); sSql.Append(sms.TB041_SmsConteudo.TrimEnd()); sSql.Append("'"); sSql.Append(" , "); sSql.Append(" TB041_SmsAgendamento = "); sSql.Append("'"); sSql.Append(sms.TB041_SmsAgendamento.ToString("MM/dd/yyyy hh:mm")); sSql.Append("'"); sSql.Append(" , "); sSql.Append(" TB041_AlteradoEm = "); sSql.Append("'"); sSql.Append(DateTime.Now.ToString("MM/dd/yyyy hh:mm")); sSql.Append("'"); sSql.Append(" , "); sSql.Append(" TB041_AlteradoPor = "); sSql.Append(sms.TB041_AlteradoPor); sSql.Append(" where "); sSql.Append(" TB041_id = "); sSql.Append(sms.TB041_id); using (SqlConnection myConnection = new SqlConnection(ParametrosDAO.StringConexao)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(sSql.ToString(), myConnection); myCommand.CommandTimeout = 300; myCommand.ExecuteScalar(); myConnection.Close(); } } catch (Exception ex) { // ReSharper disable once PossibleIntendedRethrow throw ex; } return(true); } }
public CampanhaController campanha(long TB041_id) { CampanhaController retorno = new CampanhaController(); try { SqlConnection con = new SqlConnection(ParametrosDAO.StringConexao); StringBuilder sSql = new StringBuilder(); sSql.Append(" SELECT "); sSql.Append(" * "); sSql.Append(" FROM "); sSql.Append(" dbo.TB041_Campanhas "); sSql.Append(" where "); sSql.Append(" TB041_id = "); sSql.Append(TB041_id); SqlCommand command = new SqlCommand(sSql.ToString(), con); command.CommandTimeout = 300; con.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { var obj = new CampanhaController { TB041_id = Convert.ToInt64(reader["TB041_id"]), TB041_Campanha = Convert.ToString(reader["TB041_Campanha"]), TB041_Inicio = Convert.ToDateTime(reader["TB041_Inicio"]), TB041_Fim = Convert.ToDateTime(reader["TB041_Fim"]), TB041_AlteradoEm = Convert.ToDateTime(reader["TB041_AlteradoEm"]), TB012_id = Convert.ToInt64(reader["TB012_id"]), TB041_SmsAssunto = reader["TB041_SmsAssunto"] is DBNull ? "-" : Convert.ToString(reader["TB041_SmsAssunto"]), TB041_SmsConteudo = reader["TB041_SmsConteudo"] is DBNull ? "-" : Convert.ToString(reader["TB041_SmsConteudo"]), TB041_SmsAgendamento = reader["TB041_SmsAgendamento"] is DBNull?Convert.ToDateTime(reader["TB041_Fim"]) : Convert.ToDateTime(reader["TB041_SmsAgendamento"]), TB041_StatusS = Enum.GetName(typeof(CampanhaController.TB041_StatusE), Convert.ToInt16(reader["TB041_Status"])) }; retorno = obj; } con.Close(); } catch (Exception ex) { // ReSharper disable once PossibleIntendedRethrow throw ex; } return(retorno); }
private void mnuSmsSalvar_Click(object sender, EventArgs e) { try { if (lblCampanhaId.Text.Trim() == Empty) { /*Salvar Campanha*/ } if (txtSmsAssunto.Text.Trim() == Empty) { MessageBox.Show(MensagensDoSistema._0001.Replace("$Campo", "Assunto"), @"Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtSmsConteudo.Text.Trim() == Empty) { MessageBox.Show(MensagensDoSistema._0001.Replace("$Campo", "Conteudo"), @"Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtCampanhaContrato.Text.Trim() == Empty) { txtCampanhaContrato.Text = "0"; } CampanhaController sms = new CampanhaController(); sms.TB041_id = Convert.ToInt64(lblCampanhaId.Text); sms.TB041_Sms = 1; sms.TB041_SmsAssunto = txtSmsAssunto.Text; sms.TB041_SmsConteudo = txtSmsConteudo.Text; sms.TB041_SmsAgendamento = ddtSmsAgendamento.Value; sms.TB041_AlteradoPor = ParametrosInterface.objUsuarioLogado.TB011_Id; sms.TB012_id = Convert.ToInt64(txtCampanhaContrato.Text); if (new CampanhaNegocios().campanhaUpdateCanalSms(sms)) { MessageBox.Show(MensagensDoSistema._0018, @"Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, @"Erro ao executar operação", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <CampanhaController> campanhas(string filtro) { List <CampanhaController> retornoList = new List <CampanhaController>(); try { SqlConnection con = new SqlConnection(ParametrosDAO.StringConexao); StringBuilder sSql = new StringBuilder(); sSql.Append(" SELECT "); sSql.Append(" dbo.TB041_Campanhas.TB041_id "); sSql.Append(" , dbo.TB041_Campanhas.TB041_Campanha "); sSql.Append(" , dbo.TB041_Campanhas.TB041_Inicio "); sSql.Append(" , dbo.TB041_Campanhas.TB041_Fim "); sSql.Append(" , dbo.TB041_Campanhas.TB041_CadastradoEm "); sSql.Append(" , TBCadastradoPor.TB011_Id AS CadastradoPorId "); sSql.Append(" , TBCadastradoPor.TB011_NomeExibicao AS CadastradoPorNome "); sSql.Append(" , dbo.TB041_Campanhas.TB041_AlteradoEm "); sSql.Append(" , AlteradoPor.TB011_Id AS AlteradoPorId "); sSql.Append(" , AlteradoPor.TB011_NomeExibicao AS AlteradoPorNome "); sSql.Append(" , dbo.TB041_Campanhas.TB041_Status "); sSql.Append(" FROM "); sSql.Append(" dbo.TB041_Campanhas "); sSql.Append(" INNER JOIN "); sSql.Append(" dbo.TB011_APPUsuarios AS TBCadastradoPor "); sSql.Append(" ON "); sSql.Append(" dbo.TB041_Campanhas.TB041_CadastradoPor = TBCadastradoPor.TB011_Id "); sSql.Append(" INNER JOIN "); sSql.Append(" dbo.TB011_APPUsuarios AS AlteradoPor "); sSql.Append(" ON "); sSql.Append(" dbo.TB041_Campanhas.TB041_AlteradoPor = AlteradoPor.TB011_Id "); SqlCommand command = new SqlCommand(sSql.ToString(), con); command.CommandTimeout = 300; con.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { var obj = new CampanhaController { TB041_id = Convert.ToInt64(reader["TB041_id"]), TB041_Campanha = Convert.ToString(reader["TB041_Campanha"]), TB041_Inicio = Convert.ToDateTime(reader["TB041_Inicio"]), TB041_Fim = Convert.ToDateTime(reader["TB041_Fim"]), TB041_AlteradoEm = Convert.ToDateTime(reader["TB041_AlteradoEm"]), AlteradoPor = Convert.ToString(reader["AlteradoPorNome"]).TrimEnd(), TB041_StatusS = Enum.GetName(typeof(CampanhaController.TB041_StatusE), Convert.ToInt16(reader["TB041_Status"])) }; retornoList.Add(obj); } con.Close(); } catch (Exception ex) { // ReSharper disable once PossibleIntendedRethrow throw ex; } return(retornoList); }