public static Campaign ToCampaign(this DataRow dr) { Campaign campaign = new Campaign(); campaign.ID = dr.GetInt("CampaignID"); campaign.Pixel = dr.GetString("Pixel"); return campaign; }
public static void Insert(Campaign campaign) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_INSERT_CAMPAIGN"); cmd.AddInputParam("pPublisherID", DbType.Guid, campaign.PublisherID); cmd.AddInputParam("pOfferID", DbType.Guid, campaign.OfferID); cmd.AddInputParam("pPixel", DbType.String, campaign.Pixel); cmd.AddOutputParam("oCampaignID", DbType.Int32); SqlHelpers.ExecuteNonQuery(cmd); }
public static void Update(Campaign campaign) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_UPDATE_CAMPAIGN"); cmd.AddInputParam("pCampaignID", DbType.Int32, campaign.ID); cmd.AddInputParam("pPixel", DbType.String, campaign.Pixel); SqlHelpers.ExecuteNonQuery(cmd); }