protected void UpdateJobViewedCount()
{
var request = HttpContext.Current.Request;
Uri svcUri = new Uri(Request.Url.GetLeftPart(UriPartial.Authority) + Request.ApplicationPath
+ "Services/TopTenWcfDataService.svc");
try
{
TopTenWcfDataServiceRef.JobRepoDataContext context
= new TopTenWcfDataServiceRef.JobRepoDataContext(svcUri);
int JobID = (request.QueryString["JJ"] != null ? Convert.ToInt32(request.QueryString["JJ"]) : 0);
/*The following query will be transfered to
* http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs()?$filter=JobID eq 15
* http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs()?$filter=JobID%20eq%2015
*/
DataServiceQuery <TopTenWcfDataServiceRef.Job> jobs = context.Jobs
.AddQueryOption("$filter", "JobID eq " + JobID.ToString());
var job = jobs.Single();
/*
* We can get the same result using LINQ Query:
* var job = (from j in context.Jobs
* where j.JobID.Equals(JobID)
* select j).Single();
* it will will be transfered to
* http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs(15)
*/
if (job != null)
{
job.Viewed += 1;
context.UpdateObject(job);
context.SaveChanges();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
