public Comment UpdateComment(Comment updatedComment)
{
using (var ctx = new MovieNetModelContainer())
{
Comment CommentToUpdate = FindCommentByIdPrivate(updatedComment.Id, ctx);
updatedComment.ModificationDate = DateTime.Now;
CommentToUpdate.Score = updatedComment.Score;
CommentToUpdate.Text = updatedComment.Text;
CommentToUpdate.User = updatedComment.User;
CommentToUpdate.Film = updatedComment.Film;
CommentToUpdate.CreationDate = updatedComment.CreationDate;
if (CommentToUpdate != null)
{
CommentToUpdate = updatedComment;
try
{
ctx.SaveChanges();
}
catch
{
Console.WriteLine("Error updating Comment.");
CommentToUpdate = null;
}
}
else
{
Console.WriteLine("Couldn't find Comment to update with ID " + updatedComment.Id);
CommentToUpdate = null;
}
return(CommentToUpdate);
}
}
public Boolean DeleteComment(Comment deletedComment)
{
using (var ctx = new MovieNetModelContainer())
{
Comment commentToDelete = FindCommentById(deletedComment.Id);
if (commentToDelete != null)
{
ctx.CommentSet.Attach(commentToDelete);
ctx.CommentSet.Remove(commentToDelete);
try
{
ctx.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Error deleting Comment.");
Console.WriteLine(e.Message);
return(false);
}
}
else
{
Console.WriteLine("Couldn't find Comment to delete with ID " + deletedComment.Id);
return(false);
}
}
}
public Boolean DeleteUser(User deletedUser)
{
using (var ctx = new MovieNetModelContainer())
{
User userToDelete = FindUserById(deletedUser.Id);
if (userToDelete != null)
{
ctx.UserSet.Attach(userToDelete);
ctx.UserSet.Remove(userToDelete);
try
{
ctx.SaveChanges();
return(true);
}
catch
{
Console.WriteLine("Error deleting user.");
return(false);
}
}
else
{
Console.WriteLine("Couldn't find User to delete with ID " + deletedUser.Id);
return(false);
}
}
}
public User UpdateUser(User updatedUser)
{
using (var ctx = new MovieNetModelContainer())
{
User userToUpdate = FindUserByIdPrivate(updatedUser.Id, ctx);
if (userToUpdate != null)
{
userToUpdate.Username = updatedUser.Username;
userToUpdate.Password = updatedUser.Password;
try
{
ctx.SaveChanges();
return(updatedUser);
}
catch
{
Console.WriteLine("Error updating user.");
return(null);
}
}
else
{
Console.WriteLine("Couldn't find User to update with ID " + updatedUser.Id);
return(null);
}
}
}
// Methods with one return. It is advised to make only one return on the method.
public Film UpdateFilm(Film film)
{
using (var ctx = new MovieNetModelContainer())
{
Film filmToUpdate = FindFilmByIdPrivate(film.Id, ctx);
filmToUpdate.Id = film.Id;
filmToUpdate.Title = film.Title;
filmToUpdate.Genres = film.Genres;
filmToUpdate.Synopsis = film.Synopsis;
filmToUpdate.Score = film.Score;
filmToUpdate.Year = film.Year;
filmToUpdate.Director = film.Director;
if (filmToUpdate != null)
{
try
{
//ctx.Entry(filmToUpdate).State = EntityState.Modified;
int num = ctx.SaveChanges();
Console.WriteLine(num);
}
catch
{
Console.WriteLine("[FILM DAO] Error updating.");
filmToUpdate = null;
}
}
else
{
filmToUpdate = null;
Console.WriteLine("Couldn't update the film " + film.Title);
}
return(filmToUpdate);
}
}
// CRUD
public Film CreateFilm(Film film)
{
using (var ctx = new MovieNetModelContainer())
{
ctx.FilmSet.Add(film);
try
{
ctx.SaveChanges();
}
catch
{
Console.WriteLine("[FILM DAO] Error executing query");
return(null);
}
return(film);
}
}
// ...
// CRUD
public User CreateUser(User createdUser)
{
using (var ctx = new MovieNetModelContainer())
{
ctx.UserSet.Add(createdUser);
try
{
ctx.SaveChanges();
}
catch
{
Console.WriteLine("Error creating user.");
return(null);
}
return(createdUser);
}
}
// ...
// CRUD
public Comment CreateComment(Comment createdComment)
{
using (var ctx = new MovieNetModelContainer())
{
ctx.CommentSet.Add(createdComment);
try
{
ctx.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Error creating Comment.");
Console.WriteLine(e.Source);
return(null);
}
return(createdComment);
}
}
public Boolean DeleteFilm(Film deletedFilm)
{
using (var ctx = new MovieNetModelContainer())
{
Film filmToDelete = FindFilmByIdPrivate(deletedFilm.Id, ctx);
filmToDelete.Id = deletedFilm.Id;
filmToDelete.Title = deletedFilm.Title;
filmToDelete.Genres = deletedFilm.Genres;
filmToDelete.Synopsis = deletedFilm.Synopsis;
filmToDelete.Score = deletedFilm.Score;
filmToDelete.Year = deletedFilm.Year;
filmToDelete.Director = deletedFilm.Director;
Boolean isDeleted = false;
if (filmToDelete != null)
{
//ctx.FilmSet.Attach(filmToDelete);
ctx.FilmSet.Remove(filmToDelete);
try
{
ctx.SaveChanges();
isDeleted = true;
}
catch
{
Console.WriteLine("[FILM DAO] Couldn't delete the film " + filmToDelete.Title);
}
}
else
{
Console.WriteLine("[FILM DAO] Couldn't find the film " + filmToDelete.Title);
}
return(isDeleted);
}
}
