/// <summary> /// Update Song /// </summary> /// <param name="song"></param> /// <returns></returns> public int UpdateSong(Song song) { using (SMLDBEntities context = new SMLDBEntities()) { using (System.Data.Entity.DbContextTransaction transaction = context.Database.BeginTransaction()) { try { SongTable tblSong = context.SongTables.Where(t => t.SongID == song.SongID).FirstOrDefault(); if (tblSong != null && tblSong.SongID > 0) { tblSong.SongID = song.SongID; tblSong.SongName = song.SongName ?? tblSong.SongName; tblSong.Artist = song.Artist ?? tblSong.Artist; tblSong.Lyrics = song.Lyrics ?? tblSong.Lyrics; tblSong.UserId = song.UserId > 0 ? song.UserId : tblSong.UserId; } context.SaveChanges(); transaction.Commit(); song.SongID = tblSong.SongID; return(song.SongID); } catch (Exception) { transaction.Rollback(); return(0); } } } }
/// <summary> /// Save Song /// </summary> /// <param name="song"></param> /// <returns></returns> public int SaveSong(Song song) { using (SMLDBEntities context = new SMLDBEntities()) { using (System.Data.Entity.DbContextTransaction transaction = context.Database.BeginTransaction()) { try { SongTable tblUser = new SongTable() { SongID = song.SongID, SongName = song.SongName, Artist = song.Artist, Lyrics = song.Lyrics, UserId = song.UserId }; context.SongTables.Add(tblUser); context.SaveChanges(); transaction.Commit(); song.SongID = tblUser.SongID; return(song.SongID); } catch (Exception) { transaction.Rollback(); return(0); } } } }
/// <summary> /// Update Users /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateUser(User user) { using (SMLDBEntities context = new SMLDBEntities()) { using (System.Data.Entity.DbContextTransaction transaction = context.Database.BeginTransaction()) { try { UserTable tblUser = context.UserTables.Where(t => t.UserID == user.UserID).FirstOrDefault(); if (tblUser != null && tblUser.UserID > 0) { tblUser.UserID = user.UserID; tblUser.Email = user.Email ?? tblUser.Email; tblUser.Password = user.Password ?? tblUser.Password; tblUser.UserName = user.UserName ?? tblUser.UserName; } context.SaveChanges(); transaction.Commit(); user.UserID = tblUser.UserID; return(user.UserID); } catch (Exception) { transaction.Rollback(); return(0); } } } }
/// <summary> /// Save Users /// </summary> /// <param name="user"></param> /// <returns></returns> public int SaveUser(User user) { using (SMLDBEntities context = new SMLDBEntities()) { using (System.Data.Entity.DbContextTransaction transaction = context.Database.BeginTransaction()) { try { UserTable tblUser = new UserTable() { UserID = user.UserID, Email = user.Email, Password = user.Password, UserName = user.UserName }; context.UserTables.Add(tblUser); context.SaveChanges(); transaction.Commit(); user.UserID = tblUser.UserID; return(user.UserID); } catch (Exception) { transaction.Rollback(); return(0); } } } }
//delete song public void DeleteSong(int SongId) { using (SMLDBEntities dbContext = new SMLDBEntities()) { var singleRec = dbContext.SongTables.FirstOrDefault(x => x.SongID == SongId);// object your want to delete dbContext.SongTables.Remove(singleRec); dbContext.SaveChanges(); } }
public ActionResult Register(BigViewModel obj) { if (ModelState.IsValid) { SMLDBEntities db = new SMLDBEntities(); db.UserTables.Add(obj.UserTable); db.SaveChanges(); } return(RedirectToAction("Index")); }