/// <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); } }
// // 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> 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> /// 更新所有电影信息中导演、演员、编剧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(); } }
/// <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 = "没有改变。。。" }); } } }
/// <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="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="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); } }
/// <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="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="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); } }
/// <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> /// 访问电影,电影的访问量+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> /// 审核资源不通过 /// </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(); } }
/// <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="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_Celebrity celeb = _db.tbl_Celebrity.SingleOrDefault(m => m.celeb_Id == id); celeb.celeb_Status = 2; //_db.SubmitChanges(); _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_Ask ask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id); //_db.tbl_Ask.DeleteOnSubmit(ask); _db.tbl_Ask.Remove(ask); //_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_Celebrity celeb = _db.tbl_Celebrity.SingleOrDefault(m => m.celeb_Id == model.Id); celeb.celeb_Status = 1; celeb.celeb_Note = model.Note; //_db.SubmitChanges(); _db.SaveChanges(); } }
/// <summary> /// 求资源已求到 /// </summary> /// <param name="id">求资源id</param> public static void Over(string id) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { tbl_Ask tblask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id); tblask.ask_State = true; //_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()) { var album = _db.tbl_Album.SingleOrDefault(a => a.album_Id == id); //_db.tbl_Album.DeleteOnSubmit(album); _db.tbl_Album.Remove(album); //_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()) { var cmt = _db.tbl_Comment.SingleOrDefault(a => a.cmt_Id == id); //_db.tbl_Comment.DeleteOnSubmit(cmt); //_db.SubmitChanges(); _db.tbl_Comment.Remove(cmt); _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()) { var disc = _db.tbl_Discovery.SingleOrDefault(a => a.disc_Id == id); //_db.tbl_Discovery.DeleteOnSubmit(disc); //_db.SubmitChanges(); _db.tbl_Discovery.Remove(disc); _db.SaveChanges(); } }
/// <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 Cancel(string targrt, string user, int type) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { var mark = _db.tbl_Mark.SingleOrDefault(m => m.mark_User == user && m.mark_Target == targrt && m.mark_Type == type); if (mark != null) { //_db.tbl_Mark.DeleteOnSubmit(mark); //_db.SubmitChanges(); _db.tbl_Mark.Remove(mark); _db.SaveChanges(); } } }
/// <summary> /// 删除专辑项目 /// </summary> /// <param name="id">专辑id</param> /// <param name="movie">电影id</param> public static void Minus(string id, string movie) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { var album = _db.tbl_Album.SingleOrDefault(a => a.album_Id == id); List <AlbumItemViewModel> all = JsonConvert.DeserializeObject <List <AlbumItemViewModel> >(album.album_Item); all = all.SkipWhile(m => m.Movie == movie).ToList(); album.album_Item = JsonConvert.SerializeObject(all); //_db.SubmitChanges(); _db.SaveChanges(); } }
/// <summary> /// 重置密码 /// </summary> /// <param name="account">账号</param> /// <param name="password">密码</param> /// <returns>成功 or 失败,错误信息</returns> public static RequestResult ResetPassword(string account, string password) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { password = DESEncryption.DesEncrypt(password); var newAccount = _db.tbl_UserAccount.SingleOrDefault(p => p.user_Account == account); newAccount.user_Password = password; //_db.SubmitChanges(); _db.SaveChanges(); return(new RequestResult() { Succeeded = true }); } }
/// <summary> /// 创建账户 /// </summary> /// <param name="account">用户名</param> /// <param name="password">密码</param> /// <returns>成功 or 失败,错误信息</returns> public static RequestResult Create(string account, string password) { using (MRDataEntities _db = new MRDataEntities()) //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { var hasAccount = _db.tbl_UserAccount.Where(p => p.user_Account == account); if (hasAccount.Count() > 0) { return(new RequestResult() { Succeeded = false, Error = "用户名已存在" }); } else { password = DESEncryption.DesEncrypt(password); //string guid; //do //{ // guid = Guid.NewGuid().ToString("N").ToUpper(); //} while (_db.tbl_UserAccount.Where(p => p.user_Id == guid).Count() != 0); var addAccount = new tbl_UserAccount() { //user_Id = guid, user_Id = Guid.NewGuid().ToString("N").ToUpper(), user_Account = account, user_Password = password, user_IsAdmin = false, user_CreateTime = DateTime.Now }; addAccount.user_Avatar = "User_1.jpg"; addAccount.user_Cover = "Cover_1.jpg"; _db.tbl_UserAccount.Add(addAccount); _db.SaveChanges(); //_db.tbl_UserAccount.InsertOnSubmit(addAccount); //_db.SubmitChanges(); //_db.SetUserTime(guid); return(new RequestResult() { Succeeded = true }); } } }