private void AddRandomGenresToDatabase() { using (var db = new CinameNetworkEntities()) { for (int i = 0; i < numberOfGenres; i++) { var genre = GetRandomGenre(); db.Genres.Add(genre); } db.SaveChanges(); } }
public void GenerateRandomData(string savePath) { AddRandomGenresToDatabase(); using (var db = new CinameNetworkEntities()) { var xElement = new XElement("Movies"); for (int i = 0; i < this.numberOfMovies; i++) { Movy movie = GetRandomMovie(); // Adding movie to database db.Movies.Add(movie); db.SaveChanges(); var xMovie = new XElement( "movie", new XElement("Title", movie.Title), new XElement("GenreId", movie.GenreId), new XElement("ReleaseDate", movie.ReleaseDate), new XElement("Director", movie.Director), new XElement("CountryId", movie.CountryId), new XElement("Description", movie.Description), new XElement("Description", movie.Description), new XElement("Subtitles", "yes"), new XElement("Duration", movie.DurationMinutes)); var xActors = new XElement("Actors"); foreach (var actor in movie.People) { xActors.Add(new XElement("Actor", actor.PersonId)); } xMovie.Add(new XElement("Actors", xActors)); xElement.Add(xMovie); } xElement.Save(savePath); } System.Console.WriteLine("Random movies added."); }
public static void ImportTowns(string filePath) { var currentDb = new CinameNetworkEntities(); string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filePath + "';" + "Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";"; OleDbConnection MyConnection = new OleDbConnection(connectionString); DataSet DtSet; OleDbDataAdapter MyCommand; MyCommand = new OleDbDataAdapter("select * from [Towns$]", MyConnection); MyCommand.TableMappings.Add("Table", "TestTable"); DtSet = new DataSet(); MyCommand.Fill(DtSet); var recordsCounter = 0; System.Console.WriteLine("Importing records from Excel file to database table: "); System.Console.WriteLine("------------------------"); foreach (var town in DtSet.Tables[0].AsEnumerable()) { if (!currentDb.Towns.Select(t => t.Name).ToList().Contains(town[0])) { currentDb.Towns.Add(new Town { Name = town[0].ToString() }); System.Console.WriteLine("Record added..."); recordsCounter++; } else { System.Console.WriteLine("Record found in the table.. continue"); } } System.Console.WriteLine("------------------------"); System.Console.WriteLine("All records added successfully!"); System.Console.WriteLine("Number of added records: {0}", recordsCounter); currentDb.SaveChanges(); MyConnection.Close(); }
public static void InsertNewCountries(int count) { while (count > 0) { var rand = new RandomGenerator(); CinameNetworkEntities northwindEntities = new CinameNetworkEntities(); Country newEntry = new Country { Name = rand.GetRandomString(5, 20) }; northwindEntities.Countries.Add(newEntry); northwindEntities.SaveChanges(); Console.WriteLine("Row affected - new country with movieId {0} created", newEntry.CountryId); count--; } }
private static OleDbCommand GetCommand(OleDbConnection oleDbConnection, string sheetName) { var countries = new List<string>(); var db = new CinameNetworkEntities(); using (db) { countries = db.Countries .Select(x => x.Name) .ToList(); } var cmd = new OleDbCommand("INSERT INTO [" + sheetName + "] VALUES (@name, @score)", oleDbConnection); for (int i = 0; i < countries.Count; i++) { cmd.Parameters.AddWithValue("@name", countries[i]); } return cmd; }
public static void Main(string[] args) { //int newId = InserNewMovie(); //Console.WriteLine("Row affected - new movie with movieId {0} created", newId); // InsertNewCountries(5); var countries = new List<string>(); var numberOfMoives = new List<int>(); var db = new CinameNetworkEntities(); using (db) { countries = db.Countries .Select(x => x.Name) .ToList(); numberOfMoives = db.Countries .Select(y => y.Movies.Count) .ToList(); } SqlToExcel.WriteDataToExcelFile(countries, numberOfMoives); }
public static int InserNewMovie() { var rand = new RandomGenerator(); CinameNetworkEntities northwindEntities = new CinameNetworkEntities(); Movy newProduct = new Movy { Title = rand.GetRandomString(5, 15), GenreId = rand.GetRandomInt(1, 1000), ReleaseDate = rand.GetRandomDateTime(), Director = rand.GetRandomInt(1, 1000), Actors = rand.GetRandomInt(1, 100), Description = rand.GetRandomString(20, 60), CoverLink = rand.GetRandomString(5, 25), Subtitles = false, DurationMinutes = rand.GetRandomInt(40, 150) }; northwindEntities.Movies.Add(newProduct); northwindEntities.SaveChanges(); return newProduct.MovieId; }
private Movy GetRandomMovie() { using (var db = new CinameNetworkEntities()) { var genreIds = db.Genres.Select(g => g.GenreId).ToList(); var countriesIds = db.Countries.Select(c => c.CountryId).ToList(); var peopleIds = db.People.Select(p => p.PersonId).ToList(); var people = db.People.ToList(); var movie = new Movy(); movie.Title = randomGenerator.GetRandomString(5, 20); movie.GenreId = genreIds[randomGenerator.GetRandomInt(0, genreIds.Count - 1)]; movie.ReleaseDate = randomGenerator.GetRandomDateTime(); movie.Director = peopleIds[randomGenerator.GetRandomInt(0, peopleIds.Count - 1)]; var numberOfActors = randomGenerator.GetRandomInt(3, 10); for (int i = 0; i < numberOfActors; i++) { movie.People.Add(people[randomGenerator.GetRandomInt(0, people.Count - 1)]); } movie.CountryId = countriesIds[randomGenerator.GetRandomInt(0, countriesIds.Count - 1)]; movie.Description = randomGenerator.GetRandomString(10, 20); movie.Subtitles = false; movie.DurationMinutes = randomGenerator.GetRandomInt(5, 200); return movie; } }
private IEnumerable<GenreModel> GetData(CinameNetworkEntities dbContext) { var genres = dbContext .Genres .Select(x => new GenreModel() { Name = x.Name, Movies = x.Movies .Select(m => new MovieModel() { Title = m.Title, ReleaseDate = m.ReleaseDate, Director = new PersonModel() { FirstName = m.Person.FirstName, LastName = m.Person.LastName, Gender = m.Person.Gender.Type, BirthYear = m.Person.BirthYear, Origin = m.Person.Country.Name }, Actors = m.People .Select(a => new PersonModel() { FirstName = a.FirstName, LastName = a.LastName, Gender = a.Gender.Type, BirthYear = a.BirthYear, Origin = a.Country.Name }) .ToList(), Country = m.Country.Name, Description = m.Description, CoverLink = m.CoverLink, HasSubtitles = m.Subtitles, Duration = m.DurationMinutes }) .ToList() }) .ToList(); return genres; }
public XmlReportGenerator(CinameNetworkEntities dbContext) { this.dbContext = dbContext; }