public static bool CreatePV(PackageVip pv)
{
var en = new ProjectNCTEntities();
en.PackageVips.Add(pv);
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 Rank GetRankNewest(int idCate, bool?music)
{
var en = new ProjectNCTEntities();
var id = en.Ranks.Where(w => w.SongOrMusic == music && w.CateID == idCate).Max(m => m.ID);
return(en.Ranks.SingleOrDefault(s => s.ID == id));
}
public static List <Category> GetListSubCateByID(int id)
{
ProjectNCTEntities en = new ProjectNCTEntities();
var r = en.Categories.Where(w => w.ID_root == id).ToList();
return(r ?? null);
}
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 CreatePayment(Payment p)
{
var en = new ProjectNCTEntities();
en.Payments.Add(p);
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 IEnumerable <Music> GetListMusicSearch(string value, bool music)
{
var en = new ProjectNCTEntities();
var ls = en.Musics.Where(w => w.SongOrMV == music && (w.MusicName.ToLower().Contains(value.ToLower()) || w.MusicNameUnsigned.ToLower().Contains(value.ToLower()))).ToList();
return(ls ?? null);
}
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 CreateQuality(Quality q)
{
ProjectNCTEntities en = new ProjectNCTEntities();
en.Qualities.Add(q);
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 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 CreateUser(UserDTO userDTO)
{
try
{
ProjectNCTEntities db = new ProjectNCTEntities();
if (db.Users.Where(s => s.UserEmail == userDTO.UserEmail).Count() <= 0)
{
var data = new UserDao().CreateUser(new User()
{
UserNameUnsigned = userDTO.UserNameUnsigned,
UserDescription = userDTO.UserDescription,
UserImage = userDTO.UserImage,
UserPwd = userDTO.UserPwd,
UserEmail = userDTO.UserEmail,
UserGender = userDTO.UserGender,
UserDOB = userDTO.UserDOB,
UserName = userDTO.UserName,
UserVIP = false,
UserActive = true,
RoleID = 3,
UserDayCreate = DateTime.Now,
DayVipEnd = null
});
return(true);
}
return(false);
}
catch (Exception e)
{
Console.WriteLine(e);
return(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 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 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 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 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 CreateOrd(OrderVip o)
{
o.OrdDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.OrderVips.Add(o);
return(en.SaveChanges() > 0 ? true : false);
}
//upload
public int CreateMusic(Music m)
{
m.MusicDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.Musics.Add(m);
en.SaveChanges();
return(m.ID);
}
public static bool UpdateQuality(Quality q)
{
var en = new ProjectNCTEntities();
var item = en.Qualities.SingleOrDefault(s => s.ID == q.ID);
item.QualityName = q.QualityName;
item.QualityVip = q.QualityVip;
return(en.SaveChanges() > 0 ? true : false);
}
public static bool CreatePartner(Partner p)
{
p.PartnerActive = true;
p.PartnerDayCreate = DateTime.Now;
var en = new ProjectNCTEntities();
en.Partners.Add(p);
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);
}
public static bool DelListMusicHU(int idUser, bool music)
{
var en = new ProjectNCTEntities();
var ls = GetListMusicHUByIDUser(idUser, music);
foreach (var item in ls)
{
en.HistoryUsers.Remove(en.HistoryUsers.Find(item.ID));
}
return(en.SaveChanges() > 0 ? true : false);
}
public static IEnumerable <User> GetListUser(bool vip)
{
ProjectNCTEntities en = new ProjectNCTEntities();
var ls = en.Users.Where(w => w.RoleID == 3 && w.UserVIP == vip).ToList();
foreach (var item in ls)
{
GetUserByID(item.ID);
}
return(ls);
}
public static bool UpdatePlaylist(Playlist pl)
{
var en = new ProjectNCTEntities();
var item = en.Playlists.SingleOrDefault(s => s.ID == pl.ID);
item.PlaylistName = pl.PlaylistName;
item.PlaylistImage = pl.PlaylistImage;
item.PlaylistDescription = pl.PlaylistDescription;
item.CateID = pl.CateID;
return(en.SaveChanges() > 0 ? true : false);
}
public static bool DelMusicHU(int id)
{
var en = new ProjectNCTEntities();
var hu = en.HistoryUsers.Find(id);
var ls = GetListMusicHUByIDMusic(hu.UserID, hu.MusicID);
foreach (var item in ls)
{
en.HistoryUsers.Remove(en.HistoryUsers.Find(item.ID));
}
return(en.SaveChanges() > 0?true:false);
}
