private void Review(HttpContext context) { string answer = context.Request.Params["ans"]; string question = context.Request.Params["ques"]; int bimid = int.Parse(context.Request.Params["bimid"]); Data.dbml.Review review = GetDataContext2.Review.FirstOrDefault(o => o.BIMID == bimid && (o.UserID == Common.UserID || o.SessionID == Common.SessionID)); if (review == null) { review = new Data.dbml.Review(); review.Answer = answer; review.BIMID = bimid; review.Question = question; review.UserID = Common.UserID; review.SessionID = Common.SessionID; GetDataContext2.Review.InsertOnSubmit(review); if (Common.UserID.HasValue) { GetDataContext1.Update(new Data.POCOS.AppUser() { ID = Common.UserID.Value, Points = Common.Points }, new[] { "Points" }); } } else { review.Answer = answer; review.Question = question; } GetDataContext2.SubmitChanges(); var q = from o in GetDataContext2.Review where (o.UserID == Common.UserID || o.SessionID == Common.SessionID) select o.BIMID; context.WriteJsonP(JsonConvert.SerializeObject(q)); }
private void UpdateAbout(HttpContext context) { string about = context.Request.Params["about"]; GetDataContext1.Update(new Data.POCOS.AppUser() { About = about, ID = Common.UserID.Value }, new string[] { "About" }); }