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);
}
}
