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