//Playlist Info
public JsonResult GetPlaylists()
{
using (var context = new MusicDBEntities())
{
//get current user email
var username = HttpContext.User.Identity.Name;
//get id
Users u = context.Users.Where(x => x.Email == username).FirstOrDefault();
ModelFactory mf = new ModelFactory();
//get playlists
var p = context.Playlists.Where(x => x.Uid == u.Id).ToList().Select(x => mf.Create(x));
/*
* var json = JsonConvert.SerializeObject(pList, new JsonSerializerSettings()
* {
* PreserveReferencesHandling = PreserveReferencesHandling.Objects,
* Formatting = Formatting.None
* });
*/
var json = JsonConvert.SerializeObject(p);
return(Json(p, JsonRequestBehavior.AllowGet));
}
}
public void CreateNewPL(string p_name)
{
using (var context = new MusicDBEntities())
{
//get current user email
var username = HttpContext.User.Identity.Name;
//get id
Users u = context.Users.Where(x => x.Email == username).FirstOrDefault();
//Current date and time
DateTime dt = DateTime.Now;
//string sqlFormattedDate = dt.ToString("yyyy-MM-dd");
Playlists pl = new Playlists()
{
Uid = u.Id,
P_name = p_name,
Date = dt,
Sid_arr = ""
};
context.Playlists.Add(pl);
context.SaveChanges();
}
}
public void UpdatePassword(string id, string pwd)
{
using (var context = new MusicDBEntities())
{
var u = context.Users.Where(x => x.Email == id).FirstOrDefault();
u.Pwd = pwd;
context.SaveChanges();
}
}
//delete song
public void DeleteSong(int id)
{
using (var context = new MusicDBEntities())
{
var rec = context.Songs.Find(id);
context.Songs.Remove(rec);
context.SaveChanges();
}
}
//List of songs JSON
public JsonResult GetSongs()
{
using (var context = new MusicDBEntities())
{
var data = context.Songs.ToList();
var json = JsonConvert.SerializeObject(data);
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
//Delete from Playlist
public ActionResult DeletePL(int id)
{
using (var context = new MusicDBEntities())
{
var result = context.Playlists.SingleOrDefault(x => x.Id == id);
if (result != null)
{
context.Playlists.Remove(result);
context.SaveChanges();
}
return(RedirectToAction("MyPlaylists", "User"));
}
}
//List of Users
public JsonResult GetUsers()
{
using (var context = new MusicDBEntities())
{
ModelFactory mf = new ModelFactory();
//get users
var p = context.Users.ToList().Select(x => mf.UList(x));
var json = JsonConvert.SerializeObject(p);
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
//Edit User
public int EditUser(UsersModel model)
{
using (var context = new MusicDBEntities())
{
var us = context.Users.Where(x => x.Id == model.Id).FirstOrDefault();
us.Fname = model.Fname;
us.Lname = model.Lname;
us.Email = model.Email;
us.Pwd = model.Pwd;
context.SaveChanges();
return(us.Id);
}
}
public void RemovePL(int pid, int sid)
{
using (var context = new MusicDBEntities())
{
var result = context.Playlists.SingleOrDefault(x => x.Id == pid);
if (result != null)
{
string or_arr = result.Sid_arr;
var t = or_arr.Replace(sid.ToString(), string.Empty);
result.Sid_arr = t.Trim();
//result.Sid_arr = "Some new value";
context.SaveChanges();
}
}
}
//Get user information
public UsersModel GetUserInfo(int id)
{
using (var context = new MusicDBEntities())
{
Users u = context.Users.Where(x => x.Id == id).FirstOrDefault();
UsersModel um = new UsersModel()
{
Fname = u.Fname,
Lname = u.Lname,
Email = u.Email,
Pwd = u.Pwd
};
return(um);
}
}
public void AddPL(int pid, int sid)
{
using (var context = new MusicDBEntities())
{
var result = context.Playlists.SingleOrDefault(x => x.Id == pid);
if (result != null)
{
result.Sid_arr += " " + sid;
//remove white spaces from both side
result.Sid_arr = result.Sid_arr.Trim();
//result.Sid_arr = "Some new value";
context.SaveChanges();
}
}
}
//Edit Song
public int EditSong(SongsModel model)
{
using (var context = new MusicDBEntities())
{
var sg = context.Songs.Where(x => x.Id == model.Id).FirstOrDefault();
sg.S_name = model.S_name;
sg.R_date = model.R_date;
sg.Art_name = model.Art_name;
sg.Genre = model.Genre;
sg.Album_name = model.Album_name;
sg.Song_link = model.Song_link;
context.SaveChanges();
return(sg.Id);
}
}
//get playlist information
public PlaylistsModel GetPlayList(int id)
{
using (var context = new MusicDBEntities())
{
Playlists pl = context.Playlists.Where(x => x.Id == id).FirstOrDefault();
PlaylistsModel pm = new PlaylistsModel()
{
Id = pl.Id,
Uid = pl.Uid,
P_name = pl.P_name,
Date = pl.Date,
Sid_arr = pl.Sid_arr
};
return(pm);
}
}
//Add Song
public int AddSong(SongsModel model)
{
using (var context = new MusicDBEntities())
{
Songs sg = new Songs()
{
S_name = model.S_name,
R_date = model.R_date,
Art_name = model.Art_name,
Genre = model.Genre,
Album_name = model.Album_name,
Song_link = model.Song_link
};
context.Songs.Add(sg);
context.SaveChanges();
return(sg.Id);
}
}
//Signup
public int GetRegister(Models.RegisterModel model)
{
using (var context = new MusicDBEntities())
{
Users u = new Users()
{
Fname = model.Fname,
Lname = model.Lname,
Email = model.Email,
Pwd = model.Pwd,
Role = "User"
};
context.Users.Add(u);
context.SaveChanges();
return(u.Id);
}
}
//get song
public SongsModel GetSong(int id)
{
using (var context = new MusicDBEntities())
{
Songs s = context.Songs.Where(x => x.Id == id).FirstOrDefault();
SongsModel sm = new SongsModel()
{
Id = s.Id,
S_name = s.S_name,
R_date = s.R_date,
Art_name = s.Art_name,
Genre = s.Genre,
Album_name = s.Album_name,
Song_link = s.Song_link
};
return(sm);
}
}
public int AddSong(SongsModel model)
{
using (var context = new MusicDBEntities())
{
Songs sg = new Songs()
{
image = model.image,
s_name = model.s_name,
r_date = model.r_date,
art_name = model.art_name,
genre = model.genre,
album_name = model.album_name,
song_link = model.song_link
};
context.Songs.Add(sg);
context.SaveChanges();
return(sg.sid);
}
}
//Login
public int Login(Models.LoginModel model)
{
using (var context = new MusicDBEntities())
{
//bool isValid = context.Users.Any(x=>x.Email == model.Email && x.Pwd == model.Pwd);
bool isUser = context.Users.Any(x => x.Role == "User" && x.Email == model.Email && x.Pwd == model.Pwd);
bool isAdmin = context.Users.Any(x => x.Role == "Admin" && x.Email == model.Email && x.Pwd == model.Pwd);
if (isUser)
{
return(1); // is simple user
}
else if (isAdmin)
{
return(2); // is admin user
}
else
{
return(0); // not valid
}
}
}
public MusicDBEntities Init()
{
return(_dbContext ?? (_dbContext = new MusicDBEntities()));
}
