public void textBoxEmail_Validating(object sender, CancelEventArgs e) { string mySQL = string.Empty; mySQL += "SELECT * FROM [AccountDB].[dbo].[User] WHERE[AccountDB].[dbo].[User].Email = '" + txtEmail.Text.Trim() + "'"; DataTable userData = Server_connection.executeSQL(mySQL); if (userData.Rows.Count > 0) { e.Cancel = true; errorProviderEmail.SetError(txtEmail, "User with this email already exists "); } Valid_func_delegate delegate_func = Helpers.Valid_email; if (validation(delegate_func, model.Email, txtEmail.Text.Trim())) { e.Cancel = false; errorProviderEmail.SetError(txtEmail, ""); } else { e.Cancel = true; errorProviderEmail.SetError(txtEmail, "Email should match to template [email protected] "); } }
private void btnSave_Click(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "UPDATE[AccountDB].[dbo].[User] SET Firstname = '" + txtFirstname.Text.Trim() + "', Lastname = '" + txtLastname.Text.Trim() + "' , Email = '" + txtEmail.Text.Trim() + "', Rol = '" + comboBoxRole.Text + "' WHERE UserID = " + this.user_id; DataTable userData = Server_connection.executeSQL(mySQL); MessageBox.("Unpdated successfuly"); FormHome fh = new FormHome(); fh.ShowDialog(); }
private void FormAccSettings_Load(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "SELECT * FROM [AccountDB].[dbo].[User] "; mySQL += "WHERE UserID = " + user_id; DataTable userData = Server_connection.executeSQL(mySQL); txtFirstname.Text = userData.Rows[0][1].ToString(); txtLastname.Text = userData.Rows[0][2].ToString(); txtEmail.Text = userData.Rows[0][3].ToString(); comboBoxRole.Text = userData.Rows[0][5].ToString(); }
private void FormAccountList_Load(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "SELECT [AccountDB].[dbo].[Accounts].AccNumber, [AccountDB].[dbo].[Accounts].Firstname,[AccountDB].[dbo].[Accounts].Lastname, " + " [AccountDB].[dbo].[Accounts].Last_year, FORMAT([AccountDB].[dbo].[Accounts].Summ, 'C', 'de-de') AS \"Sum on account\" FROM[AccountDB].[dbo].[Accounts] INNER JOIN[AccountDB].[dbo].[Usesr_Accounts]" + " ON[AccountDB].[dbo].[Accounts].AccNumber = [AccountDB].[dbo].[Usesr_Accounts].AccNumber WHERE[AccountDB].[dbo].[Usesr_Accounts].UserID = "; mySQL += user_id; DataTable userData = Server_connection.executeSQL(mySQL); if (userData.Rows.Count > 0) { dataGridViewAccounts.DataSource = userData; } else { MessageBox.Show("This user does not have an account"); } }
private void btnLogin_Click(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "SELECT * FROM [AccountDB].[dbo].[User] "; mySQL += "WHERE Email = '" + txtEmail.Text.Trim() + "'"; DataTable userData = Server_connection.executeSQL(mySQL); if (userData.Rows.Count == 1) { string hashed_pass = userData.Rows[0][4].ToString(); if (Helpers.Verify(txtPassword.Text.Trim(), hashed_pass)) { txtEmail.Clear(); txtPassword.Clear(); PasswordCheckBox.Checked = false; if (userData.Rows[0][0].ToString() == "Client") { this.Hide(); FormAccountList fal = new FormAccountList(userData.Rows[0][0].ToString()); fal.ShowDialog(); } else { this.Hide(); FormBankAccounts fba = new FormBankAccounts(userData.Rows[0][0].ToString()); fba.ShowDialog(); } } else { MessageBox.Show("Wrong password"); } } else { MessageBox.Show("User with this email and password is not registreted"); } }
private void btnSort_Click(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "SELECT [AccountDB].[dbo].[Accounts].AccNumber, [AccountDB].[dbo].[Accounts].Firstname,[AccountDB].[dbo].[Accounts].Lastname, " + " [AccountDB].[dbo].[Accounts].Last_year, FORMAT([AccountDB].[dbo].[Accounts].Summ, 'C', 'de-de') AS \"Sum on account\" FROM[AccountDB].[dbo].[Accounts] INNER JOIN[AccountDB].[dbo].[Usesr_Accounts]" + " ON[AccountDB].[dbo].[Accounts].AccNumber = [AccountDB].[dbo].[Usesr_Accounts].AccNumber WHERE[AccountDB].[dbo].[Usesr_Accounts].UserID = "; mySQL += user_id + " ORDER BY "; if (comboBoxSort.Text.Trim() == "Account Number") { mySQL += "[AccountDB].[dbo].[Accounts].AccNumber"; } if (comboBoxSort.Text.Trim() == "Owner name") { mySQL += "[AccountDB].[dbo].[Accounts].Firstname"; } if (comboBoxSort.Text.Trim() == "Owner surname") { mySQL += "[AccountDB].[dbo].[Accounts].Lastname"; } if (comboBoxSort.Text.Trim() == "Last year") { mySQL += "[AccountDB].[dbo].[Accounts].Last_year"; } if (comboBoxSort.Text.Trim() == "Sum on account") { mySQL += "\"Sum on account\""; } DataTable userData = Server_connection.executeSQL(mySQL); if (userData.Rows.Count > 0) { dataGridViewAccounts.DataSource = userData; } else { MessageBox.Show("You should chooce by what value to sort"); } }
private void btnSearch_Click_1(object sender, EventArgs e) { string mySQL = string.Empty; mySQL += "SELECT [AccountDB].[dbo].[Accounts].AccNumber, [AccountDB].[dbo].[Accounts].Firstname,[AccountDB].[dbo].[Accounts].Lastname, " + " [AccountDB].[dbo].[Accounts].Last_year, FORMAT([AccountDB].[dbo].[Accounts].Summ, 'C', 'de-de') AS \"Sum on account\" FROM[AccountDB].[dbo].[Accounts] INNER JOIN[AccountDB].[dbo].[Usesr_Accounts]" + " ON[AccountDB].[dbo].[Accounts].AccNumber = [AccountDB].[dbo].[Usesr_Accounts].AccNumber WHERE [AccountDB].[dbo].[Usesr_Accounts].UserID = "; mySQL += user_id + " AND [AccountDB].[dbo].[Usesr_Accounts]."; if (comboBoxSearch.Text.Trim() == "Account Number") { mySQL += "AccNumber = " + txtSearch.Text.Trim(); } if (comboBoxSearch.Text.Trim() == "Owner name") { mySQL += "Firstname = '" + txtSearch.Text.Trim() + "'"; } if (comboBoxSearch.Text.Trim() == "Owner surname") { mySQL += "Lastname = '" + txtSearch.Text.Trim() + "'"; } if (comboBoxSearch.Text.Trim() == "Last year") { mySQL += "Last_year = " + txtSearch.Text.Trim(); } if (comboBoxSearch.Text.Trim() == "Sum on account") { mySQL += "Summ = " + txtSearch.Text.Trim(); } DataTable userData = Server_connection.executeSQL(mySQL); if (userData.Rows.Count > 0) { dataGridViewAccounts.DataSource = userData; } else { MessageBox.Show("No matches finded"); } }