private void login() { Boolean valid = false; HSForm = new HomeScreen(txtUsername.Text); myConn.Close(); btnQuickLogin.Enabled = true; string loginReport = Properties.Settings.Default.loginReportPath; using (StreamWriter sw = File.AppendText(loginReport)) { System.DateTime dt = DateTime.Today; string day = dt.Day.ToString(); string month = dt.Month.ToString(); string year = dt.Year.ToString(); string fullString = txtUsername.Text + "," + day + "," + month + "," + year; sw.WriteLine(fullString); } using (StreamReader sw = new StreamReader(Properties.Settings.Default.quickLoginPath)) { string line; while ((line = sw.ReadLine()) != null) { string[] lineInfo = line.Split(','); string id = lineInfo[0]; if (id.Equals(txtUsername.Text)) { valid = true; break; } } } if (!valid) { quickLogin(txtUsername.Text); } lblPin.Visible = false; btnSubmit.Visible = false; txtPIN.Visible = false; btnLogin.Visible = true; txtUsername.Visible = true; txtPassword.Text = ""; txtUsername.Text = ""; txtPIN.Text = ""; lblSuccess.Text = ""; txtCredentialBox.Text = ""; txtPIN.Enabled = false; btnSubmit.Enabled = false; this.Hide(); HSForm.ShowDialog(); this.Show(); }
private void button1_Click(object sender, EventArgs e) { string UName = txtUsername.Text; string PWord = txtPassword.Text; myConn = new SqlConnection("Server=softwarecapproject.database.windows.net;Database=VideoStoreUsers;User ID = bcrumrin64; Password=S0ftT0pix!; Encrypt=True; TrustServerCertificate=False; Connection Timeout=30;"); myConn.Open(); myCmd = new SqlCommand("SELECT IDNumber, PassPhrase FROM UserTable WHERE IDNumber = @Uname AND PassPhrase = @Pass", myConn); myCmd.Parameters.AddWithValue("@Uname", UName); myCmd.Parameters.AddWithValue("@Pass", PWord); var test = myCmd.ExecuteScalar(); if (test == null) { lblSuccess.Text = "Invalid Username/Password"; myConn.Close(); } else { Boolean valid = true; HSForm = new HomeScreen(txtUsername.Text); myConn.Close(); string loginReport = "..\\Files\\LoginReport.txt"; using (StreamWriter sw = File.AppendText(loginReport)) { System.DateTime dt = DateTime.Today; string day = dt.Day.ToString(); string month = dt.Month.ToString(); string year = dt.Year.ToString(); string fullString = txtUsername.Text + "," + day + "," + month + "," + year; sw.WriteLine(fullString); } txtPassword.Text = ""; txtUsername.Text = ""; this.Hide(); HSForm.ShowDialog(); this.Show(); } }