Example #1
0
 public AdminRegisterInterface()
 {
     adminInterFace = new AdminInterFace();
     ul             = new UserInformation();
     ulc            = new UserContoller();
     helper         = new FormsHelper();
     InitializeComponent();
 }
Example #2
0
        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();
        }
Example #3
0
        //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;
        }
Example #4
0
        //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;
        }
Example #5
0
 private void Awake()
 {
     instance = this;
     //DontDestroyOnLoad(gameObject);
     userInfo = Client.instance.connectedClient.currentUser;
 }