public AdminRegisterInterface() { adminInterFace = new AdminInterFace(); ul = new UserInformation(); ulc = new UserContoller(); helper = new FormsHelper(); InitializeComponent(); }
public LoginPage() { helper = new FormsHelper(); ulc = new UserContoller(); ul = new UserInformation(); userInterface = new UserInterFace(); adminInterFace = new AdminInterFace(); car = new CarInformation(); carController = new CarController(); rentedContoller = new RentedContoller(); //txtMailAdress.Text = "*****@*****.**"; //txtPassword.Text = "12345678"; InitializeComponent(); }
//Updates a current user in the SQL database. public static void UpdateUser(string currentEmail, string newEmail, string NewPassword, int userId) { if (GetUserID(currentEmail) != userId) { throw new System.InvalidOperationException("Invalid data. Incorrect userId"); } //Checks to make sure the new data is valid. UserContoller.EmailValidityCheck(newEmail, NewPassword); try { SqlConnectionStringBuilder builder = DatabaseController.ConnectionBuilder(); using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); SqlCommand query = new SqlCommand(null, connection); query.CommandText = "UPDATE dbo.End_User SET email = @email, passwordValue = @password WHERE userID = @Id;"; SqlParameter emailPar = new SqlParameter("@email", SqlDbType.VarChar, 255); SqlParameter passwordPar = new SqlParameter("@password", SqlDbType.VarChar, 255); SqlParameter idPar = new SqlParameter("@Id", SqlDbType.Int, 255); emailPar.Value = newEmail; passwordPar.Value = NewPassword; idPar.Value = userId; query.Parameters.Add(emailPar); query.Parameters.Add(passwordPar); query.Parameters.Add(idPar); query.Prepare(); query.ExecuteNonQuery(); } } catch (SqlException e) { Console.WriteLine(e.ToString()); } return; }
//Will add a new user to the SQL database. public static void AddUser(string email, string password) { //Checks to make sure the new data is valid UserContoller.EmailValidityCheck(email, password); //check to see if that email is in the database. if (GetUserID(email) > 0) { throw new System.InvalidOperationException("Invalid data. email is taken."); } try { SqlConnectionStringBuilder builder = DatabaseController.ConnectionBuilder(); using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); SqlCommand query = new SqlCommand(null, connection); query.CommandText = "INSERT INTO dbo.End_User(email, passwordValue) VALUES (@email, @password)"; SqlParameter emailPar = new SqlParameter("@email", SqlDbType.VarChar, 255); SqlParameter passwordPar = new SqlParameter("@password", SqlDbType.VarChar, 255); emailPar.Value = email; passwordPar.Value = password; query.Parameters.Add(emailPar); query.Parameters.Add(passwordPar); query.Prepare(); query.ExecuteNonQuery(); } } catch (SqlException e) { Console.WriteLine(e.ToString()); } return; }
private void Awake() { instance = this; //DontDestroyOnLoad(gameObject); userInfo = Client.instance.connectedClient.currentUser; }