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