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