partial void DeleteMISUpdateDNI(MISUpdateDNI instance);
private void detach_MISUpdateDNIs(MISUpdateDNI entity) { this.SendPropertyChanging(); entity.MISUpdate = null; }
partial void InsertMISUpdateDNI(MISUpdateDNI instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { string readOnly = context.Request.Params.Get("read_only"); if (readOnly == "true" && context.Request.RequestType != "GET") { return new PagedData("Read Only"); } IQueryable<MISUpdateDNI> q = db.MISUpdateDNIs; 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": { string filter = context.Request.Params.Get("mis_update_id"); if (!isNull(filter)) { q = q.Where(a => a.mis_update_id.Equals(int.Parse(filter)) && a.route_to.Length > 1); } return new PagedData(q.Select(a => new { a.mis_updatednis_id, a.mis_update_id, a.dnis, a.route_to, a.platform, a.description, a.effective_date })); } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; MISUpdateDNI record = new MISUpdateDNI(); record.mis_update_id = (int)obj["mis_update_id"]; record.dnis = (String)obj["dnis"]; record.route_to = (String)obj["route_to"]; if (obj["platform"].GetType() == typeof(JValue)) record.platform = (String)obj["platform"]; else { string platforms = (String)((JArray)obj["platform"])[0]; for (int i = 1; i < ((JArray)obj["platform"]).Count; i++) { platforms = platforms + ", " + (String)((JArray)obj["platform"])[i]; } record.platform = platforms; } record.description = (String)obj["description"]; record.effective_date = (String)obj["effective_date"]; db.MISUpdateDNIs.InsertOnSubmit(record); db.SubmitChanges(); return new PagedData(new { record.mis_updatednis_id, record.mis_update_id, record.dnis, record.route_to, record.platform, record.description, record.effective_date }); } JArray objs = (JArray)blob["rows"]; List<Object> list = new List<Object>(); for (int j = 0; j < objs.Count; j++) { MISUpdateDNI record = new MISUpdateDNI(); record.mis_update_id = (int)objs[j]["mis_update_id"]; record.dnis = (String)objs[j]["dnis"]; record.route_to = (String)objs[j]["route_to"]; if (objs[j]["platform"].GetType() == typeof(JValue)) record.platform = (String)objs[j]["platform"]; else { string platforms = (String)((JArray)objs[j]["platform"])[0]; for (int i = 1; i < ((JArray)objs[j]["platform"]).Count; i++) { platforms = platforms + ", " + (String)((JArray)objs[j]["platform"])[i]; } record.platform = platforms; } record.description = (String)objs[j]["description"]; record.effective_date = (String)objs[j]["effective_date"]; db.MISUpdateDNIs.InsertOnSubmit(record); db.SubmitChanges(); list.Add(new { record.mis_updatednis_id, record.mis_update_id, record.dnis, record.route_to, record.platform, record.description, record.effective_date }); } return new PagedData(list); } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; MISUpdateDNI record = db.MISUpdateDNIs.Single(a => a.mis_updatednis_id.Equals((int)obj["mis_updatednis_id"])); record.dnis = (String)obj["dnis"]; record.route_to = (String)obj["route_to"]; //record.platform = (string)obj["platform"]; if (obj["platform"].GetType() == typeof(JValue)) record.platform = (String)obj["platform"]; else { string platforms = (String)((JArray)obj["platform"])[0]; for (int i = 1; i < ((JArray)obj["platform"]).Count; i++) { platforms = platforms + ", " + (String)((JArray)obj["platform"])[i]; } record.platform = platforms; } record.description = (String)obj["description"]; record.effective_date = (String)obj["effective_date"]; db.SubmitChanges(); return new PagedData(new { record.mis_updatednis_id, record.mis_update_id, record.dnis, record.route_to, record.platform, record.description, record.effective_date }); } JArray objs = (JArray)blob["rows"]; List<Object> list = new List<Object>(); for (int j = 0; j < objs.Count; j++) { MISUpdateDNI record = db.MISUpdateDNIs.Single(a => a.mis_updatednis_id.Equals((int)objs[j]["mis_updatednis_id"])); record.dnis = (String)objs[j]["dnis"]; record.route_to = (String)objs[j]["route_to"]; if (objs[j]["platform"].GetType() == typeof(JValue)) record.platform = (String)objs[j]["platform"]; else { string platforms = (String)((JArray)objs[j]["platform"])[0]; for (int i = 1; i < ((JArray)objs[j]["platform"]).Count; i++) { platforms = platforms + ", " + (String)((JArray)objs[j]["platform"])[i]; } record.platform = platforms; } record.description = (String)objs[j]["description"]; record.effective_date = (String)objs[j]["effective_date"]; list.Add(new { record.mis_updatednis_id, record.mis_update_id, record.dnis, record.route_to, record.platform, record.description, record.effective_date }); } db.SubmitChanges(); return new PagedData(list); } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; MISUpdateDNI record = db.MISUpdateDNIs.Single(a => a.mis_updatednis_id.Equals((int)obj["mis_updatednis_id"])); db.MISUpdateDNIs.DeleteOnSubmit(record); db.SubmitChanges(); return new PagedData("dnis deleted"); } JArray objs = (JArray)blob["rows"]; for (int j = 0; j < objs.Count; j++) { MISUpdateDNI record = db.MISUpdateDNIs.Single(a => a.mis_updatednis_id.Equals((int)objs[j]["mis_updatednis_id"])); db.MISUpdateDNIs.DeleteOnSubmit(record); } db.SubmitChanges(); return new PagedData("dnises deleted"); } default: return new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized"); } }