private void btnUploadAsset_Click(object sender, EventArgs e) { bool errorDetected = false; if (txtTitle.Text == string.Empty) { lblErrorTitle.Show(); errorDetected = true; } if (cboProjectType.SelectedIndex < 0) { lblErrorAssetType.Show(); errorDetected = true; } if (errorDetected == false) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); formMain.curSelectedUserProjectID = dataBase.AddProject(_userProject.GetProjectTitle(), _userProject.GetProjectType(), _userProject.GetNotes(), (int)formMain.UsersAccounts.GetCurrentUser().GetUserID(), ProjectTag.Game, ProjectStatus.In_Development); dataBase.CloseConnection(); formMain.ChangeToPage(FormMain.Pages.EditProjectPage); } }
public MyAssetsPageControl(FormMain form, string message) { InitializeComponent(); formMain = form; DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); if (message == "project") { curUserProjects = dataBase.getOwnedProjectsOfUser((int)formMain.UsersAccounts.GetCurrentUser().GetUserID()); } else if (message == "asset") { curUserAssets = dataBase.getAssetsOfUser((int)formMain.UsersAccounts.GetCurrentUser().GetUserID()); } dataBase.CloseConnection(); if (curUserAssets != null && message == "asset") { HelperTools.CreateAssetButtons(new Point(48, 104), formMain, this, curUserAssets.Count, 5, curUserAssets); } else if (curUserProjects != null && message == "project") { HelperTools.CreateAssetButtons(new Point(48, 104), formMain, this, curUserProjects.Count, 5, null, curUserProjects); } }
public EditProjectPageControl(FormMain form, int?curUserProjectID) { InitializeComponent(); formMain = form; _curUserProjectID = curUserProjectID; if (formMain.UsersAccounts.GetCurrentUser() != null) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); _curUserProject = dataBase.getProject((int)curUserProjectID); dataBase.CloseConnection(); if (curUserProjectID == null || _curUserProject == null) { MessageBox.Show("Error: Asset Not Found"); } else { txtTitle.Text = _curUserProject.GetProjectTitle(); cboProjectType.SelectedIndex = (int)_curUserProject.GetProjectType(); txtNotes.Text = _curUserProject.GetNotes(); picThumbnail.ImageLocation = _curUserProject.GetThumbNail(); _userProject.SetProjectTitle(_curUserProject.GetProjectTitle()); _userProject.SetProjectType(_curUserProject.GetProjectType()); _userProject.SetNotes(_curUserProject.GetNotes()); } } else { MessageBox.Show("Error: No user logged in"); } }
private void btnEdit_Click(object sender, EventArgs e) { if (!isAccountInfoEditable) { txtEmail.ReadOnly = false; txtName.ReadOnly = false; btnEdit.Text = "Confirm Changes!"; isAccountInfoEditable = true; } else { txtEmail.ReadOnly = true; txtName.ReadOnly = true; DataBaseAccess dataBaseAccess = new DataBaseAccess(); dataBaseAccess.StartConnection(); if (txtEmail.Text.Contains('@') && formMain.UsersAccounts.RetrieveUserData(txtEmail.Text) == null) { dataBaseAccess.ChangeUserEmail(_currentUser.userName, txtEmail.Text); } if (txtName.Text.Count() >= 1 && txtName.Text.Count() < 12) { dataBaseAccess.ChangeUserFullName((int)_currentUser.GetUserID(), txtName.Text); } formMain.UsersAccounts.SetCurrentUser(dataBaseAccess.GetUser((int)_currentUser.GetUserID())); dataBaseAccess.CloseConnection(); btnEdit.Text = "Edit User Information"; isAccountInfoEditable = false; } }
public void AddUser(UserData _userData) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); dataBase.AddUser(_userData._password, _userData.emailAddress, _userData.userName, UserType.Developer, _userData.fullName); dataBase.CloseConnection(); }
private void btnChangeProfilePic_Click(object sender, EventArgs e) { string file = HelperTools.LoadFromFile(); string databasePath = HelperTools.AddFileToStorage(file, (int)_currentUser.GetUserID()); DataBaseAccess dataBaseAccess = new DataBaseAccess(); dataBaseAccess.StartConnection(); dataBaseAccess.ChangeUserProfile((int)_currentUser.GetUserID(), databasePath); dataBaseAccess.CloseConnection(); }
public ViewAssetPageControl(FormMain form, int?userAssetID) { formMain = form; _userAssetID = userAssetID; DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); _userAsset = dataBase.getAsset((int)userAssetID); dataBase.CloseConnection(); _curUserData = formMain.UsersAccounts.GetCurrentUser(); InitializeComponent(); if (formMain.UsersAccounts.GetCurrentUser() != null) { if (_userAsset == null) { formMain.ChangeToPage(FormMain.Pages.HomePage); } else { if (_curUserData.GetUserID() == _userAsset.GetAuthor().GetUserID()) { btnEdit.Show(); } } } galPictureGallery.SetToLarge(); galPictureGallery.IsEditable(false); galPictureGallery.AddPicturesToGallery(_userAsset.GetPicturesPath()); pictureBox1.ImageLocation = _userAsset.GetThumbNail(); lblTitleDisplay.Text = _userAsset.GetAssetTitle(); lblAssetTypeDisplay.Text = _userAsset.GetAssetType().ToString(); lblSoftwareDisplay.Text = _userAsset.GetSoftwareUsed(); lblPegiDisplay.Text = _userAsset.GetPegiRating().ToString(); lblAssetStatusDisplay.Text = _userAsset.GetAssetStatus().ToString(); lblCreatorDisplay.Text = _userAsset.GetAuthor().userName; lblDescription.Text = _userAsset.GetNotes(); starOverall._canSetRating = false; if (_curUserData == null) { starRating.Visible = false; lblRatingMessage.Visible = false; } else { starRating.valueChangedEvent += rating_Click; } }
public UserData RetrieveUserData(string UsernameOrEmail) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); UserData userData = dataBase.GetUser(UsernameOrEmail); dataBase.CloseConnection(); if (userData != null) { return(userData); } return(null); }
private void updateOverallRating(object sender, EventArgs e) { DataBaseAccess database = new DataBaseAccess(); database.StartConnection(); // update the average stars int averageStars = (int)Math.Round(database.GetAverageStarRating(_userAsset.GetID())); int numberRatings = database.GetAmountOfRatingsForAsset(_userAsset.GetID()); starOverall.UpdateStarsGraphics(averageStars); lblRatingTotal.Text = numberRatings + " People Rated This Overall"; database.CloseConnection(); }
private void btnUploadAsset_Click(object sender, EventArgs e) { bool errorDetected = false; if (txtTitle.Text == string.Empty) { lblErrorTitle.Show(); errorDetected = true; } if (cboAssetType.SelectedIndex < 0) { lblErrorAssetType.Show(); errorDetected = true; } if (txtSoftwareUsed.Text == string.Empty) { lblErrorSoftwareUsed.Show(); errorDetected = true; } if (cboPegi.SelectedIndex < 0) { lblErrorPegi.Show(); errorDetected = true; } if (cboAssetType.SelectedIndex < 0) { lblErrorAssetStatus.Show(); errorDetected = true; } if (_assetUploaded == false) { lblErrorAssetStatus.Show(); errorDetected = true; } if (errorDetected == false) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); int assetDatabaseID = dataBase.AddAsset(_userAsset.GetAssetTitle(), (int)formMain.UsersAccounts.GetCurrentUser().GetUserID(), _userAsset.GetAssetStatus(), _userAsset.GetAssetType(), _userAsset.GetSoftwareUsed(), _userAsset.GetNotes(), "", _userAsset.GetPegiRating()); dataBase.ChangeAssetPath(assetDatabaseID, HelperTools.AddFileToStorage(_assetFilePath, (int)_curUserID, assetDatabaseID)); dataBase.CloseConnection(); formMain.curSelectedAssetID = assetDatabaseID; formMain.ChangeToPage(FormMain.Pages.EditAssetPage); } }
private void btnConfirmChanges_Click(object sender, EventArgs e) { bool errorDetected = false; if (txtTitle.Text == string.Empty || txtTitle.Text == "Title") { lblErrorTitle.Show(); errorDetected = true; } if (cboProjectType.SelectedIndex < 0) { lblErrorProjectType.Show(); errorDetected = true; } if (errorDetected == false) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); if (_curUserProject.GetProjectTitle() != _userProject.GetProjectTitle()) { dataBase.ChangeProjectName((int)_curUserProjectID, _userProject.GetProjectTitle()); } if (_curUserProject.GetProjectType() != _userProject.GetProjectType()) { dataBase.ChangeProjectType((int)_curUserProjectID, _userProject.GetProjectType()); } if (_curUserProject.GetNotes() != _userProject.GetNotes()) { dataBase.ChangeProjectDescription((int)_curUserProjectID, _userProject.GetNotes()); } if (_thumbNailPic != null) { dataBase.ChangeProjectThumbnail((int)_curUserProjectID, _thumbNailPic); } dataBase.CloseConnection(); formMain.curSelectedUserProjectID = _curUserProjectID; formMain.ChangeToPage(FormMain.Pages.ViewProjectPage); } }
public EditAssetPageControl(FormMain form, int?userAssetID) { _userAssetID = userAssetID; DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); _curUserAsset = dataBase.getAsset((int)userAssetID); dataBase.CloseConnection(); InitializeComponent(); pictureGallery1.InitializePictureGallery((int)_curUserAsset.GetAuthor().GetUserID(), (int)_userAssetID); formMain = form; if (formMain.UsersAccounts.GetCurrentUser() != null) { if (_curUserAsset == null || userAssetID == null) { MessageBox.Show("Error: Asset Not Found"); } else { txtTitle.Text = _curUserAsset.GetAssetTitle(); cboAssetType.SelectedIndex = (int)_curUserAsset.GetAssetType(); txtSoftwareUsed.Text = _curUserAsset.GetSoftwareUsed(); cboPegi.SelectedIndex = (int)_curUserAsset.GetPegiRating(); cboAssetStatus.SelectedIndex = (int)_curUserAsset.GetAssetStatus() - 1; txtNotes.Text = _curUserAsset.GetNotes(); pictureGallery1.AddPicturesToGallery(_curUserAsset.GetPicturesPath()); picThumbnail.ImageLocation = _curUserAsset.GetThumbNail(); _userAsset.SetAssetTitle(_curUserAsset.GetAssetTitle()); _userAsset.SetAssetStatus(_curUserAsset.GetAssetStatus()); _userAsset.SetAssetType(_curUserAsset.GetAssetType()); _userAsset.SetSoftwareUsed(_curUserAsset.GetSoftwareUsed()); _userAsset.SetPegiRating(_curUserAsset.GetPegiRating()); _userAsset.SetNotes(_curUserAsset.GetNotes()); } } else { MessageBox.Show("Error: No user logged in"); } }
private void txtSearchAsset_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e) { if (e.KeyCode == Keys.Enter) { if (_assetButtons != null) { for (int i = 0; i < _assetButtons.Count; i++) { _assetButtons[i].Dispose(); this.Controls.Remove(_assetButtons[i]); } } DataBaseAccess data = new DataBaseAccess(); data.StartConnection(); List <UserAsset> userAssets = data.SearchAsset(txtSearchAsset.Text); data.CloseConnection(); _assetButtons = HelperTools.CreateAssetButtons(new Point(160, 150), formMain, this, userAssets.Count(), 2, userAssets); } }
public ViewProjectPageControl(FormMain form, int?userProjectID) { InitializeComponent(); formMain = form; _userProjectID = userProjectID; DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); _userProject = dataBase.getProject((int)userProjectID); dataBase.CloseConnection(); _curUserData = formMain.UsersAccounts.GetCurrentUser(); InitializeComponent(); if (formMain.UsersAccounts.GetCurrentUser() != null) { if (_userProject == null) { formMain.ChangeToPage(FormMain.Pages.HomePage); } else { if (_curUserData.GetUserID() == _userProject.GetAuthor().GetUserID()) { btnEdit.Show(); } } } lblTitleDisplay.Text = _userProject.GetProjectTitle(); lblAssetTypeDisplay.Text = _userProject.GetProjectType().ToString(); lblCreatorDisplay.Text = _userProject.GetAuthor().userName; lblDescriptionDisplay.Text = _userProject.GetNotes(); picThumbNail.ImageLocation = _userProject.GetThumbNail(); picThumbNail.Show(); }
private void rating_Click(object sender, EventArgs e) { DataBaseAccess database = new DataBaseAccess(); database.StartConnection(); // if already added a rating then change it if (database.UserRatedAsset((int)_curUserData.GetUserID(), _userAsset.GetID())) { int ratingId = -1; List <Classes.UserRating> ratingsOfAsset = database.GetRatingsOfAsset(_userAsset.GetID()); // get the rating id of the previous rating for (int i = 0; i < ratingsOfAsset.Count; i++) { if (ratingsOfAsset[i].ReviewerID == _curUserData.GetUserID()) { ratingId = ratingsOfAsset[i].ID; break; } } if (ratingId != -1) { database.ChangeRatingStars(ratingId, starRating._rating); } } // if not rated yet then add rating else { database.AddRating((int)_curUserData.GetUserID(), _userAsset.GetID(), starRating._rating, ""); } updateOverallRating(sender, e); database.CloseConnection(); }
private void btnConfirmChanges_Click(object sender, EventArgs e) { bool errorDetected = false; if (txtTitle.Text == string.Empty || txtTitle.Text == "Title") { lblErrorTitle.Show(); errorDetected = true; } if (cboAssetType.SelectedIndex < 0) { lblErrorAssetType.Show(); errorDetected = true; } if (txtSoftwareUsed.Text == string.Empty || txtSoftwareUsed.Text == "Software Used") { lblErrorSoftwareUsed.Show(); errorDetected = true; } if (cboPegi.SelectedIndex < 0) { lblErrorPegi.Show(); errorDetected = true; } if (cboAssetStatus.SelectedIndex < 0) { lblErrorAssetStatus.Show(); errorDetected = true; } if (errorDetected == false) { DataBaseAccess dataBase = new DataBaseAccess(); dataBase.StartConnection(); if (_curUserAsset.GetAssetTitle() != _userAsset.GetAssetTitle()) { dataBase.ChangeAssetName((int)_userAssetID, _userAsset.GetAssetTitle()); } if (_curUserAsset.GetAssetType() != _userAsset.GetAssetType()) { dataBase.ChangeAssetType((int)_userAssetID, _userAsset.GetAssetType()); } if (_curUserAsset.GetSoftwareUsed() != _userAsset.GetSoftwareUsed()) { dataBase.ChangeAssetSoftware((int)_userAssetID, _userAsset.GetSoftwareUsed()); } if (_curUserAsset.GetAssetStatus() != _userAsset.GetAssetStatus()) { dataBase.ChangeAssetStatus((int)_userAssetID, _userAsset.GetAssetStatus()); } if (_curUserAsset.GetNotes() != _userAsset.GetNotes()) { dataBase.ChangeAssetNotes((int)_userAssetID, _userAsset.GetNotes()); } if (_thumbNailPic != null) { dataBase.ChangeAssetThumbnail((int)_userAssetID, _thumbNailPic); } List <string> tempPictureHolder = pictureGallery1.GetPicturesPathFromGallery(); _curUserAsset.SetPicturesPath(tempPictureHolder); if (tempPictureHolder.Count >= 1) { dataBase.ChangeAssetGalleryOne((int)_userAssetID, tempPictureHolder[0]); } if (tempPictureHolder.Count >= 2) { dataBase.ChangeAssetGalleryTwo((int)_userAssetID, tempPictureHolder[1]); } if (tempPictureHolder.Count >= 3) { dataBase.ChangeAssetGalleryThree((int)_userAssetID, tempPictureHolder[2]); } if (tempPictureHolder.Count >= 4) { dataBase.ChangeAssetGalleryFour((int)_userAssetID, tempPictureHolder[3]); } if (tempPictureHolder.Count >= 5) { dataBase.ChangeAssetGalleryFive((int)_userAssetID, tempPictureHolder[4]); } dataBase.CloseConnection(); formMain.curSelectedAssetID = _userAssetID; formMain.ChangeToPage(FormMain.Pages.ViewAssetPage); } }