예제 #1
0
        public ActionResult ByCategory(string name, int CategoryID)
        {
            #region Init

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();
            Book helper = new Book();
            #endregion

            #region Get Books By Category

            if (name != null)
            {
                model.BookResults = myHandler.CategoryBookSearch(name);
                model.BCategory = new BookCategory();
                helper = (Book)model.BookResults.Take(1).FirstOrDefault();
                model.BCategory = myHandler.GetBookType(helper.BookCategoryID);

            }
            else if (CategoryID != 0)
            {
                model.BookResults = myHandler.GetBooksByCategory(CategoryID);
                model.BCategory = new BookCategory();
                model.BCategory = myHandler.GetBookType(CategoryID);
            }

            #endregion

            return View(model);
        }
예제 #2
0
        public ActionResult AdminDeviceSearch(FormCollection collection)
        {
            #region Get Search Query

            string query = collection.GetValue("query").AttemptedValue;

            #endregion

            #region Prep Utilities

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();

            #endregion

            #region Execute Search

            model.Query = query;
            model.GadgetResults = myHandler.TechnologyGlobalSearch(query);
            model.GadgetCategoryResults = myHandler.DeviceGlobalSearch(query);
            model.ManufacturerResults = myHandler.ManufacturerGlobalSearch(query);

            #endregion

            return View(model);
        }
예제 #3
0
        public ActionResult AdminBookSearch(FormCollection collection)
        {
            #region Get Search Query

            string query = collection.GetValue("query").AttemptedValue;

            #endregion

            #region Prep Utilities

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();

            #endregion

            #region Execute Search

            model.Query = query;
            model.BookResults = myHandler.BookGlobalSearch(query);
            model.BookCategoryResults = myHandler.BookCategoryGlobalSearch(query);
            model.AuthorResults = myHandler.AuthorGlobalSearch(query);
            model.PublisherResults = myHandler.PublisherGlobalSearch(query);

            #endregion

            return View(model);
        }
예제 #4
0
        public ActionResult Books(int PublisherID)
        {
            #region Prep Utilities
            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();
            #endregion

            #region Get Publisher Books
            model.BookResults = myHandler.GetBooksByPublisher(PublisherID);
            #endregion
            return View(model);
        }
예제 #5
0
        public ActionResult Categories()
        {
            #region Init Categories

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();

            #endregion

            #region Get Categories From db

            model.BookCategoryResults = myHandler.GetBookCategoryList();

            #endregion

            return View(model);
        }
예제 #6
0
        public ActionResult ByCategory(string name, int CategoryID)
        {
            #region Init

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();
            Technology helper = new Technology();
            #endregion

            #region Get Devices By Category

            if (name != null)
            {
                try
                {
                    model.GadgetResults = myHandler.CategoryDeviceSearch(name);
                    model.TCategory = new TechCategory();
                    helper = (Technology)model.GadgetResults.Take(1).FirstOrDefault();
                    model.TCategory = myHandler.GetTechnologyType(helper.TechCategoryID);
                }
                catch
                {
                    model.GadgetResults = myHandler.DevicesByCategory(CategoryID);//Replace
                    model.TCategory = new TechCategory();
                    model.TCategory = myHandler.GetTechnologyType(CategoryID);
                }

            }
            if (CategoryID != 0)
            {
                model.GadgetResults = myHandler.DevicesByCategory(CategoryID);//Replace
                model.TCategory = new TechCategory();
                model.TCategory = myHandler.GetTechnologyType(CategoryID);
            }

            #endregion

            return View(model);
        }
예제 #7
0
        public ActionResult Categories()
        {
            #region Categories Init

            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();

            #endregion

            #region Get Categories From db

            model.GadgetCategoryResults = myHandler.GetTechnologyTypeList();

            #endregion
            return View(model);
        }
