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