/// <summary>
/// Helper deletes a review from database
/// </summary>
/// <param name="item">a item</param>
private void DeleteReviewFromDatabase(ListViewItem item)
{
// Retrieve item index
int index = Convert.ToInt32(item.DisplayIndex);
// Initialize object
TravelImageRating rating = new TravelImageRating();
rating.Id = Convert.ToInt32(lvImagesReview.DataKeys[index].Values["Id"]);;
// Delete from database
rating.Delete();
}
// <summary>
/// Helper inserts revew intoto database
/// </summary>
/// <param name="item"></param>
private void InsertReviewIntoDatabase(ListViewItem item)
{
// Find text boxes within list view
TextBox tempRating = (TextBox)item.FindControl("tbRating");
TextBox tempComment = (TextBox)item.FindControl("tbComment");
// Create travel image rating object
TravelImageRating rating = new TravelImageRating();
rating.ImageID = _imageID;
rating.Rating = Convert.ToInt32(tempRating.Text);
rating.ReviewDate = DateTime.Now.ToString("MMM-dd-yyyy");
// Comments which are empty will be stored as empty strings
rating.Comment = Convert.ToString(tempComment.Text);
rating.UserName = User.Identity.Name;
// Insert into database
rating.Insert();
}
