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 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158
|
namespace TennisOnline.DAL
{
public class TennisOnlineInitializer :DropCreateDatabaseIfModelChanges <TennisOnlineContext>
{
protected override void Seed(TennisOnlineContext context)
{
foreach (string line in File.ReadLines("C:/Users/De Toma Francesco/Desktop/Projet Tennis/share/Projet Tennis/tennisonline/TennisOnline/TennisOnline/Content/Customer.csv"))
{
try
{
string[] parts = line.Split(';');
Customer customer = new Customer()
{
Pin = null,
AffiliationNumber = int.Parse(parts[0]),
Name = parts[1],
FirstName = parts[2],
Mail = string.Empty,
Address = parts[3],
PostalCode = int.Parse(parts[4]),
City = parts[5],
PhoneNumber = parts[6],
Authorized=true,
};
context.Customers.Add(customer);
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
var tennisClubs = new List<TennisClub>
{
new TennisClub { Name="Tennis Club Visé",Address="Rue des 3 rois,1",City="Visé",PhoneNumber="043/794812" },
};
try
{
tennisClubs.ForEach(s => context.TennisClubs.Add(s));
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
var managers = new List<Manager>
{
new Manager { Name="Willems",FirstName="Jean-Marie",PhoneNumber=string.Empty,Role="Président",AffiliationNumber=4005180 },
new Manager { Name="Angé",FirstName="Alain",PhoneNumber=string.Empty,Role="Secrétaire et trésorier",AffiliationNumber=4034937 },
new Manager { Name="Beaujean",FirstName="Francis",PhoneNumber=string.Empty,Role="Administrateur",AffiliationNumber=4010294 },
new Manager { Name="Follin",FirstName="Mario",PhoneNumber=string.Empty,Role="Assistant travaux et entretien",AffiliationNumber=4005087 },
new Manager { Name="Gendarme",FirstName="Alain",PhoneNumber=string.Empty,Role="Responsable de la publicité",AffiliationNumber=4032237 },
new Manager { Name="Angé",FirstName="Arnaud",PhoneNumber=string.Empty,Role="Chargé des comptes de la commission des jeunes",AffiliationNumber=4013842 },
new Manager { Name="Angé",FirstName="Philippe",PhoneNumber=string.Empty,Role="Sponsoring et organisation d'évènements",AffiliationNumber=4023069 },
new Manager { Name="Jonckeere",FirstName="Bernard",PhoneNumber=string.Empty,Role="Chargé de la gestion des Interclubs",AffiliationNumber=4003851 },
new Manager { Name="Romedenne",FirstName="Guy",PhoneNumber=string.Empty,Role="Chargé des relations avec la gérance",AffiliationNumber=4004295 },
new Manager { Name="Debont",FirstName="Cédric",PhoneNumber=string.Empty,Role="Projet Couvert",AffiliationNumber=4016526 },
new Manager { Name="Laurent",FirstName="Cédric",PhoneNumber=string.Empty,Role="Sponsoring",AffiliationNumber=4026588 },
};
try
{
managers.ForEach(s => context.Managers.Add(s));
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
var teachers = new List<Teacher>
{
new Teacher {Name="Stein",FirstName="Guy",Mail=string.Empty,AffiliationNumber=4002370 },
new Teacher {Name="Dalmans",FirstName="Marc",Mail=string.Empty,AffiliationNumber=4005059 },
new Teacher {Name="Lopez",FirstName="Vincent",Mail=string.Empty,AffiliationNumber=4023647 },
new Teacher {Name="Gendarme",FirstName="Alain",Mail=string.Empty,AffiliationNumber=4032237 },
new Teacher {Name="Daune",FirstName="Eric",Mail=string.Empty,AffiliationNumber=4035200 },
new Teacher {Name="Onclin",FirstName="Julien",Mail=string.Empty,AffiliationNumber=4019038 },
};
try
{
teachers.ForEach(s => context.Teachers.Add(s));
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
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 },
};
try
{
tennisCourts.ForEach(s => context.TennisCourts.Add(s));
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
} |
Partager