Esempio n. 1
0
        private void fillOrdersGridView()
        {
            try
            {
                String currency = "€";
                if (Request.QueryString["currency"] == null)
                {
                    if (CookieUtil.CookieExists("currency"))
                    {
                        if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                        {
                            currency = "$";
                        }
                    }
                }
                else if (Request.QueryString["currency"].Equals("usd"))
                {
                    currency = "$";
                }

                customerOrders = new OrderService().getOrdersForCustomer(((Customer)Session["user"]));            //Throws NoRecrdException

                DataTable orderTable = new DataTable();
                orderTable.Columns.Add("Ordernumber");
                orderTable.Columns.Add("Status");
                orderTable.Columns.Add("Cost");
                orderTable.Columns.Add("Date");

                foreach (Order item in customerOrders)
                {
                    DataRow orderRow = orderTable.NewRow();
                    orderRow[0] = item.order_id;
                    orderRow[1] = item.orderstatus.name;
                    OrderModel orderModel = new OrderModel();
                    orderRow[2] = currency + " " + setPriceInRightCurrency((float)orderModel.getOrderCost(item), currency);
                    orderRow[3] = item.date.ToString("dd/MM/yyyy");
                    orderTable.Rows.Add(orderRow);
                }

                gvOrders.DataSource = orderTable;
                gvOrders.DataBind();
            }
            catch (NoRecordException)
            {
                lblNoOrders.Visible = true;
            }
        }
        protected void btnPay_Click(object sender, EventArgs e)
        {
            Customer user = (Customer)Session["user"];

            if (user != null)
            {
                try
                {
                    //get the order
                    String orderID = lblStatus.Text;
                    Order  order   = new OrderService().getByID(orderID); //Throws NoRecordException
                    new OrderModel().payOrder(order);                     //Throws NoRecordException || DALException

                    //get the orderLines
                    List <OrderLine> orderLines = new OrderLineService().getByOrder(order);            //Throws NoRecordException
                    //check if all orderLines can be given a dvdCopy
                    Boolean allInStock = hasAllInStock(orderLines);
                    //send the user an order confirmation

                    String currency = "€";
                    if (CookieUtil.CookieExists("currency"))
                    {
                        if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                        {
                            currency = "$";
                        }
                    }

                    new EmailModel().sendOrderConfirmationEmail(user, order, orderLines, allInStock, currency);

                    Response.Redirect("~/ThankYou.aspx");
                }
                catch (NoRecordException)
                {
                }
            }
            else
            {
                lblStatus.Text = "Please log in to access this page";
            }
        }
Esempio n. 3
0
        private void setupCurrencyLinks()
        {
            if (Request.QueryString.Count == 0)
            {
                //No query string exists, create one
                euroLink.HRef   = Request.Url.AbsoluteUri + "?currency=euro";
                dollerLink.HRef = Request.Url.AbsoluteUri + "?currency=usd";
            }
            else
            {
                string              url         = HttpContext.Current.Request.Url.AbsoluteUri;
                string[]            separateURL = url.Split('?');
                NameValueCollection queryString = System.Web.HttpUtility.ParseQueryString(separateURL[1]);
                if (Request.QueryString["currency"] != null)
                {
                    queryString.Remove("currency");
                }
                //Extend the existing querystring
                euroLink.HRef   = separateURL[0] + "?" + queryString.ToString() + "&currency=euro";
                dollerLink.HRef = separateURL[0] + "?" + queryString.ToString() + "&currency=usd";
            }

            //als de querystring het attribut currency bevat (als de gebruiker op één van de twee currencylinks heeft geklikt)
            if (Request.QueryString["currency"] != null)
            {
                //cookie aanmaken/updaten en currencysymbol updaten
                CookieUtil.CreateCookie("currency", Request.QueryString["currency"], 30);
                currencySymbol.Attributes["class"] = "glyphicon glyphicon-" + Request.QueryString["currency"];
            }
            else
            {
                //kijken of de cookie bestaat
                if (CookieUtil.CookieExists("currency"))
                {
                    //currencysymbol aanpassen adhv de waarde in de cookie
                    currencySymbol.Attributes["class"] = "glyphicon glyphicon-" + CookieUtil.GetCookieValue("currency");
                }
            }
        }
