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 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 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);
}
}
}