예제 #8
0
        public ActionResult BooksAdvanced(Book_Advanced model)
        {
            #region init Search
            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel SModel = new SearchViewModel();
            #endregion

            #region Execute Book Search
            if (model.Author == true)
            {

                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED !
                }
                else if (model.RangeTo != null && model.RangeFrom == null)
                {
                    //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED !
                }
                else if (model.RangeFrom != null && model.RangeTo != null)
                {
                    //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED !
                }
                else
                {
                    //DUE TO MULTIPLE AUTHORS NOT WORKING AS EXPECTED !
                    //SP_AUTHORBOOKSEARCH
                }

            }
            if(model.BookTitle == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.BookTitleFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.BookTitleFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                else if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.BookTitleToQueryBookSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.BookTitleToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                else if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());

                }
                else
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.BookTitleBookSearch("");
                    else
                        SModel.BookResults = myHandler.BookTitleBookSearch(model.Query);
                }
            }
            if (model.Category == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.CategoryFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.CategoryFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                else if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.CategoryToQueryBookSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.CategoryToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                else if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.CategoryBETWEENQueryBookSeach("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.CategoryBETWEENQueryBookSeach(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.CategoryBookSearch("");
                    else
                        SModel.BookResults = myHandler.BookTitleBookSearch(model.Query);
                }
            }
            if(model.ISBN == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.ISBNFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.ISBNFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                else if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.ISBNToQueryBookSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.ISBNToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                else if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.ISBNBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.ISBNBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.ISBNBookSearch("");
                    else
                        SModel.BookResults = myHandler.ISBNBookSearch(model.Query);
                }
            }
            if (model.Publisher == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.PublisherFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.PublisherFromQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                else if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.PublisherToQueryBookSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.PublisherToQueryBookSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                else if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.PublisherBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.BookResults = myHandler.PublisherBETWEENQueryBookSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.BookResults = myHandler.PublisherBookSearch("");
                    else
                        SModel.BookResults = myHandler.PublisherBookSearch(model.Query);
                }
            }
            if (model.RangeFrom != null && model.RangeTo == null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null)
            {
                SModel.BookResults = myHandler.BookTitleFromQueryBookSearch("", model.RangeFrom.GetValueOrDefault());
            }
            if (model.RangeTo != null && model.RangeFrom == null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null)
            {
                SModel.BookResults = myHandler.BookTitleToQueryBookSearch("", model.RangeTo.GetValueOrDefault());
            }
            if (model.RangeFrom != null && model.RangeTo != null && model.ISBN == false && model.Publisher == false && model.Author == false && model.BookTitle == false && model.Category == false && model.Query == null)
            {
                SModel.BookResults = myHandler.BookTitleBETWEENQueryBookSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
            }
            #endregion

            return View(SModel);
        }
예제 #9
0
        public ActionResult Search(FormCollection collect)
        {
            #region Get Search Term
            string query = collect.GetValue("query").AttemptedValue;
            #endregion

            #region init search
            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel result = new SearchViewModel();
            #endregion

            #region execute search
            result.Query = query;
            result.BookResults = myHandler.BookGlobalSearch(query);
            result.BookCategoryResults = myHandler.BookCategoryGlobalSearch(query);
            result.AuthorResults = myHandler.AuthorGlobalSearch(query);
            result.GadgetResults = myHandler.TechnologyGlobalSearch(query);
            result.GadgetCategoryResults = myHandler.DeviceGlobalSearch(query);
            result.ManufacturerResults = myHandler.ManufacturerGlobalSearch(query);
            result.PublisherResults = myHandler.PublisherGlobalSearch(query);
            #endregion

            return View(result);
        }
