public static void SeedAbout(IApplicationBuilder applicationBuilder, BeautifulChaosContext context)
{
using (var transaction = context.Database.BeginTransaction())
{
if (context.About.Any())
{
return;
}
try
{
var source = Directory.GetCurrentDirectory();
source += @"\SeedData\About.json";
var data = File.ReadAllText(source);
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].About ON");
var about = JsonConvert.DeserializeObject <About>(data);
context.About.Add(about);
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].About OFF");
transaction.Commit();
}
catch (Exception ex)
{
var msg = ex.InnerException;
}
}
}
public static void SeedPage(IApplicationBuilder applicationBuilder, BeautifulChaosContext context)
{
if (context.Page.Any())
{
return;
}
using (var transaction = context.Database.BeginTransaction())
{
try
{
var source = Directory.GetCurrentDirectory();
source += @"\SeedData\Page.json";
var data = File.ReadAllText(source);
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Page] ON");
var pages = JsonConvert.DeserializeObject <List <Page> >(data);
context.Page.AddRange(pages);
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Page] OFF");
transaction.Commit();
}
catch (Exception ex)
{
var msg = ex;
}
}
}
public static void SeedImages(IApplicationBuilder applicationBuilder, BeautifulChaosContext context)
{
using (var transaction = context.Database.BeginTransaction())
{
if (context.Images.Any())
{
return;
}
try
{
var source = Directory.GetCurrentDirectory();
source += @"\SeedData\Image.json";
var data = File.ReadAllText(source);
var image = JsonConvert.DeserializeObject <Image>(data);
context.Images.Add(image);
context.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
var msg = ex;
}
}
}
public static void SeedContentColumns(IApplicationBuilder applicationBuilder, BeautifulChaosContext context)
{
if (context.ContentColumn.Any())
{
return;
}
try
{
var source = Directory.GetCurrentDirectory();
source += @"\SeedData\ContentColumn.json";
var data = File.ReadAllText(source);
var contentColumn = JsonConvert.DeserializeObject <List <ContentColumn> >(data);
context.ContentColumn.AddRange(contentColumn);
context.SaveChanges();
}
catch (Exception ex)
{
var msg = ex;
}
}
