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