public UsuarioPortalController LoginUsuarioPortal(String CPF, string Senha) { try { PortalUsuarioDao DAO = new PortalUsuarioDao(); UsuarioPortalController LoginUsuarioPortal = new UsuarioPortalController(); LoginUsuarioPortal = DAO.LoginUsuarioPortal(CPF, Senha); return(LoginUsuarioPortal); } catch (Exception ex) { throw ex; } }
/// <summary> /// Descrição: Valida login do usuário no portal /// Autor: Fabiano Gonçalves Elias /// Data: 06/07/2017 /// ********************************************************************************************************** /// Data Alteração Autor Descrição /// </summary> public UsuarioPortalController LoginUsuarioPortal(String CPF, string Senha) { UsuarioPortalController Usuario = new UsuarioPortalController(); Usuario.Pessoa = new PessoaController(); Usuario.TB033_ChaveTemporaria = "-1"; try { StringBuilder sSQL = new StringBuilder(); sSQL.Append(" SELECT dbo.TB013_Pessoa.TB013_id, dbo.TB033_PortalUsuario.TB033_Senha, dbo.TB013_Pessoa.TB013_CPFCNPJ, dbo.TB033_PortalUsuario.TB033_CadastradoEm, dbo.TB033_PortalUsuario.TB033_CadastradoPor, "); sSQL.Append(" dbo.TB033_PortalUsuario.TB033_AlteradoEm, dbo.TB033_PortalUsuario.TB033_AlteradoPor, dbo.TB033_PortalUsuario.TB033_Status, dbo.TB033_PortalUsuario.TB033_UltimoAcesso,dbo.TB013_Pessoa.TB013_NomeCompleto, dbo.TB013_Pessoa.TB012_Corporativo "); sSQL.Append(" FROM dbo.TB033_PortalUsuario INNER JOIN "); sSQL.Append(" dbo.TB013_Pessoa ON dbo.TB033_PortalUsuario.TB013_id = dbo.TB013_Pessoa.TB013_id "); sSQL.Append(" WHERE "); sSQL.Append(" dbo.TB033_PortalUsuario.TB033_Senha = "); sSQL.Append(" '"); sSQL.Append(Cript.Encrypt(Senha)); sSQL.Append("'"); sSQL.Append(" AND "); sSQL.Append("dbo.TB013_Pessoa.TB013_CPFCNPJ = "); sSQL.Append("'"); sSQL.Append(CPF.Replace(".", "").Replace(",", "").Replace("-", "").Replace("/", "").Trim()); sSQL.Append("'"); SqlConnection con = new SqlConnection(Cript.Decrypt(ConfigurationManager.ConnectionStrings["ClubeContezaConnection"].ConnectionString)); SqlCommand command = new SqlCommand(sSQL.ToString(), con); con.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Usuario.Pessoa.TB013_Complemento = reader["TB013_NomeCompleto"].ToString().Trim(); if (Convert.ToInt16(reader["TB033_Status"]) == 0) { Usuario.TB033_ChaveTemporaria = "0"; } else { if (Convert.ToInt16(reader["TB033_Status"]) == 1) { //IPHostEntry Host = Dns.GetHostEntry(Dns.GetHostName()); //IPAddress Ip = Host.AddressList[0]; Usuario.TB033_ChaveTemporaria = Cript.EncryptInterna(reader["TB013_CPFCNPJ"].ToString().Trim() + ";" + DateTime.Now.ToString("dd/MM/yyyy hh:mm")); Usuario.Pessoa.TB012_Corporativo = Convert.ToInt64(reader["TB012_Corporativo"]); if (!ChaveTemporariaUpdate(Convert.ToInt64(reader["TB013_id"]), Usuario.TB033_ChaveTemporaria)) { Usuario.TB033_ChaveTemporaria = "-1"; Usuario.Pessoa.TB013_Complemento = "ERRO"; } } } } con.Close(); } catch (Exception ex) { throw ex; } return(Usuario); }
protected void btnConfirmar_Click(object sender, EventArgs e) { DivModulos.InnerHtml = ""; linkPerfil2.HRef = "#"; Session["Usuario"] = "0"; Session["Acesso"] = "0"; Session.Remove("Usuario"); Session.Remove("Acesso"); /*Trata campos obrigatorios do formulario*/ if (txtCPF.Text.Trim() == string.Empty) { ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('" + string.Format(msretorno.MS0001, "CPF") + "')", true); return; } if (txtSenha.Value.Trim() == string.Empty) { ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('" + string.Format(msretorno.MS0001, "Senha") + "')", true); return; } /*Consulta credenciais do usuario no banco*/ try { UsuarioPortalNegocios Usuario_N = new UsuarioPortalNegocios(); UsuarioPortalController Usuario = Usuario_N.LoginUsuarioPortal(txtCPF.Text.Trim(), txtSenha.Value.Trim()); if (Usuario.TB033_ChaveTemporaria == "-1") { ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('" + msretorno.MS0002 + "')", true); } else { if (Usuario.TB033_ChaveTemporaria == "0") { ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('" + string.Format(msretorno.MS0003, txtCPF.Text.Trim()) + "')", true); } else { Session["Usuario"] = Usuario.Pessoa.TB013_NomeCompleto; Session["Acesso"] = Usuario.TB033_ChaveTemporaria; Session.Timeout = 60; ///*Verifica acesso a plano familiar*/ PortalContratoNegocios Contrato_N = new PortalContratoNegocios(); ContratosController Contezino = Contrato_N.AcessoUsuarioPlanoFamiliar(Session["Acesso"].ToString()); if (Contezino.TB012_Id > 0) { // /*Libera Icone de acesso plano familiar*/ // DivModulos.InnerHtml = " <a href='/contezino/contezino.aspx'><img src='img/Contezino.png' /></a>"; } else { // DivModulos.InnerHtml = " <a href='/contezino/contezino.aspx'><img src='img/ContezinoPB.png' /></a>"; } linkPerfil2.HRef = Usuario.Pessoa.TB012_Corporativo > 0 ? "~/TesteWebServiceLogin.aspx" : "#"; } } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('" + ex.Message + "')", true); } }