public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { if (context.Request.Params.Count == 0) return new PagedData("Can't call UpdateProject.ashx without parameters"); bool doSubmit = false; for (int i = 0; i < context.Request.Params.Count; i++) { if (context.Request.Params.GetKey(i) == "application") { Application app = new Application(); app.base_name = context.Request.Params.Get(i); app.name = app.base_name + ".APP"; db.Applications.InsertOnSubmit(app); doSubmit = true; } } if (doSubmit) db.SubmitChanges(); return new PagedData(""); }
partial void DeleteApplication(Application instance);
partial void UpdateApplication(Application instance);
partial void InsertApplication(Application instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { IQueryable<Application> q = db.Applications; 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("name"); if (!isNull(filter)) { q = q.Where(a => a.name.IndexOf(filter) != -1); } return new PagedData(q.Select(a => new { a.applications_id, a.name, a.base_name, a.Product, a.Division, a.Platform, a.ServiceID })); } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject app = (JObject)blob["rows"]; Application newApp = new Application(); newApp.name = (string)app["name"]; newApp.base_name = (string)app["base_name"]; newApp.Product = app["Product"] == null ? "" : (string)app["Product"]; newApp.Division = app["Division"] == null ? "" : (string)app["Division"]; newApp.Platform = app["Platform"] == null ? "" : (string)app["Platform"]; newApp.ServiceID = app["ServiceID"] == null ? "" : (string)app["ServiceID"]; db.Applications.InsertOnSubmit(newApp); db.SubmitChanges(); return new PagedData(newApp); //JsonConvert.SerializeObject(newApp)); } JArray apps = (JArray)blob["rows"]; List<Application> list = new List<Application>(); for (int j = 0; j < apps.Count; j++) { Application newApp = new Application(); newApp.name = (string)apps[j]["name"]; newApp.base_name = (string)apps[j]["base_name"]; newApp.Product = apps[j]["Product"] == null ? "" : (string)apps[j]["Product"]; newApp.Division = apps[j]["Division"] == null ? "" : (string)apps[j]["Division"]; newApp.Platform = apps[j]["Platform"] == null ? "" : (string)apps[j]["Platform"]; newApp.ServiceID = apps[j]["ServiceID"] == null ? "" : (string)apps[j]["ServiceID"]; db.Applications.InsertOnSubmit(newApp); list.Add(newApp); } db.SubmitChanges(); DocumentationReq doc = new DocumentationReq(); return new PagedData(list); } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject app = (JObject)blob["rows"]; Application app2 = db.Applications.Single(a => a.applications_id.Equals((int)app["applications_id"])); app2.base_name = (string)app["base_name"]; app2.name = (string)app["name"]; app2.Product = app["Product"] == null ? "" : (string)app["Product"]; app2.Division = app["Division"] == null ? "" : (string)app["Division"]; app2.Platform = app["Platform"] == null ? "" : (string)app["Platform"]; app2.ServiceID = app["ServiceID"] == null ? "" : (string)app["ServiceID"]; db.SubmitChanges(); return new PagedData(app2); } JArray apps = (JArray)blob["rows"]; List<Application> list = new List<Application>(); for (int j = 0; j < apps.Count; j++) { Application app2 = db.Applications.Single(a => a.applications_id.Equals((int)apps[j]["applications_id"])); app2.base_name = (string)apps[j]["base_name"]; app2.name = (string)apps[j]["name"]; app2.Product = apps[j]["Product"] == null ? "" : (string)apps[j]["Product"]; app2.Division = apps[j]["Division"] == null ? "" : (string)apps[j]["Division"]; app2.Platform = apps[j]["Platform"] == null ? "" : (string)apps[j]["Platform"]; app2.ServiceID = apps[j]["ServiceID"] == null ? "" : (string)apps[j]["ServiceID"]; db.SubmitChanges(); list.Add(app2); } return new PagedData(list); } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject app = (JObject)blob["rows"]; Application app2 = db.Applications.Single(a => a.applications_id.Equals((int)app["applications_id"])); db.Applications.DeleteOnSubmit(app2); db.SubmitChanges(); return new PagedData("good"); } JArray apps = (JArray)blob["rows"]; for (int j = 0; j < apps.Count; j++) { Application app2 = db.Applications.Single(a => a.applications_id.Equals((int)apps[j]["applications_id"])); db.Applications.DeleteOnSubmit(app2); } db.SubmitChanges(); return new PagedData("deleted"); } default: return new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized"); } }
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { if (context.Request.Params.Count == 0) return new PagedData("Can't call AddApplications.ashx without parameters"); Application app = new Application(); int existingAppID = -1; for (int i = 0; i < context.Request.Params.Count; i++) { var currentParam = context.Request.Params.GetKey(i).Trim(); var currentParamData = context.Request.Params.Get(i).Trim(); switch (currentParam) { case "application": { app.base_name = currentParamData; app.name = app.base_name + ".APP"; break; } case "product": { app.Product = currentParamData; break; } case "division": { app.Division = currentParamData; break; } case "platform": { app.Platform = currentParamData; break; } case "serviceid": { app.ServiceID = currentParamData; break; } case "applications_id": { if (currentParamData != "add") { existingAppID = Convert.ToInt32(currentParamData); } break; } default: break; } } if (existingAppID < 0) { db.Applications.InsertOnSubmit(app); } else { if (db.Applications.Count(a => a.applications_id.Equals(existingAppID)) > 0) { Application existingApp = db.Applications.First(a => a.applications_id.Equals(existingAppID)); existingApp.base_name = app.base_name; existingApp.name = app.name; existingApp.Product = app.Product; existingApp.Division = app.Division; existingApp.Platform = app.Platform; existingApp.ServiceID = app.ServiceID; } else { return new PagedData("Could not find the existing app to edit!"); } } db.SubmitChanges(); return new PagedData(""); }