public static List <string> GetTableNamesInModel()
{
using (Models.AlphaContext dbContext = new Models.AlphaContext())
{
var metadata = ((IObjectContextAdapter)dbContext).ObjectContext.MetadataWorkspace;
var tables = metadata.GetItemCollection(DataSpace.SSpace)
.GetItems <EntityContainer>()
.Single()
.BaseEntitySets
.OfType <EntitySet>()
.Where(s => !s.MetadataProperties.Contains("Type") ||
s.MetadataProperties["Type"].ToString() == "Tables");
List <string> returnValue = new List <string>();
foreach (var table in tables)
{
returnValue.Add(table.Name.ToString());
// Console.WriteLine(table.Name.ToString());
//var tableName = table.MetadataProperties.Contains("Table")
// && table.MetadataProperties["Table"].Value != null
// ? table.MetadataProperties["Table"].Value.ToString()
// : table.Name;
//var tableSchema = table.MetadataProperties["Schema"].Value.ToString();
//var sothin = table.MetadataProperties["Schema"].Value.ToString();
// Console.WriteLine(tableName);
//Console.WriteLine(tableSchema + "." + tableName );
}
Console.Read();
return(returnValue);
}
}
/// <summary>
/// List lookup data and data that will not change while the program is running
/// </summary>
/// <param name="context"></param>
public static void AddAllStaticData(Models.AlphaContext context)
{
sysMaintance.AddMetalData(context);
sysMaintance.AddGemstoneData(context);
sysMaintance.AddPartTypes(context);
sysMaintance.AddMetalFinish(context);
sysMaintance.AddDiamondData(context);
}
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();
}
public static void SeedDatabase(Models.AlphaContext context)
{
AddAllStaticData(context);
// AddTestData(context);
}
