partial void DeleteAssumption(Assumption instance);
partial void UpdateAssumption(Assumption instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { IQueryable<Assumption> q = db.Assumptions; //string user = context.Request.Params.Get("user_name"); //q = q.Where(a => a.user_name.Equals(user)); 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.assumptions_id, a.assumption1, a.user_name, a.business_unit, a.category })); } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = new Assumption(); record.assumption1 = (string)obj["assumption1"]; record.user_name = (string)obj["user_name"]; record.business_unit = (string)obj["business_unit"]; record.category = (string)obj["category"]; db.Assumptions.InsertOnSubmit(record); db.SubmitChanges(); return new PagedData(record); //JsonConvert.SerializeObject(newApp)); } JArray objs = (JArray)blob["rows"]; List<Assumption> list = new List<Assumption>(); for (int j = 0; j < objs.Count; j++) { Assumption record = new Assumption(); record.assumption1 = (string)objs[j]["assumption1"]; record.user_name = (string)objs[j]["user_name"]; record.business_unit = (string)objs[j]["business_unit"]; record.category = (string)objs[j]["category"]; db.Assumptions.InsertOnSubmit(record); list.Add(record); } db.SubmitChanges(); return new PagedData(list); } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)obj["assumptions_id"])); record.assumption1 = (string)obj["assumption1"]; if (obj["user_name"] != null) { record.user_name = (string)obj["user_name"]; } record.business_unit = (string)obj["business_unit"]; record.category = (string)obj["category"]; db.SubmitChanges(); return new PagedData(record); //JsonConvert.SerializeObject(newApp)); } JArray objs = (JArray)blob["rows"]; List<Assumption> list = new List<Assumption>(); for (int j = 0; j < objs.Count; j++) { Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)objs[j]["assumptions_id"])); record.assumption1 = (string)objs[j]["assumption1"]; if (objs[j]["user_name"] != null) { record.user_name = (string)objs[j]["user_name"]; } record.business_unit = (string)objs[j]["business_unit"]; record.category = (string)objs[j]["category"]; db.SubmitChanges(); list.Add(record); } return new PagedData(list); } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)obj["assumptions_id"])); db.Assumptions.DeleteOnSubmit(record); db.SubmitChanges(); return new PagedData("good"); } JArray objs = (JArray)blob["rows"]; for (int j = 0; j < objs.Count; j++) { Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)objs[j]["assumptions_id"])); db.Assumptions.DeleteOnSubmit(record); } db.SubmitChanges(); return new PagedData("deleted"); } default: return new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized"); } }
partial void InsertAssumption(Assumption instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { IQueryable <Assumption> q = db.Assumptions; //string user = context.Request.Params.Get("user_name"); //q = q.Where(a => a.user_name.Equals(user)); 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.assumptions_id, a.assumption1, a.user_name, a.business_unit, a.category }))); } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = new Assumption(); record.assumption1 = (string)obj["assumption1"]; record.user_name = (string)obj["user_name"]; record.business_unit = (string)obj["business_unit"]; record.category = (string)obj["category"]; db.Assumptions.InsertOnSubmit(record); db.SubmitChanges(); return(new PagedData(record)); //JsonConvert.SerializeObject(newApp)); } JArray objs = (JArray)blob["rows"]; List <Assumption> list = new List <Assumption>(); for (int j = 0; j < objs.Count; j++) { Assumption record = new Assumption(); record.assumption1 = (string)objs[j]["assumption1"]; record.user_name = (string)objs[j]["user_name"]; record.business_unit = (string)objs[j]["business_unit"]; record.category = (string)objs[j]["category"]; db.Assumptions.InsertOnSubmit(record); list.Add(record); } db.SubmitChanges(); return(new PagedData(list)); } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)obj["assumptions_id"])); record.assumption1 = (string)obj["assumption1"]; if (obj["user_name"] != null) { record.user_name = (string)obj["user_name"]; } record.business_unit = (string)obj["business_unit"]; record.category = (string)obj["category"]; db.SubmitChanges(); return(new PagedData(record)); //JsonConvert.SerializeObject(newApp)); } JArray objs = (JArray)blob["rows"]; List <Assumption> list = new List <Assumption>(); for (int j = 0; j < objs.Count; j++) { Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)objs[j]["assumptions_id"])); record.assumption1 = (string)objs[j]["assumption1"]; if (objs[j]["user_name"] != null) { record.user_name = (string)objs[j]["user_name"]; } record.business_unit = (string)objs[j]["business_unit"]; record.category = (string)objs[j]["category"]; db.SubmitChanges(); list.Add(record); } return(new PagedData(list)); } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)obj["assumptions_id"])); db.Assumptions.DeleteOnSubmit(record); db.SubmitChanges(); return(new PagedData("good")); } JArray objs = (JArray)blob["rows"]; for (int j = 0; j < objs.Count; j++) { Assumption record = db.Assumptions.Single(a => a.assumptions_id.Equals((int)objs[j]["assumptions_id"])); db.Assumptions.DeleteOnSubmit(record); } db.SubmitChanges(); return(new PagedData("deleted")); } default: return(new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized")); } }