public long Create(TicketWare ticketWare)
{
var id = TicketWares.Count;
ticketWare.Id = id;
TicketWares.Add(ticketWare);
return(id);
}
public long Create(TicketWare ticketWare)
{
const string sql =
"INSERT INTO public.\"TicketWare\"(\"Id\", \"TicketId\", \"WareId\") VALUES (DEFAULT, @ticketId, @wareId) returning \"Id\";";
var par = new List <DbParameter> {
new NpgsqlParameter("ticketId", ticketWare.TicketId),
new NpgsqlParameter("wareId", ticketWare.WareId)
};
return(dataMapper.NoQueryCommand(sql, par));
}
public long Update(TicketWare ticketWare)
{
const string sql =
"UPDATE public.\"TicketWare\" SET \"TicketId\"= @ticketId, \"WareId\"= @wareId WHERE \"Id\"= @id returning \"Id\";";
var par = new List <DbParameter> {
new NpgsqlParameter("id", ticketWare.Id),
new NpgsqlParameter("ticketId", ticketWare.TicketId),
new NpgsqlParameter("wareId", ticketWare.WareId)
};
return(dataMapper.NoQueryCommand(sql, par));
}
public long Update(TicketWare item)
{
long id = -1;
TicketWares = TicketWares.Select(i => {
if (i.Id == item.Id)
{
id = item.Id;
return(item);
}
id = -1;
return(i);
}).ToList();
return(id);
}
