Example #1
0
        public ActionResult PaymentSave(MembershipContactInfoModel model)
        {
            //if (model.GatewayName != "PayPal") {
            //    //ModelState.AddModelError(string.Empty, "Wrong gateway channel, please contact your Administrator.");
            //    return View("Error");
            //}

            ViewBag.ErrorMessage = "";
            if (!model.isContactValid())
            {
                return(RedirectToAction("Index", "Membership"));
            }

            //check if model email exists
            AuthDbContext context    = new AuthDbContext();
            var           usrManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));

            if (usrManager.FindByEmail(model.Email) != null)
            {
                //already a member
                ViewBag.ErrorMessage = "Invalid information, this account already exists, please return and correct the information.";
            }

            if (!model.isContactValid())
            {
                ViewBag.ErrorMessage = "Invalid information, please return and fill out all the required information.";
                return(View(model));
            }

            DBHelper.DBMembership.BufferRegisterContact(ref model);

            return(View(model));
        }
Example #2
0
 public ActionResult ContactInfo(MembershipContactInfoModel model)
 {
     ViewBag.MembershipId    = model.MembershipId;
     ViewBag.MembershipTitle = DBHelper.DBMembership.getMembershipById(model.MembershipId).Title;
     ViewBag.Price           = model.Price;
     return(View(model));
 }
Example #3
0
        /// <summary>
        /// last call when receiving the payment confirmation
        /// when payment returns from the gateway
        /// if session saved before sending the payment is the same with the payment token then transaction ok
        /// go extract information from the database for that payment token
        /// </summary>
        /// <param name="TransactionToken"></param>
        /// <returns></returns>
        public static MembershipContactInfoModel CheckTransactionTokenReturn(string TransactionToken)
        {
            MembershipContactInfoModel model = new MembershipContactInfoModel();

            //if (Session["TransactionToken"] !=null && Session["TransactionToken"].ToString().Equals(TransactionToken))
            //{
            //    model = GetModelByTransactionToken(TransactionToken);
            //}

            model = GetModelByTransactionToken(TransactionToken);

            return(model);
        }
Example #4
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static void BufferRegisterContact(ref MembershipContactInfoModel model)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                if (connection.State != System.Data.ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "BufferRegisterSave";
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddWithValue("@email", model.Email);
                    command.Parameters.AddWithValue("@firstname", model.FirstName);
                    command.Parameters.AddWithValue("@lastname", model.LastName);
                    command.Parameters.AddWithValue("@city", model.City);
                    command.Parameters.AddWithValue("@MembershipId", model.MembershipId);

                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        model.MembershipId          = int.Parse(reader["MembershipId"].ToString());
                        model.MembershipTitle       = reader["MembershipTitle"].ToString();
                        model.MembershipDescription = reader["MembershipDescription"].ToString();
                        model.RoleName = reader["RoleName"].ToString();
                        var    dblPrice  = reader["Price"].ToString();
                        double dblMPrice = 0;
                        double.TryParse(dblPrice, out dblMPrice);
                        model.Price = dblMPrice;

                        model.Email     = reader["Email"].ToString();
                        model.FirstName = reader["FirstName"].ToString();
                        model.LastName  = reader["LastName"].ToString();
                        model.City      = reader["City"].ToString();
                        model.TokenID   = reader["TokenID"].ToString();
                    }


                    if (connection.State == System.Data.ConnectionState.Open)
                    {
                        connection.Close();
                    }

                    //return model.TokenID;
                }
            }
        }
Example #5
0
        public static MembershipContactInfoModel GetModelByTransactionToken(string TransactionToken)
        {
            MembershipContactInfoModel model = new MembershipContactInfoModel();

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                if (connection.State != System.Data.ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "select b.*, m.Title MembershipTitle, m.[Description] MembershipDescription, m.RoleName, m.Price from BufferRegister b left join Membership m on m.MembershipID = b.MembershipId where b.TransactionToken = @TransactionToken";
                    command.Parameters.AddWithValue("@TransactionToken", TransactionToken);
                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        model.TokenID          = reader["TokenID"].ToString();
                        model.Email            = reader["Email"].ToString();
                        model.FirstName        = reader["FirstName"].ToString();
                        model.LastName         = reader["LastName"].ToString();
                        model.City             = reader["City"].ToString();
                        model.TransactionToken = TransactionToken;

                        model.MembershipId          = int.Parse(reader["MembershipId"].ToString());
                        model.MembershipTitle       = reader["MembershipTitle"].ToString();
                        model.MembershipDescription = reader["MembershipDescription"].ToString();
                        model.RoleName = reader["RoleName"].ToString();
                        var    dblPrice  = reader["Price"].ToString();
                        double dblMPrice = 0;
                        double.TryParse(dblPrice, out dblMPrice);
                        model.Price = dblMPrice;
                    }

                    if (connection.State == System.Data.ConnectionState.Open)
                    {
                        connection.Close();
                    }
                }
            }
            return(model);
        }
