public HttpResponseMessage PutChecklistTemplate(int id, checklist_template_ref data) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != data.checklist_template_id) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(data).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage DeleteChecklistTemplate(int id) { checklist_template_ref data = db.CheckListTemplates.Find(id); if (data == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.CheckListTemplates.Remove(data); var chklistaitems = db.CheckListTemplatesXref.Where(s => s.checklist_template_id == id); db.CheckListTemplatesXref.RemoveRange(chklistaitems); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK, data)); }
public checklist_template_ref GetChecklistTemplate(int id) { if (id == 0) { return(GetEmptyChecklistTemplate()); //Used to create empty structure for configuration_ref for ADD-NEW-Record } checklist_template_ref item = db.CheckListTemplates.Find(id); if (item == null) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound)); } return(item); }
public HttpResponseMessage PostChecklistTemplate(checklist_template_ref data) { if (ModelState.IsValid) { db.CheckListTemplates.Add(data); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, data); //response.Headers.Location = new Uri(Url.Link("ApiByName", new { id = configuration.config_id })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
public HttpResponseMessage PostChecklistAction(checklist_action_ref data) { if (ModelState.IsValid) { // Get sub type ID from template checklist_template_ref tmprefdata = db.CheckListTemplates.Find(data.checklist_template_id); if (tmprefdata != null) { data.sub_type_id = tmprefdata.sub_type_id; } db.CheckListActions.Add(data); db.SaveChanges(); //For start new checklist : Add all checklist items from template : This will happen only first time when new checklist-action is added var itemsToBeAddedfromTemplate = (from chktempxref in db.CheckListTemplatesXref where chktempxref.checklist_template_id == data.checklist_template_id select chktempxref).ToList(); List <checklist_action_xref> addchecklistActionItems = new List <checklist_action_xref>(); foreach (var item in itemsToBeAddedfromTemplate) { checklist_action_xref row = new checklist_action_xref(); row.checklist_action_id = data.checklist_action_id; row.checklist_id = item.checklist_id; row.priority_order = item.priority_order; row.status_id = (short)CheckListStatus.NOTSTARTED; row.powershell_script = item.powershell_script; row.powershell_script_timedout = item.powershell_script_timedout; addchecklistActionItems.Add(row); } db.CheckListActionsXref.AddRange(addchecklistActionItems); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, data); //response.Headers.Location = new Uri(Url.Link("ApiByName", new { id = configuration.config_id })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }