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" });
}
private void DelContributor(HttpContext context)
{
string un = context.Request.Params["un"];
string id = context.Request.Params["boardid"];
GetDataContext1.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 DelContent(HttpContext context)
{
string ID = context.Request.Params["ID"];
if (!string.IsNullOrEmpty(ID))
{
GetDataContext1.Delete <Data.POCOS.Content>(int.Parse(ID));
}
context.Response.WriteJsonSuccess();
}
private void UserNameAvail(HttpContext context)
{
string _un = context.Request.Params["un"];
string currentname = (from o in GetDataContext2.AppUsers where o.ID == Common.UserID select o.Name).Single();
if (currentname == _un)
{
context.Response.Write(Common.Domain + _un);
}
else
{
int un = GetDataContext1.Single <int>("Select count(*) from AppUsers where Name=@0", _un);
if (un == 0)
{
context.Response.Write(string.Format(@"{0} is available", _un));
}
else
{
context.Response.WriteError(string.Format(@"{0} not available", _un));
}
}
}
private void DeletePage(HttpContext context)
{
GetDataContext1.Delete <Data.POCOS.Page>(int.Parse(p["id"]));
}