Example #6
0
        public static void UpdateTransactionToken(MembershipContactInfoModel model)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                if (connection.State != System.Data.ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "update BufferRegister set TransactionToken = @TransactionToken where Email = @Email";
                    command.Parameters.AddWithValue("@Email", model.Email);
                    command.Parameters.AddWithValue("@TransactionToken", model.TransactionToken);
                    command.ExecuteNonQuery();

                    if (connection.State == System.Data.ConnectionState.Open)
                    {
                        connection.Close();
                    }
                }
            }
        }
Example #7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static bool CreateMember(MembershipContactInfoModel model)
        {
            AuthDbContext context = new AuthDbContext();

            var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
            //Here we create a Admin super user who will maintain the website
            var user = new ApplicationUser();

            user.Email    = model.Email;
            user.UserName = user.Email;
            string userPWD = "xyz";
            var    chkUser = UserManager.Create(user, userPWD);

            //if (!roleManager.RoleExists(model.RoleName))

            //Add default User to Role Admin
            if (chkUser.Succeeded)
            {
                var result1 = UserManager.AddToRole(user.Id, model.RoleName);
            }

            return(true);
        }
Example #8
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="model"></param>
        public static void BufferTransfer(MembershipContactInfoModel model)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                if (connection.State != System.Data.ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "BufferTransfer";
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddWithValue("@Email", model.Email);

                    command.ExecuteNonQuery();

                    if (connection.State == System.Data.ConnectionState.Open)
                    {
                        connection.Close();
                    }
                }
            }
        }
Example #9
0
        public ActionResult ContactInfo(int?mid)
        {
            if (mid == null)
            {
                return(RedirectToAction("Index"));
            }
            ViewBag.MembershipId = mid.Value;
            MembershipModel model = DBHelper.DBMembership.getMembershipById(mid.Value);

            ViewBag.MembershipTitle = model.Title;
            ViewBag.Price           = model.Price;

            Gateway modelGateway = DBHelper.DBGateway.getDefaultGateway();

            MembershipContactInfoModel memModel = new MembershipContactInfoModel();

            memModel.MembershipId    = mid.Value;
            memModel.MembershipTitle = model.Title;
            memModel.Price           = model.Price;
            memModel.GatewayId       = modelGateway.GatewayId;
            memModel.GatewayName     = modelGateway.GatewayName;

            return(View(memModel));
        }
Example #10
0
        /// <summary>
        /// Submit Stripe Payment from payment page
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public ActionResult PaymentReceive(MembershipContactInfoModel model)
        {
            try {
                //save token update model
                DBHelper.DBMembership.BufferRegisterContact(ref model);
                DBHelper.DBMembership.UpdateTransactionToken(model);

                string currency = "cad";
                int    amt      = int.Parse(DBHelper.DBMembership.PriceFormat(model.Price * 100));

                var charge = new StripeChargeCreateOptions
                {
                    Amount       = amt,
                    Currency     = currency,
                    ReceiptEmail = model.Email,
                    Description  = model.MembershipTitle,
                    SourceTokenOrExistingSourceId = model.TransactionToken,
                };
                var chargeService = new StripeChargeService();
                var stripeCharge  = chargeService.Create(charge);

                ViewBag.ChargeID        = stripeCharge.Id;
                model.TransactionNumber = stripeCharge.Id;
                model.PayerID           = stripeCharge.Source.Id;
                if (stripeCharge.Paid)
                {
                    DBHelper.DBMembership.ValidateTransaction(model);
                    DBHelper.DBMembership.BufferTransfer(model);
                }
                return(View());
            }
            catch (Exception ex) {
                Console.Write(ex.Message);
                return(View("Error"));
            }
        }
Example #11
0
        /// <summary>
        /// get form submit from ContactInfo
        /// Save information to Buffer
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public ActionResult PaymentSave(MembershipContactInfoModel model)
        {
            if (model.GatewayName != "Stripe")
            {
                ModelState.AddModelError("CustomError", "Error: Wrong gateway channel");
                return(View("Error"));
            }

            try
            {
                ViewBag.ErrorMessage = "";
                if (!model.isContactValid())
                {
                    return(RedirectToAction("Index", "Membership"));
                }

                //check if model email exists
                AuthDbContext context    = new AuthDbContext();
                var           usrManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
                if (usrManager.FindByEmail(model.Email) != null)
                {
                    //already a member
                    ModelState.AddModelError("CustomError", "Error: Invalid information, this account already exists, please return and correct the information.");
                    return(View("Error"));
                }

                //save contact information into Buffer
                DBHelper.DBMembership.BufferRegisterContact(ref model);

                return(View(model));
            }
            catch (Exception ex) {
                ModelState.AddModelError("CustomError", "Error: " + ex.Message);
                return(View("Error"));
            }
        }
