1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
|
namespace TennisOnline.DAL
{
public class TennisOnlineInitializer : DropCreateDatabaseIfModelChanges<TennisOnlineContext>
{
protected override void Seed(TennisOnlineContext context)
{
foreach (string line in File.ReadLines("/Content/Customer.csv"))
{
string[] parts = line.Split(';');
Customer customer = new Customer();
customer.Pin = null;
customer.AffiliationNumber = int.Parse(parts[0]);
customer.Name = parts[1];
customer.FirstName = parts[2];
customer.Mail =String.Empty;
customer.Address = parts[3];
customer.PostalCode = int.Parse(parts[4]);
customer.City = parts[5];
customer.PhoneNumber = parts[6];
System.Diagnostics.Debug.WriteLine("test" + parts[5]);
context.Customers.Add(customer);
context.SaveChanges();
}
var managers = new List<Manager>
{
new Manager { Pin = null, Name="Willems",FirstName="Jean-Marie",PhoneNumber="",Role="Président",AffiliationNumber=4005180 },
new Manager { Pin = null, Name="Angé",FirstName="Alain",PhoneNumber="",Role="Secrétaire et trésorier",AffiliationNumber=4034937 },
new Manager { Pin = null, Name="Beaujean",FirstName="Francis",PhoneNumber="",Role="Administrateur",AffiliationNumber=4010294 },
new Manager { Pin = null, Name="Follin",FirstName="Mario",PhoneNumber="",Role="Assistant travaux et entretien",AffiliationNumber=4005087 },
new Manager { Pin = null, Name="Gendarme",FirstName="Alain",PhoneNumber="",Role="Responsable de la publicité",AffiliationNumber=4032237 },
new Manager { Pin = null, Name="Angé",FirstName="Arnaud",PhoneNumber="",Role="Chargé des comptes de la commission des jeunes",AffiliationNumber=4013842 },
new Manager { Pin = null, Name="Angé",FirstName="Philippe",PhoneNumber="",Role="Sponsoring et organisation d'évènements",AffiliationNumber=4023069 },
new Manager { Pin = null, Name="Jonckeere",FirstName="Bernard",PhoneNumber="",Role="Chargé de la gestion des Interclubs",AffiliationNumber=4003851 },
new Manager { Pin = null, Name="Romedenne",FirstName="Guy",PhoneNumber="",Role="Chargé des relations avec la gérance",AffiliationNumber=4004295 },
new Manager { Pin = null, Name="Debont",FirstName="Cédric",PhoneNumber="",Role="Projet Couvert",AffiliationNumber=4016526 },
new Manager { Pin = null, Name="Laurent",FirstName="Cédric",PhoneNumber="",Role="Sponsoring",AffiliationNumber=4026588 },
};
managers.ForEach(s => context.Managers.Add(s));
context.SaveChanges();
var teachers = new List<Teacher>
{
new Teacher {Name="Stein",FirstName="Guy",Pin=null,Mail="",AffiliationNumber=4002370 },
new Teacher {Name="Dalmans",FirstName="Marc",Pin=null,Mail="",AffiliationNumber=4005059 },
new Teacher {Name="Lopez",FirstName="Vincent",Pin=null,Mail="",AffiliationNumber=4023647 },
new Teacher {Name="Gendarme",FirstName="Alain",Pin=null,Mail="",AffiliationNumber=4032237 },
new Teacher {Name="Daune",FirstName="Eric",Pin=null,Mail="",AffiliationNumber=4035200 },
new Teacher {Name="Onclin",FirstName="Julien",Pin=null,Mail="",AffiliationNumber=4019038 },
};
teachers.ForEach(s => context.Teachers.Add(s));
context.SaveChanges();
var tennisClubs = new List<TennisClub>
{
new TennisClub { Name="Tennis Club Visé",Address="Rue des 3 rois,1",City="Visé",PhoneNumber="043/794812" },
};
tennisClubs.ForEach(s => context.TennisClubs.Add(s));
context.SaveChanges();
var tennisCourts = new List<TennisCourt>
{
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=true },
new TennisCourt { Outside=false },
new TennisCourt { Outside=false },
new TennisCourt { Outside=false },
};
tennisCourts.ForEach(s => context.TennisCourts.Add(s));
context.SaveChanges();
}
}
} |
Partager