Exemplo n.º 1
0
        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"]);

            Lipstick.dbml.Review review = GetLipstickContext2.Review.FirstOrDefault(o => o.BIMID == bimid && (o.UserID == Common.UserID || o.SessionID == Common.SessionID));
            if (review == null)
            {
                review           = new Lipstick.dbml.Review();
                review.Answer    = answer;
                review.BIMID     = bimid;
                review.Question  = question;
                review.UserID    = Common.UserID;
                review.SessionID = Common.SessionID;
                GetLipstickContext2.Review.InsertOnSubmit(review);
                if (Common.UserID.HasValue)
                {
                    GetLipstickContext1.Update(new POCOS.AppUser()
                    {
                        ID = Common.UserID.Value, Points = Common.Points
                    }, new[] { "Points" });
                }
            }
            else
            {
                review.Answer   = answer;
                review.Question = question;
            }
            GetLipstickContext2.SubmitChanges();
            var q = from o in GetLipstickContext2.Review where (o.UserID == Common.UserID || o.SessionID == Common.SessionID) select o.BIMID;

            context.Response.Write(JsonConvert.SerializeObject(q));
        }