// GET: Carts
public ActionResult Index()
{
if (TempData["AmountMessage"] != null)
{
ViewBag.errorAmount = TempData["AmountMessage"].ToString();
}
string loggedId = CookieController.GetCookie("userId");
var carts = db.Carts.SqlQuery("Select * from dbo.Carts where dbo.Carts.UserId = {0}", loggedId);
if (loggedId != null)
{
setValueToCurrentUser(loggedId);
Console.WriteLine("user is logged - " + loggedId);
return(View(carts.ToList()));
}
else
{
return(RedirectToAction("Index", "Login"));
}
/*
* ViewBag.itemsTotalValue = 100;
* ViewBag.itemsTotalDifferentProducts = 5;
* ViewBag.cartOwner = "idan";
* */
}
void Start()
{
animator = img.GetComponent <Animator>();
img.enabled = false;
isImgOn = false;
cc = CookieController.singleton;
sp = FindObjectsOfType <Spawner>();
st = FindObjectsOfType <SpikeTrap>();
}
public ActionResult Logout()
{
if (ModelState.IsValid)
{
Tuple <bool, string> tuple = CookieController.RemoveCookie("userId");
TempData["Success"] = "User was logged out successfully.";
return(RedirectToAction("Index", "Home"));
}
return(View("Index"));
}
public ActionResult BuyMovie(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string userId = CookieController.GetCookie("userId");
CartsController.addNewCartToDB(Int32.Parse(userId), id.Value);
return(RedirectToAction("Index"));
}
// GET: History
public ActionResult Index()
{
var loggedUserId = CookieController.GetCookie("userId");
if (loggedUserId != null)
{
var orders = from order in db.Orders
where order.UserId.ToString().Equals(loggedUserId)
select order;
return(View(orders));
}
return(View(new List <Order>()));
}
public ActionResult ConfirmTransaction(FormCollection fl)
{
string userLoggedIn = CookieController.GetCookie("userId");
double totalOrderValue = 0;
Order o = new Order()
{
Date = DateTime.Now,
UserId = Convert.ToInt32(userLoggedIn),
};
db.Orders.Add(o);
db.SaveChanges();
if (ModelState.IsValid)
{
//now to reduce all items from database
IList <Cart> carts = (IList <Cart>)db.Carts.SqlQuery("Select * from dbo.Carts where dbo.Carts.UserId = {0}", userLoggedIn).ToList();
foreach (Cart c in carts)
{
//we need to update MovieOrders,Orders,Cart,Movies
//first lets remove from Movies.
db.Database.ExecuteSqlCommand("UPDATE dbo.Movies SET Amount = Amount- {0} WHERE MovieId = {1}", c.Count, c.MovieId);
var currMoviePrice = db.Movies.SqlQuery("Select * from dbo.Movies where dbo.Movies.MovieId = {0}", c.MovieId).ToList();
totalOrderValue += c.Count * currMoviePrice[0].Price;
//now we create new movieOrder for each cart
MovieOrder mo = new MovieOrder()
{
OrderId = o.OrderId,
Amount = c.Count,
MovieId = c.MovieId
};
db.MovieOrders.Add(mo);
//now we remove the cart.
db.Carts.Remove(c);
//now we add to orders
//now we add remove from Cart
}
db.Database.ExecuteSqlCommand("UPDATE dbo.Orders SET TotalAmountValue = TotalAmountValue + {0} WHERE OrderId = {1}", totalOrderValue, o.OrderId);
db.SaveChanges();
ViewBag.orderId = o.OrderId;
}
HttpContext.Application["date"] = null;
HttpContext.Application["tempdate"] = null;
HttpContext.Application["cameFromSet"] = null;
return(RedirectToAction("Index", "Home"));
}
public ActionResult Create(/*[Bind(Include = "CartId,UserId,MovieId,Count")]*/ Cart cart)
{
if (cart.Count > db.Movies.Find(cart.MovieId).Amount)
{
string Error = String.Format("The amount in the storage for {0} is not avaiable", Data.getInstance().getDictionary()[cart.MovieId]);
TempData["AmountMessage"] = Error;
return(RedirectToAction("Create"));
}
//string userLoggedIn =CookieController.GetCookie("userId");
string userLoggedIn = CookieController.GetCookie("userId");
if (userLoggedIn != null)
{
cart.UserId = Convert.ToInt32(userLoggedIn);
cart.Movie = db.Movies.Find(cart.MovieId);
cart.User = db.Users.Find(cart.UserId);
if (ModelState.IsValid)
{
//first we check if item already in the cart, if yes we just want
//to add to quantity
bool isMovieInCart = db.Carts.SqlQuery("Select * from dbo.Carts where dbo.Carts.MovieId = {0} and dbo.Carts.UserId = {1}", cart.MovieId, userLoggedIn).ToList().Count > 0;
//meaning the movie for the user is already in the cart, we want to increase amount.
if (isMovieInCart)
{
var carts = db.Carts.SqlQuery("Select * from dbo.Carts where dbo.Carts.MovieId = {0} and dbo.Carts.UserId = {1}", cart.MovieId, userLoggedIn);
cart.CartId = carts.ToList()[0].CartId;
string command = String.Format("UPDATE dbo.Carts SET Count = Count + {0} WHERE CartId = {1}", cart.Count.ToString(), cart.CartId);
db.Database.ExecuteSqlCommand(command);
db.SaveChanges();
}
else
{
db.Carts.Add(cart);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
ViewBag.MovieId = new SelectList(db.Movies, "MovieId", "Title", cart.MovieId);
// ViewBag.UserId = new SelectList(db.Users, "UserId", "UserName", cart.UserId);
return(View(cart));
}
public ActionResult Index(Login logUser)
{
if (ModelState.IsValid)
{
var queryResults = db.Users.Where(a => a.UserName.Equals(logUser.UserName) && a.Password.Equals(logUser.UserPassword)).ToList();
if (queryResults.Count == 1)
{
var loggedUser = queryResults[0];
CookieController.SetCookie("userId", loggedUser.UserId.ToString());
TempData["Success"] = "User was logged successfully.";
ViewBag.loggedin = loggedUser.ToString();
return(RedirectToAction("Index", "Home"));
}
}
ViewData["Error"] = "One or more cradentials do not match.";
return(View("Index"));
}
// Initialization
void Awake()
{
// Check existing Cookie
if (singleton == null)
{
singleton = this;
}
else
{
Destroy(gameObject);
}
inputDown[0] = false;
inputDown[1] = false;
inputDown[2] = false;
inputDown[3] = false;
}
// GET: Home
public ActionResult Index()
{
string loggedId = CookieController.GetCookie("userId");
if (loggedId != null)
{
Console.WriteLine("user is logged - " + loggedId);
}
List <Movie> top5 = getMovieList("TopFivePopular");
List <Movie> recMovies = getMovieList("TopRecent");
/*
* TwoListViewModel TwoListViewModel = new TwoListViewModel
* {
* Recent = recMovies,
* TopFive = top5
* };
*/
return(View(new Tuple <IEnumerable <Movie>, IEnumerable <Movie> >(top5, recMovies)));
}
public AuthorizationController(IHttpClientFactory httpContextFactory, CookieController httpContextCookieController)
{
_httpContextFactory = httpContextFactory;
_httpContextCookieController = httpContextCookieController;
}
public ActionResult PaymentHandler()
{
if (HttpContext.Application["date"] != null)
{
ViewBag.WorkDate = HttpContext.Application["date"];
ViewBag.validDate = HttpContext.Application["date"];
}
else if (HttpContext.Application["tempdate"] != null)
{
ViewBag.WorkDate = HttpContext.Application["tempdate"];
}
else
{
ViewBag.WorkDate = DateTime.Now;
}
if (TempData["error"] != null)
{
ViewBag.DateError = TempData["error"];
}
ViewBag.Date = DateTime.Now.ToString();
ViewBag.itemsTotalValue = 0;
ViewBag.itemsTotalDifferentProducts = 0;
ViewBag.cartOwner = "";
double itemsValue = 0;
int differentProducts = 0;
User userAccount = null;
string userLoggedIn = CookieController.GetCookie("userId");
//first we need the user that is logged in
if (ModelState.IsValid)
{
var carts = db.Carts.SqlQuery("Select * from dbo.Carts where dbo.Carts.UserId = {0}", userLoggedIn);
//take all users cart by user Id
foreach (Cart c in carts)
{
differentProducts++;
var currMoviePrice = db.Movies.SqlQuery("Select * from dbo.Movies where dbo.Movies.MovieId = {0}", c.MovieId).ToList();
itemsValue += c.Count * currMoviePrice[0].Price;
}
ViewBag.itemsTotalValue = itemsValue;
ViewBag.itemsTotalDifferentProducts = differentProducts;
int UserId = Convert.ToInt32(userLoggedIn);
userAccount = db.Users.Find(UserId);
ViewBag.cartOwner = db.Users.Find(UserId).UserName;
//first last mail cell address
ViewBag.first = userAccount.FirstName;
ViewBag.last = userAccount.LastName;
ViewBag.mail = userAccount.Email;
if (userAccount.Cellular == null)
{
ViewBag.cell = "Wasn't Provide";
}
else
{
ViewBag.cell = userAccount.Cellular;
}
if (userAccount.Address == null)
{
ViewBag.address = "Wasn't Provide";
}
else
{
ViewBag.address = userAccount.Address;
}
}
return(View());
}
public void TestInitialize()
{
_controller = new CookieController();
}
public WebServiceBase(IHttpClientFactory httpClient, IHttpContextAccessor contextFactory, CookieController httpContextCookieController)
{
_httpClientFactory = httpClient;
_contextFactory = contextFactory;
_httpContextCookieController = httpContextCookieController;
}
private List <Movie> getRecommendedMovies()
{
List <Movie> solutionList = new List <Movie>();
//Dictionary<userId,amount> of match movies//
Dictionary <int, int> ratedMoviesForUser = new Dictionary <int, int>();
Dictionary <string, int> finalPrefferedMovie = new Dictionary <string, int>();
string userLoggedIn = CookieController.GetCookie("userId");
if (userLoggedIn != null)
{
var userOrders = db.Orders.SqlQuery("Select * from dbo.Orders where dbo.Orders.UserId = {0}", Convert.ToInt32(userLoggedIn));
foreach (Order o in userOrders)
{
//foreach movie order we want to find the clients the bought the movie
//if theres a match we add to dictionary
var MovieOrdersForUser = db.MovieOrders.SqlQuery("Select * from dbo.MovieOrders where dbo.MovieOrders.OrderId = {0}", o.OrderId);
//now we add to dictionary if there is a match
foreach (MovieOrder mo in MovieOrdersForUser)
{
//now we get all users for each movieId
var userOrdersForSpecificMovie = db.MovieOrders.SqlQuery("select * from dbo.MovieOrders where dbo.MovieOrders.MovieId = {0}", mo.MovieId);
foreach (MovieOrder usersMatchForMovie in userOrdersForSpecificMovie)
{
var order = db.Orders.SqlQuery("select * from dbo.Orders where dbo.Orders.OrderId = {0}", usersMatchForMovie.OrderId).ToList()[0];
int userId = order.UserId;
if (order.UserId != o.UserId)
{
if (!ratedMoviesForUser.ContainsKey(userId))
{
ratedMoviesForUser.Add(userId, 1);
}
else
{
ratedMoviesForUser[userId]++;
}
}
}
}
}
//now we want to sort the dictionary by matches
List <KeyValuePair <int, int> > myList = ratedMoviesForUser.ToList();
myList.Sort(
delegate(KeyValuePair <int, int> pair1,
KeyValuePair <int, int> pair2)
{
return(pair2.Value.CompareTo(pair1.Value));
}
);
//now we have sort list, need to return the top 5.
foreach (KeyValuePair <int, int> user in myList)
{
//we get all order of the person
//and foreach order we go on all the movies
var allUserOrders = db.Orders.SqlQuery("select * from dbo.orders where UserId = {0}", user.Key);
foreach (Order order in allUserOrders)
{
//get all the movie orders for a specific order
var movieOrdersForUser = db.MovieOrders.SqlQuery("select * from dbo.MovieOrders where dbo.MovieOrders.OrderId = {0}", order.OrderId);
foreach (MovieOrder mo in movieOrdersForUser)
{
if (Data.getInstance().getDictionary().ContainsKey(mo.MovieId))
{
string movieName = Data.getInstance().getDictionary()[mo.MovieId];
if (finalPrefferedMovie.ContainsKey(movieName))
{
finalPrefferedMovie[movieName]++;
}
else
{
finalPrefferedMovie.Add(movieName, 1);
}
}
}
}
}
//now we have all the movies and all the matches from all users
//we need to sort by value
List <KeyValuePair <string, int> > myFinalList = finalPrefferedMovie.ToList();
//the list that we suppose to return
solutionList = new List <Movie>();
myFinalList.Sort(
delegate(KeyValuePair <string, int> pair1,
KeyValuePair <string, int> pair2)
{
return(pair2.Value.CompareTo(pair1.Value));
}
);
//we need the best 5
int counter = 1;
foreach (KeyValuePair <string, int> tuple in myFinalList)
{
if (counter == 5)
{
break;
}
Movie m = db.Movies.SqlQuery("select * from dbo.Movies where dbo.Movies.Title = {0}", tuple.Key).ToList()[0];
solutionList.Add(m);
counter++;
}
solutionList = FillListWithPopularMovies(solutionList);
}
else
{
solutionList = FillListWithPopularMovies(solutionList);
}
return(solutionList);
}
public CategoriesService(IHttpClientFactory httpClient, IHttpContextAccessor contextFactory, CookieController httpContextCookieController) :
base(httpClient, contextFactory, httpContextCookieController)
{
Categories = null;
}
public ServerControllerService(IHttpClientFactory httpClient, IHttpContextAccessor contextFactory, CookieController httpContextCookieController) :
base(httpClient, contextFactory, httpContextCookieController)
{
}
public void TestCleanup()
{
_controller = null;
}
