public User createUserDao(String _login, String _password)
{
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
//Create entity to insert and set his properties
var newUser = new User()
{
login = _login,
password = _password,
};
db.Entry(newUser).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("User successfuly created");
return(newUser);
}
else
{
MessageBox.Show("Error cant create user");
return(newUser);
}
}
}
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 bool updateUserDao(int userId, String Login, String Password)
{
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var userToUpdate = db.UserSet.Where(u => u.Id == userId).First();//Search the movie to update in db
userToUpdate.login = Login;
userToUpdate.password = Password;
db.Entry(userToUpdate).State = System.Data.Entity.EntityState.Modified;
int res = db.SaveChanges();
if (res > 0)
{
MessageBox.Show("User data update successful");
return(true);
}
else
{
MessageBox.Show("User data can't be updated, try again");
return(false);
}
}
}
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 isUserExists(int id)
{
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var user = (from u in db.UserSet
where u.Id == id
select u).FirstOrDefault <User>();
return(user != null);
}
}
public Movie getMovie(int movieId)
{
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var movieToGet = (from m in db.MovieSet
where m.Id == movieId
select m).First();
return(movieToGet);
}
}
public List <Movie> getMoviesDao()
{
//DataModelContainer container the string to reference/Target wich DB to used(ctrl+click or alt+click to see the content of the class)
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var movies = (from m in db.MovieSet
select m).ToList();
return(movies);
}
}
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 User getUserDao(int userID)
{
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var user = (from u in db.UserSet
where u.Id == userID
select u).FirstOrDefault <User>();
if (user != null)
{
MessageBox.Show("the user exist" + user.login);
}
return(user);
}
}
public User loginDao(string login, string password)
{
//DataModelContainer container the string to reference/Target wich DB to used(ctrl+click or alt+click to see the content of the class)
using (var db = new DataModelContainer())
{
db.Database.Connection.Open();
var user = (from u in db.UserSet
where u.login == login && u.password == password
select u).FirstOrDefault <User>();//Récupère le premier user correspondant o critère de recherche
if (user != null)
{
MessageBox.Show("Welcome " + user.login);
}
return(user);
}
}
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);
}
}
}