コード例 #1
0
ファイル: ConversionHandler.cs プロジェクト: c0d3m0nky/mty
        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);

        }
コード例 #2
0
ファイル: ConversionHandler.cs プロジェクト: c0d3m0nky/mty
 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);
 }