public void SeedData(VehiclesPriceListAppContext context)
{
var ownersList = new[] {
new { fname = "Avi", lname = "Pro", address = "Jabotinski 14 Givatime" },
new { fname = "Guy", lname = "Bochveld", address = "Tzahal 32 Hod Hasharon" },
new { fname = "Yosi", lname = "Mizrahi", address = "Hovevei Zion 2 Petach Tikva" },
new { fname = "David", lname = "Hamelech", address = "Waizman 4 Ramat Gan" },
new { fname = "Moshe", lname = "Rabeno", address = "Rakefet 87 Tel Aviv" },
new { fname = "Gil", lname = "Cohen", address = "Almog 7 Oranit" },
new { fname = "Ziv", lname = "Barsheshet", address = "Shoshan 18 Ramat Efal" },
new { fname = "Nati", lname = "Simantov", address = "Haroee 23 Herzlia" },
new { fname = "Ofer", lname = "Wiess", address = "Nirit 31 Kfar Saba" },
}.ToList();
for (var i = 0; i < 100; i++)
{
context.VehicleOwner.Add(new VehicleOwner()
{
FirstName = ownersList[i % 9].fname,
LastName = ownersList[i % 9].lname,
Telephone = string.Format("05{0}-{1}{2}{3}{4}{5}{6}{7}", i % 4, i % 10, i % 6, i % 9, i % 10, i % 5, i % 7, i % 8),
Address = ownersList[i % 9].address,
EmailAddress = string.Format("{0}.{1}.{2}@CarSales.com", ownersList[i % 9].fname, ownersList[i % 9].lname, i),
});
}
}
public void SeedData(VehiclesPriceListAppContext context)
{
context.VehicleMenufacturer.Add(new VehicleMenufacturer()
{
Name = "Honda"
});
context.VehicleMenufacturer.Add(new VehicleMenufacturer()
{
Name = "Ford"
});
context.VehicleMenufacturer.Add(new VehicleMenufacturer()
{
Name = "Jeep"
});
context.VehicleMenufacturer.Add(new VehicleMenufacturer()
{
Name = "Kia"
});
context.VehicleMenufacturer.Add(new VehicleMenufacturer()
{
Name = "Alpha Romeo"
});
}
public void SeedData(VehiclesPriceListAppContext context)
{
context.VehicleStatus.Add(new VehicleStatus()
{
Name = "יד ראשונה"
});
context.VehicleStatus.Add(new VehicleStatus()
{
Name = "יד שנייה"
});
}
public void SeedData(VehiclesPriceListAppContext context)
{
context.VehicleType.Add(new VehicleType()
{
Name = "פרטי"
});
context.VehicleType.Add(new VehicleType()
{
Name = "מסחרי"
});
context.VehicleType.Add(new VehicleType()
{
Name = "גיפים"
});
}
public void SeedData(VehiclesPriceListAppContext context)
{
context.VehicleMenufacturingOrigin.Add(new VehicleMenufacturingOrigin()
{
Name = "Asia"
});
context.VehicleMenufacturingOrigin.Add(new VehicleMenufacturingOrigin()
{
Name = "USA"
});
context.VehicleMenufacturingOrigin.Add(new VehicleMenufacturingOrigin()
{
Name = "China"
});
context.VehicleMenufacturingOrigin.Add(new VehicleMenufacturingOrigin()
{
Name = "Germany"
});
}
public void SeedDatabase(VehiclesPriceListAppContext context)
{
//Get all the "ISeed" implementations in this assembly
var seedTypes = typeof(GlobalSeeder).Assembly.GetTypes().Where(t => typeof(ISeed).IsAssignableFrom(t) && t.IsClass);
//Little bit of Linq to object to get all the types in a suitable format.
var seeds =
seedTypes.Select(st => new
{
SeedType = st,
DependingSeeds = st.GetCustomAttributes(typeof(DependsOnAttribute), true).OfType <DependsOnAttribute>().Select(dst => dst.DependingType).ToList()
}).ToList();
//While there is still some seeds to process
while (seeds.Count > 0)
{
//Find all the seeds without anymore depending seeds to process
var oprhenSeeds = seeds.Where(s => s.DependingSeeds.Count == 0).ToList();
foreach (var orphenSeed in oprhenSeeds)
{
//Instanciate the current seed
ISeed seedInstance = (ISeed)Activator.CreateInstance(orphenSeed.SeedType);
//Execute seed process
seedInstance.SeedData(context);
//Remove the processed seed from all the dependant seeds
var relatedSeeds = seeds.Where(s => s.DependingSeeds.Any(ds => ds == orphenSeed.SeedType));
foreach (var relatedSeed in relatedSeeds)
{
relatedSeed.DependingSeeds.Remove(orphenSeed.SeedType);
}
//Remove the processed seed from the "to be processed list".
seeds.Remove(orphenSeed);
}
}
//Finally save all changes to the Entity framework context.
context.SaveChanges();
}
public void SeedData(VehiclesPriceListAppContext context)
{
var randomNumber = new Random();
KnownColor[] names = (KnownColor[])Enum.GetValues(typeof(KnownColor));
for (int i = 0; i < 100; i++)
{
context.VehiclePriceListItem.Add(new VehiclePriceListItem()
{
AskingPrice = (randomNumber.Next(40, 100) * 1000).ToString(),
DateReceived = DateTime.Now.ToLocalTime(),
EquippingDetails = "Comfrontline",
Color = names[randomNumber.Next(names.Length)].ToString(),
EngineType = "regular",
TestValidExpiration = DateTime.Now.ToLocalTime().AddMonths(1),
VehicleMenufacturer = context.VehicleMenufacturer.Local.Skip(randomNumber.Next(context.VehicleMenufacturer.Local.Count())).Take(1).FirstOrDefault(),
VehicleMenufacturingOrigin = context.VehicleMenufacturingOrigin.Local.Skip(randomNumber.Next(context.VehicleMenufacturingOrigin.Local.Count())).Take(1).FirstOrDefault(),
VehicleType = context.VehicleType.Local.Skip(randomNumber.Next(context.VehicleType.Local.Count())).Take(1).FirstOrDefault(),
VehicleOwner = context.VehicleOwner.Local.Skip(randomNumber.Next(context.VehicleOwner.Local.Count())).Take(1).FirstOrDefault(),
VehicleStatus = context.VehicleStatus.Local.Skip(randomNumber.Next(context.VehicleStatus.Local.Count())).Take(1).FirstOrDefault(),
});
}
}
public OwnersRepository(VehiclesPriceListAppContext ctx) : base(ctx)
{
}
public MenufactureringOriginRepository(VehiclesPriceListAppContext ctx) : base(ctx)
{
}
public StatusRepository(VehiclesPriceListAppContext ctx) : base(ctx)
{
}
public TypeRepository(VehiclesPriceListAppContext ctx) : base(ctx)
{
}
public UserRepository(VehiclesPriceListAppContext ctx)
{
_ctx = ctx;
}
