public static void AddMetalFinish(Models.AlphaContext context) { int count = context.MetalFinish.Count(); if (count == 0) { context.MetalFinish.AddRange(Metals.List.GetMetalFinishs()); } context.SaveChanges(); }
public static void AddMetalData(Models.AlphaContext context) { int count = context.MetalTypes.Count(); if (count == 0) { context.MetalTypes.AddRange(Metals.Data.MetalTypesList()); } context.SaveChanges(); }
public static void AddGemstoneData(Models.AlphaContext context) { int count = context.Gemstones.Count(); if (count == 0) { context.Gemstones.AddRange(GemStones.GemStonesData.CreateGemStoneData()); context.GemShapes.AddRange(GemStones.GemStonesData.GemStoneShapesData()); } context.SaveChanges(); }
public static void AddPartTypes(Models.AlphaContext context) { int count = context.PartTypes.Count(); if (count == 0) { context.PartTypes.AddRange(List.List.GetPartTypesList()); } else { List <PartType> localList = List.List.GetPartTypesList(); foreach (var item in context.PartTypes) { item.PartName = localList.Single(i => i.PartTypeID == item.PartTypeID).PartName; } //context.People.Single(i => i.LastName == "Beaver").PersonID, } context.SaveChanges(); }
/// <summary> /// Loads Test Data into the database /// </summary> /// <param name="context"></param> public static void AddTestData(Models.AlphaContext context) { var People = TestData.GetPerson(); if (context.People.Count() == 0) { context.People.AddRange(People); context.SaveChanges(); } if (context.Customers.Count() == 0) { context.Customers.AddRange(TestData.GetCustomers(People)); } context.SaveChanges(); if (context.Vendors.Count() == 0) { context.Vendors.AddRange(TestData.GetVendor()); } context.SaveChanges(); if (context.VendorContacts.Count() == 0) { context.VendorContacts.AddRange(TestData.GetVendorContact()); } context.SaveChanges(); if (context.CustomerSpecialDates.Count() == 0) { context.CustomerSpecialDates.AddRange(TestData.GetCustomerSpecialDates()); } context.SaveChanges(); if (context.Addresses.Count() == 0) { context.Addresses.AddRange(TestData.GetAddressList()); } context.SaveChanges(); if (context.EmailAddressess.Count() == 0) { context.EmailAddressess.AddRange(TestData.GetEmailAddressList()); } context.SaveChanges(); if (context.Repairs.Count() == 0) { context.Repairs.AddRange(TestData.GetRepairsList()); } context.SaveChanges(); if (context.Items.Count() == 0) { context.Items.AddRange(TestData.GetItems()); } context.SaveChanges(); if (context.ItemRepairs.Count() == 0) { context.ItemRepairs.AddRange(TestData.GetRepairItems()); } context.SaveChanges(); if (context.Parts.Count() == 0) { context.Parts.AddRange(TestData.GetParts()); List <DbEntityValidationResult> errors = context.GetValidationErrors().ToList(); } context.SaveChanges(); if (context.PartMetals.Count() == 0) { context.PartMetals.AddRange(TestData.GetMetalParts()); } context.SaveChanges(); if (context.PartGems.Count() == 0) { TestData.GetGemParts(context); } // context.SaveChanges(); }