//modificar relacion
public void updateRelation(RelTicketHasStatus newRel)
{
using (var db = new ToDoListContext())
{
var relation = db.REL_TICKET_HAS_STATUS.Where(r => r.id == newRel.Id).First();
relation.id_status = newRel.idStatus;
db.SaveChanges();
}
}
//guardar relation
public long addRelation(RelTicketHasStatus relation)
{
long newId = 0;
using (var db = new ToDoListContext())
{
var newRelation = new REL_TICKET_HAS_STATUS
{
id_ticket = relation.IdTicket,
id_status = relation.idStatus,
date = relation.Date
};
db.REL_TICKET_HAS_STATUS.Add(newRelation);
db.SaveChanges();
newId = newRelation.id;
}
return(newId);
}
public RelTicketHasStatus[] getAll()
{
List <RelTicketHasStatus> relations = new List <RelTicketHasStatus>();
using (var db = new ToDoListContext())
{
var query = from u in db.REL_TICKET_HAS_STATUS
orderby u.id ascending
select u;
foreach (var item in query)
{
RelTicketHasStatus relation = new RelTicketHasStatus();
relation.Id = item.id;
relation.Date = item.date;
relation.IdTicket = item.id_ticket;
relation.idStatus = item.id_status;
relations.Add(relation);
}
}
return(relations.ToArray());
}
public IHttpActionResult postTicket(Ticket ticket)
{
//ingresar nuevo ticket y obtener id
long newTicketId = dataTickets.addTicket(ticket);
//corroborar ingresado
if (newTicketId != 0)
{
//ingresar nueva relacion, para dejar ticket como pendiente
RelTicketHasStatus relation = new RelTicketHasStatus();
relation.idStatus = 1; //1=> pendiente
relation.IdTicket = newTicketId;
relation.Date = ticket.Date;
//ingresar relacion y corroborar que se ingresa correctamente
if (dataRelations.addRelation(relation) != 0)
{
return(Ok(ticket));
}
}
return(NotFound());
}
//modificar relacion
//put: api/ticketstatus/{id_relation}
public void putRelation(int id, RelTicketHasStatus relation)
{
dataRelation.updateRelation(relation);
}