예제 #10
0
        public ActionResult DevicesAdvanced(Device_Advanced model)
        {
            #region init Search
            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel SModel = new SearchViewModel();
            #endregion

            #region Execute Device Search

            if(model.Category == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.CategoryFromQueryDeviceSeach("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.CategoryFromQueryDeviceSeach(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.CategoryToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.CategoryToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.CategoryBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.CategoryBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.CategoryDeviceSearch("");
                    else
                        SModel.GadgetResults = myHandler.CategoryDeviceSearch(model.Query);
                }
            }
            if (model.Manufacturer == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ManufacturerFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ManufacturerFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ManufacturerToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ManufacturerToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ManufacturerBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ManufacturerBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ManufacturerDeviceSearch("");
                    else
                        SModel.GadgetResults = myHandler.ManufacturerDeviceSearch(model.Query);
                }

            }
            if(model.ModelName == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNameFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNameFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNameToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNameToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNameBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNameBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNameDeviceSearch("");
                    else
                        SModel.GadgetResults = myHandler.ModelNameDeviceSearch(model.Query);
                }

            }
            if(model.ModelNumber == true)
            {
                if (model.RangeFrom != null && model.RangeTo == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault());
                }
                if (model.RangeTo != null && model.RangeFrom == null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch(model.Query, model.RangeTo.GetValueOrDefault());
                }
                if (model.RangeFrom != null && model.RangeTo != null)
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                    else
                        SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch(model.Query, model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
                }
                else
                {
                    if (model.Query == null)
                        SModel.GadgetResults = myHandler.ModelNumberSearch("");
                    else
                        SModel.GadgetResults = myHandler.ModelNumberSearch(model.Query);
                }

            }
            if(model.RangeFrom != null && model.RangeTo == null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null)
            {
                SModel.GadgetResults = myHandler.ModelNumberFromQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault());
            }
            if (model.RangeTo != null && model.RangeFrom == null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null)
            {
                SModel.GadgetResults = myHandler.ModelNumberToQueryDeviceSearch("", model.RangeTo.GetValueOrDefault());
            }
            if (model.RangeFrom != null && model.RangeTo != null && model.ModelNumber == false && model.Manufacturer == false && model.ModelName == false && model.Category == false && model.Query == null)
            {
                SModel.GadgetResults = myHandler.ModelNumberBETWEENQueryDeviceSearch("", model.RangeFrom.GetValueOrDefault(), model.RangeTo.GetValueOrDefault());
            }

            #endregion

            return View(SModel);
        }
예제 #11
0
        public ActionResult Index()
        {
            #region Cart and wishlist actions
            if (User.Identity.IsAuthenticated)
            {
                #region Check iDentity
                if (HttpContext.User.IsInRole("admin"))
                {
                   return  RedirectToAction("Index", "Admin");
                }
                else if (HttpContext.User.IsInRole("supplier"))
                {
                  return  RedirectToAction("Home", "Supplier");
                }
                else if (HttpContext.User.IsInRole("employee"))
                {
                  return  RedirectToAction("Index", "Employee");
                }
                #endregion

                #region Getting cart total
                CartActions act = new CartActions();
                WishlistActions wish = new WishlistActions();
                ApplicationDbContext mycontext = new ApplicationDbContext();
                UserStore<ApplicationUser> myStore = new UserStore<ApplicationUser>(mycontext);
                ApplicationUserManager mgr = new ApplicationUserManager(myStore);
                var thisUser = mgr.FindByNameAsync(User.Identity.Name);
                int cartId = Convert.ToInt32(thisUser.Result.Carts.CartID);
                //
                try
                {
                    double nm = GetCartTotal(cartId); string[] xn = nm.ToString().Split('.'); Session["cartTotal"] = xn[0] + "," + xn[1];
                }
                catch
                { Session["cartTotal"] = (double)GetCartTotal(cartId); }
                Session["wishlistTotal"] = wish.GetWishlistTotal(thisUser.Result.Wishlists.WishlistID);
                #endregion
            }
            else
            { Session["cartTotal"] = "0,00"; Session["wishlistTotal"] = 0; }
            #endregion

            #region Prep utilities
            BusinessLogicHandler myHandler = new BusinessLogicHandler();
            SearchViewModel model = new SearchViewModel();
            #endregion

            #region Get New Books
            model.BookResults = myHandler.GetNewBooks();
            #endregion

            #region Get Devices
            model.GadgetResults = myHandler.GetNewDevices();
            #endregion

            return View(model);
        }