public List <string> AuthenticateUser(LoginBo loginBo)
{
var login = BuiltLoginDomain(loginBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_AuthenticateUser", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", login.UserId);
var abcd = DESEncrypt(login.Pswd);
cmd.Parameters.AddWithValue("@pswd", DESEncrypt(login.Pswd));
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
SqlDataReader reader = cmd.ExecuteReader();
List <string> lst = new List <string>();
if (reader.HasRows)
{
while (reader.Read())
{
lst.Add(reader["User_Id"].ToString());
lst.Add(reader["Authority_Id"].ToString());
lst.Add(reader["User_Type"].ToString());
}
conn.Close();
}
return(lst);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string nomeUsuario = TxtUsuario.Text;
string senha = TxtSenha.Text;
try
{
_loginBo = new LoginBo();
//Obtem usuario cadastrado no banco
var usuario = _loginBo.ObterUsuarioParaLogar(nomeUsuario, senha);
//Redireciona o usuário para tela de login caso o mesmo não esteja autenticado
FormsAuthentication.RedirectFromLoginPage(usuario.Nome, false);
Session["Perfil"] = usuario.Perfil;
}
catch (UsuarioNaoCadastradoExceptions)
{
LblStatus.Text = "Usuário não cadastrado";
}
catch (Exception)
{
LblStatus.Text = "Erro inesperado";
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var nomeUsuario = TxtUsuario.Text;
var senha = TxtSenha.Text;
try
{
var usuario = _loginBo.ObterUsuarioParaLogar(nomeUsuario, senha);
FormsAuthentication.RedirectFromLoginPage(nomeUsuario, false);
Session.Timeout = 30;
Session["UsuarioId"] = usuario.Id;
Session["UsuarioNome"] = usuario.NomeUsuario;
Session["Perfil"] = usuario.Perfil;
}
catch (UsuarioNaoCadastradoException)
{
LblMensagem.Text = "Usuario nao cadastrado";
}
catch (Exception)
{
LblMensagem.Text = "Erro no sistema"; ;
}
}
protected void btnLoginUsuario(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var Email_Usuario = txtEmail.Text;
var Senha_Usuario = txtSenha.Text;
try
{
var usuario = _loginBo.ObterUsuarioLogin(Email_Usuario, Senha_Usuario);
FormsAuthentication.RedirectFromLoginPage(Email_Usuario, false);
}
catch (Exception)
{
lblStatus.Text = "E-mail não cadastrado ou senha incorreta!";
}
}
public async Task <UserBo> Login(LoginBo entity)
{
try
{
var result = this.uow.Context.Authentications
.FirstOrDefault(p => p.Email == entity.Email.Trim().ToLower() && p.Password == entity.Password);
if (result == null)
{
throw new ArgumentException("invalied username or password");
}
return(Mapper.Map <UserBo>(result));
}
catch (Exception ex)
{
throw HandleException(ex);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
_logingBo = new LoginBo();
string nomeUsuario = TxtUsuario.Text;
string senha = txtSenha.Text;
try
{
Usuario usuario = _logingBo.ObterUsuarioParaLogar(nomeUsuario, senha);
lblStatus.Text = "Autenticação realizada com sucesso!";
}
catch (UsuarioNaoCadastradoException)
{
lblStatus.Text = "Usuário não cadastrado";
} catch (Exception exc)
{
lblStatus.Text = "Ocorreu um erro inesperado! Contatar o administrador do sistema: \n " + exc.Message;
}
}
protected void BtnEntrar_Click(object sender, EventArgs e)
{
_loginbo = new LoginBo();
var nomeusuario = TxtUsuario.Text;
var senha = TxtSenha.Text;
LblStatus.Text = "";
try
{
var usuario = _loginbo.UsuarioCadastrado(nomeusuario, senha);
FormsAuthentication.RedirectFromLoginPage(nomeusuario, false);
NomeUsuario = usuario.ToString();
}
catch (UsuarioNaoCadastradoException)
{
LblStatus.Text = "Usuário ou senha incorreto";
}
catch (Exception)
{
LblStatus.Text = "Erro, contate o administrador!";
}
}
protected void btnlogin_Click(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var nomeUsuario = txtUsuario.Text;
var senha = txtSenha.Text;
try
{
var usuario = _loginBo.ObterUsuarioParaLogar(nomeUsuario, senha);
FormsAuthentication.RedirectFromLoginPage(nomeUsuario, false);
Session["Perfil"] = usuario.Perfil;
}
catch (UsuarioNaoCadastradoException)
{
lblStatus.Text = "Usuario não identificado!!!";
}
catch (Exception)
{
lblStatus.Text = "Ocurreu um erro inesperado, favor consultar o administrador do sistema";
}
}
protected void bntLogin_Click(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var nomeusuario = txtUsuario.Text;
var senha = txtSenha.Text;
/*quando loga*/ try
{
var usuario = _loginBo.ObterUsuarioParaLogar(nomeusuario, senha);
/*faz com que o usuário vá para alogin page, definida no webConfig*/ FormsAuthentication.RedirectFromLoginPage(nomeusuario, false);
Session.Timeout = 30; //Isso é para definir o tempo que sessão vai durar, coloca o mesmo que ado site no webConfig
Session["Perfil"] = usuario.Perfil; //Isso é para passar o valor "Perfil" para a página catalogo.aspx, tipo o qe você fez para definir o id do usuário no mangaDatabase
}
/*não tem o usuário no banco de dados*/ catch (UsuarioNaoCadastradoException)
{
lblStatus.Text = "Usuário não cadastrado.";
}
/*erro desconhecido*/ catch (Exception)
{
lblStatus.Text = "Ocorreu um erro inesperado, consulte o adiminstrador do sistema.";
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var nomeUsuario = TxtUsuario.Text;
var senha = TxtSenha.Text;
try
{
var usuario = _loginBo.ObterUsuarioParaLogar(nomeUsuario, senha);
FormsAuthentication.RedirectFromLoginPage(nomeUsuario, false);
Session["Perfil"] = usuario.Perfil;
}
catch (UsuarioNaoCadastradoException)
{
LblStatus.ForeColor = System.Drawing.Color.Red;
LblStatus.Text = "Usuário não Cadastrdo!";
}
catch (Exception)
{
LblStatus.ForeColor = System.Drawing.Color.Red;
LblStatus.Text = "Ocorreu um erro inesperado, favor consultar o adminstrador do sistema.";
}
}
public async Task <AuthResponseBo> authentication(LoginBo loginBo)
{
var result = await _myContext.User.AsNoTracking().FirstOrDefaultAsync(w => w.Username == loginBo.Username && w.Password == loginBo.Password && w.RecordStatus == RecordStatus.Active);
if (result != null)
{
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(configuration["Tokens:Key"]));
var credentials = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var claims = new[]
{
new Claim(JwtRegisteredClaimNames.Sub, result.Id.ToString()),
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
new Claim(JwtRegisteredClaimNames.UniqueName, result.Username),
new Claim("isAdmin", result.IsAdmin.ToString()),
};
var token = new JwtSecurityToken(
configuration["Tokens:Issuer"],
configuration["Tokens:Audience"],
claims,
expires: DateTime.UtcNow.AddDays(1),
signingCredentials: credentials
);
var generatedToken = new AuthResponseBo
{
Token = new JwtSecurityTokenHandler().WriteToken(token),
TokenExpiration = token.ValidTo,
IsAdmin = result.IsAdmin
};
return(generatedToken);
}
return(new AuthResponseBo());
}
protected void BtgLogin_Click(object sender, EventArgs e)
{
_loginBo = new LoginBo();
var nomeUsuario = TxtUsuario.Text;
var senha = TxtSenha.Text;
try
{
var usuario = _loginBo.ObterUsuarioParaLogar(nomeUsuario, senha);
FormsAuthentication.RedirectFromLoginPage(nomeUsuario, false);
Session.Timeout = 30;
Session["Perfil"] = usuario.Perfil;
//LblStatus.Text = "Usuario Logado";
}
catch (UsuarioNaoCadastradoException)
{
LblStatus.Text = "Usuario ou senha errados";
}
catch (Exception)
{
LblStatus.Text = "Ocorreu um erro inesperado,chamar os inuteis que fizeram o sistema!";
}
}
public ResponseBo <SessionRealPerson> Login(LoginBo loginBo)
{
string locationInfo = base.GetLocationFromIp(loginBo.ClientIpAddress);
ResponseBo <SessionRealPerson> responseBo = new ResponseBo <SessionRealPerson>();
try
{
#region Checks
if (loginBo.Username.IsNull())
{
responseBo.IsSuccess = false;
responseBo.Message = GetDicValue("xEmailCantBeEmpty", loginBo.LanguageId);
return(responseBo);
}
if (loginBo.Password.IsNull())
{
responseBo.IsSuccess = false;
responseBo.Message = GetDicValue("xPasswordCantBeEmpty", loginBo.LanguageId);
return(responseBo);
}
#endregion
using (SqlConnection conn = DbAccess.Connection.GetConn())
{
var p = new DynamicParameters();
p.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 255);
p.Add("@IsSuccess", dbType: DbType.Boolean, direction: ParameterDirection.Output);
p.Add("@Username", loginBo.Username, DbType.String, ParameterDirection.Input, 250);
p.Add("@Password", loginBo.Password, DbType.String, ParameterDirection.Input, 250);
p.Add("@LoginTime", loginBo.LoginTime, DbType.DateTime, ParameterDirection.Input);
p.Add("@TokenId", loginBo.TokenId, DbType.Guid, ParameterDirection.Input);
p.Add("@LanguageIdInput", loginBo.LanguageId, DbType.Int32, ParameterDirection.Input);
p.Add("@ClientIpAddress", loginBo.ClientIpAddress, DbType.String, ParameterDirection.Input, 50);
p.Add("@LocationInfo", locationInfo, DbType.String, ParameterDirection.Input, 4000);
p.Add("@AnonymousApiSessionId", loginBo.AnonymousApiSessionId, DbType.Int64, ParameterDirection.Input);
responseBo.Bo = conn.Query <SessionRealPerson>("spAuthLogin", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
responseBo.Message = p.Get <string>("@Message");
responseBo.IsSuccess = p.Get <bool>("@IsSuccess");
//var user = conn.Execute("spAuthLogin", p, commandType: CommandType.StoredProcedure);
//responseBo.Message = p.Get<string>("@Message");
//responseBo.IsSuccess = p.Get<bool>("@IsSuccess");
//if (responseBo.IsSuccess)
//{
// apiSessionId = p.Get<long?>("ApiSessionId");
// responseBo.Bo = new Sessions.SessionRealPerson()
// {
// Id = p.Get<long>("@PersonId"),
// Name = p.Get<string>("@Name"),
// Surname = p.Get<string>("@Surname"),
// LanguageId = languageId,
// DefaultCurrencyId = p.Get<Enums.Currencies>("@DefaultCurrencyId"),
// PersonRelationId = p.Get<long>("@PersonRelationId")
// //GenderId = p.Get<Enums.Genders>("@GenderId")
// };
//}
}
}
catch (Exception ex)
{
responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, null).ToResponse <Mh.Sessions.SessionRealPerson>();
}
return(responseBo);
}
private Login BuiltLoginDomain(LoginBo loginBo)
{
return((Login) new Login().InjectFrom(loginBo));
}
public ResponseDto <LoginReturnDto> Login(LoginDto loginDto)
{
DateTime loginTime = DateTime.Now;
Guid tokenId = Guid.NewGuid();
string clientIpAddress = HttpContext.Current.Request.UserHostAddress;
long?anonymousApiSessionId = null;
if (Session != null && Session.RealPerson.Id == -2)
{
anonymousApiSessionId = Session.ApiSessionId;
}
LoginBo loginBo = new LoginBo()
{
Username = loginDto.Username,
Password = loginDto.Password,
LanguageId = loginDto.LanguageId,
LoginTime = loginTime,
TokenId = tokenId,
ClientIpAddress = clientIpAddress,
AnonymousApiSessionId = anonymousApiSessionId
};
ResponseBo <SessionRealPerson> response = authBusiness.Login(loginBo);
ResponseDto <LoginReturnDto> responseReturn = response.ToResponseDto <LoginReturnDto, SessionRealPerson>();
if (response.IsSuccess)
{
// We need to login first, then we will get my person data.
Sessions.Session session = SessionManager.Login(response.Bo, loginTime, tokenId, clientIpAddress);
PersonRelationBusiness personRelationBusiness = new PersonRelationBusiness();
session.RealPerson.MyPersonIdList = personRelationBusiness.GetMyPersonIdList(session.RealPerson.Id).Bo;
PersonChangeMyPersonDto personChangeMyPersonDto = new PersonChangeMyPersonDto();
personChangeMyPersonDto.MyPersonId = response.Bo.Id;
personChangeMyPersonDto.PersonRelationId = response.Bo.PersonRelationId;
personChangeMyPersonDto.DefaultCurrencyId = response.Bo.DefaultCurrencyId;
SessionMyPerson myPerson = PersonRelationController.GetMyPerson(personChangeMyPersonDto, session);
session.MyPerson = myPerson;
////if user decides to change language in login screen, then we change it
//if (loginDto.LanguageId != session.RealPerson.LanguageId)
//{
// BaseBo baseBo = base.ToBaseBo();
// baseBo.Session.RealPerson.LanguageId = loginDto.LanguageId;
// realPersonBusiness.ChangeLanguage(baseBo);
//}
responseReturn.Dto = new LoginReturnDto()
{
Id = response.Bo.Id,
TokenId = session.TokenId,
Name = response.Bo.Name,
Surname = response.Bo.Surname,
GenderId = response.Bo.GenderId,
DefaultCurrencyId = response.Bo.DefaultCurrencyId
};
}
else
{
responseReturn.Dto = null;
}
// System.Threading.Thread.Sleep(5000);
return(responseReturn);
}
