public void getConfiguracao()
{
try
{
int cod = int.Parse(cboxSecretaria.SelectedValue);
configuraco conf = ctx.configuracoes.First(p => p.secretariaID == cod);
textSMTP.Text = conf.smtp;
textPorta.Text = conf.porta;
textEmail.Text = conf.email;
textSenha.Text = conf.senhaEmail;
textNomeRemetente.Text = conf.nomeRemetente;
textAssunto.Text = conf.assunto;
textBodyEmailAuto.Value = conf.bodyEmailAuto;
textBodyEmailResposta.Value = conf.bodyEmailResposta;
}
catch (Exception)
{
textSMTP.Text = "";
textPorta.Text = "";
textEmail.Text = "";
textSenha.Text = "";
textNomeRemetente.Text = "";
textAssunto.Text = "";
textBodyEmailAuto.Value = "";
textBodyEmailResposta.Value = "";
mensagem = "A Secretaria Selecionada ainda não tem Configurações Definidas";
ClientScript.RegisterStartupScript(GetType(), "Popup", "info();", true);
}
}
public void getConfiguracao()
{
try
{
int cod = int.Parse(cboxSecretaria.SelectedValue);
semaEntities ctx = new semaEntities();
configuraco conf = ctx.configuracoes.First(p => p.secretariaID == cod);
imgSel.ImageUrl = "dist/img/logos/" + conf.logo;
bckColorMenu.Value = conf.bckColorMenu;
onHoverbckColorMenu.Value = conf.onHoverbckColorMenu;
textColorMenu.Value = conf.textColorMenu;
onHovertextColorMenu.Value = conf.onHovertexColorMenu;
bckColorSbMenu.Value = conf.bckColorSbMenu;
onHoverbckColorSbMenu.Value = conf.onHoverbckColorSbMenu;
textColorSbMenu.Value = conf.textColorSbMenu;
onHovertextColorSbMenu.Value = conf.onHovertextColorSbMenu;
bckColorNavbar.Value = conf.bckColorNavbar;
}
catch (Exception)
{
imgSel.ImageUrl = "dist/img/logos/sem-logo.jpg";
lblCaminhoImg.Text = "sem-logo.jpg";
bckColorMenu.Value = "#f9fafc";
onHoverbckColorMenu.Value = "#f4f4f5";
textColorMenu.Value = "#444444";
onHovertextColorMenu.Value = "#000000";
bckColorSbMenu.Value = "#f4f4f5";
onHoverbckColorSbMenu.Value = "#2c3b41";
textColorSbMenu.Value = "#777777";
onHovertextColorSbMenu.Value = "#000000";
bckColorNavbar.Value = "#3c8dbc";
mensagem = "A Secretaria Selecionada ainda não tem Configurações Definidas";
ClientScript.RegisterStartupScript(GetType(), "Popup", "info();", true);
}
}
protected void btnSalvar_Click(object sender, EventArgs e)
{
if (cboxSecretaria.SelectedValue == "selecione")
{
mensagem = "Favor Selecione a Secretaria!";
ClientScript.RegisterStartupScript(GetType(), "Popup", "erro();", true);
cboxSecretaria.Focus();
}
else
{
int cod = int.Parse(cboxSecretaria.SelectedValue);
string conecLocal = "SERVER=10.0.2.9;UID=ura;PWD=ask123;Allow User Variables=True;Pooling=False";
MySqlConnection con = new MySqlConnection(conecLocal);
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from sema.configuracoes where secretariaID=" + cod, con);
MySqlDataAdapter da = new MySqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
int result = dt.Rows.Count;
if (result == 0)
{
semaEntities ctx = new semaEntities();
configuraco cfg = new configuraco();
cfg.secretariaID = int.Parse(cboxSecretaria.SelectedValue);
cfg.smtp = textSMTP.Text.Trim();
cfg.porta = textPorta.Text.Trim();
cfg.email = textEmail.Text.Trim();
cfg.senhaEmail = textSenha.Text.Trim();
cfg.nomeRemetente = textNomeRemetente.Text.Trim();
cfg.assunto = textAssunto.Text.Trim();
cfg.bodyEmailAuto = textBodyEmailAuto.Value.Trim();
cfg.bodyEmailResposta = textBodyEmailResposta.Value.Trim();
ctx.configuracoes.Add(cfg);
ctx.SaveChanges();
mensagem = "Adicionado com sucesso !";
ClientScript.RegisterStartupScript(GetType(), "Popup", "sucesso();", true);
}
if (result == 1)
{
semaEntities ctx = new semaEntities();
configuraco cfg = ctx.configuracoes.First(p => p.secretariaID == cod);
cfg.secretariaID = int.Parse(cboxSecretaria.SelectedValue);
cfg.smtp = textSMTP.Text.Trim();
cfg.porta = textPorta.Text.Trim();
cfg.email = textEmail.Text.Trim();
cfg.senhaEmail = textSenha.Text.Trim();
cfg.nomeRemetente = textNomeRemetente.Text.Trim();
cfg.assunto = textAssunto.Text.Trim();
cfg.bodyEmailAuto = textBodyEmailAuto.Value.Trim();
cfg.bodyEmailResposta = textBodyEmailResposta.Value.Trim();
ctx.SaveChanges();
mensagem = "Alterado com sucesso !";
ClientScript.RegisterStartupScript(GetType(), "Popup", "sucesso();", true);
}
}
}
public string getLogo()
{
StringBuilder sb = new StringBuilder();
int cod = int.Parse(Session["secretaria"].ToString());
semaEntities ctx = new semaEntities();
configuraco conf = ctx.configuracoes.First(p => p.secretariaID == cod);
sb.AppendLine("<img src='dist/img/logos/" + conf.logo + "' class='img-thumbnail' style='background-color: transparent'");
return(sb.ToString());
}
public string getConfiguracao()
{
StringBuilder sb = new StringBuilder();
int cod = int.Parse(Session["secretaria"].ToString());
semaEntities ctx = new semaEntities();
configuraco conf = ctx.configuracoes.First(p => p.secretariaID == cod);
sb.Append("<style>" +
/* cor da barra de navegação superior*/
".main-header .navbar," +
".main-header li.user-header," +
".main-header .logo {" +
"background-color: " + conf.bckColorNavbar + "!important;}" + // bckColorNavbar
/* cor de backgroud do menu lateral */
".main-sidebar{" +
"background-color: " + conf.bckColorMenu + "!important;}" + //bckColorMenu
/* Cor do texto do menu lateral */
".sidebar-menu > li > a {" +
"color: " + conf.textColorMenu + "!important;}" + //textColorMenu
/* cor do efeito ao passar o mouse sobre os itens do menu lateral */
".sidebar-menu > li:hover > a," +
".sidebar-menu > li.active > a," +
".sidebar-menu > li.menu - open > a {" +
"color: " + conf.onHovertexColorMenu + "!important; /* cor da fonte */" + // onHovertexColorMenu
"background: " + conf.onHoverbckColorMenu + "!important; /* cor do fundo */}" + //onHoverbckColorMenu
/* cor de background dos submenus laterais */
".sidebar-menu > li > .treeview-menu {" +
"background: " + conf.bckColorSbMenu + "!important;}" + //bckColorSbMenu
/* cor do texto dos submenus laterais*/
".sidebar-menu .treeview-menu > li > a {" +
"color: " + conf.textColorSbMenu + "!important;}" + //textColorSbMenu
/* cor do texto dos submenus ao passar o mouse */
".sidebar-menu .treeview-menu > li > a:hover {" +
"color: " + conf.onHovertextColorSbMenu + "!important;}" + //onHovertextColorSbMenu
"background: " + conf.onHoverbckColorSbMenu + "!important;" + // onHoverbckColorSbMenu
"</style>");
return(sb.ToString());
}
private void Email()
{
try
{
int sec = int.Parse(Session["secretaria"].ToString());
semaEntities ctx = new semaEntities();
configuraco cfg = ctx.configuracoes.First(p => p.secretariaID == sec);
string protocolo = resp_txtProtocolo.Text.Trim();
string nome = resp_nome.Text.Trim();
string telefone = resp_telefone.Text.Trim();
string email = resp_email.Text.Trim();
string cpf = resp_cpf.Text.Trim();
string assunto = resp_cboxAssunto.SelectedItem.ToString();
string topico = resp_cboxTopico.SelectedItem.ToString();
string status = resp_cboxStatus.SelectedItem.ToString();
string body = cfg.bodyEmailResposta.ToString();
if (body.Contains("[nome]"))
{
body = body.Replace("[nome]", resp_nome.Text);
}
if (body.Contains("[protocolo]"))
{
body = body.Replace("[protocolo]", resp_txtProtocolo.Text);
}
if (body.Contains("[telefone]"))
{
body = body.Replace("[telefone]", resp_telefone.Text);
}
if (body.Contains("[email]"))
{
body = body.Replace("[email]", resp_email.Text);
}
if (body.Contains("[cpf]"))
{
body = body.Replace("[cpf]", resp_cpf.Text);
}
if (body.Contains("[assunto]"))
{
body = body.Replace("[assunto]", resp_cboxAssunto.SelectedItem.ToString());
}
if (body.Contains("[topico]"))
{
body = body.Replace("[topico]", resp_cboxTopico.SelectedItem.ToString());
}
if (body.Contains("[status]"))
{
body = body.Replace("[status]", resp_cboxStatus.SelectedItem.ToString());
}
MailMessage mailMessage = new MailMessage();
mailMessage.From = new MailAddress(e_mail, cfg.nomeRemetente);
mailMessage.To.Add(e_mail.ToLower());
mailMessage.Subject = cfg.assunto;
mailMessage.IsBodyHtml = true;
mailMessage.Body = descricao.Text; // body;
mailMessage.Priority = MailPriority.High;
SmtpClient smtpClient = new SmtpClient(cfg.smtp, int.Parse(cfg.porta));
smtpClient.EnableSsl = true;
smtpClient.Credentials = new NetworkCredential(cfg.email, cfg.senhaEmail);
smtpClient.Send(mailMessage);
mensagem = "E-mail de Notificação foi enviado com sucesso";
ClientScript.RegisterStartupScript(GetType(), "Popup", "sucesso();", true);
}
catch (System.Exception ex)
{
mensagem = "Erro ao enviar e-mail: " + ex.Message;
ClientScript.RegisterStartupScript(GetType(), "Popup", "erro();", true);
}
}
protected void btnSalvar_Click(object sender, EventArgs e)
{
if (cboxSecretaria.SelectedValue == "selecione")
{
mensagem = "Favor Selecione a Secretaria!";
ClientScript.RegisterStartupScript(GetType(), "Popup", "erro();", true);
cboxSecretaria.Focus();
}
else
{
int cod = int.Parse(cboxSecretaria.SelectedValue);
string conecLocal = "SERVER=10.0.2.9;UID=ura;PWD=ask123;Allow User Variables=True;Pooling=False";
MySqlConnection con = new MySqlConnection(conecLocal);
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from sema.configuracoes where secretariaID=" + cod, con);
MySqlDataAdapter da = new MySqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
int result = dt.Rows.Count;
if (result == 0)
{
semaEntities ctx = new semaEntities();
configuraco cfg = new configuraco();
cfg.secretariaID = int.Parse(cboxSecretaria.SelectedValue);
cfg.logo = lblCaminhoImg.Text;
cfg.bckColorMenu = bckColorMenu.Value;
cfg.onHoverbckColorMenu = onHoverbckColorMenu.Value;
cfg.textColorMenu = textColorMenu.Value;
cfg.onHovertexColorMenu = onHoverbckColorMenu.Value;
cfg.bckColorSbMenu = bckColorSbMenu.Value;
cfg.onHoverbckColorSbMenu = onHoverbckColorSbMenu.Value;
cfg.textColorSbMenu = textColorSbMenu.Value;
cfg.onHovertextColorSbMenu = onHovertextColorSbMenu.Value;
cfg.bckColorNavbar = bckColorNavbar.Value;
ctx.configuracoes.Add(cfg);
ctx.SaveChanges();
mensagem = "Adicionado com sucesso !";
ClientScript.RegisterStartupScript(GetType(), "Popup", "sucesso();", true);
}
if (result == 1)
{
semaEntities ctx = new semaEntities();
configuraco cfg = ctx.configuracoes.First(p => p.secretariaID == cod);
cfg.secretariaID = int.Parse(cboxSecretaria.SelectedValue);
if (lblCaminhoImg.Text != "sem-logo.jpg")
{
cfg.logo = lblCaminhoImg.Text;
}
cfg.bckColorMenu = bckColorMenu.Value;
cfg.onHoverbckColorMenu = onHoverbckColorMenu.Value;
cfg.textColorMenu = textColorMenu.Value;
cfg.onHovertexColorMenu = onHoverbckColorMenu.Value;
cfg.bckColorSbMenu = bckColorSbMenu.Value;
cfg.onHoverbckColorSbMenu = onHoverbckColorSbMenu.Value;
cfg.textColorSbMenu = textColorSbMenu.Value;
cfg.onHovertextColorSbMenu = onHovertextColorSbMenu.Value;
cfg.bckColorNavbar = bckColorNavbar.Value;
ctx.SaveChanges();
mensagem = "Alterado com sucesso !";
ClientScript.RegisterStartupScript(GetType(), "Popup", "sucesso();", true);
}
}
}