Example #12
0
        public ActionResult PaymentSend(MembershipContactInfoModel model)
        {
            //get the information as saved from DB for security purposes
            // example: send the exact amount as indicated in the database, do not use model (model can be changed in browser inspect source etc)
            MembershipContactInfoModel dbModel = DBHelper.DBMembership.GetModelByEmail(model.Email);

            //string returnURL = "https://localhost:44354/PayPal/PaymentReceive";
            //string cancelURL = "https://localhost:44354/PayPal/PaymentCancel";

            string returnURL = "https://huronet.com/PayPal/PaymentReceive";
            string cancelURL = "https://huronet.com/PayPal/PaymentCancel";


            string Your_Test_Merchant_Account_User = "******";
            string Your_Test_Account_Password      = "******";
            string Your_Test_Account_Signature     = "AFcWxV21C7fd0v3bYYYRCpSSRl31Am.wVsyYEVgjySzw5m3Tj9q9KCk5";

            string nameProduct = HttpUtility.UrlEncode(dbModel.MembershipTitle);
            string descProduct = HttpUtility.UrlEncode(dbModel.MembershipDescription);

            double tax = 13 / 100;

            // This are the URLs the PayPal process uses. The endpoint URL is created using the NVP string generated below while the redirect url is where the page the user will navigate to when leaving PayPal plus the PayerID and the token the API returns when the request is made.
            string NVP = string.Empty;

            // API call method: add the desired checkout method. As I've mentioned above, we're using the express checkout.
            NVP += "METHOD=SetExpressCheckout";
            NVP += "&VERSION=123";

            // Credentials identifying you as the merchant
            NVP += "&USER="******"&PWD=" + Your_Test_Account_Password;
            NVP += "&SIGNATURE=" + Your_Test_Account_Signature;

            // Redirect from PayPal portal
            NVP += "&RETURNURL=" + returnURL;   // Return URL from the PayPal portal for completed payment
            NVP += "&CANCELURL=" + cancelURL;   // Return URL from the PayPal portal for a cancelled purchase

            // Payment request information
            NVP += "&PAYMENTREQUEST_0_PAYMENTACTION=Sale";                                                   // Type of transaction
            NVP += "&PAYMENTREQUEST_0_AMT=" + DBHelper.DBMembership.PriceFormat(dbModel.Price * (1 + tax));; // Total payment for the transaction
            NVP += "&PAYMENTREQUEST_0_ITEMAMT=" + DBHelper.DBMembership.PriceFormat(dbModel.Price);;         // Purchased product price
            NVP += "&PAYMENTREQUEST_0_SHIPPINGAMT=0";                                                        // Shipping amount
            NVP += "&PAYMENTREQUEST_0_HANDLINGAMT=0";                                                        // Handling charges
            NVP += "&PAYMENTREQUEST_0_TAXAMT=" + DBHelper.DBMembership.PriceFormat(dbModel.Price * tax);;    // Tax amount

            // Products involved in the transaction
            NVP += "&L_PAYMENTREQUEST_0_NAME0=" + nameProduct;                                     // Product name
            NVP += "&L_PAYMENTREQUEST_0_DESC0=" + descProduct;                                     // Product description
            NVP += "&L_PAYMENTREQUEST_0_AMT0=" + DBHelper.DBMembership.PriceFormat(dbModel.Price); // Product price
            NVP += "&L_PAYMENTREQUEST_0_QTY0=1";                                                   // Product quantity


            System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;


            // Make the API call to the PayPal Service
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(endpoint);

            request.Method        = "POST";
            request.ContentLength = NVP.Length;

            string sResponse = string.Empty;

            using (StreamWriter sw = new StreamWriter(request.GetRequestStream()))
            {
                sw.Write(NVP);
            }

            HttpWebResponse response = (HttpWebResponse)request.GetResponse();

            using (StreamReader sr = new StreamReader(response.GetResponseStream()))
            {
                sResponse = sr.ReadToEnd();
            }

            // Receive the token for the operation and redirect the user to the generated URL for the PayPal portal
            string token = string.Empty;

            string[] splitResponse = sResponse.Split('&');
            if (splitResponse.Length > 0)
            {
                foreach (string responseField in splitResponse)
                {
                    if (responseField.Contains("TOKEN"))
                    {
                        token = responseField.Substring(6);
                        break;
                    }
                }

                if (!string.IsNullOrEmpty(token))
                {
                    //token receiving - payment sent ok
                    model.TransactionToken = HttpUtility.UrlDecode(token);
                    DBHelper.DBMembership.UpdateTransactionToken(model);
                    //seesion is lost after redirect ??!
                    //Session["TransactionToken"] = token;
                    //Session["Payer"] = model;

                    redirectUrl = string.Format(redirectUrl, token);
                    //redirect to paypal website
                    Response.Redirect(redirectUrl);
                }
            }

            // If we get here, something went wrong;
            //lblError.Visible = true;            // Simple error handling :)


            return(View());
        }
