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); //campaign.ID = new int(SqlHelpers.ExecuteScalar(cmd)); 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); }