public IEnumerable <TBL_MOVIES> GetAllWith(Expression <Func <TBL_MOVIES, bool> > Expression)
{
using (var _dbContext = new FilmBuzzDbContext())
{
return(_dbContext.TBL_MOVIES.Where(Expression).ToListAsync().Result);
}
}
public IEnumerable <TBL_MOVIES> GetAll()
{
using (var _dbContext = new FilmBuzzDbContext())
{
return(_dbContext.TBL_MOVIES.ToListAsync().Result);
}
}
public bool Create(TBL_MOVIES entity)
{
bool status = false;
try
{
for (int i = 0; i < entity.ActorsId.Length; i++)
{
using (var _dbContext = new FilmBuzzDbContext())
{
_dbContext.TBL_MOVIES.Add(new TBL_MOVIES()
{
Name = entity.Name,
ActorId = entity.ActorsId[i],
Plot = entity.Plot,
ProducerId = entity.ProducerId,
YearofRelease = entity.YearofRelease
});
status = _dbContext.SaveChanges() == 1 ? true : false;
}
}
return(status);
}
catch (Exception ex)
{
return(false);
}
}
public bool Create(TBL_PRODUCERS entity)
{
using (var _dbContext = new FilmBuzzDbContext())
{
_dbContext.TBL_PRODUCERS.Add(new TBL_PRODUCERS()
{
Name = entity.Name,
Sex = entity.Sex,
Bio = entity.Bio,
DOB = entity.DOB
});
return(_dbContext.SaveChanges() == 1 ? true : false);
}
}
public bool Update(TBL_MOVIES entity)
{
bool status = false;
using (var _dbContext = new FilmBuzzDbContext())
{
var oldrecords = _dbContext.TBL_MOVIES.SingleOrDefault(b => b.MovieId == entity.MovieId);
var entit = oldrecords.MovieId;
List <TBL_MOVIES> oldmoviename = _dbContext.TBL_MOVIES.Where((b => b.Name == oldrecords.Name)).ToList();
//for (int i = 0; i < entity.SelectedValues.Length; i++)
//{
// int aid = entity.SelectedValues[i];
// for (int j = 0; j < oldmoviename.Count(); j++)
// {
// if (entity.MovieId == oldmoviename[j].MovieId)
// {
// _dbContext.Entry(entit).CurrentValues.SetValues(new TBL_MOVIES()
// {
// Name = entity.Name,
// Plot = entity.Plot,
// ActorId= aid,
// ProducerId = entity.ProducerId,
// YearofRelease = entity.YearofRelease
// });
// status = _dbContext.SaveChanges() == 1 ? true : false;
// }
// else
// {
// _dbContext.TBL_MOVIES.Add(new TBL_MOVIES()
// {
// Name = entity.Name,
// ActorId = aid,
// Plot = entity.Plot,
// ProducerId = entity.ProducerId,
// YearofRelease = entity.YearofRelease
// });
// status = _dbContext.SaveChanges() == 1 ? true : false;
// }
// }
//}
for (int i = 0; i < oldmoviename.Count(); i++)
{
TBL_MOVIES deptDelete = _dbContext.TBL_MOVIES.Find(oldmoviename[i].MovieId);
_dbContext.TBL_MOVIES.Remove(deptDelete);
_dbContext.SaveChanges();
}
for (int i = 0; i < entity.SelectedValues.Length; i++)
{
_dbContext.TBL_MOVIES.Add(new TBL_MOVIES()
{
Name = entity.Name,
ActorId = entity.SelectedValues[i],
Plot = entity.Plot,
ProducerId = entity.ProducerId,
YearofRelease = entity.YearofRelease
});
status = _dbContext.SaveChanges() == 1 ? true : false;
}
return(status);
}
}