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 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 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 BeautifulChaosRepository(BeautifulChaosContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
this.Context = context;
}
public AdminApiController(BeautifulChaosContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
this.Context = context;
}
public static void SeedTestimonials(IApplicationBuilder applicationBuilder, BeautifulChaosContext context)
{
if (context.Testimonial.Any())
{
return;
}
try
{
var source = Directory.GetCurrentDirectory();
source += @"\SeedData\Testimonials.json";
var data = File.ReadAllText(source);
var testimonials = JsonConvert.DeserializeObject <List <Testimonial> >(data);
context.Testimonial.AddRange(testimonials);
context.SaveChanges();
}
catch (Exception ex)
{
var msg = ex;
}
}
public AboutRepository(BeautifulChaosContext context)
: base(context)
{
}
public TestimonialsRepository(BeautifulChaosContext context) : base(context)
{
}
public ImagesRepository(BeautifulChaosContext context)
: base(context)
{
}
public ServicesPageRepository(BeautifulChaosContext context)
: base(context)
{
}
public WorkRepository(BeautifulChaosContext context)
: base(context)
{
}
