public long Create(TicketAttribution ticketAttribution) { var id = TicketAttributions.Count; ticketAttribution.Id = id; TicketAttributions.Add(ticketAttribution); return(id); }
public IActionResult Create([FromBody] TicketAttribution ticketAttribution) { var result = new CreateTicketAttribution(repository, ticketAttribution).Execute(); if (result == -1) { return(Conflict()); } return(Ok(result)); }
public long Update(TicketAttribution ticketAttribution) { const string sql = "UPDATE public.\"TicketAttribution\" SET \"StaffId\"= @staffId, \"TicketId\"= @ticketId WHERE \"Id\"= @id RETURNING \"Id\";"; var par = new List <DbParameter> { new NpgsqlParameter("staffId", ticketAttribution.StaffId), new NpgsqlParameter("ticketId", ticketAttribution.TicketId) }; return(dataMapper.NoQueryCommand(sql, par)); }
public long Create(TicketAttribution ticketAttribution) { const string sql = "INSERT INTO public.\"TicketAttribution\"(\"Id\", \"StaffId\", \"TicketId\") VALUES (DEFAULT, @staffId, @ticketId) RETURNING \"Id\";"; var par = new List <DbParameter> { new NpgsqlParameter("staffId", ticketAttribution.StaffId), new NpgsqlParameter("ticketId", ticketAttribution.TicketId) }; return(dataMapper.NoQueryCommand(sql, par)); }
public long Update(TicketAttribution item) { long id = -1; TicketAttributions = TicketAttributions.Select(i => { if (i.Id == item.Id) { id = item.Id; return(item); } id = -1; return(i); }).ToList(); return(id); }