//public void SubmitButton() //{ while (pwd == 10) // { // } // do // { // SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User\source\repos\VIAApp2Demo\VIAApp2Demo\DB\DatabaseStudents.mdf;Integrated Security=True;Connect Timeout=30"); // try // { // if (conn.State == System.Data.ConnectionState.Closed) // conn.Open(); // String query = "SELECT COUNT (*) FROM Login WHERE pwd=@pwd"; // SqlCommand cmd = new SqlCommand(query, conn); // cmd.CommandType = CommandType.Text; // SqlParameter Pwd = cmd.Parameters.AddWithValue("@pwd", SqlDbType.Int); // cmd.Parameters["@pwd"].Value = pwd; // if (Pwd == null) // { // Pwd.Value = DBNull.Value; // } // SqlDataReader reader = cmd.ExecuteReader(); // int count = Convert.ToInt32(cmd.ExecuteScalar()); // if (count > 0) // { // MainWindow main = new MainWindow(); // main.Show(); // } // else // { // MessageBox.Show("Username or password is incorrect!"); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // finally // { // conn.Close(); // } // } while (pwd == 10); //} public static bool IsValidLogin(string password) { new Thread(() => { try { Thread.CurrentThread.IsBackground = true; password = CreatePasswordHash(password); using (DatabaseStudentsEntitiesLastStand db = new DatabaseStudentsEntitiesLastStand()) { do { var query = (from u in db.RegisterTeachers where u.pwd.Equals(password) select u); } while (password.Length == 10); Thread.Sleep(500); if (password.Length == 10 && password.Equals(pwd)) { MessageBox.Show("Logged in succesfully,please wait..."); MainWindow mv = new MainWindow(); mv.Show(); mv.Hide(); } else { MessageBox.Show("Error!Password is incorrect"); } } } catch (Exception e) { MessageBox.Show(e.Message); } }); return(true); }
private async void AccessData() { await Task.Factory.StartNew(() => { foreach (var item in Items) { if (txtBox == SerialN) { using (DatabaseStudentsEntitiesLastStand db = new DatabaseStudentsEntitiesLastStand()) { var students = (from d in db.RegisterStudents select new { SerialN = d.SN, firstName = d.fName, lastName = d.lName, studentNr = d.sNr }).ToList(); }; } } return(new List <AttendanceList>()); }); }