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