public async Task <List <country> > GetCountries(string param) { Console.WriteLine(String.Format("{0} started.", param)); using (worldEntities context = new worldEntities()) { Console.WriteLine(String.Format("{0} awaiting.", param)); List <country> countries = await context.country.ToListAsync(); Console.WriteLine(String.Format("{0} done.", param)); return(new List <country>()); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; var method = context.Request["action"]; using (worldEntities db = new worldEntities()) { if (method == "look") { var pageIndex = Convert.ToInt32(context.Request["pageIndex"]); var list = db.weibo.Where(a => true).OrderByDescending(a => a.ID).Skip((pageIndex - 1) * 5).Take(5).ToList(); var count = list.Count(); var listSer = JsonConvert.SerializeObject(list); context.Response.Write(listSer); } if (method == "page") { var list = db.weibo.Where(a => true).ToList(); var count = list.Count(); var pageCount = (count + 5 - 1) / 5; context.Response.Write(pageCount); } if (method == "add") { var con = context.Request["con"]; if (!string.IsNullOrEmpty(con)) { weibo entity = new weibo(); entity.Content = con; entity.Acc = 0; entity.Ref = 0; var startTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1)); var time = (int)(DateTime.Now - startTime).TotalSeconds; entity.Times = time; db.weibo.Add(entity); db.SaveChanges(); var list = db.weibo.Where(a => true).OrderByDescending(a => a.ID).FirstOrDefault(); var listSer = JsonConvert.SerializeObject(list); context.Response.Write(listSer); } } if (method == "del") { var con = context.Request["con"]; if (!string.IsNullOrEmpty(con)) { var intId = Convert.ToInt32(con); var dbQ = db.Set <weibo>(); var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault(); dbQ.Remove(entity); db.SaveChanges(); } } if (method == "ref") { var con = context.Request["con"]; if (!string.IsNullOrEmpty(con)) { var intId = Convert.ToInt32(con); var dbQ = db.Set <weibo>(); var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault(); entity.Ref++; db.SaveChanges(); } } if (method == "acc") { var con = context.Request["con"]; if (!string.IsNullOrEmpty(con)) { var intId = Convert.ToInt32(con); var dbQ = db.Set <weibo>(); var entity = dbQ.Where(a => a.ID == intId).FirstOrDefault(); entity.Acc++; db.SaveChanges(); } } } }