protected void Page_Load(object sender, EventArgs e)
{
int reviewId = Convert.ToInt32(Request.QueryString.Get("intReviewID"));
string cacheKey = "TReviews" + reviewId.ToString();
TReview myReview = Cache[cacheKey] as TReview;
if (myReview == null)
{
using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
{
myReview = (from r in myEntities.TReviews
where r.ID == reviewId
select r).SingleOrDefault();
if (myReview != null)
{
Cache.Insert(cacheKey, myReview, null, DateTime.Now.AddMinutes(20), System.Web.Caching.Cache.NoSlidingExpiration);
}
}
}
if (myReview != null)
{
lblTitleLabel.Text = myReview.strTitle;
lblSummaryLabel.Text = myReview.strSummary;
lblBodyLabel.Text = myReview.strBody;
Title = myReview.strTitle;
MetaDescription = myReview.strSummary;
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
{
TReview myReview;
if (_id == -1) // Insert new item
{
myReview = new TReview();
myReview.dtmCreateDateTime = DateTime.Now;
myReview.dtmUpdateDateTime = myReview.dtmCreateDateTime;
myEntities.AddToTReviews(myReview);
}
else // update existing item
{
myReview = (from r in myEntities.TReviews
where r.ID == _id
select r).Single();
myReview.dtmUpdateDateTime = DateTime.Now;
}
myReview.strTitle = TitleText.Text;
myReview.strSummary = SummaryText.Text;
myReview.strBody = BodyText.Text;
myReview.intGenreID = Convert.ToInt32(GenreList.SelectedValue);
myReview.blnAuthorized = Authorized.Checked;
myEntities.SaveChanges();
Response.Redirect("Reviews.aspx");
}
}
