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);
}
