public static void addNewCartToDB(int userId, int movieId)
{
var db = new MovieStoreEntities();
Cart newCart = new Cart {
UserId = userId, MovieId = movieId, Count = 1
};
var currCart = db.Carts.SqlQuery("select * from carts where dbo.Carts.UserId = {0} and dbo.Carts.MovieId = {1}", userId, movieId);
if (currCart.ToList().Count > 0)
{
//meaning its already exist
db.Database.ExecuteSqlCommand("UPDATE dbo.Carts SET Count = Count+1 WHERE dbo.Carts.UserId = {0} and dbo.Carts.MovieId = {1} ", userId, movieId);
}
else
{
//meaning its a new cart.
db.Carts.Add(newCart);
}
db.SaveChangesAsync();
}
public Repository(MovieStoreEntities db)
{
_db = db;
}
public UnitOfWork()
{
db = new MovieStoreEntities();
}
public DbUser()
{
_db = new MovieStoreEntities();
}
public DbRent()
{
_db = new MovieStoreEntities();
}
public DbReview()
{
db = new MovieStoreEntities();
}
