public static Campaign GetById(int id)
{
using (var context = new CampaignContext(Settings.ConnectionString))
{
return(context.Campaigns.Find(id));
}
}
public static IEnumerable <Campaign> GetAll()
{
using (var context = new CampaignContext(Settings.ConnectionString))
{
return(context.Campaigns.ToList());
}
}
public static void UpdateCampaign(Campaign campaign)
{
using (var context = new CampaignContext(Settings.ConnectionString))
{
context.Entry(campaign).State = EntityState.Modified;
context.SaveChanges();
}
}
public static Campaign GetByIdUsingSql(int campaignId)
{
using (var context = new CampaignContext(Settings.ConnectionString))
{
return(context.Database.SqlQuery <Campaign>(@"SELECT [Id]
,[CampaignImpactId]
,[Description]
,[ExternalUrl]
,[ExternalUrlText]
,[Featured]
,[FullDescription]
,[Headline]
,[ImageUrl]
,[LocationId]
,[Locked]
,[ManagingOrganizationId]
,[Name]
,[OrganizerId]
,[TimeZoneId]
FROM [dbo].[Campaign] WHERE [Id] = @p0", campaignId).Single());
}
}
