private Reviews ConvertToReviews(DbReview review)
{
return(new Reviews
{
BookCode = review.BookCode,
User = review.User,
Review = review.Review
});
}
/// <summary>
/// returns a list of reviews by user
/// </summary>
/// <param name="userId">id of user</param>
/// <returns>list of reviews</returns>
public static List <Review> ReviewsByUser(int userId)
{
var list = new List <Review>();
foreach (DataRow row in DbReview.ReviewsByUser(userId).Rows)
{
list.Add(new Review(row));
}
return(list);
}
/// <summary>
/// inserts or updates a review in the database depending if the user already submitted a review for a game
/// </summary>
/// <param name="content">content of review</param>
/// <param name="gameId">id of game</param>
/// <param name="userId">id of user</param>
/// <param name="stars">start amount between 1-5</param>
public Review(string content, int gameId, int userId, int stars)
{
Content = content;
GameId = gameId;
UserId = userId;
Stars = stars;
if (DbReview.UpdateReview(content, gameId, userId, stars) == 0)
{
DbReview.InsertReview(content, gameId, userId, stars);
}
}
public UserController()
{
rDb = new DbReview();
uDb = new DbUser();
}
private void ExportToTxtButton_Click(object sender, RoutedEventArgs e)
{
ExportToTxtButton.IsEnabled = false;
var revs = DbReviews_DataGrid.SelectedItems;
if (revs.Count == 0)
{
revs = DbReviews_DataGrid.Items;
}
if (revs.Count > 1)
{
CommonOpenFileDialog dialog = new CommonOpenFileDialog()
{
IsFolderPicker = true
};
CommonFileDialogResult result = dialog.ShowDialog();
if (result.ToString() == "Ok")
{
foreach (DbReview rev in revs)
{
string fileName = dialog.FileName + "\\rev_" + rev.Rev_CeneoID + ".txt";
using (StreamWriter sw = new StreamWriter(fileName))
{
sw.WriteLine("ID: " + rev.Rev_CeneoID);
sw.WriteLine("Data: " + rev.Rev_Date);
sw.WriteLine("Reviewer: " + rev.Rev_Reviewer);
sw.WriteLine("Advantages: " + rev.Rev_Advantages);
sw.WriteLine("Defects: " + rev.Rev_Defects);
sw.WriteLine("Review: " + rev.Rev_Content);
sw.WriteLine("Down votes: " + rev.Rev_DownVotes);
sw.WriteLine("Up votes: " + rev.Rev_UpVotes);
sw.WriteLine("Rating: " + rev.Rev_Rating);
sw.WriteLine("Recom: " + rev.Rev_Recom);
}
}
MessageBox.Show("Files are saved in: " + dialog.FileName);
ExportToTxtButton.IsEnabled = true;
}
else
{
ExportToTxtButton.IsEnabled = true;
return;
}
}
else if (revs.Count == 1)
{
DbReview rev = revs[0] as DbReview;
SaveFileDialog dialog = new SaveFileDialog()
{
FileName = "rev_" + rev.Rev_CeneoID + ".txt",
Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*"
};
var result = dialog.ShowDialog();
if (result.Value)
{
using (StreamWriter sw = new StreamWriter(dialog.FileName))
{
sw.WriteLine("ID: " + rev.Rev_CeneoID);
sw.WriteLine("Data: " + rev.Rev_Date);
sw.WriteLine("Reviewer: " + rev.Rev_Reviewer);
sw.WriteLine("Advantages: " + rev.Rev_Advantages);
sw.WriteLine("Defects: " + rev.Rev_Defects);
sw.WriteLine("Review: " + rev.Rev_Content);
sw.WriteLine("Down votes: " + rev.Rev_DownVotes);
sw.WriteLine("Up votes: " + rev.Rev_UpVotes);
sw.WriteLine("Rating: " + rev.Rev_Rating);
sw.WriteLine("Recom: " + rev.Rev_Recom);
}
ExportToTxtButton.IsEnabled = true;
if (MessageBox.Show("File saved!\nDo you want to open new file?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
Process.Start(dialog.FileName);
}
}
else
{
ExportToTxtButton.IsEnabled = true;
return;
}
}
}
