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"]); EyeShadow.dbml.Review review = GetEyeShadowContext2.Review.FirstOrDefault(o => o.BIMID == bimid && (o.UserID == Common.UserID || o.SessionID == Common.SessionID)); if (review == null) { review = new EyeShadow.dbml.Review(); review.Answer = answer; review.BIMID = bimid; review.Question = question; review.UserID = Common.UserID; review.SessionID = Common.SessionID; GetEyeShadowContext2.Review.InsertOnSubmit(review); if (Common.UserID.HasValue) { GetEyeShadowContext1.Update(new POCOS.AppUser() { ID = Common.UserID.Value, Points = Common.Points }, new[] { "Points" }); } } else { review.Answer = answer; review.Question = question; } GetEyeShadowContext2.SubmitChanges(); var q = from o in GetEyeShadowContext2.Review where (o.UserID == Common.UserID || o.SessionID == Common.SessionID) select o.BIMID; context.Response.Write(JsonConvert.SerializeObject(q)); }
private void DelContributor(HttpContext context) { string un = context.Request.Params["un"]; string id = context.Request.Params["boardid"]; GetEyeShadowContext1.Execute(string.Format(@"DELETE FROM BoardContributor FROM BoardContributor INNER JOIN AppUsers ON BoardContributor.ContributorID = AppUsers.ID WHERE (BoardContributor.BoardID = {0}) AND (AppUsers.Name = '{1}')", id, un)); }
private void UserNameAvail(HttpContext context) { string _un = context.Request.Params["un"]; if (Common.ReadValue("name") == _un) { context.Response.Write("This is your Current User Name"); } else { int un = GetEyeShadowContext1.Single <int>("Select count(*) from AppUsers where Name=@0", _un); context.Response.Write(string.Format(un > 0 ? @"{0} not available" : @"{0} is available", _un)); } }