public ActionResult wallet_refill(Transection tr)
        {
            if (ModelState.IsValid)
            {
                var v = db.wallet_deposit_temp.Where(r => r.username == tr.username).ToList();
                if (v.Count() > 0)
                {
                    var v1 = v.ToArray();
                    //wallet_deposit_temp wdt = new wallet_deposit_temp();
                    v1[0].deposit_ammount = tr.transection_ammount;
                    //wdt.deposit_ammount = tr.transection_ammount;
                    db.Entry(v1[0]).State = EntityState.Modified;
                    db.SaveChanges();
                    string url   = paypal_wallet.paypal_wallet_pay(tr);
                    string email = db.userprofiles.
                                   Where(r => r.username == User.Identity.Name).Select(r => r.e_mail).FirstOrDefault();
                    url += "&email=" + email;
                    Response.Redirect(url);

                    //return RedirectToAction("Thank_You");
                }
                else
                {
                    wallet_deposit_temp wdt = new wallet_deposit_temp();
                    wdt.username        = tr.username;
                    wdt.deposit_date    = tr.transection_date;
                    wdt.deposit_ammount = tr.transection_ammount;
                    db.wallet_deposit_temp.Add(wdt);
                    db.SaveChanges();
                    string url   = paypal_wallet.paypal_wallet_pay(tr);
                    string email = db.userprofiles.
                                   Where(r => r.username == User.Identity.Name).Select(r => r.e_mail).FirstOrDefault();
                    url += "&email=" + email;
                    Response.Redirect(url);

                    //return RedirectToAction("Thank_You");
                }

                /*user_deposit_history udh = new user_deposit_history();
                 * udh.username = tr.username;
                 * udh.deposit_date = tr.transection_date;
                 * udh.deposit_ammount = tr.transection_ammount;
                 * udh.deposit_status = "Approved";
                 * db.deposit_history.Add(udh);
                 *
                 * var d = db.userprofiles
                 *  .Where(r => r.username == tr.username).FirstOrDefault();
                 * d.wallet_money = d.wallet_money + udh.deposit_ammount;
                 * db.Entry(d).State = EntityState.Modified;*/
                //db.SaveChanges();
                //string url = paypal_wallet.paypal_wallet_pay(tr);
                //Response.Redirect(url);
                //return RedirectToAction("Thank_You");
            }
            else
            {
                ModelState.AddModelError(" ", "Please provide valid data");
            }
            return(PartialView(tr));
        }
        public ActionResult wallet_refill(Transection tr)
        {
            if (ModelState.IsValid)
            {
                var z = db.refil_history.ToList();
                if (z.Count() > 0)
                {
                    foreach (var i1 in z)
                    {
                        db.refil_history.Remove(i1);
                    }
                }
                var v = db.wallet_deposit_temp.Where(r => r.username == tr.username).ToList();
                if (v.Count() > 0)
                {
                    var v1 = v.ToArray();
                    v1[0].deposit_ammount = tr.transection_ammount;
                    db.Entry(v1[0]).State = EntityState.Modified;
                    db.SaveChanges();
                    string url   = paypal_wallet.paypal_wallet_pay(tr);
                    string email = db.userprofiles.
                                   Where(r => r.username == User.Identity.Name).Select(r => r.e_mail).FirstOrDefault();
                    url += "&email=" + email;
                    Response.Redirect(url);

                    //return RedirectToAction("Thank_You");
                }
                else
                {
                    wallet_deposit_temp wdt = new wallet_deposit_temp();
                    wdt.username        = tr.username;
                    wdt.deposit_date    = tr.transection_date;
                    wdt.deposit_ammount = tr.transection_ammount;
                    db.wallet_deposit_temp.Add(wdt);
                    db.SaveChanges();
                    string url   = paypal_wallet.paypal_wallet_pay(tr);
                    string email = db.userprofiles.
                                   Where(r => r.username == User.Identity.Name).Select(r => r.e_mail).FirstOrDefault();
                    url += "&email=" + email;
                    Response.Redirect(url);

                    //return RedirectToAction("Thank_You");
                }
            }
            else
            {
                ModelState.AddModelError(" ", "Please provide valid data");
            }
            return(PartialView(tr));
        }