partial void DeleteCategory(Category instance);
partial void InsertCategory(Category instance);
partial void UpdateCategory(Category instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
IQueryable<Category> q = db.Categories;
System.IO.StreamReader reader = new System.IO.StreamReader(context.Request.InputStream, context.Request.ContentEncoding);
var jsonSerializer = new JsonSerializer();
JObject blob = (JObject)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd())));
switch (context.Request.RequestType)
{
case "GET":
{
return new PagedData(q.Select(a => new { a.category_id, a.category1 }));
}
case "POST":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
Category record = new Category();
record.category1 = (string)obj["category1"];
db.Categories.InsertOnSubmit(record);
db.SubmitChanges();
return new PagedData(record); //JsonConvert.SerializeObject(newApp));
}
JArray objs = (JArray)blob["rows"];
List<Category> list = new List<Category>();
for (int j = 0; j < objs.Count; j++)
{
Category record = new Category();
record.category1 = (string)objs[j]["category1"];
db.Categories.InsertOnSubmit(record);
list.Add(record);
}
db.SubmitChanges();
return new PagedData(list);
}
case "PUT":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
Category record = db.Categories.Single(a => a.category_id.Equals((int)obj["category_id"]));
record.category1 = (string)obj["category1"];
db.SubmitChanges();
return new PagedData(record); //JsonConvert.SerializeObject(newApp));
}
JArray objs = (JArray)blob["rows"];
List<Category> list = new List<Category>();
for (int j = 0; j < objs.Count; j++)
{
Category record = db.Categories.Single(a => a.category_id.Equals((int)objs[j]["category_id"]));
record.category1 = (string)objs[j]["category1"];
db.SubmitChanges();
list.Add(record);
}
return new PagedData(list);
}
case "DELETE":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
Category record = db.Categories.Single(a => a.category_id.Equals((int)obj["category_id"]));
db.Categories.DeleteOnSubmit(record);
db.SubmitChanges();
return new PagedData("good");
}
JArray objs = (JArray)blob["rows"];
for (int j = 0; j < objs.Count; j++)
{
Category record = db.Categories.Single(a => a.category_id.Equals((int)objs[j]["category_id"]));
db.Categories.DeleteOnSubmit(record);
}
db.SubmitChanges();
return new PagedData("deleted");
}
default:
return new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized");
}
}
