public bool Insert(Basic_Celebrity_Info info)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
database.Basic_Celebrity.Add(ToDatabase(info));
database.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool Delete(Guid id)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
var resource = database.Basic_Resource.FirstOrDefault(p => p.Id == id);
database.Basic_Resource.Remove(resource);
database.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
//public bool Update(Guid id, Dictionary<string, object> changes)
//{
// using (MovieResShareEntities database = new MovieResShareEntities())
// {
// try
// {
// var celeb = database.Basic_Movie_Visit.FirstOrDefault(p => p.Id == id);
// foreach (var item in changes)
// {
// switch (item.Key)
// {
// case "state":
// celeb.State = (string)item.Value;
// break;
// case "note":
// celeb.Note = (string)item.Value;
// break;
// default: break;
// }
// }
// database.SaveChanges();
// return true;
// }
// catch (Exception)
// {
// return false;
// }
// }
//}
public bool Delete(Guid id)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
var sigin = database.Basic_User_Signin.FirstOrDefault(p => p.Id == id);
database.Basic_User_Signin.Remove(sigin);
database.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Update(Guid id, Dictionary <string, object> changes)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
var celeb = database.Basic_Collection.FirstOrDefault(p => p.Id == id);
foreach (var item in changes)
{
switch (item.Key)
{
case "title":
celeb.Title = (string)item.Value;
break;
case "content":
celeb.Content = (string)item.Value;
break;
case "summary":
celeb.Summary = (string)item.Value;
break;
case "cover":
celeb.Cover = (string)item.Value;
break;
case "altertime":
celeb.Alter_Time = (DateTime)item.Value;
break;
default: break;
}
}
database.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Delete(Guid id)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
Basic_Celebrity celeb = database.Basic_Celebrity.FirstOrDefault(p => p.Id == id);
Step_Celeb_Avatar avatar = database.Step_Celeb_Avatar.FirstOrDefault(p => p.Celeb == id);
database.Basic_Celebrity.Remove(celeb);
database.Step_Celeb_Avatar.Remove(avatar);
database.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool Update(Guid id, Dictionary <string, object> changes)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
var movie = database.Basic_Movie.FirstOrDefault(p => p.Id == id);
foreach (var item in changes)
{
switch (item.Key)
{
case "title":
movie.Title = (string)item.Value;
break;
case "titleen":
movie.Title_En = (string)item.Value;
break;
case "aka":
movie.Aka = (string)item.Value;
break;
case "year":
movie.Year = (short)item.Value;
break;
case "website":
movie.Website = (string)item.Value;
break;
case "currentseason":
movie.Current_Season = (short)item.Value;
break;
case "seasoncount":
movie.Season_Count = (short)item.Value;
break;
case "episodecount":
movie.Episode_Count = (int)item.Value;
break;
case "pubdate":
movie.Pubdate = (string)item.Value;
break;
case "duration":
movie.Duration = (string)item.Value;
break;
case "douban":
movie.Douban = (string)item.Value;
break;
case "imdb":
movie.IMDb = (string)item.Value;
break;
case "summary":
movie.Summary = (string)item.Value;
break;
case "collectcount":
movie.Summary = (string)item.Value;
break;
case "altertime":
movie.Alter_Time = (DateTime)item.Value;
break;
case "country":
var removecountry = database.Step_Movie_Country.Where(p => p.Movie == id);
foreach (var item1 in removecountry)
{
database.Step_Movie_Country.Remove(item1);
}
foreach (var item2 in (List <Step_Movie_Country_Info>)item.Value)
{
movie.Step_Movie_Country.Add(Step_Movie_Country_DAL.ToDatabase(item2));
}
break;
case "genre":
var removegenre = database.Step_Movie_Genre.Where(p => p.Movie == id);
foreach (var item1 in removegenre)
{
database.Step_Movie_Genre.Remove(item1);
}
foreach (var item2 in (List <Step_Movie_Genre_Info>)item.Value)
{
movie.Step_Movie_Genre.Add(Step_Movie_Genre_DAL.ToDatabase(item2));
}
break;
case "lang":
var removelang = database.Step_Movie_Lang.Where(p => p.Movie == id);
foreach (var item1 in removelang)
{
database.Step_Movie_Lang.Remove(item1);
}
foreach (var item2 in (List <Step_Movie_Lang_Info>)item.Value)
{
movie.Step_Movie_Lang.Add(Step_Movie_Lang_DAL.ToDatabase(item2));
}
break;
case "poster":
movie.Step_Movie_Poster.FirstOrDefault().Large = ((Step_Movie_Poster_Info)item.Value).Large;
movie.Step_Movie_Poster.FirstOrDefault().Small = ((Step_Movie_Poster_Info)item.Value).Small;
movie.Step_Movie_Poster.FirstOrDefault().Medium = ((Step_Movie_Poster_Info)item.Value).Medium;
break;
case "rating":
movie.Step_Movie_Rating.FirstOrDefault().Rated_Num = ((Step_Movie_Rating_Info)item.Value).Rated_Num;
movie.Step_Movie_Rating.FirstOrDefault().Score = ((Step_Movie_Rating_Info)item.Value).Score;
movie.Step_Movie_Rating.FirstOrDefault().Star1 = ((Step_Movie_Rating_Info)item.Value).Star1;
movie.Step_Movie_Rating.FirstOrDefault().Star2 = ((Step_Movie_Rating_Info)item.Value).Star2;
movie.Step_Movie_Rating.FirstOrDefault().Star3 = ((Step_Movie_Rating_Info)item.Value).Star3;
movie.Step_Movie_Rating.FirstOrDefault().Star4 = ((Step_Movie_Rating_Info)item.Value).Star4;
movie.Step_Movie_Rating.FirstOrDefault().Star5 = ((Step_Movie_Rating_Info)item.Value).Star5;
break;
default: break;
}
}
database.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool Update(Guid id, Dictionary <string, object> changes)
{
using (MovieResShareEntities database = new MovieResShareEntities())
{
try
{
var celeb = database.Basic_Celebrity.FirstOrDefault(p => p.Id == id);
foreach (var item in changes)
{
switch (item.Key)
{
case "name":
celeb.Name = (string)item.Value;
break;
case "nameen":
celeb.Name_En = (string)item.Value;
break;
case "aka":
celeb.Aka = (string)item.Value;
break;
case "akaen":
celeb.Aka_En = (string)item.Value;
break;
case "gender":
celeb.Gender = (bool)item.Value;
break;
case "profession":
celeb.Profession = (string)item.Value;
break;
case "birthdate":
celeb.Birth_Date = (string)item.Value;
break;
case "deathdate":
celeb.Death_Date = (string)item.Value;
break;
case "bornplace":
celeb.Profession = (string)item.Value;
break;
case "family":
celeb.Family = (string)item.Value;
break;
case "douban":
celeb.Douban = (string)item.Value;
break;
case "imdb":
celeb.IMDb = (string)item.Value;
break;
case "summary":
celeb.Summary = (string)item.Value;
break;
case "altertime":
celeb.Alter_Time = (DateTime)item.Value;
break;
case "avatar":
celeb.Step_Celeb_Avatar.FirstOrDefault().Large = ((Step_Celeb_Avatar_Info)item.Value).Large;
celeb.Step_Celeb_Avatar.FirstOrDefault().Small = ((Step_Celeb_Avatar_Info)item.Value).Small;
celeb.Step_Celeb_Avatar.FirstOrDefault().Medium = ((Step_Celeb_Avatar_Info)item.Value).Medium;
break;
default: break;
}
}
database.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}