//
// GET: /Home/Test/
public ActionResult Test()
{
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
foreach (var celeb in _db.tbl_Celebrity)
{
if (celeb.celeb_DoubanID != null)
{
foreach (var item in _db.tbl_Movie)
{
if (item.movie_DirectorsId != null && item.movie_DirectorsId.Contains(celeb.celeb_DoubanID))
{
item.movie_DirectorsId.Replace(celeb.celeb_DoubanID, celeb.celeb_Id);
}
if (item.movie_WritersId != null && item.movie_WritersId.Contains(celeb.celeb_DoubanID))
{
item.movie_WritersId.Replace(celeb.celeb_DoubanID, celeb.celeb_Id);
}
if (item.movie_CastsId != null && item.movie_CastsId.Contains(celeb.celeb_DoubanID))
{
item.movie_CastsId.Replace(celeb.celeb_DoubanID, celeb.celeb_Id);
}
}
}
}
//_db.SubmitChanges();
_db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 添加每日发现电影
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static string Create(ManageDiscViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Discovery disc = new tbl_Discovery()
{
disc_Movie = model.Movie,
disc_Image = model.Image
};
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Discovery.Where(p => p.disc_Id == guid).Count() != 0);
disc.disc_Id = guid;
disc.disc_Flag = _db.tbl_Discovery.OrderByDescending(d => d.disc_Flag).ToList()[0].disc_Flag + 1;
//_db.tbl_Discovery.InsertOnSubmit(disc);
//_db.SubmitChanges();
//_db.SetDiscTime(guid);
_db.tbl_Discovery.Add(disc);
_db.SaveChanges();
return(disc.disc_Id);
}
}
/// <summary>
/// 修改封面
/// </summary>
/// <param name="model"></param>
/// <returns>成功 or 失败，错误信息</returns>
public static RequestResult ChangeCover(ChangeCoverViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
bool hasModified = false;
var account = _db.tbl_UserAccount.SingleOrDefault(p => p.user_Id == model.Id);
if (model.Cover != account.user_Avatar && !string.IsNullOrEmpty(model.Cover) && !string.IsNullOrWhiteSpace(model.Cover))
{
account.user_Cover = model.Cover;
hasModified = true;
}
if (hasModified)
{
//_db.SubmitChanges();
//_db.AlterUserAlterTime(account.user_Id);
_db.SaveChanges();
return(new RequestResult()
{
Succeeded = true
});
}
else
{
return(new RequestResult()
{
Error = "没有改变。。。"
});
}
}
}
public AlbumViewModel(tbl_Album album)
{
Id = album.album_Id;
Title = album.album_Title;
Summary = album.album_Summary;
Cover = album.album_Cover;
UserId = album.album_User;
UserAccount = AccountManager.GetAccount(album.album_User);
CreateTime = ((DateTime)album.album_Time).Date.ToShortDateString();
AlterTime = ((DateTime)album.album_AlterTime).Date.ToShortDateString();
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
ItemJson = album.album_Item;
var others = _db.tbl_Album.Where(a => a.album_User == album.album_User);
Albums = new List <AlbumListItem>();
foreach (var item in others)
{
if (item.album_Id != album.album_Id)
{
Albums.Add(new AlbumListItem(item));
}
}
IsCreator = false;
HasFollow = false;
}
/// <summary>
/// 通过json创建电影
/// </summary>
/// <param name="json">json</param>
/// <param name="mappath">电影海报保存地址</param>
/// <param name="create">电影创建者</param>
/// <returns></returns>
public static string CreateJson(JObject json, string mappath, string create)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
var createMovie = new tbl_Movie();
createMovie = MovieManager.JsonToMovie(json, mappath);
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Movie.Where(p => p.movie_Id == guid).Count() != 0);
createMovie.movie_Id = guid;
createMovie.movie_Create = create;
createMovie.movie_VisitCount = 0;
if ((bool)_db.tbl_UserAccount.SingleOrDefault(u => u.user_Id == create).user_IsAdmin)
{
createMovie.movie_Status = 2;
}
else
{
createMovie.movie_Status = 0;
}
//_db.tbl_Movie.InsertOnSubmit(createMovie);
//_db.SubmitChanges();
//_db.SetMovieTime(guid);
_db.tbl_Movie.Add(createMovie);
_db.SaveChanges();
return(createMovie.movie_Id);
}
}
/// <summary>
/// 创建资源
/// </summary>
/// <param name="model"></param>
public static void Create(ManageResViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Resource res = new tbl_Resource()
{
res_Movie = model.MovieId,
res_Name = model.FileName,
res_Content = model.Content,
res_Size = float.Parse(model.FileSize),
res_Type = model.ResType,
res_FavorCount = 0,
res_Status = model.Status
};
if (model.User != null)
{
res.res_User = model.User;
}
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Resource.Where(p => p.res_Id == guid).Count() != 0);
res.res_Id = guid;
//_db.tbl_Resource.InsertOnSubmit(res);
//_db.SubmitChanges();
//_db.SetResTime(guid);
_db.tbl_Resource.Add(res);
_db.SaveChanges();
}
}
/// <summary>
/// 验证邮箱
/// </summary>
/// <param name="account">账号</param>
/// <param name="email">输入的邮箱</param>
/// <returns>成功 or 失败，错误信息</returns>
public static RequestResult ValidateEmail(string account, string email)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
var hasAccount = _db.tbl_UserAccount.Where(p => p.user_Account == account).ToList();
if (hasAccount.Count() == 0)
{
return(new RequestResult()
{
Succeeded = false, Error = "用户名不存在"
});
}
else if (hasAccount[0].user_EmailAddress != email)
{
return(new RequestResult()
{
Succeeded = false, Error = "电子邮件错误"
});
}
else
{
return(new RequestResult()
{
Succeeded = true
});
}
}
}
/// <summary>
/// 更新所有电影信息中导演、演员、编剧id
/// </summary>
/// <param name="celeb">影人id</param>
/// <param name="douban">影人豆瓣id</param>
public static void RefreshCeleb(string celeb, string douban)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
var movies = _db.tbl_Movie;
foreach (var item in movies)
{
if (!string.IsNullOrEmpty(item.movie_DirectorsId) && item.movie_DirectorsId.Contains(douban))
{
item.movie_DirectorsId = item.movie_DirectorsId.Replace(douban, celeb);
}
if (!string.IsNullOrEmpty(item.movie_WritersId) && item.movie_WritersId.Contains(douban))
{
item.movie_WritersId = item.movie_WritersId.Replace(douban, celeb);
}
if (!string.IsNullOrEmpty(item.movie_CastsId) && item.movie_CastsId.Contains(douban))
{
item.movie_CastsId = item.movie_CastsId.Replace(douban, celeb);
}
}
//_db.SubmitChanges();
_db.SaveChanges();
}
}
public ActionResult Index(string search, int page = 1)
{
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
var query = from m in _db.tbl_Resource
select m;
if (!string.IsNullOrWhiteSpace(search) && !string.IsNullOrEmpty(search))
{
search = search.ToLower();
query = (IOrderedQueryable <tbl_Resource>)query.Where(s => s.res_Name.ToLower().Contains(search) || s.res_Content.ToLower().Contains(search));
}
query = query.Skip((page - 1) * 20).Take(20).OrderByDescending(m => m.res_Time);
List <ResViewModel> ress = new List <ResViewModel>();
foreach (var item in query)
{
if (!string.IsNullOrEmpty(item.res_User) && !string.IsNullOrWhiteSpace(item.res_User))
{
ress.Add(new ResViewModel(item));
}
}
FilterResViewModel resModel = new FilterResViewModel();
resModel.Ress = ress;
resModel.Search = search;
resModel.Page = page;
return(View(resModel));
}
/// <summary>
/// 创建专辑
/// </summary>
/// <param name="model"></param>
/// <returns>专辑id</returns>
public static string Create(ManageAlbumViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Album album = new tbl_Album()
{
album_Title = model.Title,
album_Summary = model.Summary,
album_User = model.UserId,
album_Cover = model.Cover
};
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Album.Where(p => p.album_Id == guid).Count() != 0);
album.album_Id = guid;
album.album_Item = "[]";
album.album_Visit = 0;
//_db.tbl_Album.InsertOnSubmit(album);
//_db.SubmitChanges();
//_db.SetAlbumTime(guid);
_db.tbl_Album.Add(album);
_db.SaveChanges();
return(album.album_Id);
}
}
/// <summary>
/// 标记
/// </summary>
/// <param name="targrt">被标记目标id</param>
/// <param name="user">用户id</param>
/// <param name="type">1想看电影，2看过电影，3喜欢电影，4收藏影人，5赞资源，6同求资源，7关注专辑</param>
public static void Create(string targrt, string user, int type)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
if (MarkManager.Validate(targrt, user, type))
{
return;
}
var mark = new tbl_Mark();
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Mark.Where(p => p.mark_Id == guid).Count() != 0);
mark.mark_Id = guid;
mark.mark_Target = targrt;
mark.mark_User = user;
mark.mark_Type = (byte)type;
//_db.tbl_Mark.InsertOnSubmit(mark);
//_db.SubmitChanges();
//_db.SetMarkMovieTime(mark.mark_Id);
_db.tbl_Mark.Add(mark);
_db.SaveChanges();
}
}
/// <summary>
/// 创建求资源
/// </summary>
/// <param name="model"></param>
public static void Create(ManageAskViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Ask ask = new tbl_Ask()
{
ask_Movie = model.MovieId,
ask_Note = model.Note,
ask_State = false,
ask_With = 0
};
if (model.User != null)
{
ask.ask_User = model.User;
}
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Ask.Where(p => p.ask_Id == guid).Count() != 0);
ask.ask_Id = guid;
//_db.tbl_Ask.InsertOnSubmit(ask);
//_db.SubmitChanges();
//_db.SetAskTime(guid);
_db.tbl_Ask.Add(ask);
_db.SaveChanges();
}
}
/// <summary>
/// 创建评论
/// </summary>
/// <param name="content">评论内容</param>
/// <param name="movie">评论的电影id</param>
/// <param name="user">用户id</param>
/// <returns>评论id</returns>
public static string Create(string content, string movie, string user)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Comment cmt = new tbl_Comment()
{
cmt_Content = content,
cmt_User = user,
cmt_Movie = movie
};
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Comment.Where(p => p.cmt_Id == guid).Count() != 0);
cmt.cmt_Id = guid;
//_db.tbl_Comment.InsertOnSubmit(cmt);
//_db.SubmitChanges();
//_db.SetCmtTime(guid);
_db.tbl_Comment.Add(cmt);
_db.SaveChanges();
return(cmt.cmt_Id);
}
}
public ActionResult Edit(ManageMovieViewModel model, System.Web.HttpPostedFileBase file)
{
if (!ModelState.IsValid)
{
return(View(model));
}
if (file != null && file.ContentLength > 0)
{
var fileName = System.IO.Path.Combine(Request.MapPath("~/Content/Movie/"), System.IO.Path.GetFileName(file.FileName));
file.SaveAs(fileName);
model.Avatar = System.IO.Path.GetFileName(file.FileName);
string oldAvatar = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == model.Id).movie_Avatar;
if (oldAvatar != "Movie_Default.png")
{
ImageManager.Delete(Server.MapPath("~/Content/Movie/" + oldAvatar));
}
}
else
{
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
model.Avatar = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == model.Id).movie_Avatar;
}
MovieManager.Edit(model);
return(RedirectToAction("Index", new { id = model.Id }));
}
public ActionResult CreateMovie(ManageMovieViewModel movie, System.Web.HttpPostedFileBase file)
{
if (!ModelState.IsValid)
{
return(View(movie));
}
if (file != null && file.ContentLength > 0)
{
var fileName = System.IO.Path.Combine(Request.MapPath("~/Content/Movie/"), System.IO.Path.GetFileName(file.FileName));
file.SaveAs(fileName);
movie.Avatar = System.IO.Path.GetFileName(file.FileName);
}
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
if ((bool)_db.tbl_UserAccount.SingleOrDefault(u => u.user_Account == CookieHepler.GetCookie("user")).user_IsAdmin)
{
movie.Status = 2;
}
else
{
movie.Status = 0;
}
movie.Create = AccountManager.GetId(CookieHepler.GetCookie("user"));
string newId = MovieManager.CreateMovie(movie);
return(RedirectToAction("Index", new { id = newId }));
}
public static List <tbl_UserAccount> ExecuteSqlQuery(string sql, SqlParameter param)
{
using (MRDataEntities _db = new MRDataEntities())
{
return(_db.tbl_UserAccount.SqlQuery(sql, param).ToList());
}
}
/// <summary>
/// 检查某个用户时候为管理员
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
public static bool CheckAdmin(string id)
{
using (MRDataEntities _db = new MRDataEntities())
{
var result = _db.tbl_UserAccount.FirstOrDefault(p => p.user_Id == id);
return((bool)result.user_IsAdmin);
}
}
/// <summary>
/// 创建电影
/// </summary>
/// <param name="movie"></param>
/// <returns>电影id</returns>
public static string CreateMovie(ManageMovieViewModel movie)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
string guid;
do
{
guid = Guid.NewGuid().ToString("N").ToUpper();
} while (_db.tbl_Movie.Where(p => p.movie_Id == guid).Count() != 0);
if (!string.IsNullOrEmpty(movie.Genres) && !string.IsNullOrWhiteSpace(movie.Genres))
{
movie.Genres = Translator.GenreToId(movie.Genres);
}
if (!string.IsNullOrEmpty(movie.Countries) && !string.IsNullOrWhiteSpace(movie.Countries))
{
movie.Countries = Translator.CountryToId(movie.Countries);
}
if (!string.IsNullOrEmpty(movie.Languages) && !string.IsNullOrWhiteSpace(movie.Countries))
{
movie.Languages = Translator.LangToId(movie.Languages);
}
var createMovie = new tbl_Movie()
{
movie_Id = guid,
movie_Title = movie.Title,
movie_TitleEn = movie.TitleEn,
movie_Aka = movie.Aka,
movie_Directors = movie.Directors,
movie_Writers = movie.Writers,
movie_Casts = movie.Casts,
movie_Durations = movie.Durations,
movie_Genres = movie.Genres,
movie_Countries = movie.Countries,
movie_Languages = movie.Languages,
movie_Pubdates = movie.Pubdates,
movie_Year = movie.Year,
movie_Rating = movie.Rating,
movie_RatingCount = movie.RatingCount,
movie_Summary = movie.Summary,
movie_DoubanID = movie.DoubanID,
movie_IMDbID = movie.IMDbID,
movie_VisitCount = 0,
movie_Create = movie.Create,
movie_Status = movie.Status,
movie_Avatar = movie.Avatar == null ? "Movie_Default.png" : movie.Avatar
};
//_db.tbl_Movie.InsertOnSubmit(createMovie);
//_db.SubmitChanges();
//_db.SetMovieTime(guid);
_db.tbl_Movie.Add(createMovie);
_db.SaveChanges();
return(createMovie.movie_Id);
}
}
//
// GET: /Home/Index/
public ActionResult Index(int offset = 0)
{
HomeViewModel model = new HomeViewModel();
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
var dis = _db.tbl_Discovery.OrderByDescending(d => d.disc_Flag).ToList();
if (offset >= dis.Count || offset < 0)
{
return(Redirect("/Home/Index?offset=0"));
}
model.Discovery = new HomeDiscViewModel(dis[offset]);
model.Discovery.Offset = offset;
model.Discovery.Post = offset - 1;
model.Discovery.Pre = offset + 1;
if (User.Identity.IsAuthenticated)
{
model.Discovery.Movie.IsPlan = MarkManager.Validate(model.Discovery.Movie.Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 1);
model.Discovery.Movie.IsFinish = MarkManager.Validate(model.Discovery.Movie.Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 2);
model.Discovery.Movie.IsFavor = MarkManager.Validate(model.Discovery.Movie.Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 3);
}
var newmovie = _db.tbl_Movie.Where(m => m.movie_Status == 2).OrderByDescending(m => m.movie_Time).ToList().Take(20);
model.News = new List <MovieListViewModel>();
foreach (var item in newmovie)
{
MovieListViewModel movie = new MovieListViewModel();
movie.Title = item.movie_Title;
if (!string.IsNullOrEmpty(item.movie_TitleEn) && !string.IsNullOrWhiteSpace(item.movie_TitleEn))
{
movie.Title += "\t" + item.movie_TitleEn;
}
movie.Year = item.movie_Year;
movie.Id = item.movie_Id;
model.News.Add(movie);
}
var mostmovie = _db.tbl_Movie.Where(m => m.movie_Status == 2).OrderByDescending(m => m.movie_VisitCount).ToList().Take(20);
model.Mosts = new List <MovieListViewModel>();
foreach (var item in mostmovie)
{
MovieListViewModel movie = new MovieListViewModel();
movie.Title = item.movie_Title;
if (!string.IsNullOrEmpty(item.movie_TitleEn) && !string.IsNullOrWhiteSpace(item.movie_TitleEn))
{
movie.Title += "\t" + item.movie_TitleEn;
}
movie.Year = item.movie_Year;
movie.Id = item.movie_Id;
model.Mosts.Add(movie);
}
return(View(model));
}
//
// GET: /Search/
public ActionResult Index(string search, string genre = "0", string country = "0", string year = "0", int page = 1)
{
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
ClassifyViewModel movieGroup = new ClassifyViewModel();
var filterMovie = from m in _db.tbl_Movie
where m.movie_Status == 2
select m;
if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search))
{
filterMovie = filterMovie.Where(m => m.movie_Title.Contains(search) || m.movie_TitleEn.Contains(search) || m.movie_Aka.Contains(search));
}
if (genre != "0")
{
filterMovie = filterMovie.Where(m => m.movie_Genres.IndexOf(genre) > -1);
}
if (country != "0")
{
filterMovie = filterMovie.Where(m => m.movie_Countries.IndexOf(country) > -1);
}
if (year != "0")
{
filterMovie = filterMovie.Where(m => m.movie_Year == year);
}
filterMovie.OrderByDescending(m => m.movie_Time);
movieGroup.listMovies.Clear();
foreach (var item in filterMovie)
{
MovieViewModel movie = new MovieViewModel(item);
movie.IsPlan = MarkManager.Validate(item.movie_Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 1);
movie.IsFinish = MarkManager.Validate(item.movie_Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 2);
movie.IsFavor = MarkManager.Validate(item.movie_Id, AccountManager.GetId(CookieHepler.GetCookie("user")), 3);
movieGroup.listMovies.Add(movie);
}
movieGroup.Count = movieGroup.listMovies.Count();
movieGroup.Search = search;
movieGroup.Genre = genre;
movieGroup.Country = country;
movieGroup.Year = year;
movieGroup.Page = page;
movieGroup.PagingCount = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(movieGroup.Count) / movieGroup.MovieSize));
movieGroup.listMovies = movieGroup.listMovies.Skip((page - 1) * movieGroup.MovieSize).Take(movieGroup.MovieSize).ToList();
if (page > movieGroup.PagingCount && movieGroup.listMovies.Count > 0)
{
return(RedirectToAction("NotFound", "Error"));
}
string url = Translator.BuildUrl(Request.Url.ToString(), "search", search);
url = Translator.BuildUrl(url, "genre", genre);
url = Translator.BuildUrl(url, "country", country);
url = Translator.BuildUrl(url, "year", year);
ViewBag.CurrentUrl = url;
return(View(movieGroup));
}
public HomeDiscViewModel(tbl_Discovery dis)
{
Id = dis.disc_Id;
//MR_DataClassesDataContext _db = new MR_DataClassesDataContext();
MRDataEntities _db = new MRDataEntities();
Movie = new MovieViewModel(_db.tbl_Movie.SingleOrDefault(m => m.movie_Id == dis.disc_Movie));
Image = dis.disc_Image;
Flag = dis.disc_Flag;
}
/// <summary>
/// 访问电影，电影的访问量+1
/// </summary>
/// <param name="id">电影id</param>
public static void Visit(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Movie movie = _db.tbl_Movie.SingleOrDefault(s => s.movie_Id == id);
movie.movie_VisitCount++;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
/// <summary>
/// 访问电影，专辑的访问量+1
/// </summary>
/// <param name="id">专辑id</param>
public static void Visit(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Album album = _db.tbl_Album.SingleOrDefault(a => a.album_Id == id);
album.album_Visit++;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
/// <summary>
/// 删除影人
/// </summary>
/// <param name="id"></param>
public static void Delete(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Celebrity celeb = _db.tbl_Celebrity.SingleOrDefault(s => s.celeb_Id == id);
//_db.tbl_Celebrity.DeleteOnSubmit(celeb);
//_db.SubmitChanges();
_db.tbl_Celebrity.Remove(celeb);
_db.SaveChanges();
}
}
/// <summary>
/// 审核用户创建的电影不通过
/// </summary>
/// <param name="model"></param>
public static void Reject(RejectViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Movie movie = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == model.Id);
movie.movie_Status = 1;
movie.movie_Note = model.Note;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
/// <summary>
/// 审核用户创建的电影通过
/// </summary>
/// <param name="id">电影id</param>
public static void Audit(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Movie movie = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == id);
movie.movie_Status = 2;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
/// <summary>
/// 删除资源
/// </summary>
/// <param name="id">资源id</param>
public static void Delete(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == id);
//_db.tbl_Resource.DeleteOnSubmit(res);
//_db.SubmitChanges();
_db.tbl_Resource.Remove(res);
_db.SaveChanges();
}
}
/// <summary>
/// 审核资源通过
/// </summary>
/// <param name="id">资源id</param>
public static void Audit(string id)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == id);
res.res_Status = 2;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
/// <summary>
/// 审核资源不通过
/// </summary>
/// <param name="model"></param>
public static void Reject(RejectResViewModel model)
{
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
tbl_Resource res = _db.tbl_Resource.SingleOrDefault(s => s.res_Id == model.Id);
res.res_Status = 1;
res.res_Note = model.Note;
//_db.SubmitChanges();
_db.SaveChanges();
}
}
public ClassifyViewModel()
{
listGenre = new List <SelectListItem>();
listCountry = new List <SelectListItem>();
listYear = new List <SelectListItem>();
listMovies = new List <MovieViewModel>();
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
using (MRDataEntities _db = new MRDataEntities())
{
var tblGenre = _db.tbl_GenreMovie.ToList();
var tblCountry = _db.tbl_Country.ToList();
var tblYear = from m in _db.tbl_Movie
select m.movie_Year;
tblYear = tblYear.Distinct().OrderByDescending(y => y);
listYear.Add(new SelectListItem()
{
Text = "选择年代", Value = "0"
});
foreach (var item in tblYear)
{
listYear.Add(new SelectListItem()
{
Text = item, Value = item
});
}
listGenre.Add(new SelectListItem()
{
Text = "选择类型", Value = "0"
});
foreach (var item in tblGenre)
{
listGenre.Add(new SelectListItem()
{
Text = item.genre_Name, Value = item.genre_Id.ToString()
});
}
listCountry.Add(new SelectListItem()
{
Text = "选择国家/地区", Value = "0"
});
foreach (var item in tblCountry)
{
listCountry.Add(new SelectListItem()
{
Text = item.country_Name, Value = item.country_Id.ToString()
});
}
}
}
