// GET: PricingQuery
        public ActionResult Index()
        {
            PricingQueryModel pricingQuery = new PricingQueryModel();

            pricingQuery.getProducts();

            return(View(pricingQuery));
        }
        public ActionResult Index(PricingQueryModel pricingQuery)
        {
            String ok           = pricingQuery.callProcedure();
            var    body         = "<p>Email From: {0} ({1})</p><p>Query On Products:</p><p>{2}</p>";
            String emailContent = string.Format(body, pricingQuery.Customer.LastName, pricingQuery.Customer.Email, pricingQuery.SelectedProd);
            var    client       = new SmtpClient("smtp.gmail.com", 587)
            {
                Credentials = new NetworkCredential("*****@*****.**", "password"),
                EnableSsl   = true
            };

            client.Send("*****@*****.**", "*****@*****.**", "test", "testbody");


            if (ok == "Ok")
            {
                return(Redirect(Url.Action("Success", "PricingQuery")));
            }
            else
            {
                return(Redirect(Url.Action("Failure", "PricingQuery")));
            }
        }