public IHttpActionResult PutHold([FromUri] string Id, [FromBody] Ticket NewTicket) { OldTicket = db.Tickets.FirstOrDefault(a => a.Ticket_Id == NewTicket.Ticket_Id); OldTicket.status = Status.Open; OldUserTicket = db.UserTickets.FirstOrDefault(a => a.Ticket_id == NewTicket.Ticket_Id && a.User_id == Id); OldUserTicket.Status = Status.Open; db.SaveChanges(); Layer_SLA layerSla = db.LayerSLAs.OrderBy(a => a.LayerId).FirstOrDefault(s => s.SLAId == NewTicket.SLA_Id); int? layerTime = layerSla.Time; return(Ok(layerTime)); }
public IHttpActionResult Post(SLA sla ,Layer_SLA[] layersSla) { if (sla == null) { return BadRequest(); } else { //dummy // two.slaid = 2000; SLA s = new SLA(); //s.SLA_id = two.slaid; s.SLA_name = two.slaname; s.L1_Time = two.l1time; s.L2_Time = two.l2time; s.L3_Time = two.l3time; db.SLAs.Add(s); db.SaveChanges(); List<Layer> layers = new List<Layer>(); layers = db.Layers.ToList(); for(int i=two.Layer_id;i<=layers.Count;i++) { Layer_SLA LayerSla = new Layer_SLA(); LayerSla.SLAId = s.SLA_id; LayerSla.LayerId = i; db.LayerSLAs.Add(LayerSla); } db.SaveChanges(); return Ok(two); } }