public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { string project_id = context.Request.Params.Get("project_id"); if (!isNull(project_id)) { string username = context.Request.Params.Get("user_name"); string permission = context.Request.Params.Get("permission"); HardwareRequirement record = new HardwareRequirement(); record.project_id = int.Parse(project_id); record.description = ""; record.cost_per_item = ""; record.total_item_cost = ""; record.target_order_date = ""; record.target_delivery = ""; record.actual_order_date = ""; record.actual_delivery_date = ""; db.HardwareRequirements.InsertOnSubmit(record); db.SubmitChanges(); doChangeLogging(username, permission, project_id, db); return new PagedData(new { record.hardware_req_id }); } return new PagedData("AddSystemsAssessment.ashx requires a project_id"); }
public void doChangeLogging(string type, string username, string permission, string project_id, CookDBDataContext db, HardwareRequirement record) { //if (permission != "PM") //{ ChangeLog newLog = new ChangeLog(); newLog.project_id = Convert.ToInt32(project_id); newLog.time = DateTime.Now.ToShortTimeString(); newLog.date = DateTime.Now.ToShortDateString(); newLog.tab = "Systems"; newLog.user_name = username; string description = (record.description == null || record.description == "") ? "(empty)" : record.description; string costPerItem = (record.cost_per_item == null || record.cost_per_item == "") ? "(empty)" : record.cost_per_item; var quantity = (record.quantity == 0) ? 0 : record.quantity; string targetOrderDate = (record.target_order_date == null || record.target_order_date == "") ? "(empty)" : record.target_order_date; string targetDelivery = (record.target_delivery == null || record.target_delivery == "") ? "(empty)" : record.target_delivery; string actualOrderDate = (record.actual_order_date == null || record.actual_order_date == "") ? "(empty)" : record.actual_order_date; string actualDelivery = (record.actual_delivery_date == null || record.actual_delivery_date == "") ? "(empty)" : record.actual_delivery_date; newLog.description = "Existing record deleted from Hardware Requirements: Description: " + description + "; Cost Per Item: " + costPerItem + "; Quantity: " + quantity+ "; Target Order Date: " + targetOrderDate + "; Target Delivery" + targetDelivery + "; Actual Order Date: " + actualOrderDate + "; Actual Delivery: " + actualDelivery + "."; db.ChangeLogs.InsertOnSubmit(newLog); db.SubmitChanges(); //} }
private void detach_HardwareRequirements(HardwareRequirement entity) { this.SendPropertyChanging(); entity.ProjectInformation = null; }
partial void DeleteHardwareRequirement(HardwareRequirement instance);
partial void UpdateHardwareRequirement(HardwareRequirement instance);
partial void InsertHardwareRequirement(HardwareRequirement instance);
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { IQueryable<HardwareRequirement> q = db.HardwareRequirements; string username = context.Request.Params.Get("user_name"); string filter = context.Request.Params.Get("project_id"); 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()))); string readOnly = context.Request.Params.Get("read_only"); if (readOnly == "true" && context.Request.RequestType != "GET") { return new PagedData("Read Only"); } switch (context.Request.RequestType) { case "GET": { if (!isNull(filter)) { q = q.Where(a => a.project_id == int.Parse(filter)); return new PagedData(q.Select(a => new { a.hardware_req_id, a.description, a.cost_per_item, a.quantity, a.total_item_cost, a.target_delivery, a.target_order_date, a.actual_delivery_date, a.actual_order_date, a.requirement_type, a.number_of_sites })); } else { return new PagedData("GetHardwareRequirements expects a project_id"); } } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; HardwareRequirement record = new HardwareRequirement(); record.project_id = int.Parse(filter); record.description = ""; record.cost_per_item = ""; record.quantity = 0; record.total_item_cost = ""; record.target_order_date = ""; record.target_delivery = ""; record.actual_delivery_date = ""; record.actual_order_date = ""; record.number_of_sites = 0; try { record.requirement_type = (string)obj["requirement_type"]; } catch (Exception) { record.requirement_type = "One Time Charges"; } db.HardwareRequirements.InsertOnSubmit(record); db.SubmitChanges(); return new PagedData(record); } else { JArray objs = (JArray)blob["rows"]; List<HardwareRequirement> list = new List<HardwareRequirement>(); for (int j = 0; j < objs.Count; j++) { HardwareRequirement record = new HardwareRequirement(); record.project_id = int.Parse(filter); record.description = ""; record.cost_per_item = ""; record.quantity = 0; record.total_item_cost = ""; record.target_order_date = ""; record.target_delivery = ""; record.actual_delivery_date = ""; record.actual_order_date = ""; try { record.requirement_type = (string)objs["requirement_type"]; } catch (Exception) { record.requirement_type = "One Time Charges"; } record.number_of_sites = 0; db.HardwareRequirements.InsertOnSubmit(record); db.SubmitChanges(); list.Add(record); } return new PagedData(list); } } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; HardwareRequirement record = db.HardwareRequirements.Single(a => a.hardware_req_id.Equals((int)obj["hardware_req_id"])); record.description = (string)obj["description"]; record.cost_per_item = obj["cost_per_item"] == null ? "0" : (string)obj["cost_per_item"]; record.quantity = obj["quantity"] == null ? 0 : (int)obj["quantity"]; record.number_of_sites = obj["number_of_sites"] == null ? 0 : (int)obj["number_of_sites"]; try { record.total_item_cost = "$" + (record.quantity * double.Parse(record.cost_per_item) * record.number_of_sites); } catch (Exception) { record.total_item_cost = ""; } record.target_order_date = obj["target_order_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["target_order_date"]) : ((string)obj["target_order_date"] == null ? "" : (string)obj["target_order_date"]); record.target_delivery = obj["target_delivery"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["target_delivery"]) : ((string)obj["target_delivery"] == null ? "" : (string)obj["target_delivery"]); record.actual_delivery_date = obj["actual_delivery_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["actual_delivery_date"]) : ((string)obj["actual_delivery_date"] == null ? "" : (string)obj["actual_delivery_date"]); record.actual_order_date = obj["actual_order_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["actual_order_date"]) : ((string)obj["actual_order_date"] == null ? "" : (string)obj["actual_order_date"]); try { record.requirement_type = (string)obj["requirement_type"]; } catch (Exception) { record.requirement_type = "One Time Charges"; } db.SubmitChanges(); return new PagedData(record); } else { JArray objs = (JArray)blob["rows"]; List<HardwareRequirement> list = new List<HardwareRequirement>(); for (int j = 0; j < objs.Count; j++) { HardwareRequirement record = db.HardwareRequirements.Single(a => a.hardware_req_id.Equals((int)objs["hardware_req_id"])); record.description = (string)objs["description"]; record.cost_per_item = objs["cost_per_item"] == null ? "0" : (string)objs["cost_per_item"]; record.quantity = objs["quantity"] == null ? 0 : (int)objs["quantity"]; record.number_of_sites = objs["number_of_sites"] == null ? 0 : (int)objs["number_of_sites"]; try { record.total_item_cost = "$" + (record.quantity * double.Parse(record.cost_per_item) * record.number_of_sites); } catch (Exception) { record.total_item_cost = ""; } record.target_order_date = objs["target_order_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["target_order_date"]) : ((string)objs["target_order_date"] == null ? "" : (string)objs["target_order_date"]); record.target_delivery = objs["target_delivery"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["target_delivery"]) : ((string)objs["target_delivery"] == null ? "" : (string)objs["target_delivery"]); record.actual_delivery_date = objs["actual_delivery_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["actual_delivery_date"]) : ((string)objs["actual_delivery_date"] == null ? "" : (string)objs["actual_delivery_date"]); record.actual_order_date = objs["actual_order_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["actual_order_date"]) : ((string)objs["actual_order_date"] == null ? "" : (string)objs["actual_order_date"]); try { record.requirement_type = (string)objs["requirement_type"]; } catch (Exception) { record.requirement_type = "One Time Charges"; } db.SubmitChanges(); } return new PagedData(list); } } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; HardwareRequirement record = db.HardwareRequirements.Single(a => a.hardware_req_id.Equals((int)obj["hardware_req_id"])); db.HardwareRequirements.DeleteOnSubmit(record); db.SubmitChanges(); return new PagedData("Hardware Rec Deleted"); } else { JArray objs = (JArray)blob["rows"]; List<HardwareRequirement> list = new List<HardwareRequirement>(); for (int j = 0; j < objs.Count; j++) { JObject obj = (JObject)blob["rows"]; HardwareRequirement record = db.HardwareRequirements.Single(a => a.hardware_req_id.Equals((int)obj["hardware_req_id"])); db.HardwareRequirements.DeleteOnSubmit(record); db.SubmitChanges(); } return new PagedData("Hardware Recs Deleted"); } } default: return new PagedData("Error: Unsupported Http Request: " + context.Request.RequestType + " not recognized", false); } }