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