static void Main(string[] args) { using (var db = new AllInOfficeDbContext()) { //db.Database.EnsureDeleted(); // //db.Database.EnsureCreated(); //Seed(db); db.Employees.Update(e => new Employee { Salary = e.Salary + 10000m }); } }
private static void Seed(AllInOfficeDbContext db) { //var employees = new[] // { // new Employee { EmployeeId = 1, FirstName = "Kiro", LastName = "Pora", AddressId = 2, BirthDate = DateTime.ParseExact("1990/01/02", "yyyy/MM/dd", CultureInfo.InvariantCulture), DepartmentId = 6, Email = "*****@*****.**", Gender = Gender.Male, MeritialStatus = MeritialStatus.Single, Position = "Juniour Seller", Salary = 1234.56m }, // new Employee { EmployeeId = 2, FirstName = "Ilarion", LastName = "Makariopolski", AddressId = 3, BirthDate = DateTime.ParseExact("1987/10/20", "yyyy/MM/dd", CultureInfo.InvariantCulture), DepartmentId = 5, Email = "*****@*****.**", Gender = Gender.Male, MeritialStatus = MeritialStatus.Meried, Position = "Export Packing", Salary = 1432.65m }, // new Employee { EmployeeId = 3, FirstName = "Minka", LastName = "Svirkata", AddressId = 4, BirthDate = DateTime.ParseExact("1993/11/02", "yyyy/MM/dd", CultureInfo.InvariantCulture), DepartmentId = 3, Email = "*****@*****.**", Gender = Gender.Female, MeritialStatus = MeritialStatus.Devorced, Position = "TDM", Salary = 650.14m }, // new Employee { EmployeeId = 4, FirstName = "Pesho", LastName = "Pora", AddressId = 5, BirthDate = DateTime.ParseExact("1990/01/02", "yyyy/MM/dd", CultureInfo.InvariantCulture), DepartmentId = 2, Email = "*****@*****.**", Gender = Gender.Male, MeritialStatus = MeritialStatus.Devorced, Position = "Chief Security", Salary = 903.26m } // }; // //db.Employees.AddRange(employees); //db.SaveChanges(); // //var clients = new[] //{ // new Client { FirstName = "Svetoslav", LastName = "Nakov", Gender = Gender.Male, BirthDate = DateTime.ParseExact("1980/07/31", "yyyy/MM/dd", CultureInfo.InvariantCulture), CompanyName = "HardUni", Password = "******", ResponsiveEmployeeId = 1, Email = "*****@*****.**", Bulstat = "53464453"}, // new Client { FirstName = "Vladislav", LastName = "Dimanovski", Gender = Gender.Male, BirthDate = DateTime.ParseExact("1989/07/30", "yyyy/MM/dd", CultureInfo.InvariantCulture), CompanyName = "SoftSchool", Password = "******", ResponsiveEmployeeId = 2, Email = "*****@*****.**", Bulstat = "45263584"}, // new Client { FirstName = "Slavin", LastName = "Drajev", Gender = Gender.Male, BirthDate = DateTime.ParseExact("1979/01/12", "yyyy/MM/dd", CultureInfo.InvariantCulture), CompanyName = "GirlsExport", Password = "******", ResponsiveEmployeeId = 1, Email = "*****@*****.**", Bulstat = "12323445"}, // new Client { FirstName = "Courtney", LastName = "Cocks", Gender = Gender.Female, BirthDate = DateTime.ParseExact("1964/06/15", "yyyy/MM/dd", CultureInfo.InvariantCulture), CompanyName = "Hard&Proud", Password = "******", ResponsiveEmployeeId = 4, Email = "*****@*****.**", Bulstat = "89787454"}, // new Client { FirstName = "Sofi", LastName = "Marinova", Gender = Gender.Female, BirthDate = DateTime.ParseExact("1965/04/12", "yyyy/MM/dd", CultureInfo.InvariantCulture), CompanyName = "CS", Password = "******", ResponsiveEmployeeId = 2, Email = "*****@*****.**", Bulstat = "25853674"} // }; // //db.Clients.AddRange(clients); //db.SaveChanges(); //var vehicles = new[] //{ // new Vehicle { Brand = "VW", Model = "Caddy", RegNumber = "C1234AC", DateRegistrated = DateTime.ParseExact("2016/01/01", "yyyy/MM/dd", CultureInfo.InvariantCulture)}, // new Vehicle { Brand = "Ferrari", Model = "Enzo", RegNumber = "C4321AC", DateRegistrated = DateTime.ParseExact("2014/04/04", "yyyy/MM/dd", CultureInfo.InvariantCulture)}, // new Vehicle { Brand = "Lada", Model = "2105", RegNumber = "A1623KA", DateRegistrated = DateTime.ParseExact("2015/03/03", "yyyy/MM/dd", CultureInfo.InvariantCulture)}, // new Vehicle { Brand = "VW", Model = "Paddy", RegNumber = "CB1234AC", DateRegistrated = DateTime.ParseExact("2017/02/02", "yyyy/MM/dd", CultureInfo.InvariantCulture)}, // }; // //db.Vehicles.AddRange(vehicles); //db.SaveChanges(); //var phoneNumbers = new[] //{ // new PhoneNumber {PnoneNumber = "056858888", EmployeeId = 1}, // new PhoneNumber {PnoneNumber = "0877784512", EmployeeId = 2}, // new PhoneNumber {PnoneNumber = "0877235689", EmployeeId = 3}, // new PhoneNumber {PnoneNumber = "0898546210", ClientId = 1}, // new PhoneNumber {PnoneNumber = "0898546215", ClientId = 1}, // new PhoneNumber {PnoneNumber = "0886887763", ClientId = 2}, // new PhoneNumber {PnoneNumber = "0886887762", ClientId = 2}, // new PhoneNumber {PnoneNumber = "0888654832", ClientId = 3}, // new PhoneNumber {PnoneNumber = "0886887761", ClientId = 2} // }; // //db.PhoneNumbers.AddRange(phoneNumbers); //db.SaveChanges(); // //var orders = new[] //{ // new Order { ClientId = 1, DateRecived = DateTime.ParseExact("2017/11/21", "yyyy/MM/dd", CultureInfo.InvariantCulture), AddressId = 6, EmployeeServecingId = 1}, // new Order { ClientId = 2, DateRecived = DateTime.ParseExact("2017/11/12", "yyyy/MM/dd", CultureInfo.InvariantCulture), AddressId = 7, EmployeeServecingId = 2, OrderAccepted = true, OrderDelivered = true}, // }; // //db.Orders.AddRange(orders); //db.SaveChanges(); }