public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
int page;
int.TryParse(context.Request.Params["page"], out page);
if (page == 0)
{
page = 1;
}
using (var t1 = new TEST1Entities())
{
var list = t1.UserInfo.OrderBy(c => c.Id).Pager(page, 10);
context.Response.Write(JsonAdapter.Serialize(list.ToFlexigridObject(c => c.Id,
x => x.Add(c => c.Id)
.Add(c => c.Email)
.Add(c => c.Name)
.Add(c => c.Age)
.Add(c => 1))
));
}
context.Response.End();
}
public ActionResult Remove(int id)
{
using (var t1 = new TEST1Entities())
{
var x = t1.UserInfo.FirstOrDefault(c => c.Id == id);
if (x != null)
{
t1.UserInfo.Remove(x);
}
}
return(Content(""));
}
public ActionResult Add()
{
using (var t1 = new TEST1Entities())
{
var id = t1.UserInfo.Max(c => c.Id);
t1.UserInfo.Add(new UserInfo
{
Id = id + 1,
Age = 23,
Email = Guid.NewGuid().ToString(),
Name = Guid.NewGuid().ToString()
});
}
return(Content(""));
}
public ActionResult GetEntity(int?page, int?rp, string sortname, string sortorder)
{
PagedList <UserInfo> json;
using (var t1 = new TEST1Entities())
{
var list1 = t1.UserInfo.OrderBy(c => c.Id);
var list = list1.Pager(page ?? 1, rp ?? 10);
json = list;
}
var data = json.ToFlexigridObject(c => c.Id,
x => x.Add(c => c.Id)
.Add(c => c.Email)
.Add(c => c.Name)
.Add(c => c.Age)
.Add(c => 1));
return(Json(data, JsonRequestBehavior.AllowGet));
}
