public static List <EventoTemplate> GetAll()
{
List <EventoTemplate> eventos = new List <EventoTemplate>();
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "Select id_evento, nome, logo, data_evento, descricao, cidade, UF from tbl_evento where oculto = 0 and publico = 1";
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
EventoTemplate evento = new EventoTemplate();
evento.idEvento = dr.GetInt32(0);
evento.Nome = dr.GetString(1);
evento.Logo = dr.GetString(2);
evento.Data_evento = Convert.ToString(dr.GetDateTime(3));
evento.Descricao = dr.GetString(4);
evento.Cidade = dr.GetString(5);
evento.UF = dr.GetString(6);
//adiciona evento
eventos.Add(evento);
}
}
return(eventos);
}
public static int TrocarSenha(int idUsuario, string senhaAtual, string SenhaNova)
{
try
{
string cryptoSenhaAtual = CoolEventsEncrypter.Encrypt(senhaAtual);
string cryptoSenhaNova = CoolEventsEncrypter.Encrypt(SenhaNova);
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.CommandText = "SELECT COUNT(*) FROM TBL_USUARIO WHERE SENHA = @_SENHA AND ID_USUARIO = @IDUSUARIO";
conexao.command.Parameters.Add("@_SENHA", SqlDbType.VarChar).Value = cryptoSenhaAtual;
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = idUsuario;
if ((int)conexao.command.ExecuteScalar() == 0)
{
return(0);
}
conexao.command.Parameters.Clear();
conexao.command.CommandText = "UPDATE TBL_USUARIO SET SENHA = @_NOVASENHA WHERE ID_USUARIO = @IDUSUARIO";
conexao.command.Parameters.Add("@_NOVASENHA", SqlDbType.VarChar).Value = cryptoSenhaNova;
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = idUsuario;
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
return(1);
}
catch (Exception)
{
return(2);
}
}
public bool DoIt()
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "SELECT id_usuario,nome FROM tbl_usuario WHERE EMAIL = @EMAIL AND SENHA = @SENHA";
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = Email;
conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = CoolEventsEncrypter.Encrypt(Senha);
System.Data.SqlClient.SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
HttpContext.Current.Session["idUsuario"] = dr.GetInt32(0);
HttpContext.Current.Session["nomeUsuario"] = dr.GetString(1);
conexao.connection.Close();
return(true);
}
conexao.connection.Close();
return(false);
}
public static List <EventoTemplate> GetEventsImIn()
{
List <EventoTemplate> eventos = new List <EventoTemplate>();
BDConexao conexao = new BDConexao();
conexao.command.CommandText = @"Select id_evento, nome, logo, data_evento, descricao, cidade, UF
from tbl_evento WHERE id_evento in (SELECT ID_EVENTO FROM TBL_CONVIDADO WHERE ID_USUARIO = @IDUSUARIO AND CONFIRMADO = 1)";
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = HttpContext.Current.Session["idUsuario"];
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
EventoTemplate evento = new EventoTemplate();
evento.idEvento = dr.GetInt32(0);
evento.Nome = dr.GetString(1);
evento.Logo = dr.GetString(2);
evento.Data_evento = Convert.ToString(dr.GetDateTime(3));
evento.Descricao = dr.GetString(4);
evento.Cidade = dr.GetString(5);
evento.UF = dr.GetString(6);
//adiciona evento
eventos.Add(evento);
}
}
return(eventos);
}
public static List <Tipo> GetTipos()
{
List <Tipo> lista_de_tipos = new List <Tipo>();
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.CommandText = "SELECT ID_TIPO,TIPO FROM TBL_TIPOEVENTO";
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Tipo tipo = new Tipo();
tipo.Id = dr.GetInt32(0);
tipo.Nome = dr.GetString(1);
lista_de_tipos.Add(tipo);
}
}
conexao.connection.Close();
return(lista_de_tipos);
}
public void Cadastrar()
{
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "INSERT INTO TBL_TAREFA(TAREFA, ID_EVENTO) VALUES (@TAREFA, @ID_EVENTO)";
conexao.command.Parameters.Add("@TAREFA", SqlDbType.VarChar).Value = Tarefa;
conexao.command.Parameters.Add("@ID_EVENTO", SqlDbType.Int).Value = Id_evento;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
public void RedefinirSenhaPorkey(string key, string novaSenha)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "UPDATE CLIENTE SET senha = @SENHA WHERE codSenha = @CODSENHA";
conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = CoolEventsEncrypter.Encrypt(novaSenha);
conexao.command.Parameters.Add("@CODSENHA", SqlDbType.VarChar).Value = key;
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
public void SetRestoreKeyOnUser(string email, string key)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "UPDATE CLIENTE SET codSenha = @CODSENHA WHERE EMAIL = @EMAIL";
conexao.command.Parameters.Add("@CODSENHA", SqlDbType.VarChar).Value = key;
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
public void AlterarSenha(string novaSenha)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "UPDATE CLIENTE SET SENHA = @NOVASENHA WHERE IDCLIENTE = @IDCLIENTE";
conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"];
conexao.command.Parameters.Add("@NOVASENHA", SqlDbType.VarChar).Value = CoolEventsEncrypter.Encrypt(novaSenha);
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
public bool UpdateUser(Usuario usuario, int idUsuario)
{
try {
BDConexao conexao = new BDConexao();
string command = "exec updateUsuario " +
"@IDUSUARIO = @_ID, " +
"@NOME = @_NOME, " +
"@SOBRENOME = @_SOBRENOME, " +
"@EMAIL = @_EMAIL, " +
"@NASC = @_NASC, " +
"@GENERO = @_SEXO, " +
"@APELIDO = @_APELIDO, " +
"@CIVIL = @_CIVIL, " +
"@UF = @_UF, " +
"@CIDADE = @_CIDADE, " +
"@CEP = @_CEP, " +
"@BAIRRO = @_BAIRRO, " +
"@LOGRADOURO = @_LOGRADOURO," +
"@NUMERO = @_NUMERO, " +
"@COMPLEMENTO = @_COMPLEMENTO," +
"@DESCRICAO = @_DESCRICAO";
conexao.command.CommandText = command;
conexao.command.Parameters.Add("@_ID", SqlDbType.Int).Value = idUsuario;
conexao.command.Parameters.Add("@_NOME", SqlDbType.VarChar).Value = usuario.Nome;
conexao.command.Parameters.Add("@_SOBRENOME", SqlDbType.VarChar).Value = usuario.Sobrenome;
conexao.command.Parameters.Add("@_EMAIL", SqlDbType.VarChar).Value = usuario.Email;
conexao.command.Parameters.Add("@_NASC", SqlDbType.Date).Value = usuario.DataNascimento;
conexao.command.Parameters.Add("@_SEXO", SqlDbType.Char).Value = usuario.Sexo;
conexao.command.Parameters.Add("@_APELIDO", SqlDbType.VarChar).Value = usuario.Apelido;
conexao.command.Parameters.Add("@_CIVIL", SqlDbType.VarChar).Value = usuario.Civil;
conexao.command.Parameters.Add("@_UF", SqlDbType.Char).Value = usuario.UF;
conexao.command.Parameters.Add("@_CIDADE", SqlDbType.VarChar).Value = usuario.Cidade;
conexao.command.Parameters.Add("@_CEP", SqlDbType.VarChar).Value = usuario.CEP;
conexao.command.Parameters.Add("@_BAIRRO", SqlDbType.VarChar).Value = usuario.Bairro;
conexao.command.Parameters.Add("@_LOGRADOURO", SqlDbType.VarChar).Value = usuario.Logradouro;
conexao.command.Parameters.Add("@_NUMERO", SqlDbType.Int).Value = usuario.Numero;
conexao.command.Parameters.Add("@_COMPLEMENTO", SqlDbType.VarChar).Value = usuario.Complemento;
conexao.command.Parameters.Add("@_DESCRICAO", SqlDbType.VarChar).Value = usuario.Descricao;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
return(true);
}
catch (Exception Ex) {
return(false);
}
}
public static void Cadastrar(string email, int idEvento)
{
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "INSERT INTO tbl_convidado(id_usuario, id_evento, CONFIRMADO) VALUES ((SELECT ID_USUARIO FROM TBL_USUARIO WHERE EMAIL = @EMAIL), @ID_EVENTO, 0)";
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
conexao.command.Parameters.Add("@ID_EVENTO", SqlDbType.Int).Value = idEvento;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
public Usuario GetUser(int id)
{
Usuario user = new Usuario();
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "SELECT * from tbl_USUARIO WHERE ID_USUARIO = @IDUSUARIO";
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = id;
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
user.Id = dr.GetInt32(0).ToString();
user.Nome = dr.GetString(1);
user.Sobrenome = dr.GetString(2);
user.Email = dr.GetString(3);
//user.Senha = dr.GetString(4);
user.DataNascimento = Convert.ToString(dr.GetDateTime(5));
user.Sexo = dr.GetString(6);
user.Foto = dr.GetString(7);
user.Apelido = dr.GetString(8);
user.Civil = dr.GetString(9);
user.UF = dr.GetString(10);
user.Cidade = dr.GetString(11);
user.CEP = dr.GetString(12);
user.Bairro = dr.GetString(13);
user.Logradouro = dr.GetString(14);
user.Numero = dr.GetString(15);
user.Complemento = dr.GetString(16);
user.Descricao = dr.GetString(17);
user.Pontuacao = dr.GetInt32(18);
conexao.connection.Close();
return(user);
}
else
{
conexao.connection.Close();
return(null);
}
}
public static EventoView GetEventoById(int idEvento)
{
EventoView evento = new EventoView();
BDConexao conexao = new BDConexao();
conexao.command.CommandText = @"SELECT
NOME, DATA_EVENTO, INICIO, FIM, MAX_PESSOAS,
(SELECT COUNT(*) FROM tbl_convidado WHERE ID_EVENTO = @IDEVENTO) AS [PESSOAS CONFIRMADAS],
DESCRICAO, LOGO, BACKGROUND, UF, CIDADE, CEP, BAIRRO, LOGRADOURO, NUMERO,
COMPLEMENTO, (SELECT TIPO FROM tbl_tipoevento WHERE ID_TIPO = (SELECT ID_TIPO FROM TBL_EVENTO WHERE ID_EVENTO = @IDEVENTO)) AS [TIPO EVENTO]
FROM tbl_evento where id_evento = @IDEVENTO";
conexao.command.Parameters.Add("@IDEVENTO", SqlDbType.VarChar).Value = idEvento;
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
evento.Id = idEvento;
evento.Nome = dr.GetString(0);
evento.DataEvento = dr.GetDateTime(1).ToString();
evento.Inicio = dr.GetTimeSpan(2).ToString();
evento.Fim = dr.GetTimeSpan(2).ToString();
evento.MaxPessoas = dr.GetInt32(4);
evento.PessoasConfirmadas = dr.GetInt32(5);
evento.Descricao = dr.GetString(6);
evento.Logo = dr.GetString(7);
evento.Background = dr.GetString(8);
evento.UF = dr.GetString(9);
evento.Cidade = dr.GetString(10);
evento.CEP = dr.GetString(11);
evento.Bairro = dr.GetString(12);
evento.Logradouro = dr.GetString(13);
evento.Numero = Convert.ToInt32(dr.GetString(14));
evento.Complemento = dr.GetString(15);
evento.TipoEvento = dr.GetString(16);
}
}
conexao.connection.Close();
return(evento);
}
public void Cadastrar()
{
string urlLogo = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(Logo.FileName);
string urlBackground = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(Background.FileName);
var path = (@"C:\ImageProvider\public\eventoLogo\" + urlLogo);
Logo.SaveAs(path);
path = (@"C:\ImageProvider\public\eventoBackground\" + urlBackground);
Background.SaveAs(path);
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "INSERT INTO TBL_EVENTO OUTPUT INSERTED.ID_EVENTO values (@NOME, @DATA_EVENTO, @DATA_CRIACAO, @INICIO, @FIM, @PUBLICO, @OCULTO, @MAX_PESSOAS, @DESCRICAO, @LOGO, @BACKGROUND, " +
"@UF, @CIDADE, @CEP, @BAIRRO, @LOGRADOURO, @NUMERO, @COMPLEMENTO, @ID_TIPO, @ID_USUARIO)";
conexao.command.Parameters.Add("@NOME", SqlDbType.VarChar).Value = Nome;
conexao.command.Parameters.Add("@DATA_EVENTO", SqlDbType.DateTime).Value = DataEvento;
conexao.command.Parameters.Add("@DATA_CRIACAO", SqlDbType.DateTime).Value = DateTime.Now;
conexao.command.Parameters.Add("@INICIO", SqlDbType.Time).Value = Inicio;
conexao.command.Parameters.Add("@FIM", SqlDbType.Time).Value = Fim;
conexao.command.Parameters.Add("@PUBLICO", SqlDbType.Bit).Value = Publico;
conexao.command.Parameters.Add("@OCULTO", SqlDbType.Bit).Value = false;
conexao.command.Parameters.Add("@MAX_PESSOAS", SqlDbType.Int).Value = MaxPessoas;
conexao.command.Parameters.Add("@DESCRICAO", SqlDbType.NVarChar).Value = Descricao;
conexao.command.Parameters.Add("@LOGO", SqlDbType.NVarChar).Value = urlLogo;
conexao.command.Parameters.Add("@BACKGROUND", SqlDbType.VarChar).Value = urlBackground;
conexao.command.Parameters.Add("@UF", SqlDbType.Char).Value = UF;
conexao.command.Parameters.Add("@CIDADE", SqlDbType.VarChar).Value = Cidade;
conexao.command.Parameters.Add("@CEP", SqlDbType.VarChar).Value = CEP;
conexao.command.Parameters.Add("@BAIRRO", SqlDbType.NVarChar).Value = Bairro;
conexao.command.Parameters.Add("@LOGRADOURO", SqlDbType.NVarChar).Value = Logradouro;
conexao.command.Parameters.Add("@NUMERO", SqlDbType.Int).Value = Numero;
conexao.command.Parameters.Add("@COMPLEMENTO", SqlDbType.VarChar).Value = Complemento;
conexao.command.Parameters.Add("@ID_TIPO", SqlDbType.Int).Value = TipoEvento;
conexao.command.Parameters.Add("@ID_USUARIO", SqlDbType.Int).Value = HttpContext.Current.Session["idUsuario"];
conexao.connection.Open();
int idUsuario = (int)conexao.command.ExecuteScalar();
conexao.connection.Close();
Id = idUsuario;
}
public void CarCookietoUser(string cookie)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.CommandText = "DELETE FROM CARCLIENTE WHERE IDCLIENTE = @IDCLIENTE";
conexao.command.Parameters.Clear();
conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"];
conexao.command.ExecuteNonQuery();
conexao.command.CommandText = "INSERT INTO CARCLIENTE (idProduto, quantidade, idCliente, idTamanho) " +
"SELECT idProduto, quantidade,@IDCLIENTE,idTamanho FROM Detalhe_CarPublico WHERE IDCARPUBLICO = (SELECT IDCARPUBLICO FROM CARPUBLICO WHERE COOKIEVALUE = @COOKIE)";
conexao.command.Parameters.Clear();
conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"];
conexao.command.Parameters.Add("@COOKIE", SqlDbType.VarChar).Value = cookie;
conexao.command.ExecuteNonQuery();
}
public static bool SaveUserImageById(int idUsuario, string fileName)
{
try
{
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "UPDATE TBL_USUARIO SET foto = @FILENAME WHERE ID_USUARIO = @IDUSUARIO";
conexao.command.Parameters.Add("@FILENAME", SqlDbType.VarChar).Value = fileName;
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = idUsuario;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public Enquete GetEnqueteById(int id)
{
Enquete enquete = new Enquete();
BDConexao conexao = new BDConexao();
conexao.command.CommandText = @"SELECT * FROM TBL_ENQUETE WHERE ID_ENQUETE = @IDENQUETE";
conexao.command.Parameters.Add("@IDENQUETE", SqlDbType.Int).Value = id;
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
this.Id = dr.GetInt32(0);
this.Imagem = dr.GetString(2);
this.Titulo = dr.GetString(3);
this.Texto = dr.GetString(4);
this.Prazo = dr.GetDateTime(5).ToString().Substring(0, 10);
this.Valor = dr.GetInt32(7);
this.QUESTAO_A = dr.GetString(8);
this.ALTERNATIVA_AA = dr.GetString(9);
this.ALTERNATIVA_AB = dr.GetString(10);
this.ALTERNATIVA_AC = dr.GetString(11);
this.ALTERNATIVA_AD = dr.GetString(12);
this.QUESTAO_B = dr.GetString(13);
this.ALTERNATIVA_BA = dr.GetString(14);
this.ALTERNATIVA_BB = dr.GetString(15);
this.ALTERNATIVA_BC = dr.GetString(16);
this.ALTERNATIVA_BD = dr.GetString(17);
}
}
conexao.connection.Close();
return(enquete);
}
public void Submit()
{
BDConexao conexao = new BDConexao();
conexao.command.CommandText = @"INSERT INTO TBL_RESULTADO VALUES (@IDENQUETE, @IDUSUARIO, @REALIZADO, @QUESTAOA, @QUESTAOB, @PONTUACAO)";
conexao.command.Parameters.Add("@IDENQUETE", SqlDbType.Int).Value = Id_Enquete;
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.Int).Value = HttpContext.Current.Session["idUsuario"];
conexao.command.Parameters.Add("@REALIZADO", SqlDbType.DateTime).Value = DateTime.Today;
conexao.command.Parameters.Add("@QUESTAOA", SqlDbType.Char).Value = QUESTAO_A;
conexao.command.Parameters.Add("@QUESTAOB", SqlDbType.Char).Value = QUESTAO_B;
conexao.command.Parameters.Add("@PONTUACAO", SqlDbType.Int).Value = Pontuacao;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.command.CommandText = @"update tbl_usuario set PONTUACAO = (select sum(pontuacao) from tbl_resultado) WHERE ID_USUARIO = @IDUSUARIO";
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
}
//public bool Check() {
//}
public bool Cadastrar()
{
try {
this.Pontuacao = 0;
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "INSERT INTO tbl_USUARIO values (@NOME, @SOBRENOME, @EMAIL, @SENHA, @NASC, @GENERO, @FOTO, @APELIDO, @CIVIL, @UF, " +
"@CIDADE, @CEP, @BAIRRO, @LOGRADOURO, @NUMERO, @COMPLEMENTO, @DESCRICAO, @PONTUACAO)";
conexao.command.Parameters.Add("@NOME", SqlDbType.NVarChar).Value = Nome;
conexao.command.Parameters.Add("@SOBRENOME", SqlDbType.NVarChar).Value = Sobrenome;
conexao.command.Parameters.Add("@EMAIL", SqlDbType.NVarChar).Value = Email;
conexao.command.Parameters.Add("@SENHA", SqlDbType.NVarChar).Value = CoolEventsEncrypter.Encrypt(Senha);
conexao.command.Parameters.Add("@NASC", SqlDbType.Date).Value = DataNascimento;
conexao.command.Parameters.Add("@GENERO", SqlDbType.Char).Value = Sexo;
conexao.command.Parameters.Add("@FOTO", SqlDbType.NVarChar).Value = "";
conexao.command.Parameters.Add("@APELIDO", SqlDbType.NVarChar).Value = Apelido;
conexao.command.Parameters.Add("@CIVIL", SqlDbType.NVarChar).Value = Civil;
conexao.command.Parameters.Add("@UF", SqlDbType.NVarChar).Value = UF;
conexao.command.Parameters.Add("@CIDADE", SqlDbType.NVarChar).Value = Cidade;
conexao.command.Parameters.Add("@CEP", SqlDbType.NVarChar).Value = CEP;
conexao.command.Parameters.Add("@BAIRRO", SqlDbType.NVarChar).Value = Bairro;
conexao.command.Parameters.Add("@LOGRADOURO", SqlDbType.NVarChar).Value = Logradouro;
conexao.command.Parameters.Add("@NUMERO", SqlDbType.VarChar).Value = Numero;
conexao.command.Parameters.Add("@COMPLEMENTO", SqlDbType.NVarChar).Value = Complemento;
conexao.command.Parameters.Add("@DESCRICAO", SqlDbType.NVarChar).Value = Descricao;
conexao.command.Parameters.Add("@PONTUACAO", SqlDbType.Int).Value = Pontuacao;
conexao.connection.Open();
conexao.command.ExecuteNonQuery();
conexao.connection.Close();
return(true);
}
catch (Exception Ex)
{
return(false);
}
}
public string verificaEmail(string email)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "SELECT NOME FROM CLIENTE WHERE email = @EMAIL";
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
var nome = conexao.command.ExecuteScalar();
conexao.connection.Close();
if (nome == null)
{
return("");
}
else
{
return((string)nome);
}
}
public bool VerificarCodigo(string key)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "SELECT COUNT(*) FROM CLIENTE WHERE CODSENHA = @CODSENHA";
conexao.command.Parameters.Add("@CODSENHA", SqlDbType.VarChar).Value = key;
int cont = (int)conexao.command.ExecuteScalar();
conexao.connection.Close();
if (cont == 0)
{
return(false);
}
else
{
return(true);
}
}
public static bool Verificar(string email)
{
BDConexao conexao = new BDConexao();
conexao.command.CommandText = "SELECT COUNT(*) FROM TBL_USUARIO WHERE EMAIL = @EMAIL";
conexao.command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = email;
conexao.connection.Open();
int possui = (int)conexao.command.ExecuteScalar();
conexao.connection.Close();
if (possui == 0)
{
return(false);
}
else
{
return(true);
}
}
public bool verificaSenha(string senha)
{
BDConexao conexao = new BDConexao();
conexao.connection.Open();
conexao.command.Parameters.Clear();
conexao.command.CommandText = "SELECT COUNT(*) FROM CLIENTE WHERE IDCLIENTE = @IDCLIENTE AND SENHA = @SENHA";
conexao.command.Parameters.Add("@IDCLIENTE", SqlDbType.Int).Value = (int)HttpContext.Current.Session["idUsuario"];;
conexao.command.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = CoolEventsEncrypter.Encrypt(senha);
int ok = (int)conexao.command.ExecuteScalar();
conexao.connection.Close();
if (ok == 0)
{
return(false);
}
else
{
return(true);
}
}
public static List <Enquetes> GetAll()
{
List <Enquetes> enquetes = new List <Enquetes>();
BDConexao conexao = new BDConexao( );
conexao.command.CommandText = @"
select ID_ENQUETE, tbl_tipoevento.TIPO, IMAGEM, TITULO, TEXTO, PRAZO FROM tbl_enquete LEFT JOIN tbl_tipoevento ON tbl_enquete.ID_TIPO = tbl_tipoevento.ID_TIPO
where ID_ENQUETE not in (select id_enquete from tbl_resultado where id_usuario = @IDUSUARIO) AND OCULTO = 0";
conexao.command.Parameters.Add("@IDUSUARIO", SqlDbType.VarChar).Value = HttpContext.Current.Session["idUsuario"];
conexao.connection.Open();
SqlDataReader dr = conexao.command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Enquetes enquete = new Enquetes();
enquete.Id = dr.GetInt32(0);
enquete.TipoEnquete = dr.GetString(1);
enquete.Imagem = dr.GetString(2);
enquete.Titulo = dr.GetString(3);
enquete.Texto = dr.GetString(4);
enquete.PrazoResposta = dr.GetDateTime(5).ToString();
enquetes.Add(enquete);
}
}
conexao.connection.Close();
return(enquetes);
}