public int updateMovieDao(int movieId, string movieTitle, string movieKind, string movieSynopsis) { using (var db = new DataModelContainer()) { db.Database.Connection.Open(); var movieSelected = db.MovieSet.Where(m => m.Id == movieId).First();//Search the movie to update in db //set the property of the movie movieSelected.title = movieTitle; movieSelected.kind = movieKind; movieSelected.synopsis = movieSynopsis; int res = db.SaveChanges(); if (res > 0) { MessageBox.Show("Movie update successful"); return(res); } else { MessageBox.Show("Error cant update movie"); return(res); } } }
public int createMovieDao(string _title, string _kind, string _synopsis) { using (var db = new DataModelContainer()) { db.Database.Connection.Open(); //Create entity to insert and set his properties var myMovie = new Movie() { title = _title, kind = _kind, synopsis = _synopsis, }; db.Entry(myMovie).State = System.Data.Entity.EntityState.Added; //Insert property in the DB int res = db.SaveChanges(); //Save the modification to th DB if the save is successful the function return "true" if (res > 0) { MessageBox.Show("Movie creation successful"); return(res); } else { MessageBox.Show("Error cant create movie"); return(res); } } }
public bool deleteMovieDao(int movieId) { using (var db = new DataModelContainer()) { var movieToDelete = new Movie { Id = movieId }; db.Entry(movieToDelete).State = System.Data.Entity.EntityState.Deleted;//Delete element in DB according to the ID db.SaveChanges(); //db.Database.Connection.Close(); } return(true); }
public bool deleteUserDao(User userTodelete) { using (var db = new DataModelContainer()) { db.Database.Connection.Open(); var user = (from u in db.UserSet where u.Id == userTodelete.Id select u).FirstOrDefault <User>(); if (user == null) { return(false); } else { db.Entry(user).State = System.Data.Entity.EntityState.Deleted;//Delete element in DB according to db.SaveChanges(); return(true); } } }