public void ImportDataFromMongo(TelecommunicationDbContext telecommunicationDbContext, ITelecommunicationProviderMongoDbContext telecommunicationMongoDbContext) { var mongoData = new TelecommunicationProviderMongoDb(telecommunicationMongoDbContext); var usersCollection = mongoData.User.FindAll(); var telephonesCollection = mongoData.TelephoneNumber.FindAll(); var addressCollection = mongoData.Address.FindAll(); foreach (var item in usersCollection) { var user = new User { FirstName = item.FirstName, LastName = item.LastName, Ssn = item.Ssn, Type = item.Type, AddressId = item.AddressId }; telecommunicationDbContext.Users.Add(user); telecommunicationDbContext.SaveChanges(); } foreach (var item in telephonesCollection) { var phone = new TelephoneNumber { Number = item.Number, UserId = item.UserId }; telecommunicationDbContext.TelephoneNumbers.Add(phone); telecommunicationDbContext.SaveChanges(); } foreach (var item in addressCollection) { var address = new Address { Name = item.Name, Number = item.Number, City = item.City, Country = item.Country, ZipCode = item.ZipCode }; telecommunicationDbContext.Adresses.Add(address); telecommunicationDbContext.SaveChanges(); } Console.WriteLine("Import from Mongo is ready"); }
public void ImportContractsFromExcelFilesInFolder(TelecommunicationDbContext telecommunicationDbContext, string excelFolderDataPath) { ExcelImporter excelDataImporter = new ExcelImporter(); ICollection<Contract> importedContractsFromExcel = excelDataImporter.ImportContractsDataFromDirectory(excelFolderDataPath); foreach (var contract in importedContractsFromExcel) { telecommunicationDbContext.Contracts.Add(contract); } telecommunicationDbContext.SaveChanges(); }
public void ImportContractsFromXml(TelecommunicationDbContext telecommunicationDbContext, string xmlDataPath) { XmlImporter xmlDataImporter = new XmlImporter(); ICollection<Contract> importedContractsFromXml = xmlDataImporter.ImportContractsDataFromFile(xmlDataPath); foreach (var contract in importedContractsFromXml) { telecommunicationDbContext.Contracts.Add(contract); } telecommunicationDbContext.SaveChanges(); }
public void CreateDatabase(TelecommunicationDbContext context) { context.Adresses.Add( new Address { Name = "Cvetna Gradina", Number = 32, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Rakovska", Number = 32, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Aleksandar Malinov", Number = 32, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Bogatitsa", Number = 45, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Kliment Ohridski", Number = 62, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Cherny vryh", Number = 32, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.Adresses.Add( new Address { Name = "Arsenalski blvd", Number = 32, City = "Sofiq", Country = "Bulgaria", ZipCode = "1000" }); context.SaveChanges(); context.Users.Add( new User { LastName = "Stoycheva", FirstName = "Aleksandra", AddressId = 1, Ssn = "123467891236", Type = "Gold User" }); context.Users.Add( new User { LastName = "Dragneva", FirstName = "Pavlina", AddressId = 2, Ssn = "123467691236", Type = "Gold User" }); context.Users.Add(new User { LastName = "Madjarova", FirstName = "Velimira", AddressId = 3, Ssn = "123467861236", Type = "Gold User" }); context.Users.Add( new User { LastName = "Pesho", FirstName = "Peshov", AddressId = 1, Ssn = "123467881236", Type = "Gold User" }); context.Users.Add( new User { LastName = "Doncho", FirstName = "Minkov", AddressId = 4, Ssn = "127467691236", Type = "Gold User" }); context.Users.Add(new User { LastName = "Niki", FirstName = "Kostov", AddressId = 3, Ssn = "123467879236", Type = "Gold User" }); context.SaveChanges(); context.Packages.Add(new Package { Name = "A++", Type = "Gold", Price = 32 }); context.Packages.Add(new Package { Name = "B++", Type = "Gold", Price = 35 }); context.Packages.Add(new Package { Name = "A", Type = "Silver", Price = 25 }); context.Packages.Add(new Package { Name = "B", Type = "Silver+", Price = 28 }); context.Packages.Add(new Package { Name = "C++", Type = "Gold", Price = 50 }); context.Packages.Add(new Package { Name = "D++", Type = "Gold", Price = 35 }); context.Packages.Add(new Package { Name = "X", Type = "Silver", Price = 25 }); context.Packages.Add(new Package { Name = "M", Type = "Silver+", Price = 28 }); context.SaveChanges(); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 1, Number = "00359864576326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 2, Number = "00359864566466" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 3, Number = "00359864571326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 4, Number = "00359774591326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 5, Number = "00359864556326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 6, Number = "00359864566466" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 4, Number = "00359864544326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 1, Number = "00359774521326" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 5, Number = "00359456123783" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 6, Number = "00359456123782" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 4, Number = "00359456123781" }); context.TelephoneNumbers.Add(new TelephoneNumber { UserId = 1, Number = "00359456123789" }); context.SaveChanges(); }