/// <summary> /// PUT: edit a director /// </summary> /// <param name="id"> id of director </param> /// <param name="director"> director </param> /// <returns> result status </returns> public int UpdateDirector(DirectorModel director) { if (director == null) { return(-1); } // search director by ID var select = ctx.Directors.Where(d => d.DirectorID == director.DirectorID).SingleOrDefault(); if (select != null) { // update select.DirectorID = director.DirectorID; select.DirectorName = director.DirectorName; select.DirectorBirthday = director.DirectorBirthday; select.DirectorGender = director.DirectorGender; select.DirectorDescribe = director.DirectorDescribe; select.DirectorStatus = director.DirectorStatus; select.DirectorImg = director.DirectorImg; // return 1 if update success, 0 if update fail return(ctx.SaveChanges()); } return(-1); }
///<summary> /// Thêm mới ///</summary> public int AddNewType(TypeFilmModel typeFilm) { if (typeFilm == null) { return(-1); } //Create actor DataObject.EF.TypeFilm _tType = new DataObject.EF.TypeFilm() { NameType = typeFilm.NameType, TypeID = typeFilm.TypeID }; db.TypeFilms.Add(_tType); return(db.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()); } }
/// <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 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); }
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> /// 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); }
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> /// 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()); } }
/// <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> /// 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> /// 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()); } }