private bool checkRecord(string email, string box) { try { var temp = LoginTable.Find(item => item.Email == email); Console.Write(temp.Password); if (SaltPassword.VerifyHash(passwordTextBox.Text, "SHA512", temp.Password) == true) { SessionInfo.UserID = temp.UserLogin; SessionInfo.UserName = temp.Email; Console.WriteLine(SessionInfo.UserID); return(true); } else { return(false); } ; } catch (Exception e) { Console.WriteLine(e); } return(false); }
public async Task <IActionResult> Authenticate([FromBody] Clients cliParam) { string test = (from c in _context.clients where c.cliMail == cliParam.cliMail select c.cliPassword).FirstOrDefault(); if (test != null) { if (SaltPassword.ComparePassword(test, cliParam.cliPassword)) { var cli = _clientService.Authenticate(cliParam.cliMail, test); if (cli == null) { return(BadRequest(new { message = "Login ou mots de passe incorrect" })); } await _context.SaveChangesAsync(); cli.cliPassword = null; return(Ok(cli)); } else { return(BadRequest(new { message = "Login ou mots de passe incorrect" })); } } return(BadRequest(new { message = "Login ou mots de passe incorrect" })); }
public async Task <IActionResult> Authenticate([FromBody] Employer empParam) { string test = (from c in _context.Employer where c.empLogin == empParam.empLogin select c.empPassword).FirstOrDefault(); if (test != null) { if (SaltPassword.ComparePassword(test, empParam.empPassword)) { var emp = _employerService.Authenticate(empParam.empLogin, test); if (emp == null) { return(BadRequest(new { message = "Username or password is incorrect" })); } await _context.SaveChangesAsync(); emp.empPassword = null; return(Ok(emp)); } else { return(BadRequest(new { message = "Username or password is incorrect" })); } } return(BadRequest(new { message = "Username or password is incorrect" })); }
public void InstallServices(IServiceCollection services, IConfiguration configuration) { SaltPassword saltPass = new SaltPassword(); configuration.GetSection(nameof(SaltPassword)).Bind(saltPass); services.AddSingleton(saltPass); services.AddSingleton(new Hash(saltPass)); }
private void signUpButton_Click_1(object sender, EventArgs e) { var textboxs = new Object[] { firstNameTextBox, lastNameTextBox, emailTextBox, departmentComboBox, passwordTextBox, retypePasswordTextBox, empCodeTextBox, addressTextBox }; if (!isFilled(textboxs)) { MessageBox.Show("Please fill out the form", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (!agreeCheckBox.Checked) { MessageBox.Show("You must agree with conditions and terms", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } var appPath = Application.StartupPath; Console.WriteLine(appPath); var constring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + appPath + "\\CriminalRecord.mdf;Integrated Security=True;Connect Timeout=30"; var con = new SqlConnection(constring); if (con.State != ConnectionState.Open) { con.Open(); } var sql = "INSERT INTO UserInformations (First_name, Last_name, Address, Phone, Officer_Department_ID, profile_image) " + "VALUES (@first_name, @last_name, @address, @phone, @officer, @profile_image)" + " SELECT @user_id = SCOPE_IDENTITY(); " + "INSERT INTO LoginInformation(User_Login_ID, Email, Password) " + "VALUES (@user_id, @email , @password)"; var command = new SqlCommand(sql, con); if (checkEmail(emailTextBox.Text) == true) { MessageBox.Show("Email's already existed.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (!passwordTextBox.Text.Equals(retypePasswordTextBox.Text)) { MessageBox.Show("Retype password not match", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { command.Parameters.Add("@first_name", SqlDbType.VarChar, 38).Value = firstNameTextBox.Text; command.Parameters.Add("@last_name", SqlDbType.VarChar, 38).Value = lastNameTextBox.Text; command.Parameters.Add("@address", SqlDbType.VarChar, 38).Value = addressTextBox.Text; command.Parameters.Add("@phone", SqlDbType.VarChar, 38).Value = string.Empty; command.Parameters.Add("@officer", SqlDbType.Int).Value = 1; command.Parameters.Add("@email", SqlDbType.VarChar, 38).Value = emailTextBox.Text; var ePass = SaltPassword.ComputeHash(passwordTextBox.Text, "SHA512", null); command.Parameters.Add("@user_id", SqlDbType.Int).Direction = ParameterDirection.Output; command.Parameters.Add("@password", SqlDbType.VarChar).Value = ePass; command.Parameters.Add("@profile_image", SqlDbType.VarChar).Value = image; command.ExecuteNonQuery(); Console.WriteLine("COMPLETE"); Close(); } } } }
private bool checkRecord(string email, string box) { try { LoginInfo temp = LoginTable.Find(item => item.Email == email); Console.Write(temp.Password); if (SaltPassword.VerifyHash("JohnWick", "SHA512", temp.Password) == true) { MessageBox.Show("Welcome My N***a"); return(true); } else { return(false); }; } catch (Exception e) { Console.WriteLine(e); } return(false); }
public async Task <IActionResult> PostClients([FromBody] Clients clients) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } string cliPassword = clients.cliPassword; clients.cliPassword = SaltPassword.GetPasswordHash(clients.cliPassword); _context.clients.Add(clients); await _context.SaveChangesAsync(); clients.cliPassword = cliPassword; await Authenticate(clients); clients.cliPassword = null; return(CreatedAtAction("GetClients", new { id = clients.cliId }, clients)); }
private void btn_submit_Click(object sender, EventArgs e) { String appPath = Application.StartupPath; string constring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + appPath + "\\CriminalRecord.mdf;Integrated Security=True;Connect Timeout=30"; Console.WriteLine(appPath + "Hello"); SqlConnection con = new SqlConnection(constring); if (con.State != ConnectionState.Open) { con.Open(); } string sql = "INSERT INTO LoginInformation (User_Login_ID, Email, Password) VALUES (@id, @email, @password)"; SqlCommand command = new SqlCommand(sql, con); command.Parameters.Add("@id", SqlDbType.Int).Value = id; command.Parameters.Add("@email", SqlDbType.VarChar, 38).Value = "*****@*****.**"; string ePass = SaltPassword.ComputeHash("JohnWick", "SHA512", null); Console.WriteLine(ePass); command.Parameters.Add("@password", SqlDbType.VarChar).Value = ePass; command.ExecuteNonQuery(); Console.WriteLine("COMPLETE"); }
public Hash(SaltPassword salt) { _saltPass = salt; }
public void PopulateDataBase() { new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test", SaltPassword.GetPasswordHash("test"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test2", SaltPassword.GetPasswordHash("test2"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test3", SaltPassword.GetPasswordHash("test3"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test3", SaltPassword.GetPasswordHash("test4"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test4", SaltPassword.GetPasswordHash("test5"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test5", SaltPassword.GetPasswordHash("test6"))); new EmployeDataService(_cache, _serializer, _errorLogger).PostEmploye(new Employe("Test6", SaltPassword.GetPasswordHash("test7"))); }
private async void BtnSignIn_Clicked(object sender, EventArgs e) { //nb https://www.c-sharpcorner.com/article/xamarin-android-create-login-with-web-api-using-azure-sql-server-part-two/ // int clientId = 0; tblUser user = new tblUser() { EmailAddress = usernameEntry.Text, Password = passwordEntry.Text, }; var json = JsonConvert.SerializeObject(user); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpClient client = new HttpClient(); var response = await client.PostAsync(string.Concat("http://192.168.0.53:45455/Api/ClientLogin?EmailAdddress=" + usernameEntry.Text /*, "&Password="******"Progress", null, null, true, MaskType.Black)) { var client_post_hash_password = Convert.ToBase64String( SaltPassword.saltHashPassword( Encoding.ASCII.GetBytes(passwordEntry.Text), Convert.FromBase64String(UserInfo.Salt))); if (client_post_hash_password.Equals(UserInfo.Password)) { if (UserInfo.Roles == "Admin") { for (int i = 0; i < 100; i++) { // progress.PercentComplete = i; await Task.Delay(60); } using (UserDialogs.Instance.Loading("Loading", null, null, true, MaskType.Black)) { await Task.Delay(5000); await Navigation.PushAsync(new HomePage()); } } else if (UserInfo.Roles == "User") { for (int i = 0; i < 100; i++) { // progress.PercentComplete = i; await Task.Delay(60); } using (UserDialogs.Instance.Loading("Loading", null, null, true, MaskType.Black)) { await Task.Delay(5000); await Navigation.PushAsync(new MasterPage(UserInfo.EmailAddress /*,UserInfo.ClientID*/)); globalUsername = UserInfo.EmailAddress; // await Navigation.PushAsync(new TestCode(UserInfo.EmailAddress/*,UserInfo.ClientID*/)); } } } else { await DisplayAlert("Login Failed", "Error: Password is incorrect", "Ok"); } } //else //return JsonConvert.SerializeObject("Wrong Password"); //} else { await DisplayAlert("Login Failed", "Error: Username is incorrect", "Ok"); //return JsonConvert.SerializeObject("User not Existing in Database"); } // IMyAPI myAPI; // //int userId = 0; ; // myAPI = RestService.For<IMyAPI>("http://192.168.0.53:45455"); // tblUser user = new tblUser(); // user.UserName = usernameEntry.Text; // user.Password = passwordEntry.Text; //// user.Id = userId; // var results = await myAPI.LoginUser(user); // int userId = 2; // //userId= Convert.ToInt32(usernameEntry.Text); // //if (results.Contains("Success")) // //string roles ="User"; // // { // user.Roles = ""; // if (results.Contains("Pass")) // { // await DisplayAlert("Login", "You have succesful Login", "Ok"); // await Navigation.PushAsync(new HomePage()); // } // else if (results.Contains("User")) // { // await DisplayAlert("Login", "You have succesful Login", "Ok"); // await Navigation.PushAsync(new UserTabbedPage(userId)); // } // //} // else // { // await DisplayAlert("Login", "Failed", "Ok"); // } }