Esempio n. 4
0
        /*Displays the details of the selected order.*/
        private void displayOrderDetails(String orderID)
        {
            try
            {
                String currency = "€";
                if (Request.QueryString["currency"] == null)
                {
                    if (CookieUtil.CookieExists("currency"))
                    {
                        if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                        {
                            currency = "$";
                        }
                    }
                }
                else if (Request.QueryString["currency"].Equals("usd"))
                {
                    currency = "$";
                }


                //show details
                pnlOrderDetails.Visible = true;

                //get the order info
                OrderService orderService  = new OrderService();
                Order        selectedOrder = orderService.getByID(orderID);    //Throws NoRecordException


                lblOrderStatus.Text = "(" + selectedOrder.orderstatus.name + ")"; //1 = new, 2 = paid, 3 = shipped
                lblOrderID.Text     = selectedOrder.order_id.ToString();

                //hide pay button if the order has already been paid
                if (selectedOrder.orderstatus.id != 1)
                {
                    lblPay.Visible = false;
                    btnPay.Visible = false;
                }
                else
                {
                    lblPay.Visible = true;
                    btnPay.Visible = true;
                }

                //get all articles in the order and display them
                Order            order      = orderService.getByID(orderID);            //Throws NoRecordException
                List <OrderLine> orderLines = new OrderLineService().getByOrder(order); //Throws NoRecordException

                Boolean hasRentItems = false;

                foreach (OrderLine item in orderLines)
                {
                    if (item.orderLineType.id == 1)
                    {
                        hasRentItems = true;
                    }
                }

                DataTable orderTable = new DataTable();
                orderTable.Columns.Add("Item number");
                orderTable.Columns.Add("Name");
                orderTable.Columns.Add("Type");
                orderTable.Columns.Add("Price");

                if (hasRentItems)
                {
                    orderTable.Columns.Add("Start date");
                    orderTable.Columns.Add("End date");
                }


                foreach (OrderLine item in orderLines)
                {
                    DataRow orderRow = orderTable.NewRow();
                    orderRow[0] = item.orderline_id;
                    orderRow[1] = item.dvdInfo.name;
                    orderRow[2] = item.orderLineType.name;
                    orderRow[3] = currency + " " + setPriceInRightCurrency(item.dvdInfo.buy_price, currency);
                    if (item.orderLineType.name.Equals("Verhuur"))
                    {
                        orderRow[4] = item.startdate.ToString("dd/MM/yyyy");
                        orderRow[5] = item.enddate.ToString("dd/MM/yyyy");
                    }

                    orderTable.Rows.Add(orderRow);
                }


                gvOrderDetails.DataSource = orderTable;
                gvOrderDetails.DataBind();

                //total cost
                OrderModel orderModel = new OrderModel();
                lblTotalCost.Text = currency + " " + setPriceInRightCurrency((float)orderModel.getOrderCost(order), currency);

                //user has already paid, check status of copies in cart
                if (selectedOrder.orderstatus.id > 1)
                {
                    Boolean allInStock = hasAllInStock(orderLines);
                    updateOrderStatusDetails(allInStock);
                }
            }
            catch (NoRecordException)
            {
                //order does not exist, reload the current page to update the gridview and close this order's panel
                Response.Redirect("Orders.aspx");
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            String currency = "€";

            wsCurrencyWebService.CurrencyWebService currencyWebService = new wsCurrencyWebService.CurrencyWebService();

            dvdInfoLink.NavigateUrl  = "~/detail.aspx?id=" + id;
            dvdInfoLink2.NavigateUrl = dvdInfoLink.NavigateUrl;
            imgDvdCover.ImageUrl     = imageUrl;
            if (title.Length <= 40)
            {
                lblTitle.Text = title;
            }
            else
            {
                lblTitle.Text = title.Substring(0, 28) + "...";
            }


            if (Request.QueryString["currency"] == null)
            {
                if (CookieUtil.CookieExists("currency"))
                {
                    switch (CookieUtil.GetCookieValue("currency"))
                    {
                    case "usd":
                        currency   = "$";
                        buy_price  = (float)currencyWebService.convert(buy_price, "usd");
                        rent_price = (float)currencyWebService.convert(rent_price, "usd");
                        break;
                    }
                }
            }
            else
            {
                switch (Request.QueryString["currency"])
                {
                case "usd":
                    currency   = "$";
                    buy_price  = (float)currencyWebService.convert(buy_price, "usd");
                    rent_price = (float)currencyWebService.convert(rent_price, "usd");
                    break;
                }
            }

            //set buy button color and text
            if (AvailabilityModel.isAvailableForBuying(Convert.ToString(id)))
            {
                btnBuyB.Attributes.Add("Class", "btn btn-success price-box");
            }
            else
            {
                btnBuyB.Attributes.Add("Class", "btn btn-warning price-box");
            }
            btnBuyB.InnerText = "Buy " + currency + " " + buy_price;

            //set rent button properties and text
            btnRentB.Attributes.Add("CommandArgument", id);

            DvdInfoService dvdbll = new DvdInfoService();

            try
            {
                DvdInfo         thisDVD = dvdbll.getByID(Convert.ToString(id));                             //Throws NoRecordExample
                List <DateTime> dates   = new AvailabilityModel().getAvailabilities(thisDVD, DateTime.Now); //Throws NoRecordException


                if (dates.Count >= 14)
                {
                    //fully available, green button
                    btnRentB.Attributes.Add("Class", "btn btn-success price-box");
                }
                else if (dates.Count > 0)
                {
                    //available on some days, orange button
                    btnRentB.Attributes.Add("Class", "btn btn-warning price-box");
                }
                else
                {
                    //not available at all, red button
                    btnRentB.Attributes.Add("Class", "btn btn-danger price-box");
                }
            }
            catch (NoRecordException)
            {
            }

            btnRentB.InnerText = "Rent " + currency + " " + rent_price;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                Customer     user         = (Customer)Session["user"];
                OrderService orderService = new OrderService();
                if (user != null)
                {
                    String orderID = Request.QueryString["order"];
                    try
                    {
                        Order order = orderService.getByID(orderID);           //Throws NoRecordException
                        if (order.customer.customer_id == user.customer_id)
                        {
                            String currency = "€";
                            if (Request.QueryString["currency"] == null)
                            {
                                //Check if the user has set the currencypreference
                                if (CookieUtil.CookieExists("currency"))
                                {
                                    if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                                    {
                                        currency = "$";
                                    }
                                }
                            }
                            else
                            {
                                switch (Request.QueryString["currency"])
                                {
                                case "usd":
                                    currency = "$";
                                    break;
                                }
                            }

                            //all good
                            lblStatus.Text = orderID;
                            OrderModel helper = new OrderModel();
                            lblCost.Text = currency + " " + Math.Round(helper.getOrderCost(order), 2).ToString();
                            List <OrderLine> orderLines = new OrderLineService().getByOrder(order);            //Throws NoRecordException

                            Boolean hasRentItems = false;

                            foreach (OrderLine item in orderLines)
                            {
                                if (item.orderLineType.id == 1)
                                {
                                    hasRentItems = true;
                                }
                            }

                            DataTable orderTable = new DataTable();
                            orderTable.Columns.Add("Item number");
                            orderTable.Columns.Add("Name");
                            orderTable.Columns.Add("Type");
                            orderTable.Columns.Add("Price");
                            if (hasRentItems)
                            {
                                orderTable.Columns.Add("Start date");
                                orderTable.Columns.Add("End date");
                            }

                            foreach (OrderLine item in orderLines)
                            {
                                DataRow orderRow = orderTable.NewRow();
                                orderRow[0] = item.orderline_id;
                                orderRow[1] = item.dvdInfo.name;
                                orderRow[2] = item.orderLineType.name;
                                if (item.orderLineType.id == 1)
                                {
                                    double cost = item.dvdInfo.rent_price * (item.enddate - item.startdate).Days;
                                    orderRow[3] = currency + " " + Math.Round(cost, 2);
                                    orderRow[4] = item.startdate.ToString("dd/MM/yyyy");
                                    orderRow[5] = item.enddate.ToString("dd/MM/yyyy");
                                }
                                else
                                {
                                    double cost = item.dvdInfo.buy_price;
                                    orderRow[3] = currency + " " + Math.Round(cost, 2);
                                }

                                orderTable.Rows.Add(orderRow);
                            }

                            //set gridview
                            gvOrderDetails.DataSource = orderTable;
                            gvOrderDetails.DataBind();
                        }
                        else
                        {
                            //this order does not belong to the logged in user, access denied.
                            lblStatus.Text = "Access denied";
                        }
                    }
                    catch (NoRecordException)
                    {
                    }
                }
                else
                {
                    //not logged in, access denied
                    lblStatus.Text = "Please log in to access this page";
                }
            }
        }
        private void setStatistics()
        {
            Customer user = (Customer)Session["user"];

            if (user != null)
            {
                OrderModel orderModel = new OrderModel();
                RentModel  rentModel  = new RentModel();

                lblOrderTotal.Text = "You have purchased " + orderModel.getNumberOfOrderLinesForCustomer(user) + " items ("
                                     + orderModel.getItemsBoughtByCustomer(user).Count + " unique) so far.";

                lblActiveRentCopies.Text = "You are currently renting " + rentModel.getNumberOfActiveRentOrdersCopiesForCustomer(user) + " items:";

                if (rentModel.getNumberOfActiveRentOrdersCopiesForCustomer(user) > 0)
                {
                    List <OrderLine> orderLines = new OrderLineService().getActiveRentOrderLinesByCustomer(user);

                    String currency = "€";
                    if (Request.QueryString["currency"] == null)
                    {
                        if (CookieUtil.CookieExists("currency"))
                        {
                            if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                            {
                                currency = "$";
                            }
                        }
                    }
                    else if (Request.QueryString["currency"].Equals("usd"))
                    {
                        currency = "$";
                    }

                    Boolean hasRentItems = false;

                    foreach (OrderLine item in orderLines)
                    {
                        if (item.orderLineType.id == 1)
                        {
                            hasRentItems = true;
                        }
                    }

                    DataTable orderTable = new DataTable();
                    orderTable.Columns.Add("Item number");
                    orderTable.Columns.Add("Name");
                    orderTable.Columns.Add("Type");
                    orderTable.Columns.Add("Price");

                    if (hasRentItems)
                    {
                        orderTable.Columns.Add("Start date");
                        orderTable.Columns.Add("End date");
                    }

                    foreach (OrderLine item in orderLines)
                    {
                        DataRow orderRow = orderTable.NewRow();
                        orderRow[0] = item.orderline_id;
                        orderRow[1] = item.dvdInfo.name;
                        orderRow[2] = item.orderLineType.name;
                        orderRow[3] = currency + " " + setPriceInRightCurrency(item.dvdInfo.buy_price, currency);
                        orderRow[4] = item.startdate.ToString("dd/MM/yyyy");
                        orderRow[5] = item.enddate.ToString("dd/MM/yyyy");

                        orderTable.Rows.Add(orderRow);
                    }

                    gvActiveRent.DataSource = orderTable;
                    gvActiveRent.DataBind();
                }
            }
        }
