public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { string project_id = context.Request.Params.Get("project_id"); if (!isNull(project_id)) { string type = context.Request.Params.Get("type"); string username = context.Request.Params.Get("user_name"); string permission = context.Request.Params.Get("permission"); if (!isNull(type)) { SWDAssessment record = new SWDAssessment(); record.project_id = int.Parse(project_id); record.assessment_type_id = db.AssessmentTypes.Single(a => a.type.Equals(type)).assessment_type_id; record.contact_id = db.Contacts.Single(a => a.name.Equals("Test Guy")).contact_id; record.action = ""; record.booked_hours = "0"; record.hours = "0"; db.SWDAssessments.InsertOnSubmit(record); db.SubmitChanges(); doChangeLogging(type, username, permission, project_id, db); return new PagedData(new { record.swd_assessment_id, record.Contact.name }); } return new PagedData("AddSWDAssessment.ashx requires a type"); } return new PagedData("AddSWDAssessment.ashx requires a project_id"); }
public void doChangeLogging(string type, string username, string permission, string project_id, CookDBDataContext db, SWDAssessment 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 = "TLS"; newLog.user_name = username; string action = (record.action == null || record.action == "") ? "(empty)" : record.action; string billed = (record.hours == null || record.hours == "") ? "(empty)" : record.hours; string booked = (record.booked_hours == null || record.booked_hours == "") ? "(empty)" : record.booked_hours; newLog.description = "Existing record deleted from " + record.AssessmentType.type + ": Name: " + record.Contact.name + "; Notes: " + action + "; Billed Hours: " + billed + "; Booked Hours: " + booked + "."; db.ChangeLogs.InsertOnSubmit(newLog); db.SubmitChanges(); //} }
private void detach_SWDAssessments(SWDAssessment entity) { this.SendPropertyChanging(); entity.ProjectInformation = null; }
partial void DeleteSWDAssessment(SWDAssessment instance);
partial void UpdateSWDAssessment(SWDAssessment instance);
partial void InsertSWDAssessment(SWDAssessment instance);
private void detach_SWDAssessments(SWDAssessment entity) { this.SendPropertyChanging(); entity.Contact = null; }
private void attach_SWDAssessments(SWDAssessment entity) { this.SendPropertyChanging(); entity.AssessmentType = this; }
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { IQueryable<SWDAssessment> q = db.SWDAssessments; 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) && ( a.AssessmentType.type == "Design/Documentation" || a.AssessmentType.type == "Coding" || a.AssessmentType.type == "Project Overhead" || a.AssessmentType.type == "MIS Other" || a.AssessmentType.type == "MIS" || a.AssessmentType.type == "Requirements Clarification" || a.AssessmentType.type == "QA" || a.AssessmentType.type == "Workflow" || a.AssessmentType.type == "Testing/Implementation" || a.AssessmentType.type == "UAT Support" )); return new PagedData(q.Select(a => new { a.project_id, a.Contact.name, a.AssessmentType.type, a.hours, a.action, a.requested_start_date, a.requested_complete, a.scheduled_start_date, a.scheduled_complete, a.actual_complete, a.booked_hours, a.swd_assessment_id })); } else { return new PagedData("GetSWDAssessment expects a project_id"); } } case "POST": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; SWDAssessment record = new SWDAssessment(); record.project_id = int.Parse(filter); record.Contact = db.Contacts.Single(a => a.name.Equals("Test Guy")); record.Contact.name = "Test Guy"; record.action = ""; record.hours = ""; record.booked_hours = ""; record.requested_start_date = ""; record.requested_complete = ""; record.scheduled_start_date = ""; record.scheduled_complete = ""; record.actual_complete = ""; try { record.assessment_type_id = db.AssessmentTypes.Single(a => a.type == (string)obj["type"]).assessment_type_id; } catch (Exception) { record.assessment_type_id = db.AssessmentTypes.Single(a => a.type == "Coding").assessment_type_id; } db.SWDAssessments.InsertOnSubmit(record); db.SubmitChanges(); q = q.Where(a => a.project_id == int.Parse(filter) && a.swd_assessment_id == record.swd_assessment_id); return new PagedData(q.Select(a => new { a.swd_assessment_id, a.AssessmentType.type, a.action, a.Contact.name, a.hours, a.booked_hours, a.requested_start_date, a.requested_complete, a.scheduled_start_date, a.scheduled_complete, a.actual_complete })); } else { JArray objs = (JArray)blob["rows"]; List<SWDAssessment> list = new List<SWDAssessment>(); for (int j = 0; j < objs.Count; j++) { SWDAssessment record = new SWDAssessment(); record.project_id = int.Parse(filter); record.Contact = db.Contacts.Single(a => a.name.Equals("Test Guy")); record.Contact.name = "Test Guy"; record.action = ""; record.hours = ""; record.booked_hours = ""; record.requested_start_date = ""; record.requested_complete = ""; record.scheduled_start_date = ""; record.scheduled_complete = ""; record.actual_complete = ""; try { record.assessment_type_id = db.AssessmentTypes.Single(a => a.type == (string)objs["type"]).assessment_type_id; } catch (Exception) { record.assessment_type_id = db.AssessmentTypes.Single(a => a.type == "Coding").assessment_type_id; } db.SWDAssessments.InsertOnSubmit(record); db.SubmitChanges(); list.Add(record); } return new PagedData(list); } } case "PUT": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; SWDAssessment record = db.SWDAssessments.Single(a => a.swd_assessment_id.Equals((int)obj["swd_assessment_id"])); try { record.Contact = db.Contacts.Single(a => a.name.Equals((string)obj["name"])); } catch (Exception) { record.Contact = db.Contacts.Single(a => a.name.Equals("Test Guy")); } record.action = (string)obj["action"]; record.hours = (string)obj["hours"]; record.booked_hours = (string)obj["booked_hours"]; record.requested_start_date = obj["requested_start_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["requested_start_date"]) : ((string)obj["requested_start_date"] == null ? "" : (string)obj["requested_start_date"]); record.requested_complete = obj["requested_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["requested_complete"]) : ((string)obj["requested_complete"] == null ? "" : (string)obj["requested_complete"]); record.scheduled_start_date = obj["scheduled_start_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["scheduled_start_date"]) : ((string)obj["scheduled_start_date"] == null ? "" : (string)obj["scheduled_start_date"]); record.scheduled_complete = obj["scheduled_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["scheduled_complete"]) : ((string)obj["scheduled_complete"] == null ? "" : (string)obj["scheduled_complete"]); record.actual_complete = obj["actual_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)obj["actual_complete"]) : ((string)obj["actual_complete"] == null ? "" : (string)obj["actual_complete"]); db.SubmitChanges(); q = q.Where(a => a.project_id == int.Parse(filter) && a.swd_assessment_id == record.swd_assessment_id); return new PagedData(q.Select(a => new { a.swd_assessment_id, a.AssessmentType.type, a.action, a.Contact.name, a.hours, a.booked_hours, a.requested_start_date, a.requested_complete, a.scheduled_start_date, a.scheduled_complete, a.actual_complete })); } else { JArray objs = (JArray)blob["rows"]; List<SWDAssessment> list = new List<SWDAssessment>(); for (int j = 0; j < objs.Count; j++) { SWDAssessment record = db.SWDAssessments.Single(a => a.swd_assessment_id.Equals((int)objs["swd_assessment_id"])); try { record.Contact = db.Contacts.Single(a => a.name.Equals((string)objs["name"])); } catch (Exception) { record.Contact = db.Contacts.Single(a => a.name.Equals("Test Guy")); } record.action = (string)objs["action"]; record.hours = (string)objs["hours"]; record.booked_hours = (string)objs["booked_hours"]; record.requested_start_date = objs["requested_start_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["requested_start_date"]) : ((string)objs["requested_start_date"] == null ? "" : (string)objs["requested_start_date"]); record.requested_complete = objs["requested_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["requested_complete"]) : ((string)objs["requested_complete"] == null ? "" : (string)objs["requested_complete"]); record.scheduled_start_date = objs["scheduled_start_date"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["scheduled_start_date"]) : ((string)objs["scheduled_start_date"] == null ? "" : (string)objs["scheduled_start_date"]); record.scheduled_complete = objs["scheduled_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["scheduled_complete"]) : ((string)objs["scheduled_complete"] == null ? "" : (string)objs["scheduled_complete"]); record.actual_complete = objs["actual_complete"].ToString().Contains("T00:00:00") ? convertToProperDate((string)objs["actual_complete"]) : ((string)objs["actual_complete"] == null ? "" : (string)objs["actual_complete"]); db.SubmitChanges(); list.Add(record); } return new PagedData(list); } } case "DELETE": { if (blob["rows"].GetType() == typeof(JObject)) { JObject obj = (JObject)blob["rows"]; SWDAssessment record = db.SWDAssessments.Single(a => a.swd_assessment_id.Equals((int)obj["swd_assessment_id"])); db.SWDAssessments.DeleteOnSubmit(record); db.SubmitChanges(); return new PagedData("SWD Assessment Rec Deleted"); } else { JArray objs = (JArray)blob["rows"]; List<SWDAssessment> list = new List<SWDAssessment>(); for (int j = 0; j < objs.Count; j++) { JObject obj = (JObject)blob["rows"]; SWDAssessment record = db.SWDAssessments.Single(a => a.swd_assessment_id.Equals((int)obj["swd_assessment_id"])); db.SWDAssessments.DeleteOnSubmit(record); db.SubmitChanges(); } return new PagedData("SWD Assessment Recs Deleted"); } } default: return new PagedData("Error: Unsupported Http Request: " + context.Request.RequestType + " not recognized", false); } }
//smm (added assessmentID to the parameters) public SWDAssessment processProjectContact(string contactNameBlob, string assessmentType, CookDBDataContext db, int project_id, string actionBlob, int assessmentID) {//this sets the name/action/assessment_type_id //ah 1-30-13 removed the parsing of action within contact name due to contacts now having parse the action out of the name, if it exists name = contactNameBlob; name = name.Trim(); action = ""; //check the newly added Notes field for an action there. If there is one present, overwrite the currently saved action if (actionBlob != null && actionBlob != "") { action = actionBlob.Trim(); } //check for null name if (db.Contacts.Count(a => a.name.Equals(name)) > 0) { //get corresponding id of contact from contacts table contactNameId = db.Contacts.Single(a => a.name.Equals(name)).contact_id; //get assessment type corresponding with type passed in //*** smm (no longer needed since assessmentType is assigned in AddSWDAssessment.ashx) *** //assessmentTypeId = db.AssessmentTypes.Single(a => a.type.Equals(assessmentType)).assessment_type_id; //now add a new record with the name/action/assessment type SWDAssessment newRecord = db.SWDAssessments.Single(a => a.swd_assessment_id.Equals(assessmentID)); //(smm) new SWDAssessment(); newRecord.contact_id = contactNameId; //newRecord.project_id = project_id; (smm - not needed) if (action != "") { newRecord.action = action; } //newRecord.assessment_type_id = assessmentTypeId; (smm - not needed) return newRecord; } else { SWDAssessment newRecord = new SWDAssessment(); return newRecord; } }