public ActionResult buy_prepaid_cards(string operator_name) { string v = db.pre_cards.Where(r => r.operator_name == operator_name).Select(r => r.pre_number).FirstOrDefault(); //List<double> card_amount = new List<double>(); ViewBag.card_number = v; //remove card number var s = db.pre_cards.Where(r => r.operator_name == operator_name).ToList(); var s1 = s.Where(r => r.pre_number == v).FirstOrDefault(); db.pre_cards.Remove(s1); //deducting wallet money var x = db.userprofiles.Where(r => r.username == User.Identity.Name).FirstOrDefault(); x.wallet_money = x.wallet_money - 400; db.Entry(x).State = EntityState.Modified; //adding transection history transection_final tf = new transection_final(); tf.ammount = 400; tf.send_to = v; tf.sent_date = DateTime.Now; tf.status = "Prepaid card"; tf.username = User.Identity.Name; db.transection_finals.Add(tf); db.SaveChanges(); db.SaveChanges(); return PartialView("buy_prepaid_cards1"); }
public ActionResult Thank_You_post() { if (Request.IsAuthenticated) { string s = User.Identity.Name; //checking deposit in wallet teporary folder var x = db.wallet_deposit_temp.Where(r => r.username == s).FirstOrDefault(); if (!string.IsNullOrEmpty(x.username)) { //var x1 = x.ToArray(); user_deposit_history udh = new user_deposit_history(); udh.username = s; udh.deposit_status = "Approved"; udh.deposit_date = x.deposit_date; udh.deposit_ammount = x.deposit_ammount; db.wallet_deposit_temp.Remove(x); db.deposit_history.Add(udh); //updating user wallet money var p = db.userprofiles.Where(r => r.username == s).FirstOrDefault(); p.wallet_money = p.wallet_money + x.deposit_ammount; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("myprofile", "Home"); } //updating instant refill history transection_final tf = new transection_final(); var y = db.refil_history.Where(r => r.username == s).FirstOrDefault(); tf.username = y.username; tf.status = y.status; tf.sent_date = y.sent_date; tf.send_to = y.send_to; tf.ammount = y.ammount; db.transection_finals.Add(tf); db.refil_history.Remove(y); db.SaveChanges(); } else { /*string s = "UnknowN"; //updating instant refill history transection_final tf = new transection_final(); //var y = db.refil_history.Where(r => r.username == s).FirstOrDefault(); tf.username = s; tf.status = "Pending"; tf.sent_date = DateTime.Now; tf.send_to = "Instant recharge"; tf.ammount = 0; db.transection_finals.Add(tf); //db.refil_history.Remove(y); db.SaveChanges();*/ return RedirectToAction("myprofile", "Home"); } return RedirectToAction("Index", "Home"); }
public ActionResult refill_by_wallet_bangla(Transection tr) { if (ModelState.IsValid) { //updating wallet money info var x = db.userprofiles.Where(r => r.username == tr.username).FirstOrDefault(); x.wallet_money = x.wallet_money - tr.transection_ammount; db.Entry(x).State = EntityState.Modified; db.SaveChanges(); //updating refill history transection_final tf = new transection_final(); //User_refill_history r_h = new User_refill_history(); tf.ammount = tr.transection_ammount; tf.send_to = tr.mo_number; tf.sent_date = tr.transection_date; tf.status = "Pending"; tf.username = tr.username; db.transection_finals.Add(tf); db.SaveChanges(); //send mail MailMessage message = new MailMessage(); var fromAddress = "*****@*****.**"; var toAddress = "*****@*****.**"; const string fromPassword = "******"; string subject = "Wallet refill-bangla"; string body = string.Format("{0} has sent {1} to {2}", User.Identity.Name, tr.transection_ammount, tr.mo_number); SmtpClient smtp = new SmtpClient { Host = "mail.paymobd.com", Port = 587, EnableSsl = false, Credentials = new NetworkCredential(fromAddress, fromPassword) }; smtp.Send(fromAddress, toAddress, subject, body); Thread.Sleep(2000); return RedirectToAction("order_confirm_bangla"); } else { ModelState.AddModelError(" ", "Please provide valid data"); } return PartialView(tr); }
public ActionResult refill_by_wallet(Transection tr) { if (ModelState.IsValid) { //updating wallet money info var x = db.userprofiles.Where(r => r.username == tr.username).FirstOrDefault(); x.wallet_money = x.wallet_money - tr.transection_ammount; db.Entry(x).State = EntityState.Modified; db.SaveChanges(); //updating refill history transection_final tf = new transection_final(); //User_refill_history r_h = new User_refill_history(); tf.ammount = tr.transection_ammount; tf.send_to = tr.mo_number; tf.sent_date = tr.transection_date; tf.status = "Pending"; tf.username = tr.username; db.transection_finals.Add(tf); db.SaveChanges(); return RedirectToAction("myprofile"); } else { ModelState.AddModelError(" ", "Please provide valid data"); } return PartialView(tr); }