Esempio n. 8
0
        private void setupDvdInfo(String id)
        {
            try
            {
                wsCurrencyWebService.CurrencyWebService currencyWebService = new wsCurrencyWebService.CurrencyWebService();
                String currency = "€";

                DvdInfo dvdInfo = new DvdInfoService().getByID(id.ToString());           //Throws NoRecordException

                lblTitle.Text        = dvdInfo.name + " ";
                linkYear.Text        = "(" + dvdInfo.year + ")";
                linkYear.NavigateUrl = "~/Catalog.aspx?year=" + dvdInfo.year;

                linkDirector.Text        = dvdInfo.author;
                linkDirector.NavigateUrl = "~/Catalog.aspx?director=" + dvdInfo.author;

                if (!dvdInfo.actors[0].Equals("")) //even dvd's without actors contain 1 empty string element
                {
                    foreach (String a in dvdInfo.actors)
                    {
                        HyperLink actor = new HyperLink();
                        actor.Text        = a;
                        actor.NavigateUrl = "~/Catalog.aspx?actor=" + a;
                        actorLinks.Controls.Add(actor);
                        Label l = new Label();
                        l.Text = ", ";
                        actorLinks.Controls.Add(l);
                    }
                    int i = actorLinks.Controls.Count;
                    actorLinks.Controls.RemoveAt(i - 1);
                    actorLinks.Controls.Add(new LiteralControl("<br />"));
                }
                else
                {
                    lblActors.Visible = false;
                }

                if (!dvdInfo.duration.Equals(""))
                {
                    lblDuration.Text = dvdInfo.duration + " min";
                }
                else
                {
                    spanRuntime.Visible = false;
                }

                foreach (Genre g in dvdInfo.genres)
                {
                    HyperLink genre = new HyperLink();
                    genre.Text        = g.name;
                    genre.NavigateUrl = "~/Catalog.aspx?genre=" + g.genre_id;

                    genreLinks.Controls.Add(genre);
                    Label l = new Label();
                    l.Text = ", ";
                    genreLinks.Controls.Add(l);
                }
                int j = genreLinks.Controls.Count;
                if (j > 0)
                {
                    genreLinks.Controls.RemoveAt(j - 1);
                }

                lblPlot.Text = dvdInfo.descripion;

                if (Request.QueryString["currency"] == null)
                {
                    if (CookieUtil.CookieExists("currency"))
                    {
                        switch (CookieUtil.GetCookieValue("currency"))
                        {
                        case "usd":
                            currency           = "$";
                            dvdInfo.buy_price  = (float)currencyWebService.convert(dvdInfo.buy_price, "usd");
                            dvdInfo.rent_price = (float)currencyWebService.convert(dvdInfo.rent_price, "usd");
                            break;
                        }
                    }
                }
                else
                {
                    switch (Request.QueryString["currency"])
                    {
                    case "usd":
                        currency           = "$";
                        dvdInfo.buy_price  = (float)currencyWebService.convert(dvdInfo.buy_price, "usd");
                        dvdInfo.rent_price = (float)currencyWebService.convert(dvdInfo.rent_price, "usd");
                        break;
                    }
                }

                if (AvailabilityModel.isAvailableForBuying(Request.QueryString["id"]))
                {
                    lblBuyStatus.Text = "";
                    btnBuyB.Attributes.Add("Class", "btn btn-success");
                }
                else
                {
                    lblBuyStatus.Text = "Item currently out of stock!";
                    btnBuyB.Attributes.Add("Class", "btn btn-warning");
                }

                btnBuyB.InnerText = "Buy " + currency + " " + dvdInfo.buy_price.ToString();
                btnRent1.Text     = "Rent 1 day " + currency + " " + dvdInfo.rent_price.ToString();
                btnRent3.Text     = "Rent 3 days " + currency + " " + (dvdInfo.rent_price * 3).ToString();
                btnRent7.Text     = "Rent 7 days " + currency + " " + (dvdInfo.rent_price * 7).ToString();

                foreach (KeyValuePair <int, String> k in dvdInfo.media)
                {
                    if (k.Key == 1)
                    {
                        imgDvdCoverFocus.ImageUrl = k.Value;
                    }

                    else if (k.Key == 2)
                    {
                        HtmlGenericControl div = new HtmlGenericControl("div");
                        div.Attributes["class"] = "col-xs-3 col-sm-3 col-md-3 col-lg-3 DocumentItem";

                        Image img = new Image();
                        img.ImageUrl = k.Value;
                        div.Controls.Add(img);

                        scrollrow.Controls.Add(div);
                    }
                    else if (k.Key == 3)
                    {
                        HtmlGenericControl div = new HtmlGenericControl("div");
                        div.Attributes["class"] = "col-xs-3 col-sm-3 col-md-3 col-lg-3 DocumentItem";
                        Literal youtube = new Literal();
                        youtube.Text = GetYouTubeScript(k.Value);
                        div.Controls.Add(youtube);
                        scrollrow.Controls.Add(div);
                    }
                }
            }
            catch (NoRecordException)
            {
            }
        }
        private void fillCartGridView()
        {
            try
            {
                List <ShoppingcartItem> cartContent = new ShoppingCartService().getCartContentForCustomer(((Customer)Session["user"]));            //Throws NoRecordException

                Boolean hasRentItems = false;

                double totalCost = 0;

                divCartContent.Visible = true;
                divCartEmpty.Visible   = false;

                foreach (ShoppingcartItem item in cartContent)
                {
                    if (item.dvdCopyType.id == 1)
                    {
                        hasRentItems = true;
                    }
                }

                DataTable cartTable = new DataTable();

                cartTable.Columns.Add("Id");
                cartTable.Columns.Add("Name");
                cartTable.Columns.Add("Amount");
                cartTable.Columns.Add("Price");

                if (hasRentItems)
                {
                    cartTable.Columns.Add("Start date");
                    cartTable.Columns.Add("End date");
                }

                String currency = "€";
                if (Request.QueryString["currency"] == null)
                {
                    if (CookieUtil.CookieExists("currency"))
                    {
                        if (CookieUtil.GetCookieValue("currency").Equals("usd"))
                        {
                            currency = "$";
                        }
                    }
                }
                else if (Request.QueryString["currency"].Equals("usd"))
                {
                    currency = "$";
                }

                foreach (ShoppingcartItem item in cartContent)
                {
                    double  cost    = 0;
                    DataRow cartRow = cartTable.NewRow();
                    cartRow[0] = item.shoppingcart_item_id;
                    cartRow[1] = item.dvdInfo.name;
                    cartRow[2] = 1;
                    cartRow[3] = item.dvdInfo.buy_price;

                    if (item.dvdCopyType.id == 1)
                    {
                        cost       = item.dvdInfo.rent_price * (item.enddate - item.startdate).Days;
                        cartRow[4] = item.startdate.ToString("dd/MM/yyyy");
                        cartRow[5] = item.enddate.ToString("dd/MM/yyyy");
                    }
                    else
                    {
                        cost = item.dvdInfo.buy_price;
                    }
                    cost = setPriceInRightCurrency((float)cost, currency);

                    totalCost += cost;

                    cartRow[3] = currency + " " + Math.Round(cost, 2);

                    cartTable.Rows.Add(cartRow);
                }

                lblTotalCost.Text = currency + " " + Math.Round(totalCost, 2).ToString();

                gvCart.DataSource = cartTable;
                gvCart.DataBind();
            }
            catch (NoRecordException)
            {
                divCartContent.Visible = false;
                divCartEmpty.Visible   = true;
            }
        }