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