public virtual void Add(T entity)
{
DetachEntities();
_dbSet.Add(entity); // eq Db.Set<T>().Attach(entity);
_dataContext.Entry(entity).State = EntityState.Added;
_dataContext.SaveChanges();
}
public ActionResult Create([Bind(Include = "ArtistID,ArtistName,Photo")] Artist artist)
{
if (ModelState.IsValid)
{
db.Artists.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}
public ActionResult Create([Bind(Include = "AlbumID,Photo,ReleaseYear,WonAward,BiggestHit,TrackList,ArtistID")] Album album)
{
if (ModelState.IsValid)
{
db.Albums.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", album.ArtistID);
return(View(album));
}
public ActionResult Create([Bind(Include = "AlbumID,AlbumName,Description,ReleaseDate,Photo,TrackList,Grammy,ArtistID")] Album album)
{
if (ModelState.IsValid)
{
db.Albums.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", album.ArtistID);
return(View(album));
}
public ActionResult Create([Bind(Include = "AlbumID,Title,Genre,YearReleased,WonGrammy,AlbumPhoto,ArtistID")] Album album)
{
if (ModelState.IsValid)
{
db.Albums.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "Name", album.ArtistID);
return(View(album));
}
public ActionResult Create([Bind(Exclude = "Id")] Models.Music musicToCreate)
{
if (!ModelState.IsValid)
{
return(View());
}
_db.Musics.Add(musicToCreate);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
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();
}
}
//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"));
}
}
//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();
}
}
}
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);
}
}
//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);
}
}
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);
}
}
