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);
}
