public static LoginHandler.User SearchBlockData(User username) { LoginHandler.User user = username; try { conn.Open(); //parametroi sto query searchCommand = new OleDbCommand(@"SELECT * FROM [Blocked] WHERE User_id=?", conn); searchCommand.Parameters.AddWithValue("@p1", user.userID); searchReader = searchCommand.ExecuteReader(); while (searchReader.Read()) { //set profile data user.blockID = searchReader.GetInt32(0); user.reason = searchReader.GetString(2); user.blockedDays = searchReader.GetInt32(3); user.isBlocked = searchReader.GetBoolean(4); } searchReader.Close(); conn.Close(); return(user); } catch (Exception ex) { Console.WriteLine(ex.Message); conn.Close(); } return(new LoginHandler.User()); }
public static bool UpdateUserData(User username) { LoginHandler.User user = username; try { conn.Open(); //parametroi sto query searchCommand = new OleDbCommand(@"Update [User] Set Email = ?,First_name = ?,Last_name = ? Where User_id = ?;", conn); //searchCommand.Parameters.AddWithValue("@p1", user.username); searchCommand.Parameters.AddWithValue("@p1", user.email); searchCommand.Parameters.AddWithValue("@p2", user.name); searchCommand.Parameters.AddWithValue("@p3", user.surname); searchCommand.Parameters.AddWithValue("@p4", user.userID); searchReader = searchCommand.ExecuteReader(); int countRow = 0; while (searchReader.Read()) { countRow++; } Console.WriteLine("Records found: " + countRow); searchReader.Close(); conn.Close(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); conn.Close(); return(false); } }
public static LoginHandler.User SearchAccountData(string username) { LoginHandler.User user = new LoginHandler.User(); try { conn.Open(); //parametroi sto query searchCommand = new OleDbCommand(@"SELECT * FROM [User] WHERE Username=?", conn); searchCommand.Parameters.AddWithValue("@p1", username); searchReader = searchCommand.ExecuteReader(); int countRow = 0; while (searchReader.Read()) { //set profile data user.userID = searchReader.GetInt32(0); user.username = searchReader.GetString(1); user.role = searchReader.GetString(3); user.email = searchReader.GetString(4); user.name = searchReader.GetString(5); user.surname = searchReader.GetString(6); countRow++; } Console.WriteLine("Records found: " + countRow); searchReader.Close(); conn.Close(); return(user); } catch (Exception ex) { Console.WriteLine(ex.Message); conn.Close(); } return(new LoginHandler.User()); }
private void LoadUserFields() { if (!String.IsNullOrWhiteSpace(SearchIDBox.Text)) { warningLabel.Visible = false; LoginHandler.User user = DBConnection.SearchAccountData(SearchIDBox.Text); if (user.name != null) { warningLabel.Visible = false; UserIDBox.Text = "" + user.userID; RoleBox.Text = user.role; NameBox.Text = user.name; LastNameBox.Text = user.surname; EmailBox.Text = user.email; user = DBConnection.SearchBlockData(user); if (user.reason != null) { BlockData.blockID = user.blockID; BlockData.reason = user.reason; BlockData.days = user.blockedDays; BlockData.blocked = user.isBlocked; if (BlockData.blocked) { BlockButton.Text = "Unblock"; } } else { BlockData.blockID = 0; BlockData.reason = ""; BlockData.days = 0; BlockButton.Text = "Block"; } } else { warningLabel.Text = "This user does not exist."; warningLabel.Visible = true; } } else { warningLabel.Text = "Please input a username."; warningLabel.Visible = true; } }