protected void btnCadastrar2_onClick(object sender, EventArgs e)
{
Model.Login login = new Model.Login();
Controller.ControllerLogin con = new Controller.ControllerLogin();
string senha1 = txtpassword1.Text;
string senha2 = txtpasswordrepeat1.Text;
if (senha1 != senha2)
{
Response.Write("<script>alert('Senhas incompatives!');</script>");
}
else
{
login.email = txtusername1.Text;
login.senha = senha1;
login.cnpj = "";
}
if (login.email != null)
{
if (con.InsertLogin(login))
{
Response.Redirect("~/UserForm.aspx?Email=" + login.email);
}
else
{
Response.Write("<script>alert('ERRO');</script>");
}
}
}
public bool Login(Model.Login login)
{
bool loginS = false;
using (OracleConnection conn = new OracleConnection(db_connection))
using (OracleCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM login" +
" WHERE username = :username AND pw = :pw";
cmd.Parameters.Add("username", login.Username);
cmd.Parameters.Add("pw", login.Pw);
int rowCount = 0;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
rowCount++;
}
if (rowCount == 1)
{
loginS = true;
OnlineFelhasznalo = GetFelhasznaloFromUname(login.Username);
}
}
return(loginS);
}
public static void UpdatePwd(int loginid, string pwdhash)
{
Sparta.Model.Login aanmeld = new Model.Login();
SqlConnection connection = DALConnection.openConnectieDB();
DALConnection.openConnectieDB();
StringBuilder sbquery = new StringBuilder();
sbquery.Append("INSERT INTO Login (AanmeldNaam,PwdHash, PersoonId) Values('@aanmeldnaam','@pwdhash'," + loginid + "); ");
String sql = sbquery.ToString();
SqlCommand command = new SqlCommand(sql, connection);
//aanmeldnaam
SqlParameter aanmeldnaamParam = new SqlParameter("@aanmeldnaam", System.Data.SqlDbType.NVarChar);
command.Parameters.Add(aanmeldnaamParam);
aanmeldnaamParam.Value = aanmeld.Naam;
command.Prepare();
//wwhash
SqlParameter pwdhashParam = new SqlParameter("@pwdhash", System.Data.SqlDbType.NChar);
command.Parameters.Add(pwdhashParam);
pwdhashParam.Value = aanmeld.Pwdhash;
command.Prepare();
command.ExecuteNonQuery();
DALConnection.sluitConnectieDB(connection);
}
public void Cadastrar(String usuario, String senha)
{
con = new MySqlConnection();
loginDAO = new Model.Login();
conexao = new Utils.Conexao();
con.ConnectionString = conexao.getConnectionString();
String query = "INSERT INTO login(Usuario, Senha)";
query += " VALUES (?Usuario, ?Senha)";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("?Usuario", usuario);
cmd.Parameters.AddWithValue("?Senha", senha);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex);
}
finally
{
con.Close();
}
}
public static Model.Persoon checkCredentials(Model.Login user)
{
Model.Persoon p = new Model.Persoon();
int Persoonid = GetLogin(user);
GetPersoon(Persoonid, p);
return(p);
}
public Model.User Login(Model.Login login)
{
var user = BaseService.GetFirst(x => x.UserName == login.UserName);
if (user == null)
{
return(null);
}
return(PasswordHash.PasswordHash.ValidatePassword(login.Password, user.Password) ? AutoMapper.Mapper.Map <Model.User>(user) : null);
}
public void VerificaLogin(String email, String senha)
{
con = new MySqlConnection();
loginv = new Model.Login();
conexao = new Conexao.Conexao();
con.ConnectionString = conexao.getConnectionString();
String query = "SELECT Nome, Permissao, Senha FROM login WHERE Nome = ?Nome and Senha = ?Senha";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("?Nome", email);
cmd.Parameters.AddWithValue("?Senha", senha);
cmd.Dispose();
MySqlDataReader mysqlDT = cmd.ExecuteReader();
if (mysqlDT.Read())
{
string Permissao = mysqlDT["Permissao"].ToString();
string Usuario = mysqlDT["Nome"].ToString();
MessageBox.Show("Welcome " + Usuario);
if (Permissao.Equals("Total"))
{
menu = new Menu();
menu.ShowDialog();
}
else if (Permissao.Equals("Vendedor"))
{
menu = new Menu();
menu.btnCadastrarproduto.Enabled = false;
menu.btnCadastrarservico.Enabled = false;
menu.btnRelatorio.Enabled = false;
menu.btncadastrartipo.Enabled = false;
menu.ShowDialog();
}
else
{
MessageBox.Show("Usuario ou senha incorreto");
}
}
}
finally
{
con.Close();
}
}
protected void btnRegist_Click(object sender, EventArgs e)
{
Model.Login user = new Model.Login();
user.UserName = txtName.Text;
user.PassWord = txtPassword.Text;
user.Sex = dropSex.SelectedItem.Text;
user.Birthday = DateTime.Parse(txtDate.Text);
if (BLL.LoginBLL.UserResgist(user) > 0)
{
lblMes.Text = "注册成功！是否立即登入<a href='Login.aspx'>点击登入</a>";
}
}
async void login(object sender, EventArgs e)
{
string UserName = txtUsername.Text;
string PassWord = txtPassword.Text;
bool InvalidCredentials = false;
bool error = false;
Regex UserPass = new Regex("^[a-zA-Z0-9]*$");
Regex AccountUser = new Regex("^[a-zA-Z0-9]*$");
Match test = AccountUser.Match(UserName);
if (!test.Success)
{
InvalidCredentials = true;
}
test = UserPass.Match(PassWord);
if (!test.Success)
{
InvalidCredentials = true;
}
if (InvalidCredentials == false)
{
Database DB = new Database();
error = await DB.Login(UserName, PassWord);
}
if (error == true)
{
//On Regester also need a way of storing a variable for the username for inserting into accounts
//new user login object
Model.Login login = new Model.Login()
{
User = UserName
};
AccountDataAccessService adas = new AccountDataAccessService();
//store login
adas.AddLogin(login);
//navigate to sync screen
Navigation.InsertPageBefore(new SyncWithApi(UserName), this); //(Ford,2016)
await Navigation.PopAsync().ConfigureAwait(false);
}
else
{
LblError.Text = "Username/Password Was Incorrect";
}
}
public StartLogin()
{
Cef.Initialize(new CefSettings());
login_uri = String.Format("https://bgm.tv/oauth/authorize?client_id={0}&response_type=code", Settings.Default.ClientID);
browser = new ChromiumWebBrowser(browserSettings: new BrowserSettings());
while (!browser.IsBrowserInitialized)
{
System.Threading.Thread.Sleep(100);
}
login = new Model.Login();
captcha_src_result = new CaptchaSrcResult();
login_result = new LoginResult();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Model.Login user = new Model.Login();
user.UserName = txtName.Text;
user.PassWord = txtPassword.Text;
if (BLL.LoginBLL.UserLogin(user) > 0)
{
Response.Redirect("Login_Ok.aspx");
}
else
{
lblMes.Text = "登入失败，请重新填写用户名和密码";
}
}
public Login()
{
_model = new Model.Login();
GoToRegister = new Command(() =>
{
Application.Current.MainPage = new View.Registration();
});
LogIn = new Command(async() =>
{
Func <string, Task> mention_about_error = async(string message) => await Application.Current.MainPage.DisplayAlert("Ошибка!", message, "OK");
try
{
Data.User data = await _model.LogIn(Application.Current.Resources["url"] as string);
if (data != null)
{
data.Bind(Application.Current.Properties);
await Application.Current.SavePropertiesAsync();
Application.Current.MainPage = new View.Master();
}
}
catch (Exception e)
{
if (e is Exceptions.EmptyField)
{
await mention_about_error("Одно или несколько полей пусты");
}
else if (e is Exceptions.NotEmail)
{
await mention_about_error("Пожалуйста, введите корректную почту");
}
else if (e is Exceptions.LoginEmailNotFound)
{
await mention_about_error("Пользователь с данным логином или почтой не найден");
}
else if (e is Exceptions.InccorrectPassword)
{
await mention_about_error("Неверный пароль");
}
else
{
await mention_about_error($"Неизвестная ошибка - {e}\n\n {e.Message}");
}
}
});
}
private void btnEntrar_Click(object sender, EventArgs e)
{
Model.Login login = new Model.Login();
login.Email = txtusuario.Text;
login.Senha = txtsenha.Text;
try
{
this.Hide();
login.VerificarLogin();
}
catch
{
MessageBox.Show("Usuario ou senha incorreto", "Erro ao autenticar", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
protected void btnCadastrar2_onClick(object sender, EventArgs e)
{
Model.Login login = new Model.Login();
Controller.ControllerLogin con = new Controller.ControllerLogin();
login.email = "";
login.senha = "345";
login.cnpj = "";
if (con.InsertLogin(login))
{
Response.Redirect("~/UserForm.aspx");
}
else
{
Response.Write("<script>alert('ERRO');</script>");
}
}
public Login Login(string address, string emailOrUsername, string password)
{
BaseEmailOrUsernameValidation(emailOrUsername);
BasePasswordValidation(password);
address = WalletBusiness.GetAddressFormatted(address);
var user = Data.GetByEmailOrUsername(emailOrUsername);
if (user == null)
{
throw new ArgumentException("Email or username is invalid.");
}
else if (user.Wallet.Address?.ToUpper() != address?.ToUpper())
{
throw new ArgumentException("Wallet is invalid.");
}
else if (user.Password != Security.Hash(password))
{
throw new ArgumentException("Password is invalid.");
}
var result = new Model.Login()
{
Address = user.Wallet.Address,
Email = user.Email,
Username = user.Username,
PendingConfirmation = !user.ConfirmationDate.HasValue
};
if (!result.PendingConfirmation)
{
MemoryCache.Set <User>(user.Email, user);
var purchases = Task.Factory.StartNew(() => BuyBusiness.ListPurchases(user.Id));
var advisor = Task.Factory.StartNew(() => AdvisorBusiness.SimpleGetByOwner(user.Id));
Task.WaitAll(purchases, advisor);
result.HumanAdvisorId = advisor.Result?.Id;
result.HasInvestment = purchases.Result.Count > 0;
}
return(result);
}
public void Login()
{
var SessionMock = new TestControllerBuilder();
var controller = new ClearSkiesController(new AirlineLogikk(new AirlineDALStub()));
SessionMock.InitializeController(controller);
Model.Login info = new Model.Login()
{
Brukernavn = "Admin",
Passord = "Admin"
};
// Act
var result = (RedirectToRouteResult)controller.Login(info);
// Assert
result.AssertActionRedirect().ToAction("homePage");
Assert.AreEqual(true, controller.Session["LoggetInn"]);
}
public void Login_IKKE_OK()
{
var SessionMock = new TestControllerBuilder();
var controller = new ClearSkiesController(new AirlineLogikk(new AirlineDALStub()));
SessionMock.InitializeController(controller);
Model.Login info = new Model.Login()
{
Brukernavn = "",
Passord = ""
};
// Act
var result = (ViewResult)controller.Login(info);
//Assert
Assert.AreEqual("", result.ViewName);
Assert.AreEqual(false, result.ViewBag.Innlogget);
Assert.AreEqual(false, controller.Session["LoggetInn"]);
}
public Model.Login UserLogin(string userName)
{
var user = new Model.Login {
};
try
{
var res = context.Usuarios.Where(s => s.Usuario == userName).Select(s => new Model.Login {
IdUsuario = s.IdUsuario, Usuario = s.Usuario, NombreUsuario = s.NombreUsuario, IdPerfil = s.IdPerfil, Contraseña = s.Contraseña
}).Take(1).ToList();
if (res.Count != 0)
{
user = res[0];
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(user);
}
public static BasicEntity Login(Model.Login data, Output.Login obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@Password", data.Password);
retVal.AddParameter("@UserLogin", data.UserLogin);
data.SqlDetail = retVal.SQLCommandBuilder("spUserLogin");
using (SqlDataReader reader = retVal.ExecReader())
{
while (reader.Read())
{
obj.ResultCode = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0);
obj.ErrorMessage = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
retVal.ResultCode = obj.ResultCode;
}
if (retVal.ResultCode == 1)
{
reader.NextResult();
while (reader.Read())
{
var item = new Output.LoginData();
item.UserID = (reader.IsDBNull(0)) ? string.Empty : reader.GetString(0);
item.SessionToken = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
item.Level = (reader.IsDBNull(2)) ? string.Empty : reader.GetString(2);
obj.Content.Data.Add(item);
}
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static int GetLogin(Model.Login user)
{
SqlConnection connection = DALConnection.openConnectieDB();
DALConnection.openConnectieDB();
StringBuilder sbquery = new StringBuilder();
sbquery.Append("SELECT PersoonId FROM Login WHERE AanmeldNaam = 'jj' AND PwdHash = '4518675ca4c68e676ada63a756852224';");
//sbquery.Append("SELECT PersoonId FROM Login WHERE AanmeldNaam = '@id' AND PwdHash = '@ww';");
String sql = sbquery.ToString();
SqlCommand command = new SqlCommand(sql, connection);
//aanmeldnaam
SqlParameter IdParam = new SqlParameter("@id", System.Data.SqlDbType.NVarChar, 50, "AanmeldNaam");
IdParam.Value = user.Naam;
command.Parameters.Add(IdParam);
//pwshash
SqlParameter wwParam = new SqlParameter("@ww", System.Data.SqlDbType.NChar, 32, "PwdHash");
wwParam.Value = user.Pwdhash.GetHashCode();
command.Parameters.Add(wwParam);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
int persoonid = 0;
while (reader.Read())
{
persoonid = (int)reader["PersoonId"];
}
reader.Close();
DALConnection.sluitConnectieDB(connection);
return(persoonid);
}
private void btnCadastrar_Click(object sender, EventArgs e)
{
loginmodel = new Model.Login();
try
{
loginmodel.Usuario = UsernameTextBox.Text;
loginmodel.Senha = SenhaTextBox.Text;
loginmodel.Cadastrar();
MessageBox.Show("Cadastrado Efetuado!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Erro: Não foi possível efetuar o cadastro " + ex);
}
finally
{
}
Limpar();
}
public static BaseHelper Login(Model.Login data)
{
var retVal = new BaseHelper();
var objJSON = new Output.Login();
try
{
var entity = User.Login(data, objJSON);
retVal.SQLElapsed = entity.SQLElapsed;
retVal.SQLInfo(entity.SQLDetail);
retVal.IsError = (entity.ResultCode == 1) ? false : true;
}
catch (Exception ex)
{
retVal.Exception = ex;
if (ex is System.Data.SqlClient.SqlException sqlEx)
{
retVal.SQLInfo($"sp:{sqlEx.Procedure}, line:{sqlEx.LineNumber}, detail:{data.SqlDetail}");
retVal.SQLException = true;
objJSON.ResultCode = 69998;
objJSON.ErrorMessage = "SQL Exception";
}
else
{
objJSON.ResultCode = 69999;
objJSON.ErrorMessage = "Unknown Error";
}
}
finally
{
retVal.SerializeObject <Output.Login>(objJSON);
}
return(retVal);
}
private void btnLogin_Click(object sender, EventArgs e)
{
LoginBL loginBL = new LoginBL();
Model.Login login = loginBL.GetLogin(txtUserName.Text, txtPassword.Text);
if (login.LoginUserName == null || login.Password == null)
{
lblErrorMessage.Text = "Invalid Password or Login User Name";
txtUserName.Focus();
}
else
{
if (login.Password.Trim() == txtPassword.Text && login.LoginUserName.Trim() == txtUserName.Text)
{
DialogResult = DialogResult.OK;
}
else
{
lblErrorMessage.Text = "Invalid Password or Login User Name";
txtUserName.Focus();
}
}
}
public ActionResult GetToken([FromBody] Model.Login login)
{
System.IdentityModel.Tokens.Jwt.JwtSecurityToken token;
Model.appsettings.TokenSettings instance;
List <System.Security.Claims.Claim> claims;
Microsoft.IdentityModel.Tokens.SigningCredentials credentials;
// Token şimdiden ne kadar zaman sonra geçerli olsun. Hemen geçerli olsun diye null.
DateTime?notWorkBeforeDate = null;
// Token'ın kullanım süresini belirler. Daima kullanılsın diye null set edilebilir.
DateTime?expirationDate = DateTime.Now.AddDays(7);
if (!login.UserName.Equals("petro") && !login.Password.Equals("net"))
{
return(this.BadRequest("Hatali kullanici bilgileri!"));
}
// appsettings.json 'dan ilgili ayarları çekelim
instance = new TokenSettings();
this.config.Bind("JwtSettings", instance);
// Oluşan token bilgisini HMAC-SHA256 ile şifreleyeceğiz
credentials = new SigningCredentials(instance.IssuerSigningKey, "http://www.w3.org/2001/04/xmldsig-more#hmac-sha256");
// Token ile göndereceğimiz bilgileri ayarlayalım
claims = new List <Claim> {
new Claim("http://schemas.microsoft.com/ws/2008/06/identity/claims/role", "Yönetici"),
new Claim("http://schemas.microsoft.com/ws/2008/06/identity/claims/role", "Servis Görevlisi"),
// Uygulamaya özgü bir özellik eklerken:
new Claim("Yetkiler", "Servis:C,R,U,D;Dosya:C,R"),
// ister "xml schema" bilgisiyle ister bu bilgiyle eşleşmi ClaimTypes.xxx tipinin statik özellikleriyle
new Claim(ClaimTypes.Country, "Türkiye"),
new Claim(ClaimTypes.GivenName, "Cem Topkaya")
};
var tokenDescriptor = new SecurityTokenDescriptor {
Audience = instance.Audience,
Expires = expirationDate,
IssuedAt = DateTime.Now,
Issuer = instance.Issuer,
NotBefore = null, // null verdiğimiz için DateTime.Now değerini yazacak
SigningCredentials = credentials,
Subject = new ClaimsIdentity(claims)
};
var tokenHandler = new JwtSecurityTokenHandler();
token = tokenHandler.CreateJwtSecurityToken(tokenDescriptor);
return(Ok(new { login, Token = tokenHandler.WriteToken(token) }));
token = new JwtSecurityToken(
instance.Issuer,
instance.Audience,
(IEnumerable <Claim>)claims,
notWorkBeforeDate,
expirationDate,
credentials);
return(this.Ok(new JwtSecurityTokenHandler().WriteToken(token)));
}
public static void RegisterLoginAction(bool isLogin, int userLoggedInId)
{
Model.Login login = new Model.Login()
{
IsLogin = isLogin,
LoginDate = DateTime.Now,
UserId = userLoggedInId
};
if (Controllers.BusinessController.Instance.Add<Model.Login>(login) == false)
{
MessageBox.Show("No se pudo registrar el " + (isLogin ? "inicio" : "cierre") + " de sesión", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public int UpdateUserRoot(Model.Login login)
{
return(Dallogin.UpdateUserRoot(login));
}
public string GetUserName(Model.Login login)
{
return(Dallogin.GetUserName(login));
}
private void LoginControl_AfterLogin()
{
Login = loginControl.Login;
DialogResult = Login.Validated;
}
public static void RegistreerPersoon(Model.DeelnemerCategorie categorie, string naam, string achternaam, DateTime gbdatum, Model.Login aanmeld)
{
int id = nieuwPersoon(categorie, naam, achternaam, gbdatum);
NieuweLogin(aanmeld, id);
}
public string Pasar(string usuario, string password)
{
Model.Login login = new Model.Login();
login.Verificar(usuario, password);
return(login.Verificar(usuario, password));
}
/// <summary>
/// Sets login paramater for SQLite database
/// </summary>
/// <param name="newLogin">the user to login to the app</param>
public void AddLogin(Model.Login newLogin)
{
DBConnection.Insert(newLogin);
}
