public UnitOfWork(MovieDBContext context)
{
_context = context;
Movies = new MovieRepository(_context);
Users = new UserRepository(_context);
}
public MovieControllerTests()
{
_dbContext = new MovieDBContext();
_transaction = _dbContext.Database.BeginTransaction();
_dbContext.Movies.RemoveRange(_dbContext.Movies.ToList());
var aRomanceMovie = new Movie {
ID = 1, Genre = "Romance", Price = 1.00m, Rating = "A+", ReleaseDate = DateTime.Now, Title = "A Romance Movie"
};
var romeoAndJuliet = new Movie {
ID = 2, Genre = "Romance", Price = 1.00m, Rating = "A+", ReleaseDate = DateTime.Now, Title = "Romeo and Juliet"
};
var zoolander = new Movie {
ID = 3, Genre = "Comedy", Price = 1.00m, Rating = "A+", ReleaseDate = DateTime.Now, Title = "Romeo and Juliet"
};
var aComedyMovie = new Movie {
ID = 4, Genre = "Comedy", Price = 1.00m, Rating = "A+", ReleaseDate = DateTime.Now, Title = "A Comedy Movie"
};
_dbContext.Movies.Add(aRomanceMovie);
_dbContext.Movies.Add(romeoAndJuliet);
_dbContext.Movies.Add(zoolander);
_dbContext.Movies.Add(aComedyMovie);
_sut = new MoviesController(_dbContext);
}
public static void EnsurePopulated(IApplicationBuilder application)
{
MovieDBContext context = application.ApplicationServices.
CreateScope().ServiceProvider.GetRequiredService <MovieDBContext>();
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
if (!context.Movies.Any())
{
context.Movies.AddRange(
new Movie
{
Rating = "PG-13",
Category = "Action Adventure",
Title = "Indiana Jones and the Raiders of the Lost Ark",
Year = 1981,
Director = "Steven Spielberg",
LentTo = "",
Edited = false,
Notes = ""
}
);
//save all changes
context.SaveChanges();
}
}
public async Task <ActionResult <Movie> > PostMovie([FromBody] URLDTO URL)
{
String movieID = Helper.MovieHelper.GetMovieFromLink(URL.URL);
Movie newMovie = Helper.MovieHelper.GetMovieFromID(movieID);
_context.Movie.Add(newMovie);
await _context.SaveChangesAsync();
// We are creating a new context so that loading realted movies don't block the api.
MovieDBContext tempContext = new MovieDBContext();
RelatedMoviesController realtedMoviesController = new RelatedMoviesController(tempContext);
//// This will be executed in the background.
Task addCaptions = Task.Run(async() =>
{
List <RelatedMovie> relatedMovies = Helper.MovieHelper.GetRelatedMovies(movieID);
for (int i = 0; i < relatedMovies.Count; i++)
{
RelatedMovie relatedMovie = relatedMovies.ElementAt(i);
relatedMovie.MovieId = newMovie.MovieId;
// posting related movies to the database
await realtedMoviesController.PostRelatedMovie(relatedMovie);
}
});
return(CreatedAtAction("GetMovie", new { id = newMovie.MovieId }, newMovie));
}
public AdminForm(MovieDBContext db)
{
InitializeComponent();
Users = db.Users.ToList();
_db = db;
objectListView1.SetObjects(Users);
this.FormClosed += AdminForm_FormClosed;
}
// GET: Movie
public ActionResult Index()
{
using (var db = new MovieDBContext())
{
var movies = db.Movies.ToList();
return(View(movies));
}
}
public static ApplicationUserManager Create(IdentityFactoryOptions <ApplicationUserManager> options,
IOwinContext context)
{
MovieDBContext db = context.Get <MovieDBContext>();
ApplicationUserManager manager = new ApplicationUserManager(new UserStore <ApplicationUser>(db));
return(manager);
}
public MovieProvider(MovieDBContext dbContext, ILogger <Db.Movie> logger, IMapper mapper)
{
this.dbContext = dbContext;
this.logger = logger;
this.mapper = mapper;
SeedData();
}
public void SimpleCodeFirstSelect()
{
MovieDBContext db = new MovieDBContext();
db.Database.Initialize(true);
var l = db.Movies.ToList();
foreach (var i in l)
{
}
}
public FirstLoginForm(MovieDBContext db, User user)
{
_db = db;
_user = user;
genres = _db.MovieGenres.ToList();
InitializeComponent();
this.FormClosed += FirstLoginForm_FormClosed;
favoriteGenresSelect.Items.AddRange(genres.Select(g => g.Name).ToArray());
}
public void Store(MovieModel movieModel, MovieDBContext _context)
{
var newMovie = new Movies();
newMovie.Title = movieModel.Title;
newMovie.Genre = movieModel.Genre.ToString();
_context.Movies.Add(newMovie);
_context.SaveChanges();
}
static void Main(string[] args)
{
using (var db = new MovieDBContext())
{
Movie movie = new Movie {
Rank = 1, Title = "The Shawshank Redemption", Year = 1994
};
db.Movies.Add(movie);
db.SaveChanges();
}
}
public Users GetUsers(string username)
{
try
{
MovieDBContext db = new MovieDBContext();
return(db.Users.Where(o => o.Mobile == username || o.Email == username).Select(o => o).First());
}
catch (Exception e)
{
return(null);
}
}
public List <MovieList> GetRecommandedMovies(string customerID)
{
try
{
MovieDBContext db = new MovieDBContext();
return(db.UserIntrestedGenerics.Where(o => o.UserId == customerID).Select(o => o.UserIntrest.MovieList).Single().ToList());
}
catch (Exception e)
{
return(null);
}
}
public UserDashboardForm(MovieDBContext db, User user)
{
InitializeComponent();
_db = db;
_user = user;
if (_user.Age > 60)
{
SetAllControlsFont(this.Controls, 4);
}
this.FormClosed += UserDashboardForm_FormClosed;
goToDashboard();
}
public List <MovieList> GetMovieLists()
{
try
{
MovieDBContext db = new MovieDBContext();
return(db.MovieList.Select(o => o).ToList());
}
catch (Exception e)
{
return(null);
}
}
//static StreamReader f;
static void Main(string[] args)
{
ReadMovie rm = new ReadMovie();
MovieDBContext context = new MovieDBContext();
int cpt = rm.readAnddecodeline();
Console.WriteLine("Nombre de films inseres = " + cpt);
//Lecture + affichage de 5 premiers films
/*int[] tabIdFilm = { 2, 3, 5, 6, 9 };
* foreach(int FilmId in tabIdFilm)
* {
*
* Film film = context.Films.Find(FilmId);
* List<Actor> listeActors = film.Actors.ToList();
* Console.WriteLine(film);
* foreach (Actor actor in listeActors)
* Console.WriteLine(actor);
* }*/
//affichage des Star Wars
/* List<Film> listeStarWars = (from film in context.Films where film.FilmTitle.Equals("Star Wars") select film).ToList();
* foreach (Film f in listeStarWars)
* Console.WriteLine(f);*/
//Affichage des films dans lesquels joue Harrison Ford ou Tom Hanks
/*Actor a = context.Actors.SingleOrDefault(aa =>aa.ActorName.Equals("Harrison") && aa.ActorSurname== "Ford");
* Console.WriteLine(a);
* if (a != null)
* {
* List<Film> listeFilms = a.Films.ToList();
* foreach (Film ff in listeFilms)
* Console.WriteLine(ff);
* }
* else
* Console.WriteLine("Aucun film trouve");*/
//Mrs Doubtfire (dans lequel Robin Williams joue plusieurs rôles).
/*
* select Films.*, Actors.*,Characters.*
* from Films join CharacterActors on Films.FilmId=CharacterActors.FilmId
* join Actors on Actors.ActorId=CharacterActors.ActorId
* join Characters on Characters.CharacterId=CharacterActors.CharacterId
* where Films.FilmTitle='Mrs. Doubtfire' and Actors.ActorName='Robin' and Actors.ActorSurname='Williams';
*/
Console.ReadKey();
}
public ActionResult Delete(int id = 0)
{
using (var db = new MovieDBContext())
{
Movie movie = db.Movies.Find(id);
// Find the movie from db
if (movie == null) // There is no movie with the passed id
{
return(HttpNotFound());
}
return(View(movie));
}
}
private async Task asynctask(ThreadParam p)
{
//return await Task.Run(() => {
MovieDBContext tmpdb = new MovieDBContext();
p.to = tmpdb.Movies.ToList();
tmpdb.Dispose();
ViewBag.asyncThreadid2 = Thread.CurrentThread.ManagedThreadId;
await Task.Delay(100);
// return 0;
// });
}
public static void Seed()
{
MovieDBContext context = new MovieDBContext();
try
{
context.Movies.AddOrUpdate(i => i.Title,
new Movie
{
Title = "When Harry Met Sally",
ReleaseDate = DateTime.Parse("1989-1-11"),
Genre = "Romantic Comedy",
Price = 7.99M,
Rating = "PG"
},
new Movie
{
Title = "Ghostbusters ",
ReleaseDate = DateTime.Parse("1984-3-13"),
Genre = "Comedy",
Price = 8.99M,
Rating = "PG"
},
new Movie
{
Title = "Ghostbusters 2",
ReleaseDate = DateTime.Parse("1986-2-23"),
Genre = "Comedy",
Price = 9.99M,
Rating = "PG"
},
new Movie
{
Title = "Rio Bravo",
ReleaseDate = DateTime.Parse("1959-4-15"),
Genre = "Western",
Price = 3.99M,
Rating = "PG"
}
);
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
public void AlterTableTest()
{
ReInitDb();
MovieDBContext db = new MovieDBContext();
db.Database.Initialize(true);
var l = db.MovieFormats.ToList();
foreach (var i in l)
{
}
MovieFormat m = new MovieFormat();
m.Format = 8.0f;
db.MovieFormats.Add(m);
db.SaveChanges();
}
static void Main()
{
var connString = ConfigurationManager
.ConnectionStrings["MovieDB"]
.ConnectionString;
MovieDBContext movieDB = new MovieDBContext(connString);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var loginForm = new LoginForm(movieDB);
loginForm.Show();
Application.Run();
}
public ActionResult Edit(Movie movieToUpdate)
{
if (ModelState.IsValid)
{
//Update the data in db and show the list of movies
using (var db = new MovieDBContext())
{
db.Entry(movieToUpdate).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(movieToUpdate));
}
public ActionResult Add(Movie movieFromView)
{
if (ModelState.IsValid)
{
//Save the data in db and show the list of movies
using (var db = new MovieDBContext())
{
db.Movies.Add(movieFromView);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(movieFromView));
}
public void AddingEmptyRow()
{
using (MovieDBContext ctx = new MovieDBContext())
{
ctx.Database.Initialize(true);
ctx.EntitySingleColumns.Add(new EntitySingleColumn());
ctx.SaveChanges();
}
using (MovieDBContext ctx2 = new MovieDBContext())
{
var q = from esc in ctx2.EntitySingleColumns where esc.Id == 1 select esc;
Assert.AreEqual(1, q.Count());
}
}
public async Task GetMoviesBySearchText()
{
var options = new DbContextOptionsBuilder <MovieDBContext>().UseInMemoryDatabase(nameof(GetMoviesBySearchText)).Options;
var dbContext = new MovieDBContext(options);
CreateProducts(dbContext);
var productProfile = new MovieProfile();
var configuration = new MapperConfiguration(cfg => cfg.AddProfile(productProfile));
var mapper = new Mapper(configuration);
var movieProvider = new MovieProvider(dbContext, null, mapper);
var result = await movieProvider.SeachMovieAsync("Siddarth");
Assert.True(result.IsSucess);
}
//Returns all Genres currently in the database
public JsonResult GetAvailableGenres()
{
using (MovieDBContext db = new MovieDBContext())
{
var genres = from genre in db.Genres
select new { id = genre.TmdbGenreId, name = genre.Name };
//Expected JSON is in format: {[{}, {}, {}]}, i.e. array fo objects wrapped in an object
var returnObj = new
{
genres = genres.ToList()
};
return(Json(returnObj, JsonRequestBehavior.AllowGet));
}
}
public void WriteAllMovies()
{
var movieDbContext = new MovieDBContext();
var controller = new MoviesController(movieDbContext);
for (var i = 1; i <= NumberOfSearches; i++)
{
var result = controller.Index(movieGenre: null, searchString: null) as ViewResult;
var model = result.Model as IEnumerable <Movie>;
foreach (var movie in model)
{
Console.WriteLine($"Result {movie.Title}");
}
}
}
public void ConcurrencyCheck()
{
using (MovieDBContext db = new MovieDBContext())
{
db.Database.ExecuteSqlCommand(
@"DROP TABLE IF EXISTS `test3`.`MovieReleases`");
db.Database.ExecuteSqlCommand(
@"CREATE TABLE `MovieReleases` (
`Id` int(11) NOT NULL,
`Name` varbinary(45) NOT NULL,
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary");
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
try
{
MovieRelease mr = db.MovieReleases.Create();
mr.Id = 1;
mr.Name = "Commercial";
db.MovieReleases.Add(mr);
db.SaveChanges();
mr.Name = "Director's Cut";
db.SaveChanges();
}
finally
{
db.Database.ExecuteSqlCommand(@"DROP TABLE IF EXISTS `MovieReleases`");
}
// Check sql
Regex rx = new Regex(@"Query Opened: (?<item>UPDATE .*)", RegexOptions.Compiled | RegexOptions.Singleline);
foreach (string s in listener.Strings)
{
Match m = rx.Match(s);
if (m.Success)
{
CheckSql(m.Groups["item"].Value, SQLSyntax.UpdateWithSelect);
Assert.Pass();
}
}
Assert.Fail();
}
}
private void CreateProducts(MovieDBContext dbContext)
{
dbContext.Movies.Add(new Db.Movie
{
MovieId = 1,
Title = "180",
Release_Year = "2011",
Locations = "Randall Museum",
Production_Company = "SPI Cinemas",
Director = "Jayendra",
Writer = "Hemant",
Actor_1 = "Siddarth",
Actor_2 = "Nithya Menon",
Actor_3 = "Priya Anand"
});
dbContext.SaveChanges();
dbContext.Movies.Add(new Db.Movie
{
MovieId = 2,
Title = "180",
Release_Year = "2012",
Locations = "Randall Museum",
Production_Company = "SPI Cinemas",
Director = "Rajendra",
Writer = "Hemant",
Actor_1 = "Siddarth",
Actor_2 = "Anushka",
Actor_3 = "Urmila"
});
dbContext.SaveChanges();
dbContext.Movies.Add(new Db.Movie
{
MovieId = 3,
Title = "180",
Release_Year = "2013",
Locations = "Singapore",
Production_Company = "SPI Cinemas",
Director = "Upendra",
Writer = "Ramakant",
Actor_1 = "Anil Kapur",
Actor_2 = "Katrina",
Actor_3 = "Tapsee"
});
dbContext.SaveChanges();
}
private static int testMethodDelegate(int tm, MoviesController ctl)
{
if (!ctl.ms.mClient.KeyExists("xxxxxx2"))
{
MovieDBContext tmpdb = new MovieDBContext();
Movie mv = tmpdb.Movies.Find(6);
tmpdb.Dispose();
}
int tmp = 1;
for (int i = 0; i < tm * 1000; i++)
{
Random rnd = new Random();
int rd = rnd.Next(1, 1000);
tmp = (tmp * rd) % 999999999;
}
ctl.ViewBag.asyncThreadid2 = Thread.CurrentThread.ManagedThreadId;
return(tmp);
}
public string ShopCategoryTest()
{
using (var db = new MovieDBContext())
{
var generalCategory = db.ShopCategories.Single(c => c.CategoryId == 1);
var computerPeriphCategory = db.ShopCategories.Single(c => c.CategoryId == 3);
var miceCategory = db.ShopCategories.Where(c => c.CategoryId == 4).Single();
if (miceCategory.ParentCategory != null)
{
miceCategory.ParentCategory = miceCategory.ParentCategory.CategoryId == 3
? generalCategory
: computerPeriphCategory;
}
db.SaveChanges();
return("ShopCategoryTest complete");
}
}
public bool SaveCustomer(Customer req)
{
try
{
Users user_obj = new Users();
user_obj.Id = Guid.NewGuid().ToString();
user_obj.Email = req.Email;
user_obj.IsVerified = false;
user_obj.Mobile = req.MobileNumber;
user_obj.Name = req.Name;
MovieDBContext db = new MovieDBContext();
db.Users.Add(user_obj);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Initiate a new todo list for new user
/// </summary>
/// <param name="userName"></param>
private static void InitiateDatabaseForNewUser(string userName)
{
var db = new MovieDBContext();
TodoList todoList = new TodoList();
todoList.UserId = userName;
todoList.Title = "My Todo List #1";
todoList.Todos = new List <TodoItem>();
db.TodoLists.Add(todoList);
db.SaveChanges();
todoList.Todos.Add(new TodoItem()
{
Title = "Todo item #1", TodoListId = todoList.TodoListId, IsDone = false
});
todoList.Todos.Add(new TodoItem()
{
Title = "Todo item #2", TodoListId = todoList.TodoListId, IsDone = false
});
db.SaveChanges();
}
public void TestPrecisionNscale()
{
MovieDBContext db = new MovieDBContext();
db.Database.Initialize(true);
var l = db.Movies.ToList();
IDataReader r = execReader(string.Format(
@"select numeric_precision, numeric_scale from information_schema.columns
where table_schema = '{0}' and table_name = 'movies' and column_name = 'Price'", conn.Database));
r.Read();
Assert.AreEqual(16, r.GetInt32(0));
Assert.AreEqual(2, r.GetInt32(1));
}
public void FirstOrDefaultNested()
{
ReInitDb();
using (MovieDBContext ctx = new MovieDBContext())
{
ctx.Database.Initialize(true);
int DirectorId = 1;
var q = ctx.Movies.Where(p => p.Director.ID == DirectorId).Select(p =>
new
{
Id = p.ID,
FirstMovieFormat = p.Formats.Count == 0 ? 0.0 : p.Formats.FirstOrDefault().Format
});
string sql = q.ToString();
foreach (var r in q)
{
}
}
}
public void CheckByteArray()
{
MovieDBContext db = new MovieDBContext();
db.Database.Initialize(true);
string dbCreationScript =
((IObjectContextAdapter)db).ObjectContext.CreateDatabaseScript();
Regex rx = new Regex(@"`Data` (?<type>[^\),]*)", RegexOptions.Compiled | RegexOptions.Singleline);
Match m = rx.Match(dbCreationScript);
Assert.AreEqual("longblob", m.Groups["type"].Value);
}
public void CallStoredProcedure()
{
using (MovieDBContext context = new MovieDBContext())
{
context.Database.Initialize(true);
int count = context.Database.SqlQuery<int>("GetCount").First();
Assert.AreEqual(5, count);
}
}
