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