private void UserProfile_Load(object sender, EventArgs e)
{
string workingDirectory = Environment.CurrentDirectory;
string projectDirectory = Directory.GetParent(workingDirectory).Parent.FullName;
pictureBox1.ImageLocation = projectDirectory + @"\resources\" + user.Gender + ".jpg";
textBox1.Text = user.First_name;
textBox2.Text = user.Last_name;
textBox3.Text = user.Nick;
textBox4.Text = user.Gender.ToString();
textBox5.Text = user.Country;
textBox6.Text = user.Date_of_birth.ToString("dd/MM/yyyy");
textBox7.Text = user.Registration_date.ToString("dd/MM/yyyy");
textBox8.Text = user.Favorit_category.Name;
UserReviewTable userReviewTable = new UserReviewTable();
GameTable gameTable = new GameTable();
ReviewerTable reviewerTable = new ReviewerTable();
List <User_review> reviews = userReviewTable.selectReviewsForUser(user.User_id);
foreach (User_review ur in reviews)
{
reviewBox.Text += ur.ToString() + Environment.NewLine;
}
List <Game> favGames = gameTable.selectFavoritGames(user.User_id);
foreach (Game g in favGames)
{
textBox9.Text += g.ToStringHeader() + Environment.NewLine;
}
List <Reviewer> favRevs = reviewerTable.selectFavoritReviewers(user.User_id);
foreach (Reviewer r in favRevs)
{
textBox10.Text += r.ToStringHeader() + Environment.NewLine;
}
}
private void Button1_Click(object sender, EventArgs e)
{
bool hasTitle = false;
if (!(string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrWhiteSpace(textBox1.Text)))
{
hasTitle = true;
}
int score = comboBox1.SelectedIndex + 1;
int order = comboBox2.SelectedIndex + 1;
int rows = 0;
if (hasTitle && order > 0)
{
UserReviewTable userReviewTable = new UserReviewTable();
User_review userReview = new User_review(textBox1.Text, score, userId, gameId, DateTime.Now, order);
try
{
rows = userReviewTable.insertNew(userReview);
}
catch
{
MessageBox.Show("Something went wrong");
}
}
else
{
MessageBox.Show("Title or order is empty");
}
if (rows > 0)
{
MessageBox.Show("Review successfully submitted");
}
}