private static void AddDataToDB()
{
MRandomatorDataContext context = new MRandomatorDataContext();
String text = System.IO.File.ReadAllText(@"C:\Users\Emre\Desktop\json files\imdbFull2.json");
JObject mov = JsonConvert.DeserializeObject<JObject>(text);
JArray jar = (JArray)mov["movies"];
for (int i = 0; i < jar.Count; i++)
{
Movy movie = new Movy();
movie.Title = jar[i]["Title"].ToString();
movie.Year = Int32.Parse(jar[i]["Year"].ToString());
movie.Rated = jar[i]["Rated"].ToString();
movie.Released = jar[i]["Released"].ToString();
movie.Runtime = jar[i]["Runtime"].ToString();
movie.Genre = jar[i]["Genre"].ToString();
movie.Director = jar[i]["Director"].ToString();
movie.Writer = jar[i]["Writer"].ToString();
movie.Actors = jar[i]["Actors"].ToString();
movie.Plot = jar[i]["Plot"].ToString();
movie.Language = jar[i]["Language"].ToString();
movie.Country = jar[i]["Country"].ToString();
movie.Awards = jar[i]["Awards"].ToString();
movie.Poster = jar[i]["Poster"].ToString();
movie.Metascore = jar[i]["Metascore"].ToString();
movie.imdbRating = jar[i]["imdbRating"].ToString();
movie.imdbVotes = jar[i]["imdbVotes"].ToString();
//movie.Type = jar[i]["Type"].ToString();
movie.Trailer = jar[i]["Trailer"].ToString();
context.Movies.InsertOnSubmit(movie);
//context.SubmitChanges(); Değişiklikleri uygular.
}
}
public static void AddMovie(Movy movie)
{
using (var database = new movieLibraryEntities())
{
database.Movies.Add(movie);
database.SaveChanges();
}
}
public List <Avi> getAllAvisforIdMovie(Movy movi)
{
List <Avi> avis = new List <Avi>();
if (movi != null)
{
var query = DMCCTX.ctx.Avis.Where(m => m.Movies_Id.Equals(movi.Id));
DMCCTX.ctx.SaveChanges();
avis = (List <Avi>)query.ToList();
}
return(avis);
}
public IHttpActionResult DeleteMovy(int id)
{
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(NotFound());
}
db.Movies.Remove(movy);
db.SaveChanges();
return(Ok(movy));
}
// GET: Movies/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
return(View(movy));
}
//Upodate Function
protected void Update_btn_Click(object sender, EventArgs e)
{
Movy Obj_Ins_Movi = new Movy
{
MovieID = Convert.ToInt32(ddl_Movie.SelectedValue),
Title = txt_title.Text,
Year = txt_year.Text,
Gener = txt_Gener.Text,
RentPerDay = Convert.ToDecimal(txt_RentPerDay.Text)
};
Database.Movies_DAL.UpdateMovie(Obj_Ins_Movi);
Response.Redirect("default.aspx");
}
// GET: Movies/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
ViewBag.MovieGenre = new SelectList(db.Genres, "GenreID", "GenreName", movy.MovieGenre);
return(View(movy));
}
// GET: Movies/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.Registrations, "UserID", "FirstName", movy.UserID);
return(View(movy));
}
public Movy GetMovieByRandom()
{
//create random object
Random random = new Random();
//get copy of data base
MovieEntities db = new MovieEntities();
//create list of all movies from data base
List <Movy> movies = db.Movies.ToList();
//use random object to generate a random number which is used as an index in my list
//to pick a random movie to dissplay
Movy mov = movies[random.Next(0, movies.Count)];
//return the movie
return(mov);
}
public ActionResult Delete(int?id) //? is saying its optional-- this is an action method for displaying and deleting a movie record
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movie = db.Movies.Find(id);
if (movie == null)
{
return(HttpNotFound());
}
return(View(movie));
}
public static void AddNewMovieIntoTable(string MovieName, string MovieCategory)
{
string strConnectionString = DalUtils.GetConnectionSring();
List <Movy> movyList = new List <Movy>();
DataClasses1DataContext nw = new DataClasses1DataContext(strConnectionString);
Movy NewMovie = new Movy
{
Name = MovieName,
Category = MovieCategory
};
nw.Movies.InsertOnSubmit(NewMovie);
nw.SubmitChanges();
}
// GET: Movies/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
ViewBag.Producer_Id = new SelectList(db.Producers, "Id", "Name", movy.Producer_Id);
return(View(movy));
}
// POST: Webflix/movies/New
//This method adds a new movie in the database if there is not already a movie with the same title
public HttpResponseMessage Post([FromBody] Movy value) //replace Movy by the class used in CA
{
if (value == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Failed to read input"));
}
if (db.Movies.Count(p => p.Title.Equals(value.Title)) != 0)
//check if there is any title in database which matches the title of the new movie to be inserted
{
return(Request.CreateResponse(HttpStatusCode.OK, "Movie " + value.Title + " already exists in database."));
}
db.Movies.Add(value);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, "Movie " + value.Title + " added to database."));
}
public ActionResult SaveDeleteMovie(Models.Movie obj)
{
Repository rep = new Repository();
Movy list = new Movy();
var list1 = AutoMapper.Mapper.Map(obj, list);
var status = rep.DeleteMovie(list1);
if (status == true)
{
return(RedirectToAction("Details"));
}
else
{
return(View("Error"));
}
}
public ActionResult Edit(int id, Movy movies)
{
try
{
using (mvcEntities1 dbModel = new mvcEntities1())
{
dbModel.Entry(movies).State = EntityState.Modified;//this edits the movie
dbModel.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//Function of adding Movie button
protected void btn_Submit_Click(object sender, EventArgs e)
{
//creating new object to get the new Movie details
Movy Obj_Int_Movie = new Movy
{
Title = txt_title.Text,
Year = txt_year.Text,
Gener = txt_Gener.Text,
RentPerDay = Convert.ToDecimal(txt_RentPerDay.Text)
};
Database.Movies_DAL obj_Database = new Database.Movies_DAL();
// calling from database layer
obj_Database.InsertMovies_DAL(Obj_Int_Movie);
Response.Redirect("default.aspx");
}
public IHttpActionResult PostvMovieBook(vMovieBook vMovieBook)
{
Movy movy = db.Movies.Single(t => t.MovieName == vMovieBook.MovieName);
User user = db.Users.Single(t => t.UserName == vMovieBook.UserName);
Theater theater = db.Theaters.SingleOrDefault(t => t.ShowTime == vMovieBook.ShowTime && t.Price == vMovieBook.Price);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var movieBooking = new MovieBooking()
{
MovieId = movy.MovieId,
UserId = user.UserId,
TheaterId = theater.TheaterId
};
db.MovieBookings.Add(movieBooking);
db.SaveChanges();
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//db.vMovieBooks.Add(vMovieBook);
//try
//{
// db.SaveChanges();
//}
//catch (DbUpdateException)
//{
// if (vMovieBookExists(vMovieBook.MovieName))
// {
// return Conflict();
// }
// else
// {
// throw;
// }
//}
return(CreatedAtRoute("DefaultApi", new { id = vMovieBook.MovieName }, vMovieBook));
}
public static void UpdateMovie(Movy movie,int id)
{
using (var database = new movieLibraryEntities())
{
var movieToUpdate = database.Movies.Where(x => x.Id == id).FirstOrDefault();
if (movieToUpdate != null)
{
movieToUpdate.Title = movie.Title;
movieToUpdate.description = movie.description;
movieToUpdate.Director = movie.Director;
movieToUpdate.ImdbLink = movie.ImdbLink;
movieToUpdate.viewed = movie.viewed;
movieToUpdate.Rating = movie.Rating;
database.SaveChanges();
}
}
}
public Movy MovieTitle(string name)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
Movy result = ORM.Movies.Find(name);
if (result != null)
{
return(result);
}
else
{
Movy info = new Movy {
Title = "movie not found"
};
return(info);
}
}
public ActionResult SaveNewMovie(Movy ourMovie, Director ourDirector)
{
//DevBuildMoviesEntities ORM = new DevBuildMoviesEntities();
if (ourMovie != null)
{
//List<Movy> movieMatches = ORM.Movies.Where(m => //m.MovieTitle == ourMovie.MovieTitle && m.Year == //ourMovie.Year).ToList();
//if (movieMatches.Count == 0)
{
//ORM.Movies.Add(ourMovie);
//ORM.Entry(ourMovie).State = EntityState.Added;
//ORM.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public void Add(Movy movie)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
var commandText =
"INSERT INTO Movies (Title, Rating, Year, Runtime, Director) VALUES (@Title, @Rating, @Year, @Runtime, @Director)";
SqlCommand command = new SqlCommand(commandText, conn);
command.Parameters.AddWithValue("@Title", movie.Title);
command.Parameters.AddWithValue("@Rating", movie.Rating);
command.Parameters.AddWithValue("@Year", movie.Year);
command.Parameters.AddWithValue("@Runtime", movie.Director);
command.Parameters.AddWithValue("@Director", movie.Director);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
/** *********** Methode Add Comment ******** **/
void AddCommentExe()
{
Validator.ValidateAll();
var validationResult = Validator.GetResult();
if (validationResult.IsValid)
{
/******************* Build Object for commit in Database *******************/
Avi avis = new Avi();
avis.Note = NoteAdd;
avis.Commentaire = CommentAdd;
Movy m = new Movy();
m = DAOF.getMovie(ViewModelLocator.homeViewModel.SelectedMovie);
avis.Movy = m;
avis.Movies_Id = m.Id;
User u = new User();
u = DAOF.getUser(ViewModelLocator.mainViewModel.User);
avis.User = u;
avis.User_Id = u.Id;
/******************* Insert in Database *******************/
DAOF.insertAvis(avis);
/******************* Add Avis in front End *****************/
AvisList.Add(avis);
/******************* Remove attribute front End *****************/
NoteAdd = 0;
CommentAdd = "";
ErrorList = new List <String>();
}
else
{
List <string> ErrorListLocal = new List <string>();
foreach (MvvmValidation.ValidationError validationError in validationResult.ErrorList)
{
ErrorListLocal.Add(validationError.ErrorText);
}
ErrorList = ErrorListLocal;
}
}
public HttpResponseMessage Delete(int id)
{
Movy movie = db.Movies.Where(m => m.MovieId == id).FirstOrDefault();
movie.UpdatedBy = 1;
movie.UpdatedDt = DateTime.Now;
if (movie.Active)
{
movie.Active = false;
}
else
{
movie.Active = true;
}
db.Entry(movie).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Record removed Successfully"));
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
using (mvcEntities1 dbModel = new mvcEntities1())
{
Movy movies = dbModel.Movies.Where(x => x.Id == id).FirstOrDefault();//this delets the movie
dbModel.Movies.Remove(movies);
dbModel.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: MoviesBooking/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
MovieModel movieModel = new MovieModel();
movieModel.Name = movy.Name;
movieModel.NoOfSeatsAvailable = movy.NoOfSeatsAvailable;
movieModel.Id = movy.Id;
if (movy == null)
{
return(HttpNotFound());
}
return(View(movieModel));
}
public void Edit(Movy movie)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
var commandText =
"UPDATE Movies Set Title = @Title, Rating = @Rating, Year = @Year, Runtime = @Runtime, Director = @Director WHERE MovieId = @Id";
SqlCommand command = new SqlCommand(commandText, conn);
command.Parameters.AddWithValue("@Id", movie.MovieID);
command.Parameters.AddWithValue("@Title", movie.Title);
command.Parameters.AddWithValue("@Rating", movie.Rating);
command.Parameters.AddWithValue("@Year", movie.Year);
command.Parameters.AddWithValue("@Runtime", movie.Director);
command.Parameters.AddWithValue("@Director", movie.Director);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
public void deleteMovy(Movy movy)
{
DAOFacadeSingleton DAOF = new DAOFacadeSingleton();
if (movy.Avis.Count != 0)
{
foreach (Avi a in movy.Avis.ToList())
{
Avi aa = DAOF.getAvi(a.Id);
DMCCTX.ctx.Avis.Attach(aa);
DMCCTX.ctx.Avis.Remove(aa);
}
}
DMCCTX.ctx.Movies.Attach(movy);
DMCCTX.ctx.Movies.Remove(movy);
DMCCTX.ctx.SaveChanges();
}
public ActionResult Create(Movy movie)
{
try
{
using (mvcEntities1 dbModel = new mvcEntities1())//this add the movie to the databse
{
dbModel.Movies.Add(movie);
dbModel.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit([Bind(Include = "MovieID, Name, YearOfRelease, Plot, Poster, ActorID, ProducerID")] Movy movy, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string Path = System.IO.Path.Combine(Server.MapPath("~/Images/"), pic);
file.SaveAs(Path);
movy.Poster = file != null ? pic : movy.Poster;
}
if (ModelState.IsValid)
{
db.Entry(movy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movy));
}
public PartialViewResult AddMovie(Movy form, HttpPostedFileBase poster1)
{
try {
Movy movie = new Movy();
movie.MovieName = form.MovieName;
movie.ReleaseDate = Convert.ToDateTime(form.ReleaseDate).Date;
movie.Synopsis = form.Synopsis;
movie.VideoLink = form.VideoLink;
if (poster1 != null)
{
movie.Poster = new byte[poster1.ContentLength];
poster1.InputStream.Read(movie.Poster, 0, poster1.ContentLength);
}
entities.Movies.Add(movie);
entities.SaveChanges();
return(PartialView("_AddMovieSuccess"));
}
catch (Exception ex) { throw ex; }
}
public static void DeleteMovie(string Obj_mov_Delete)
{
try
{
using (MovieRentalDBEntities db = new MovieRentalDBEntities())
{
//Lembda expression to delete movie
Movy c = db.Movies.SingleOrDefault(x => x.MovieID.ToString().Trim() == Obj_mov_Delete.Trim());
if (c != null)
{
db.Movies.Remove(c);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Movies/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
else
{
Movie_User user = db.Movie_User.Find(2, "*****@*****.**");
db.Movie_User.Remove(user);
db.SaveChanges();
}
return(View(movy));
}
public List <Movy> GetRandomMovies(int quantity)
{
MoviesEntities db = new MoviesEntities();
Random random = new Random();
int pick = 0;
List <Movy> movies = new List <Movy>();
for (int i = 0; i < quantity; i++)
{
pick = random.Next(1, (db.Movies.Count() + 1));
Movy movie = (from c in db.Movies
where c.Id == pick
select c).Single();
movies.Add(movie);
}
return(movies);
}
public void EditMovie(Movy movie)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var movieUpdate = from m in db.Movies
where m.Id == movie.Id
select m;
Movy movieTemp = movieUpdate.FirstOrDefault();
movieTemp.Title = movie.Title;
movieTemp.Category = movie.Category + 1;
movieTemp.Director = movie.Director;
movieTemp.Cast = movie.Cast;
movieTemp.Country = movie.Country;
movieTemp.Year = movie.Year;
movieTemp.Description = movie.Description;
db.SubmitChanges();
}
}
// GET: Movies/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movy movy = db.Movies.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
var moviedetail = new MovieDetail
{
movie = movy,
movieID = movy.MovieID
};
return(View(moviedetail));
}
public List<Movy> GetAllMoviesList()
{
List<Movy> movies = new List<Movy>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SELECT * FROM Movies", conn);
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Movy movie = new Movy();
movie.MovieID = reader.GetInt32(0);
movie.Title = reader.GetString(1);
movie.Rating = reader.GetString(2);
movie.Year = reader.GetInt32(3);
movie.Runtime = reader.GetInt32(4);
movie.Director = reader.GetString(5);
movie.Actors = new List<Actor>();
movies.Add(movie);
}
}
return movies;
}
