public void ClearCart(int userId, string cartId)
{
var cart = _dbContext.Carts.Where(n => n.CartId == cartId && n.UserId == userId);
foreach (var items in cart)
{
_dbContext.Carts.Remove(items);
}
_dbContext.SaveChanges();
}
public ActionResult Add(User user)
{
if (ModelState.IsValid)
{
db.User.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "Artist_OneTowManyID,Name")] Artist_OneTowMany artist_OneTowMany)
{
if (ModelState.IsValid)
{
db.OneTowMany_tbl_Artists.Add(artist_OneTowMany);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist_OneTowMany));
}
public ActionResult Create([Bind(Include = "AlbumID,Name,ReleaseDate,Rating,IsEnable")] Album album)
{
if (ModelState.IsValid)
{
db.Album.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(album));
}
public ActionResult Create([Bind(Include = "Albam_OneTowManyID,Title,ArtistID")] Albam_OneTowMany albam_OneTowMany)
{
if (ModelState.IsValid)
{
db.OneTowMany_tbl_Albams.Add(albam_OneTowMany);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(albam_OneTowMany));
}
public ActionResult Create([Bind(Include = "ArtistID,Name")] Artist artist)
{
if (ModelState.IsValid)
{
db.Artists.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.ArtistDetails, "ArtistID", "Bio", artist.ArtistID);
return(View(artist));
}
public ActionResult Create([Bind(Include = "ID,AlbumId,AuthorId,CreateDate")] AlbumAuthor albumAuthor)
{
if (ModelState.IsValid)
{
db.AlbumAuthor.Add(albumAuthor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Album, "AlbumID", "Name", albumAuthor.AlbumId);
ViewBag.AuthorId = new SelectList(db.Author, "AuthorID", "Name", albumAuthor.AuthorId);
return(View(albumAuthor));
}
public void Save(AddToCart model)
{
var cartCount = _dbContext.Carts.Where(n => n.UserId == model.UserId && n.CartId == model.CartId).Count() + 1;
var cartModel = new Cart
{
CartId = model.CartId,
AlbumId = model.AlbumId,
Count = cartCount,
DateCreated = System.DateTime.Now,
UserId = model.UserId
};
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
_dbContext.Carts.Add(cartModel);
var updateCart = _dbContext.Carts.Where(n => n.UserId == model.UserId && n.CartId == model.CartId);
foreach (var items in updateCart)
{
items.Count = cartCount;
}
_dbContext.SaveChanges();
tScope.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void Save(AlbumCrud model)
{
var albumEntity = new Album
{
ArtistId = model.ArtistId,
GenreId = model.GenreId,
Title = model.Title,
Price = model.Price,
AlbumArtUrl = model.AlbumArtUrl
};
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
_dbContext.Albums.Add(albumEntity);
_dbContext.SaveChanges();
tScope.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void Save(RegisterUser model)
{
var userModel = new User
{
Firstname = model.Firstname,
Lastname = model.Lastname,
Mobile = model.Mobile,
Email = model.Email,
Password = model.Password,
RoleId = 2
};
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
_dbContext.Users.Add(userModel);
_dbContext.SaveChanges();
tScope.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Author author = db.Author.Find(id);
db.Author.Remove(author);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Artist artist)
{
if (!ModelState.IsValid)
{
return(View(artist));
}
context.Artist.Add(artist);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult AddStudent(Student student)
{
if (student != null)
{
using (MusicStoreDataContext dbContext = new MusicStoreDataContext())
{
dbContext.Student.Add(student);
dbContext.SaveChanges();
return(Json(student, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("Some Error Occured"));
}
}
public string DeleteStudent(int Id)
{
if (Id != 0)
{
using (MusicStoreDataContext dataContext = new MusicStoreDataContext())
{
// int id = Convert.ToInt32(Id);
var lstStud = dataContext.Student.Where(x => x.ID == Id).FirstOrDefault();
dataContext.Student.Remove(lstStud);
dataContext.SaveChanges();
return("Student has been deleted succhessfully.");
}
}
else
{
return(" Oops! Error occered.");
}
}
public string UpdateStudent(Student stu)
{
if (stu != null)
{
using (MusicStoreDataContext dbContext = new MusicStoreDataContext())
{
Student lstStudent = dbContext.Student.Where(x => x.ID == stu.ID).FirstOrDefault();
lstStudent.StudentName = stu.StudentName;
lstStudent.StudentAddress = stu.StudentAddress;
lstStudent.StudentEmail = stu.StudentEmail;
dbContext.SaveChanges();
return("Student Updated");
}
}
else
{
return("Oops! something went wrong.");
}
}
public int Save(SubmitOrder model)
{
int orderId = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
var order = SetOrder(model);
_dbContext.Orders.Add(order);
_cartService.ClearCart(LoginUserInfo.UserId, LoginUserInfo.CartId);
model.OrderId = order.OrderId;
_dbContext.SaveChanges();
tScope.Complete();
}
catch (Exception ex)
{
throw ex;
}
return(orderId);
}
}
public void SaveChanges()
{
context.SaveChanges();
}