Example #13
0
        public ActionResult PaymentReceive(string token, string payerID)
        {
            ViewBag.ErrorMessage = "";
            // First thing's first. We'll need to get the token and payer ID returned from the previous call:
            if (string.IsNullOrEmpty(token) || string.IsNullOrEmpty(payerID))
            {
                ViewBag.ErrorMessage = "Something went wrong, payment didn't go through the gateway.";
                return(View());
            }

            string Your_Test_Merchant_Account_User = "******";
            string Your_Test_Account_Password      = "******";
            string Your_Test_Account_Signature     = "AFcWxV21C7fd0v3bYYYRCpSSRl31Am.wVsyYEVgjySzw5m3Tj9q9KCk5";

            MembershipContactInfoModel model = new MembershipContactInfoModel();

            MembershipContactInfoModel dbModel = DBHelper.DBMembership.GetModelByTransactionToken(token);
            string nameProduct = HttpUtility.UrlEncode(dbModel.MembershipTitle);
            string descProduct = HttpUtility.UrlEncode(dbModel.MembershipDescription);
            double tax         = 13 / 100;

            try
            {
                // Than we add the tokens to string type variables as we'll need to rebuild the NVP string

                // Rebuilding the NVP string for the request; I've hardcoded the payment values again as this sample app does not have a database behind it.
                string NVP = string.Empty;

                NVP += "METHOD=DoExpressCheckoutPayment";
                NVP += "&VERSION=123";

                NVP += "&USER="******"&PWD=" + Your_Test_Account_Password;
                NVP += "&SIGNATURE=" + Your_Test_Account_Signature;

                NVP += "&TOKEN=" + token;
                NVP += "&PAYERID=" + payerID;

                NVP += "&PAYMENTREQUEST_0_PAYMENTACTION=Sale";
                NVP += "&PAYMENTREQUEST_0_AMT=" + DBHelper.DBMembership.PriceFormat(dbModel.Price * (1 + tax));
                NVP += "&PAYMENTREQUEST_0_ITEMAMT=" + DBHelper.DBMembership.PriceFormat(dbModel.Price);
                NVP += "&PAYMENTREQUEST_0_SHIPPINGAMT=0";
                NVP += "&PAYMENTREQUEST_0_HANDLINGAMT=0";
                NVP += "&PAYMENTREQUEST_0_TAXAMT=" + DBHelper.DBMembership.PriceFormat(tax);

                // Making the API call
                string response = APICall(NVP);

                // Interpreting the response from PayPal; As a simple UI for checking the transaction, I'm displaying the transaction ID in the page on success so to make things easier when I'm checking the transaction log in PayPal's web UI.
                if (response.Contains("Success"))
                {
                    string transactionId  = response.Substring(response.IndexOf("PAYMENTINFO_0_TRANSACTIONID"), response.IndexOf("&", response.IndexOf("PAYMENTINFO_0_TRANSACTIONID")) - response.IndexOf("PAYMENTINFO_0_TRANSACTIONID"));
                    string TransactNumber = transactionId.Split('=')[1];
                    ViewBag.PaymentStatus += transactionId;
                    model = DBHelper.DBMembership.CheckTransactionTokenReturn(token);
                    if (model.isContactValid())
                    {
                        model.PayerID           = payerID;
                        model.TransactionNumber = TransactNumber;
                        //update transaction number and payerid to buffer
                        DBHelper.DBMembership.ValidateTransaction(model);
                        //create username
                        DBHelper.DBMembership.CreateMember(model);
                        //transfer Buffer into Contacts and the rest of tables
                        DBHelper.DBMembership.BufferTransfer(model);
                    }
                }
                else
                {
                    //model = (MembershipContactInfoModel)Session["Payer"];
                    ViewBag.ErrorMessage = "Something went wrong, payment didn't go through the gateway.";
                }
            }
            catch (Exception ex) {
                //model = (MembershipContactInfoModel)Session["Payer"];
                ViewBag.ErrorMessage = ex.Message;
            }


            return(View(model));
        }
Example #14
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public ActionResult MembershipPay(MembershipContactInfoModel model)
 {
     return(View());
 }
Example #15
0
 public ActionResult PaymentSend(MembershipContactInfoModel model)
 {
     //
     return(View());
 }