public static bool CreateRank(Rank r)
{
var en = new ProjectNCTEntities();
var newest = GetRankNewest(r.CateID, r.SongOrMusic);
if (newest == null || r.RMusicStart == newest.RMusicEnd)
{
en.Ranks.Add(r);
en.SaveChanges();
var id = r.ID;
var grade = 1;
var lsCate = CategoryDAO.GetListSubCateByID(r.CateID);
foreach (var cate in lsCate)
{
var ls = en.Musics.Where(w => w.SongOrMV == r.SongOrMusic && w.CateID == cate.ID).OrderByDescending(o => o.MusicView).Take(10).ToList();
foreach (var item in ls)
{
if (grade < 11)
{
en.RankMusics.Add(new RankMusic {
MusicID = item.ID, RankID = id, RMusicGrade = grade
});
en.SaveChanges();
grade++;
}
}
}
return(true);
}
return(false);
}
public bool CreateCate(Category category)
{
db.Categories.Add(category);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public bool Create(LyricsMusic lyricsMusic)
{
db.LyricsMusics.Add(lyricsMusic);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public bool CreatePartner(Partner partner)
{
db.Partners.Add(partner);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public bool CreatePlaylist(Playlist playlist)
{
db.Playlists.Add(playlist);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
//create
public Payment Create(Payment payment)
{
db.Payments.Add(payment);
if (db.SaveChanges() > 0)
{
return(payment);
}
return(null);
}
//create
public SingerMusic Create(SingerMusic singerMusic)
{
db.SingerMusics.Add(singerMusic);
if (db.SaveChanges() > 0)
{
return(singerMusic);
}
return(null);
}
//create
public RankMusic Create(RankMusic rank)
{
db.RankMusics.Add(rank);
if (db.SaveChanges() > 0)
{
return(rank);
}
return(null);
}
//create
public QualityMusic Create(QualityMusic qualityMusic)
{
db.QualityMusics.Add(qualityMusic);
if (db.SaveChanges() > 0)
{
return(qualityMusic);
}
;
return(null);
}
//create
public Quality Create(Quality quality)
{
db.Qualities.Add(quality);
if (db.SaveChanges() > 0)
{
return(quality);
}
;
return(null);
}
public static bool DelRank(int id)
{
var en = new ProjectNCTEntities();
var ls = GetListRM(id);
foreach (var item in ls)
{
en.RankMusics.Remove(en.RankMusics.Find(item.ID));
en.SaveChanges();
}
en.Ranks.Remove(en.Ranks.Find(id));
return(en.SaveChanges() > 0?true:false);
}
public static bool CreateCate(Category cate)
{
ProjectNCTEntities en = new ProjectNCTEntities();
en.Categories.Add(cate);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreatePV(PackageVip pv)
{
var en = new ProjectNCTEntities();
en.PackageVips.Add(pv);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool DelSM(int id)
{
var en = new ProjectNCTEntities();
en.SingerMusics.Remove(en.SingerMusics.Find(id));
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreateSM(SingerMusic sm)
{
var en = new ProjectNCTEntities();
en.SingerMusics.Add(sm);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreatePayment(Payment p)
{
var en = new ProjectNCTEntities();
en.Payments.Add(p);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreateQuality(Quality q)
{
ProjectNCTEntities en = new ProjectNCTEntities();
en.Qualities.Add(q);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreateHU(HistoryUser hu)
{
var en = new ProjectNCTEntities();
en.HistoryUsers.Add(hu);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool DelPV(int id)
{
var en = new ProjectNCTEntities();
en.PackageVips.Remove(en.PackageVips.Find(id));
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreatePM(PlaylistMusic pm)
{
var en = new ProjectNCTEntities();
en.PlaylistMusics.Add(pm);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool DelPM(int id)
{
var en = new ProjectNCTEntities();
var item = en.PlaylistMusics.Find(id);
en.PlaylistMusics.Remove(item);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool DelSinger(int id, int idSinger)
{
var en = new ProjectNCTEntities();
var item = en.SingerMusics.SingleOrDefault(s => s.MusicID == id && s.SingerID == idSinger);
en.SingerMusics.Remove(item);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreateOrd(OrderVip o)
{
o.OrdDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.OrderVips.Add(o);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool ApproveFile(int id)
{
var en = new ProjectNCTEntities();
var item = en.QualityMusics.Find(id);
item.NewFile = false;
item.QMusicApproved = true;
return en.SaveChanges() > 0 ? true : false;
}
public static bool DelCate(int id)
{
ProjectNCTEntities en = new ProjectNCTEntities();
var item = en.Categories.SingleOrDefault(s => s.ID == id);
en.Categories.Remove(item);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool UpdateLM(LyricsMusic lm)
{
var en = new ProjectNCTEntities();
var item = en.LyricsMusics.SingleOrDefault(s => s.ID == lm.ID);
item.LMusicDetail = lm.LMusicDetail;
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreateLM(LyricsMusic lm)
{
lm.LMusicDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.LyricsMusics.Add(lm);
return(en.SaveChanges() > 0 ? true : false);
}
public static bool UpdateCate(Category cate)
{
ProjectNCTEntities en = new ProjectNCTEntities();
var item = en.Categories.SingleOrDefault(s => s.ID == cate.ID);
item.CateName = cate.CateName;
item.ID_root = cate.ID_root;
return(en.SaveChanges() > 0 ? true : false);
}
public static int UpdateView(int id)
{
var en = new ProjectNCTEntities();
var item = en.Musics.Find(id);
var viewUp = item.MusicView + 1;
item.MusicView = viewUp;
return(en.SaveChanges() > 0 ? viewUp : 0);
}
//upload
public int CreateMusic(Music m)
{
m.MusicDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.Musics.Add(m);
en.SaveChanges();
return(m.ID);
}