private void UpdateRevenue(RevenueDTO revenue) { string sql = @" update dbo.Revenue set Revenue = @Revenue, Offer_id = @Offer_id, OfferAmount = @OfferAmount, date_created = @date_created, date_modified = @date_modified where batch_id = @Batch_id AND list_id = @List_id AND subscriber_id = @Subscriber_id "; _oenConnection.Execute(sql, revenue); }
private void InsertRevenue(RevenueDTO revenue) { string sql = "insert into dbo.Revenue (Batch_id, List_id, subscriber_id, revenue, offer_id, offeramount, date_created) values (@Batch_id, @List_id, @Subscriber_id, @Revenue, @Offer_id, @OfferAmount, @date_created)"; _oenConnection.Execute(sql, revenue); }