protected override void OnCreate(Bundle savedInstanceState)
{
Window.RequestFeature(WindowFeatures.ContentTransitions);
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.MoviePageLayout);
_movie = Schedule.GetMovieByID(Intent.GetIntExtra("MovieID", 0));
FindViews();
Initialize();
Animate();
}
public void FillPage(Movie movie)
{
name.Text = movie.name;
date.Text = movie.date;
country.Text = movie.country;
genre.Text = movie.genres.ToString();
img.Source = movie.image;
studio.Text = movie.studio;
this.movie = movie;
}
public IActionResult Index()
{
Model.Movie movie = new Model.Movie
{
Title = "The Godfather",
ReleaseDate = new DateTime(1972, 3, 24)
};
ViewData["name"] = movie.Title;
return(View(movie));
}
public bool UpdateMovie(Model.Movie innMovie, String ImagePath)
{
if (innMovie.Title == "Title" && ImagePath == "jpg/image.jpg")
{
return(true);
}
else
{
return(false);
}
}
public bool AddMovie(Model.Movie movie, string ImagePath)
{
if (movie.Title == "Title" && ImagePath == "jpg/image.jpg")
{
return(true);
}
else
{
return(false);
}
}
public async void feelUsersMovies()
{
ListViewItem listViewItem = new ListViewItem();
listUserMovie = moviesFromDatabase.getMoviesFromDatabase();
foreach (Model.UserMovie movie in listUserMovie)
{
Model.Movie movieModel = await ViewModel.JsonParser.getMovieById(movie.imdbId);
listViewUserMovies.Items.Add(movieModel.title + ' ' + movie.userVote);
}
}
private void BtnUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
BL.Movie movieLogic = new BL.Movie();
Model.Movie movie = movieLogic.findMovie(txtId.Text);
UpdateMovie um = new UpdateMovie(txtId.Text);
um.Show();
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
public Model.Movie GetMovie(int id)
{
using (PersonServiceClient proxy = new PersonServiceClient())
{
Movie m = proxy.GetMovie(id);
Model.Movie movie = new Model.Movie();
movie.MovieId = m.MovieId;
movie.MovieLength = m.MovieLength;
movie.PremiereDate = m.PremiereDate;
movie.Resume = m.Resume;
movie.Title = m.Title;
movie.ImagePath = m.ImagePath;
movie.Genre = m.Genre;
return(movie);
}
}
public SearchMovieCatalogResponseJSON searchMovieCatalog(SearchMovieCatalogRequestJSON req)
{
SearchMovieCatalogResponseJSON res = new SearchMovieCatalogResponseJSON();
using (MovieEntities db = new MovieEntities())
{
string keyword = !string.IsNullOrWhiteSpace(req.keyword) ? req.keyword : "";
var query = db.pr_SearchMovieCatalog(keyword, req.pageNumber, req.pageSize).ToList();
List <Model.Movie> lst = new List <Model.Movie>();
foreach (var item in query)
{
Model.Movie m = new Model.Movie();
m.description = item.description;
m.genre = item.genre;
m.language = item.language;
if (item.releasedate.HasValue)
{
m.releasedate = item.releasedate.Value.ToShortDateString();
}
else
{
m.releasedate = "";
}
m.title = item.title;
m.price = item.price;
List <string> actors = new List <string>();
if (!string.IsNullOrWhiteSpace(item.actors))
{
string[] actorarr = item.actors.Split(',');
foreach (var actor in actorarr)
{
actors.Add(actor);
}
m.actors = actors;
}
else
{
m.actors = actors;
}
lst.Add(m);
}
res.Movies = lst;
}
return(res);
}
public List <Model.Movie> GetMovies()
{
var MovieList = new List <Model.Movie>();
var Movie = new Model.Movie()
{
Title = "Movie",
Director = "Director",
Actor = "Actor",
Genre = "Genre",
Price = 199
};
MovieList.Add(Movie);
MovieList.Add(Movie);
MovieList.Add(Movie);
return(MovieList);
}
private async void SaveMovies(IEnumerable <TMDB.DiscoveredMovie> discoveredMovies)
{
foreach (var discoveredMovie in discoveredMovies)
{
var imageUrl = discoveredMovie.Poster_Path is null
? ""
: $"https://image.tmdb.org/t/p/w200{discoveredMovie.Poster_Path}";
var movie = new Model.Movie()
{
Id = discoveredMovie.Id,
AverageRating = discoveredMovie.Vote_Average,
Description = discoveredMovie.Overview,
ImageUrl = imageUrl,
Title = discoveredMovie.Title
};
_context.Movies.Attach(movie);
await _context.Movies.AddAsync(movie);
foreach (var tagId in discoveredMovie.Genre_Ids)
{
var movieTag = new Model.MovieTag()
{
MovieId = discoveredMovie.Id,
TagId = tagId
};
try
{
_context.MovieTags.Attach(movieTag);
await _context.MovieTags.AddAsync(movieTag);
}
catch { }
}
//try
//{
await _context.SaveChangesAsync();
//}
//catch ( DbUpdateException e ){ Console.WriteLine(e.Message); }
}
}
public List <Model.Movie> GetAllMovies()
{
using (PersonServiceClient proxy = new PersonServiceClient())
{
List <Model.Movie> movies = new List <Model.Movie>();
List <Movie> mS = proxy.GetAllMovies();
foreach (Movie m in mS)
{
Model.Movie movie = new Model.Movie();
movie.MovieId = m.MovieId;
movie.MovieLength = m.MovieLength;
movie.PremiereDate = m.PremiereDate;
movie.Resume = m.Resume;
movie.Title = m.Title;
movie.ImagePath = m.ImagePath;
movie.Genre = m.Genre;
movies.Add(movie);
}
return(movies);
}
}
public Model.Movie GetMovie(int id)
{
if (id == 1)
{
var returnMovie = new Model.Movie()
{
Title = "Tittel",
Actor = "Actor",
Director = "Director",
Genre = "Genre"
};
return(returnMovie);
}
else
{
var Movie = new Model.Movie()
{
Title = "Fail",
};
return(Movie);
}
}
public int Create(Model.Movie Movie)
{
return(base.Channel.Create(Movie));
}
public List<Model.Movie> getMovieListByName(string name)
{
List<Model.Movie> lst = new List<Model.Movie>();
string sql = "SELECT * FROM Movies WHERE (MovieName LIKE @movieName) ORDER BY MovieName";
SqlParameter[] sps = new SqlParameter[]{
new SqlParameter(){ParameterName="@movieName",Value="%"+name+"%"}
};
DataTable dt = DBUtility.SqlHelper.executeTable(sql,
CommandType.Text, sps);
foreach (DataRow item in dt.Rows)
{
Model.Movie emp = new Model.Movie() { MovieID = int.Parse(item[0].ToString()),
MovieName = item[1].ToString(), CoverURL = item[2].ToString(),
Director = item[3].ToString(), Protagonist = item[4].ToString(),
Type = item[5].ToString(), ReleaseDate = DateTime.Parse(item[6].ToString()),
RunTime = item[7].ToString()};
lst.Add(emp);
}
return lst;
//throw new NotImplementedException();
}
public System.Threading.Tasks.Task <Model.Movie> UpdateAsync(Model.Movie Movie)
{
return(base.Channel.UpdateAsync(Movie));
}
public System.Threading.Tasks.Task <int> CreateAsync(Model.Movie Movie)
{
return(base.Channel.CreateAsync(Movie));
}
public Model.Movie Update(Model.Movie Movie)
{
return(base.Channel.Update(Movie));
}
public List<Model.Movie> getMovieList()
{
List<Model.Movie> lst = new List<Model.Movie>();
DataTable dt = DBUtility.SqlHelper.executeTable("select * from Movies", CommandType.Text, null);
foreach (DataRow item in dt.Rows)
{
Model.Movie emp = new Model.Movie() { MovieID = int.Parse(item[0].ToString()), MovieName = item[1].ToString(), CoverURL = item[2].ToString(),Director = item[3].ToString(), Protagonist = item[4].ToString(), Type = item[5].ToString(),ReleaseDate=DateTime.Parse(item[6].ToString()),RunTime=item[7].ToString() };
lst.Add(emp);
}
return lst;
//throw new NotImplementedException();
}
public Product(Movie b)
{
movie = b;
}
public void Init(DBContext context)
{
var Movie1 = new Model.Movie
{
Title = "Solo: A Star War Story",
Genre = "Action",
Actor = "Emila Clarke",
Director = "Ron Haward",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img.jpg"
};
var Movie2 = new Model.Movie
{
Title = "The Meg",
Genre = "Action",
Actor = "Ruby Rose",
Director = "Jon Turteltaub",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img1.jpg"
};
var Movie3 = new Model.Movie
{
Title = "Venom",
Genre = "Action",
Actor = "Tom Hardy",
Director = "Ruben Fleisher",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img2.jpg",
};
var Movie4 = new Model.Movie
{
Title = "Misson Impossible: Fallout",
Genre = "Action",
Actor = "Tom Cruise",
Director = "Christopher McQuarrie",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img3.jpg"
};
var Movie5 = new Model.Movie
{
Title = "Black Panther",
Genre = "Adventure",
Actor = "Chadwic Boseman",
Director = "Ryan Coogler",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img4.jpg"
};
var Movie6 = new Model.Movie
{
Title = "Alpha",
Genre = "Action",
Actor = "Kodi Smit-McPhee",
Director = "Albert Hughes",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img5.jpg"
};
var Movie7 = new Model.Movie
{
Title = "Jonny English Strikes Again",
Genre = "Comedy",
Actor = "Rowan Atkinson",
Director = "David Kerr",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img6.jpg"
};
var Movie8 = new Model.Movie
{
Title = "The Equalize 2",
Genre = "Action",
Actor = "Denzel Washington",
Director = "Antonie Fuqua",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img7.jpg"
};
var Movie9 = new Model.Movie
{
Title = "Tag",
Genre = "Comedy",
Actor = "Jenny Renner",
Director = "Jeff Tosmic",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img8.jpg"
};
var Movie10 = new Model.Movie
{
Title = "Uncle Drew",
Genre = "Comedy",
Actor = "Kyrie Irving",
Director = "Charles Stone lll",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img9.jpg"
};
var Movie11 = new Model.Movie
{
Title = "Night School",
Genre = "Comedy",
Actor = "Kevin Hart",
Director = "Malcom D.Lee",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img10.jpg"
};
var Movie12 = new Model.Movie
{
Title = "Game Night",
Genre = "Comedy",
Actor = "Jason Batman",
Director = "John Francis Daley",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img11.jpg"
};
var Movie13 = new Model.Movie
{
Title = "Life Of The Party",
Genre = "Comedy",
Actor = "Melissa McCarthy",
Director = "Melissa McCarthy",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img12.jpg"
};
var Movie14 = new Model.Movie
{
Title = "Jurrasic World",
Genre = "Adventure",
Actor = "Chris Pratt",
Director = "J.A. Bayona",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img13.jpg"
};
var Movie15 = new Model.Movie
{
Title = "Avvengers: Infinity War",
Genre = "Adventure",
Actor = "Robert D.Jr.",
Director = "Joe Russo",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img14.jpg"
};
var Movie16 = new Model.Movie
{
Title = "Ant-Man and The Wasp",
Genre = "Adventure",
Actor = "Paul Rudd",
Director = "Peython Reed",
ReleasedYear = 2018,
Price = 199,
Image = "jpg/img15.jpg"
};
/*
* var Movie17 = new Model.Movie
* {
* Title = "Next Gen",
* Genre = "Adventure",
* Actor = "JAson Sudeikis",
* Director = "Kevin R.Adams.",
* ReleasedYear = 2018,
* Price = 199,
* Image = "jpg/img16.jpg"
* };
*
* var Movie18 = new Model.Movie
* {
* Title = "Spiderman: Into the spider-verse",
* Genre = "Adventure",
* Actor = "Nicholas Cage",
* Director = "Bob Persichetti",
* ReleasedYear = 2018,
* Price = 199,
* Image = "jpg/img17.jpg"
* };
*/
context.MovieTable.Add(Movie1);
context.MovieTable.Add(Movie2);
context.MovieTable.Add(Movie3);
context.MovieTable.Add(Movie4);
context.MovieTable.Add(Movie5);
context.MovieTable.Add(Movie6);
context.MovieTable.Add(Movie7);
context.MovieTable.Add(Movie8);
context.MovieTable.Add(Movie9);
context.MovieTable.Add(Movie10);
context.MovieTable.Add(Movie11);
context.MovieTable.Add(Movie12);
context.MovieTable.Add(Movie13);
context.MovieTable.Add(Movie14);
context.MovieTable.Add(Movie15);
context.MovieTable.Add(Movie16);
// context.MovieTable.Add(Movie17);
// context.MovieTable.Add(Movie18);
string path = HttpContext.Current.Server.MapPath(@"~\Content\Postnummerregister-ansi.txt");
string[] lines = System.IO.File.ReadAllLines(path);
foreach (var line in lines)
{
string[] words = line.Split('\t');
var postedsRad = new Model.City()
{
Postnummer = words[0],
Poststed = words[1]
};
context.CityTable.Add(postedsRad);
context.SaveChanges();
}
var defaultAdmin = new Model.Users
{
Fornavn = "Administrator",
Etternavn = "",
Adresse = "",
Epost = "Admin",
AccessLevel = "Admin"
};
byte[] salt = UserDAL.LagSalt();
byte[] hash = UserDAL.LagHash("admin", salt);
defaultAdmin.Passord = hash;
defaultAdmin.Salt = salt;
context.UserTable.Add(defaultAdmin);
context.SaveChanges();
}
public List<Model.Movie> getSoonMovieList(int cinemaID)
{
List<Model.Movie> movies = new List<Model.Movie>();
DateTime now = DateTime.Now;//获取现在的系统时间
string sql = "SELECT DISTINCT MovieID,MovieName,CoverURL,Director,Protagonist,MovieType,ReleaseDate,RunTime FROM vew_PlayTime WHERE CinemaID=@cinemaID AND PlayTime>@todayTime ORDER BY RunTime ASC";
SqlParameter[] sps = new SqlParameter[]{
new SqlParameter(){ParameterName="@todayTime",Value=now},
new SqlParameter(){ParameterName="@cinemaID",Value=cinemaID}
};
DataTable dt = DBUtility.SqlHelper.executeTable(sql, CommandType.Text, sps);
foreach (DataRow item in dt.Rows)
{
Model.Movie movie = new Model.Movie()
{
MovieID = int.Parse(item[0].ToString()),
MovieName = item[1].ToString(),
CoverURL = item[2].ToString(),
Director = item[3].ToString(),
Protagonist = item[4].ToString(),
Type = item[5].ToString(),
ReleaseDate = DateTime.Parse(item[6].ToString()),
RunTime = item[7].ToString()
};
movies.Add(movie);
}
return movies;
//throw new NotImplementedException();
}
public Model.Movie getMovieById(int id)
{
List<Model.Movie> lst = new List<Model.Movie>();
//Model.Movie movie = new Model.Movie();
string sql = "SELECT * FROM Movies WHERE MovieID=@movieID";
SqlParameter[] sps = new SqlParameter[]{
new SqlParameter(){ParameterName = "@movieID",Value=id}
};
SqlDataReader dr = DBUtility.SqlHelper.executeReader(sql, CommandType.Text, sps);
if (dr.Read())
{
Model.Movie movie = new Model.Movie() { MovieID = int.Parse(dr[0].ToString()), MovieName = dr[1].ToString(), CoverURL = dr[2].ToString(), Director = dr[3].ToString(), Protagonist = dr[4].ToString(), Type = dr[5].ToString(), ReleaseDate = DateTime.Parse(dr[6].ToString()), RunTime = dr[7].ToString() };
return movie;
}
else
return null;
//throw new NotImplementedException();
}
private void ExecuteClick(object args)
{
Movie movie = new Model.Movie();
Name = movie.Story();
}
public Model.Movie getAppMovie(int id)
{
Movie movieFromApi = null;
try
{
movieFromApi = client.GetMovieAsync(id, MovieMethods.Credits).Result;
}
catch (Exception e)
{
Console.WriteLine("Error");
}
Model.Movie movie = null;
if (movieFromApi != null)
{
string pc = null;
foreach (var productionCountry in movieFromApi.ProductionCountries)
{
pc = pc + productionCountry.Name + ", ";
}
string gen = null;
foreach (var genre in movieFromApi.Genres)
{
gen = gen + genre.Name + ", ";
}
string dir = null;
string sp = null;
foreach (var crew in movieFromApi.Credits.Crew)
{
if (crew.Job.ToLowerInvariant() == "director")
{
dir = crew.Name;
}
if (crew.Job.ToLowerInvariant() == "screenplay")
{
sp = crew.Name;
}
}
string cast = null;
for (int i = 0; i <= 5; i++)
{
cast = cast + movieFromApi.Credits.Cast[i].Name + ", ";
}
string adult = null;
if (movieFromApi.Adult)
{
adult = "Tak";
}
else
{
adult = "Nie";
}
movie = new Model.Movie(
movieFromApi.Title,
movieFromApi.Overview,
//movieFromApi.Images.Posters.ToString(),
movieFromApi.PosterPath,
MovieHelper.getHours(movieFromApi.Runtime),
MovieHelper.getMinutes(movieFromApi.Runtime),
((DateTime)movieFromApi.ReleaseDate).ToString("d", new CultureInfo("pl-PL")),
pc,
gen,
adult,
dir,
cast,
sp
);
}
return(movie);
}
