public String AddTechs(String username, String firstname, String lastname, String password) { TechSupport tech = new TechSupport(username, firstname, lastname, password); database.addTech(tech); return("Admin was created"); }
public formManageUsers(TechSupport tech, formTechSupport parent) { InitializeComponent(); this.tech = tech; this.parent = parent; userslist = database.getAllAccounts(); loadTable(tech); dgvUsers.CurrentCell = dgvUsers.Rows[0].Cells["colPassword"]; }
public formTechSupport(Account tech, Home parent) : base(tech, parent) { InitializeComponent(); tickets = database.getAllTickets(); this.tech = (TechSupport)tech; this.parent = parent; ticketComboBox.DropDownStyle = ComboBoxStyle.DropDownList; ticketBox(this.tech); }
private void loadTable(TechSupport tech) { for (int i = 0; i < userslist.Count; i++) { if (userslist[i].Username != tech.Username) { string[] row = new string[] { userslist[i].Username, userslist[i].Password, userslist[i].Disabled.ToString() }; dgvUsers.Rows.Add(row); } } }
private void ticketBox(TechSupport tech) { dgvTicketBox.Rows.Clear(); tickets = database.getAllTickets(); for (int i = 0; i < tickets.Count; i++) /* Fill the table with values instead of the current representative */ { string[] row = new string[] { tickets[i].Id.ToString(), tickets[i].Username, tickets[i].Details, tickets[i].Representative, tickets[i].Date }; dgvTicketBox.Rows.Add(row); } }
public void addTech(TechSupport tech) { m_dbConnection = new SQLiteConnection(db_Address); m_dbConnection.Open(); string sql = "INSERT INTO Accounts(username, fname, lname, password, permission, disabled) VALUES(" + "'" + tech.Username + "'," + "'" + tech.Fname + "'," + "'" + tech.Lname + "'," + "'" + tech.Password + "'," + "1," + "0" + ");" + "INSERT INTO TechSupport(username) VALUES(" + "'" + tech.Username + "'" + ");"; SQLiteCommand query = new SQLiteCommand(sql, m_dbConnection); query.ExecuteNonQuery(); }
public formSettingsTechSupport(TechSupport tech, formTechSupport parent) { InitializeComponent(); this.tech = tech; this.parent = parent; }
private void btnSignUp_Click(object sender, EventArgs e) { resetValidLables(); List <bool> valid = new List <bool>(); Program.permissionLevels permission = (Program.permissionLevels)cbFormType.SelectedItem; switch (permission) { case Program.permissionLevels.User: valid.Add(checkIfUsernameExists()); valid.Add(checkUsername()); valid.Add(checkPassword()); valid.Add(checkPasswordsMatch()); valid.Add(checkFname()); valid.Add(checkLname()); valid.Add(checkDate()); valid.Add(checkCity()); valid.Add(checkMaritalStatus()); valid.Add(checkInfo()); break; case Program.permissionLevels.TechSupport: valid.Add(checkIfUsernameExists()); valid.Add(checkUsername()); valid.Add(checkPassword()); valid.Add(checkPasswordsMatch()); valid.Add(checkFname()); valid.Add(checkLname()); break; case Program.permissionLevels.Admin: valid.Add(checkIfUsernameExists()); valid.Add(checkUsername()); valid.Add(checkPassword()); valid.Add(checkPasswordsMatch()); valid.Add(checkFname()); valid.Add(checkLname()); break; default: MessageBox.Show("Exceptional Exception - permission unknown - exiting program"); return; break; } if (valid.Contains(false) == false) { switch (permission) { case Program.permissionLevels.User: User user = new User(txtUsername.Text, txtFname.Text, txtLname.Text, txtPassword.Text, cbMaritalStatus.SelectedText, txtDob.Text, txtCity.Text, txtInfo.Text, ""); this.database.addUser(user); break; case Program.permissionLevels.TechSupport: TechSupport tech = new TechSupport(txtUsername.Text, txtFname.Text, txtLname.Text, txtPassword.Text); this.database.addTech(tech); break; case Program.permissionLevels.Admin: Admin admin = new Admin(txtUsername.Text, txtFname.Text, txtLname.Text, txtPassword.Text); this.database.addAdmin(admin); break; default: MessageBox.Show("Exceptional Exception - permission unknown - exiting program"); return; break; } MessageBox.Show("Succesful!"); this.Close(); } }
public Account Login(String AccUsername, String AccPassword) { m_dbConnection = new SQLiteConnection(db_Address); m_dbConnection.Open(); string sql = "SELECT * FROM Accounts WHERE username LIKE '" + AccUsername + "' AND password LIKE '" + AccPassword + "'"; SQLiteCommand query = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = query.ExecuteReader(); if (reader.Read()) { string username = reader["username"].ToString(); string password = reader["password"].ToString(); string fname = reader["fname"].ToString(); string lname = reader["lname"].ToString(); int permission = Int32.Parse(reader["permission"].ToString()); bool disabled = (Int32.Parse(reader["disabled"].ToString()) == 1) ? true : false; if (permission == 0) { reader.Close(); sql = "SELECT * FROM Users WHERE username LIKE '" + AccUsername + "'"; query.CommandText = sql; reader = query.ExecuteReader(); if (reader.Read()) { string maritalStatus = reader["maritalStatus"].ToString(); string dob = reader["dob"].ToString(); string city = reader["city"].ToString(); string info = reader["info"].ToString(); string status = reader["status"].ToString(); reader.Close(); User temp = new User(username, fname, lname, password, maritalStatus, dob, city, info, status); temp.Disabled = disabled; return(temp); } } else if (permission == 1) { reader.Close(); sql = "SELECT * FROM TechSupport WHERE username LIKE '" + AccUsername + "'"; query.CommandText = sql; reader = query.ExecuteReader(); if (reader.Read()) { long workerID = (long)reader["workerID"]; reader.Close(); TechSupport temp = new TechSupport(username, fname, lname, password); temp.Disabled = disabled; return(temp); } } else { reader.Close(); Admin temp = new Admin(username, fname, lname, password); temp.Disabled = disabled; return(temp); } } reader.Close(); return(null); }
public List <Account> getAllAccounts() { m_dbConnection = new SQLiteConnection(db_Address); m_dbConnection.Open(); string sql = "SELECT * FROM Accounts"; SQLiteCommand query = new SQLiteCommand(sql, m_dbConnection); SQLiteCommand querySpecific = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = query.ExecuteReader(); SQLiteDataReader readerSpecific; List <Account> list = new List <Account>(); while (reader.Read()) { string username = reader["username"].ToString(); string password = reader["password"].ToString(); string fname = reader["fname"].ToString(); string lname = reader["lname"].ToString(); int permission = Int32.Parse(reader["permission"].ToString()); bool disabled = ((reader["disabled"].ToString() == "1") ? true : false); if (permission == 0) { sql = "SELECT * FROM Users WHERE username LIKE '" + username + "'"; querySpecific.CommandText = sql; readerSpecific = querySpecific.ExecuteReader(); if (readerSpecific.Read()) { string maritalStatus = readerSpecific["maritalStatus"].ToString(); string dob = readerSpecific["dob"].ToString(); string city = readerSpecific["city"].ToString(); string info = readerSpecific["info"].ToString(); string status = readerSpecific["status"].ToString(); User user = new User(username, fname, lname, password, disabled, maritalStatus, dob, city, info, status); list.Add(user); } readerSpecific.Close(); } else if (permission == 1) { sql = "SELECT * FROM TechSupport WHERE username LIKE '" + username + "'"; querySpecific.CommandText = sql; readerSpecific = querySpecific.ExecuteReader(); if (readerSpecific.Read()) { String workerID = readerSpecific["workerID"].ToString(); TechSupport tech = new TechSupport(username, fname, lname, password, disabled); list.Add(tech); } readerSpecific.Close(); } else { Admin admin = new Admin(username, fname, lname, password, disabled); list.Add(admin); } } reader.Close(); return(list); }