private void btnAceptar_Click(object sender, EventArgs e)
{
if(this.txtConfirmarPassword.Text == "" || this.txtPassword.Text == "" || this.txtUsername.Text == "")
{
MessageBox.Show(this, "No pueden haber campos vacios", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (this.txtPassword.Text == this.txtConfirmarPassword.Text)
{
StringBuilder checkUser = new StringBuilder();
checkUser.AppendFormat("SELECT * FROM TRANSA_SQL.CuponeteUser CU WHERE CU.Username='******'", this.txtUsername.Text);
int userRows = Conexion.Instance.ejecutarQuery(checkUser.ToString()).Rows.Count;
if (userRows == 0)
{
int userTypeId;
int roleId;
if ((this.cmbTipoUsr.SelectedItem as string) == "Cliente")
{
userTypeId = 2;
roleId = 2;
}
else
{
userTypeId = 3;
roleId = 3;
}
string password = new LoginApplication().encriptarPassword(this.txtPassword.Text);
StringBuilder sentece = new StringBuilder();
sentece.AppendFormat("INSERT INTO TRANSA_SQL.CuponeteUser(Username, Password, FirstLogin, FailedAttemps, RoleId, Enabled, Deleted, UserTypeId) VALUES ('{0}','{1}',0,0,{2},1,0, '{3}')", this.txtUsername.Text, password, roleId, userTypeId);
Conexion.Instance.ejecutarQuery(sentece.ToString());
StringBuilder sentece2 = new StringBuilder();
sentece2.AppendFormat("SELECT TOP 1 CU.UserId FROM TRANSA_SQL.CuponeteUser CU ORDER BY CU.UserId DESC");
int newUserId = (int)Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0][0];
if (userTypeId == 2)
{
RegistrarCliente registrarCliente = new RegistrarCliente(newUserId);
registrarCliente.ShowDialog();
this.Close();
}
else if (userTypeId == 3)
{
RegristrarProveedor registrarProveedor = new RegristrarProveedor(newUserId);
registrarProveedor.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show(this, "El nombre de usuario ya existe", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "Los passwords ingresados no coinciden", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAceptar_Click(object sender, EventArgs e)
{
if (this.txtConfirmarPassword.Text == "" || this.txtPassword.Text == "" || this.txtUsername.Text == "")
{
MessageBox.Show(this, "No pueden haber campos vacios", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (this.txtPassword.Text == this.txtConfirmarPassword.Text)
{
StringBuilder checkUser = new StringBuilder();
checkUser.AppendFormat("SELECT * FROM TRANSA_SQL.CuponeteUser CU WHERE CU.Username='******'", this.txtUsername.Text);
int userRows = Conexion.Instance.ejecutarQuery(checkUser.ToString()).Rows.Count;
if (userRows == 0)
{
int userTypeId;
int roleId;
if ((this.cmbTipoUsr.SelectedItem as string) == "Cliente")
{
userTypeId = 2;
roleId = 2;
}
else
{
userTypeId = 3;
roleId = 3;
}
string password = new LoginApplication().encriptarPassword(this.txtPassword.Text);
StringBuilder sentece = new StringBuilder();
sentece.AppendFormat("INSERT INTO TRANSA_SQL.CuponeteUser(Username, Password, FirstLogin, FailedAttemps, RoleId, Enabled, Deleted, UserTypeId) VALUES ('{0}','{1}',0,0,{2},1,0, '{3}')", this.txtUsername.Text, password, roleId, userTypeId);
Conexion.Instance.ejecutarQuery(sentece.ToString());
StringBuilder sentece2 = new StringBuilder();
sentece2.AppendFormat("SELECT TOP 1 CU.UserId FROM TRANSA_SQL.CuponeteUser CU ORDER BY CU.UserId DESC");
int newUserId = (int)Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0][0];
if (userTypeId == 2)
{
RegistrarCliente registrarCliente = new RegistrarCliente(newUserId);
registrarCliente.ShowDialog();
this.Close();
}
else if (userTypeId == 3)
{
RegristrarProveedor registrarProveedor = new RegristrarProveedor(newUserId);
registrarProveedor.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show(this, "El nombre de usuario ya existe", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "Los passwords ingresados no coinciden", "Error en Registro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public LoginOperationHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
loginMethods = new Dictionary <LoginMethod, System.Func <LoginOperationRequest, OperationResponse> > {
{ LoginMethod.server, LoginViaServer },
{ LoginMethod.facebook, LoginViaFacebook },
{ LoginMethod.vkontakte, LoginViaVkontakte },
{ LoginMethod.steam, LoginViaSteam },
{ LoginMethod.device_id, LoginViaDeviceId }
};
}
public void ValidarUsuarioTest()
{
LoginApplication target = new LoginApplication();
UsuarioDTO usuario = new UsuarioDTO();
LoginFilter filtro = new LoginFilter();
filtro.Login = "******";
filtro.Clave = "tnsclave";
usuario = target.ValidarUsuario(filtro);
Assert.IsNotNull(usuario);
}
public int GetIdLoginAccessWithEmail(string emailAccess)
{
try
{
appLogin = new LoginApplication();
int idLoginAccess = 0;
foreach (DataRow linha in appLogin.SearchIdLoginAccessWithEmail(emailAccess).Rows)
{
idLoginAccess = Convert.ToInt32(linha["idLoginAccess"]);
}
return(idLoginAccess);
}
catch (Exception)
{
throw;
}
}
public bool IsValidLogin(LoginModel loginModel)
{
try
{
appLogin = new LoginApplication();
if (appLogin.QuerieLogin(loginModel.emailAccess, loginModel.passwordAccess).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public void RegistrarUsuarioTest()
{
LoginApplication target = new LoginApplication();
LoginFilter filtro = new LoginFilter
{
Nombre = "David",
Apellido = "Lopez",
Cedula = "708743564",
Login = "******",
Clave = "davidclave"
};
try
{
target.RegistrarUsuario(filtro);
}
catch (BussinesException ex)
{
//Excepción esperada según alguna regla de negocio.
Assert.IsNotNull(ex);
}
}
public IActionResult ValidarUsuario([FromQuery] LoginFilter filtro)
{
try
{
if (string.IsNullOrEmpty(filtro.Login) || string.IsNullOrEmpty(filtro.Clave))
{
return(BadRequest(BadRequestError));
}
UsuarioDTO usuario = new LoginApplication().ValidarUsuario((LoginFilter)filtro);
if (usuario == null)
{
return(NotFound(NotFoundError));
}
return(Ok(usuario));
}
catch (Exception ex)
{
logger.Error(ex, InternalServerErrorValidarUsuario);
return(StatusCode((int)HttpStatusCode.InternalServerError, InternalServerErrorValidarUsuario));
}
}
public InvokeMethodOperationHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
}
static void Main(string[] args)
{
LoginApplication login = new LoginApplication();
var a = login.CreateCompany("jitendra", "jkcompany", "*****@*****.**", "12345");
}
public BaseOperationHandler(LoginApplication app, PeerBase peer)
{
this.application = app;
this.peer = peer;
}
public RegisterUserHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
}
private static void Main()
{
LoginApplication app = new LoginApplication();
app.Run();
}
public async Task RegisterNewSessionAsync(AuthorizationToken token, RefreshToken refreshToken, string userAgent, string ip, string description, PlatformTypes platformType, LoginApplication application)
{
if (!token.RootSessionId.HasValue)
{
throw new Exception("Cannot RegisterNewSession without RootSessionId");
}
var pkBase64 = token.PublicKey != null?Convert.ToBase64String(token.PublicKey) : "";
var session = RootSessionNoSqlEntity.Generate(token.RootSessionId.Value, token.TraderId(), token.BrandId, userAgent, ip, pkBase64,
token.Passed2FA, token.EmailVerified, description, platformType, application);
session.Expires = refreshToken.Expires;
var task1 = _sessionWriter.InsertOrReplaceAsync(session).AsTask();
var shortSession = ShortRootSessionNoSqlEntity.Create(session);
shortSession.Expires = refreshToken.Expires;
var task2 = _rootSessionWriter.InsertOrReplaceAsync(shortSession).AsTask();
var task3 = _rootSessionWriter.GetCountAsync(
ShortRootSessionNoSqlEntity.GeneratePartitionKey(token.TraderId())).AsTask();
await Task.WhenAll(task1, task2, task3);
if (task3.Result > _maxSessionsCount)
{
var sessions = await _sessionWriter.GetAsync(
ShortRootSessionNoSqlEntity.GeneratePartitionKey(token.TraderId()));
var oldestSession = sessions.OrderBy(s => s.CreateTime).First();
await Logout(token.TraderId(), oldestSession.RootSessionId);
}
}
public CharacterOperationHandler(LoginServerPeer peer, LoginApplication application)
{
this.application = application;
this.peer = peer;
}
public static RootSessionNoSqlEntity Generate(Guid rootSessionId, string traderId, string brandId, string userAgent, string ip, string publicKeyBase64, bool passed2FA, bool emailVerified,
string description, PlatformTypes platformType, LoginApplication application)
{
return(new RootSessionNoSqlEntity()
{
PartitionKey = GeneratePartitionKey(traderId),
RowKey = GenerateRowKey(rootSessionId),
BrandId = brandId,
CreateTime = DateTime.UtcNow,
IP = ip,
PublicKeyBase64 = publicKeyBase64,
Passed2FA = passed2FA,
RootSessionId = rootSessionId,
TraderId = traderId,
UserAgent = userAgent,
Description = description,
EmailVerified = emailVerified,
PlatformType = platformType,
Application = application
});
}
public GetUsersOnlineHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
}
public GetNebulaCreditsOperationHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
}
public RecoverUserOperationHandler(LoginApplication app, PeerBase peer)
: base(app, peer)
{
}
