/// <summary>
/// Add new director
/// </summary>
/// <param name="director"> director </param>
/// <returns> status add </returns>
public int AddNewDirector(DirectorModel director)
{
using (ctx = new FilmDataContext())
{
if (director == null)
{
return(-1);
}
//Create director
DataObject.EF.Director addDirector = new DataObject.EF.Director()
{
DirectorID = director.DirectorID,
DirectorName = director.DirectorName,
DirectorGender = director.DirectorGender,
DirectorBirthday = director.DirectorBirthday,
DirectorImg = director.DirectorImg,
DirectorStatus = director.DirectorStatus,
DirectorDescribe = director.DirectorDescribe
};
// Add director
ctx.Directors.Add(addDirector);
// return 1 if success, 0 if fail
return(ctx.SaveChanges());
}
}
public int AddUser(UserModel user)
{
using (FilmDataContext ctx = new FilmDataContext())
{
if (user == null)
{
return(-1);
}
//Create actor
DataObject.EF.User _tUser = new DataObject.EF.User()
{
UserID = user.UserID,
UserName = user.UserName,
Birthday = user.Birthday,
Email = user.Email,
Gender = user.Gender,
Phone = user.Phone,
Name = user.Name,
Password = user.Password,
isAdmin = user.isAdmin,
status = true
// AccessDate = user.AccessDate,
// AccessToken = user.AccessToken
};
ctx.Users.Add(_tUser);
return(ctx.SaveChanges());
}
}
public int EditUser(int id, UserModel user)
{
using (FilmDataContext ctx = new FilmDataContext())
{
DataObject.EF.User userToEdit = new DataObject.EF.User();
userToEdit = ctx.Users.Where(u => u.UserID == id).FirstOrDefault();
if (userToEdit != null)
{
userToEdit.UserName = user.UserName;
userToEdit.Name = user.Name;
userToEdit.Password = user.Password;
userToEdit.Phone = user.Phone;
userToEdit.Birthday = user.Birthday;
userToEdit.Gender = user.Gender;
userToEdit.isAdmin = user.isAdmin;
userToEdit.status = user.status;
return(ctx.SaveChanges());
}
else
{
return(0);
}
}
}
/// <summary>
/// Remove director
/// </summary>
/// <param name="director"> director </param>
/// <returns> status remove </returns>
public int RemoveDirector(DirectorModel director)
{
using (FilmDataContext database = new FilmDataContext())
{
if (director == null)
{
return(-1);
}
else
{
DataObject.EF.Director _tDirector = new DataObject.EF.Director()
{
DirectorStatus = director.DirectorStatus,
DirectorBirthday = director.DirectorBirthday,
DirectorDescribe = director.DirectorDescribe,
DirectorGender = director.DirectorGender,
DirectorID = director.DirectorID,
DirectorImg = director.DirectorImg,
DirectorName = director.DirectorName
};
// Remove director
database.Directors.Remove(_tDirector);
// return status add ( return 1 if success, 0 if fail
return(database.SaveChanges());
}
}
}
/// <summary>
/// Xóa actor
/// </summary>
/// <param name="filmID"></param>
/// <param name="typeID"></param>
/// <returns></returns>
public int RemoveActorForFilm(int filmID, int actorID)
{
using (ctx = new FilmDataContext())
{
var sub = ctx.SubActors.Where(s => s.FilmID == filmID && s.ActorID == actorID).FirstOrDefault();
ctx.SubActors.Remove(sub);
return(ctx.SaveChanges());
}
}
/// <summary>
/// this Method help you change the status's actor via id of this actor
/// Example : status = true modify to false
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int EditStatusById(int id)
{
using (ctx = new FilmDataContext())
{
var editActor = ctx.Actors.Find(id);
if (editActor != null)
{
editActor.Status = !editActor.Status;
return(ctx.SaveChanges());
}
}
return(-1);
}
/// <summary>
/// Thêm mới actor
/// </summary>
/// <param name="filmID"></param>
/// <param name="typeID"></param>
/// <returns></returns>
public int AddActorForFilm(int filmID, int actorID)
{
using (ctx = new FilmDataContext())
{
SubActor sub = new SubActor()
{
FilmID = filmID,
ActorID = actorID
};
ctx.SubActors.Add(sub);
return(ctx.SaveChanges());
}
}
/// <summary>
/// deleting a actor
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteActor(int id)
{
using (ctx = new FilmDataContext())
{
//find actor by id
var item = ctx.Actors.Find(id);
if (item != null)
{
ctx.Actors.Remove(item);
return(ctx.SaveChanges()); //ok
}
}
//fail delete
return(-1);
}
/// <summary>
/// Delete subdirector by id director
/// </summary>
/// <param name="idDirector"> id of director </param>
/// <returns> status delete </returns>
public int DeleteSubDirectorById(int idDirector)
{
// Connect to database
using (ctx = new FilmDataContext())
{
// get myData (data type SubDirector)
var myData = ctx.SubDirectors.Where(sd => sd.DirectorID == idDirector).ToList();
//remove myData
foreach (var item in myData)
{
ctx.SubDirectors.Remove(item);
}
return(ctx.SaveChanges());
}
}
public int setRole(int id, bool admin)
{
using (FilmDataContext ctx = new FilmDataContext())
{
DataObject.EF.User user = ctx.Users.Where(u => u.UserID == id).FirstOrDefault();
if (user != null)
{
user.isAdmin = admin;
return(ctx.SaveChanges());
}
else
{
return(0);
}
}
}
/// <summary>
/// Update director status by ID
/// </summary>
/// <param name="id"> id of director </param>
/// <returns> result of update </returns>
public int UpdateStatusDirectorByID(int id)
{
using (ctx = new FilmDataContext())
{
// search director by ID
var editDirector = ctx.Directors.Find(id);
if (editDirector != null)
{
editDirector.DirectorStatus = !editDirector.DirectorStatus;
// return status update
return(ctx.SaveChanges());
}
}
// Update fail
return(-1);
}
/// <summary>
/// get all subdirector
/// </summary>
/// <returns> list subdirector </returns>
public List <SubDirectorModel> GetAllSubDirector()
{
// Connect to database
using (ctx = new FilmDataContext())
{
// get list subdirector map to SubDirectorModel
var Mydata = ctx.SubDirectors.Select(sd => new SubDirectorModel
{
FilmID = sd.FilmID,
DirectorID = sd.DirectorID
}).ToList();
// Create list SubDirectors to store Mydata
List <SubDirectorModel> list = Mydata;
return(list);
}
}
public int DeleteUser(int id)
{
using (FilmDataContext ctx = new FilmDataContext())
{
DataObject.EF.User userToDelete = ctx.Users.Where(u => u.UserID == id).FirstOrDefault();
if (userToDelete != null)
{
userToDelete.status = false;
return(ctx.SaveChanges());
}
else
{
return(0);
}
}
}
/// <summary>
/// get subdirector by id director
/// </summary>
/// <param name="idDirector"> id of director </param>
/// <returns> list subdirector </returns>
public List <SubDirectorModel> GetSubDirectorByIdDirector(int idDirector)
{
// Connect to database
using (ctx = new FilmDataContext())
{
// get list SubDirector and map to SubDirectorModel
var MyData = ctx.SubDirectors.Where(sd => sd.DirectorID == idDirector).Select(data =>
new SubDirectorModel
{
FilmID = data.FilmID,
DirectorID = data.DirectorID
}).ToList();
// Create list subActorModel to store Mydata
List <SubDirectorModel> list = MyData;
return(list);
}
}
/// <summary>
/// Remove director by ID
/// </summary>
/// <param name="id"></param>
/// <returns> result status </returns>
public int RemoveDirectorByID(int id)
{
using (ctx = new FilmDataContext())
{
//find director by id
var item = ctx.Directors.Find(id);
if (item != null)
{
// Delete director
ctx.Directors.Remove(item);
// Return 1 if success, 0 if fail
return(ctx.SaveChanges());
}
}
return(0);
}
/// <summary>
/// Finding a actor by name
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <ActorModel> FindActorByName(string name)
{
using (ctx = new FilmDataContext())
{
var item = ctx.Actors.Where(p => p.ActorName.Contains(name)).Select(a => new ActorModel
{
ActorID = a.ActorID,
ActorName = a.ActorName,
Status = a.Status,
Birthday = a.Birthday,
Describe = a.Describe,
Gender = a.Gender,
Img = a.Img
}).ToList();
return(item);
}
}
/// <summary>
/// Lấy những actor không thuộc phim đang tìm
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <ActorModel> GetAllListActorNotInFilmByFilmID(int id)
{
using (ctx = new FilmDataContext())
{
return((from actors in ctx.Actors
where !(from sub in ctx.SubActors where sub.FilmID == id select sub.ActorID).Contains(actors.ActorID)
select new ActorModel
{
ActorID = actors.ActorID,
ActorName = actors.ActorName,
Birthday = actors.Birthday,
Describe = actors.Describe,
Gender = actors.Gender,
Img = actors.Img,
Status = actors.Status
}).ToList());
}
}
/// <summary>
/// Finding a actor by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActorModel FindActorByID(int id)
{
using (ctx = new FilmDataContext())
{
var myActor = ctx.Actors.Where(a => a.ActorID == id).Select(aa => new ActorModel
{
ActorID = aa.ActorID,
ActorName = aa.ActorName,
Birthday = aa.Birthday,
Describe = aa.Describe,
Gender = aa.Gender,
Img = aa.Img,
Status = aa.Status
});
ActorModel data = myActor.FirstOrDefault();
return(data);
}
}
/// <summary>
/// Modify a actor by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
///PUT
public int EditActor(int id, ActorModel actor)
{
using (ctx = new FilmDataContext())
{
var data = ctx.Actors.Where(a => a.ActorID == id).FirstOrDefault();
if (data != null)
{
data.ActorName = actor.ActorName;
data.Birthday = actor.Birthday;
data.Describe = actor.Describe;
data.Gender = actor.Gender;
data.Img = actor.Img;
data.Status = actor.Status;
return(ctx.SaveChanges());
}
}
return(-1);
}
/// <summary>
/// get all director of list
/// </summary>
/// <returns> list of director </returns>
public List <DirectorModel> GetAllDirectors()
{
using (ctx = new FilmDataContext())
{
// get list director
var lstDir = ctx.Directors.Select(dir => new DirectorModel
{
DirectorID = dir.DirectorID,
DirectorName = dir.DirectorName,
DirectorBirthday = dir.DirectorBirthday,
DirectorGender = dir.DirectorGender,
DirectorImg = dir.DirectorImg,
DirectorStatus = dir.DirectorStatus,
DirectorDescribe = dir.DirectorDescribe
}).ToList();
// transfer
List <DirectorModel> list = lstDir;
return(list);
}
}
/// <summary>
/// Get director by id
/// </summary>
/// <param name="id"> id of director</param>
/// <returns> director </returns>
public DirectorModel GetDirectorByID(int id)
{
using (ctx = new FilmDataContext())
{
// get list director
var myDirector = ctx.Directors.Where(d => d.DirectorID == id).Select(dir => new DirectorModel
{
DirectorID = dir.DirectorID,
DirectorName = dir.DirectorName,
DirectorBirthday = dir.DirectorBirthday,
DirectorGender = dir.DirectorGender,
DirectorImg = dir.DirectorImg,
DirectorStatus = dir.DirectorStatus,
DirectorDescribe = dir.DirectorDescribe
});
// transfer
DirectorModel data = myDirector.FirstOrDefault();
return(data);
}
}
/// <summary>
/// Getting all metadata actor from database by idActor
/// </summary>
/// <returns></returns>
public List <ActorModel> GetAllListActor()
{
using (ctx = new FilmDataContext())
{
// get list actor
var actor = ctx.Actors.Select(a => new ActorModel
{
ActorID = a.ActorID,
ActorName = a.ActorName,
Birthday = a.Birthday,
Describe = a.Describe,
Gender = a.Gender,
Img = a.Img,
Status = a.Status
}).ToList();
// transfer
List <ActorModel> list = actor;
return(list);
}
}
/// <summary>
/// Add subdirector to database
/// </summary>
/// <param name="subDirector"> subdirector you want to add </param>
/// <returns> add status </returns>
public int AddSubDirector(SubDirectorModel subDirector)
{
// connect database
using (ctx = new FilmDataContext())
{
// paramater subDirector is null return -1
if (subDirector == null)
{
return(-1);
}
// Creating MySubDirector and data is map to a subDirector(SubDirector)
DataObject.EF.SubDirector MySubDirector = new DataObject.EF.SubDirector
{
FilmID = subDirector.FilmID,
DirectorID = subDirector.DirectorID
};
// add mySubActor to database
ctx.SubDirectors.Add(MySubDirector);
return(ctx.SaveChanges());
}
}
/// <summary>
/// Add a new actor
/// </summary>
/// <param name="actor"></param>
/// <returns></returns>
public int AddNewActor(ActorModel actor)
{
using (ctx = new FilmDataContext())
{
if (actor == null)
{
return(-1);
}
//Create actor
DataObject.EF.Actor _tActor = new DataObject.EF.Actor()
{
ActorID = actor.ActorID,
ActorName = actor.ActorName,
Birthday = actor.Birthday,
Describe = actor.Describe,
Gender = actor.Gender,
Img = actor.Img,
Status = actor.Status
};
ctx.Actors.Add(_tActor);
return(ctx.SaveChanges());
}
}
public UserModel GetUserByUsername(string username)
{
using (FilmDataContext ctx = new FilmDataContext())
{
var myUser = ctx.Users.Where(a => a.UserName == username).Select(aa => new UserModel
{
UserID = aa.UserID,
UserName = aa.UserName,
Birthday = aa.Birthday,
Email = aa.Email,
Gender = aa.Gender,
Phone = aa.Phone,
Name = aa.Name,
Password = aa.Password,
isAdmin = aa.isAdmin,
filmModel = (from film in ctx.Films
join sub in ctx.SubUsers
on film.FilmID equals sub.FilmID
where sub.UserID == aa.UserID
select new FilmModel
{
FilmID = film.FilmID,
FilmName = film.FilmName,
Describe = film.Describe,
Rate = film.Rate,
Year = film.Year,
Img = film.Img,
Status = film.Status,
}).ToList()
//,AccessDate = user.AccessDate,
//AccessToken = user.AccessToken
});
UserModel data = myUser.FirstOrDefault();
return(data);
}
}
///<summary>
/// Khởi tạo chuỗi kết nối
///</summary>
public ServiceType()
{
db = new FilmDataContext();
}
public DirectorService()
{
ctx = new FilmDataContext();
}
public List <UserModel> GetAllUsers()
{
using (FilmDataContext ctx = new FilmDataContext())
{
var user = ctx.Users.Where(u => u.status == true).Select(a => new UserModel
{
UserID = a.UserID,
UserName = a.UserName,
Birthday = a.Birthday,
Email = a.Email,
Gender = a.Gender,
Phone = a.Phone,
Name = a.Name,
Password = a.Password,
isAdmin = a.isAdmin,
filmModel = (from film in ctx.Films
join sub in ctx.SubUsers
on film.FilmID equals sub.FilmID
where sub.UserID == a.UserID
select new FilmModel
{
FilmID = film.FilmID,
FilmName = film.FilmName,
Describe = film.Describe,
Rate = film.Rate,
Year = film.Year,
Img = film.Img,
Status = film.Status,
//// thể loại phim
//TypeFilms = (from type in ctx.TypeFilms
// join sub in ctx.SubTypes
// on type.TypeID equals sub.TypeID
// where sub.FilmID == film.FilmID
// select new TypeFilmModel
// {
// TypeID = type.TypeID,
// NameType = type.NameType
// }).ToList(),
//// diễn viên tham gia
//Actors = (from actor in ctx.Actors
// join sub in ctx.SubActors
// on actor.ActorID equals sub.ActorID
// where sub.FilmID == film.FilmID
// select new ActorModel
// {
// ActorID = actor.ActorID,
// ActorName = actor.ActorName,
// Birthday = actor.Birthday,
// Describe = actor.Describe,
// Gender = actor.Gender,
// Img = actor.Img,
// Status = actor.Status
// }).ToList(),
//// đạo diễn
//Directors = (from director in ctx.Directors
// join sub in ctx.SubDirectors
// on director.DirectorID equals sub.DirectorID
// where sub.FilmID == film.FilmID
// select new DirectorModel
// {
// DirectorBirthday = director.DirectorBirthday,
// DirectorDescribe = director.DirectorDescribe,
// DirectorGender = director.DirectorGender,
// DirectorID = director.DirectorID,
// DirectorImg = director.DirectorImg,
// DirectorName = director.DirectorName,
// DirectorStatus = director.DirectorStatus
// }).ToList()
}).ToList()
//,AccessDate = user.AccessDate,
//AccessToken = user.AccessToken
}).ToList();
// transfer
//List<UserModel> list = user;
return(user);
}
}
