public ActionResult Create([Bind(Include = "CategoryID,CategoryName")] CategoryModel categoryModel) { if (ModelState.IsValid) { db.Categories.Add(categoryModel); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } return(View(categoryModel)); }
public ActionResult Create([Bind(Include = "ActivityID,ProductTitle,Price,StartTime,EndTime,MinBuyers,CurrentBuyers,CategoryID")] ActivityModel activityModel) { if (ModelState.IsValid) { db.Activities.Add(activityModel); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", activityModel.CategoryID); return(View(activityModel)); }
public ActionResult Create(int activityId) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } string actId = activityId.ToString(); var activity = db.Activities.Find(activityId); if (activity == null) { return(PartialView()); } var userName = User.Identity.Name; var orders = db.Orders.Include(o => o.OrderDetails); var order = orders.Where(t => (t.IsFinished == false && t.Username == User.Identity.Name)).FirstOrDefault(); if (order != null && !order.IsValid(actId)) { ModelState.AddModelError("", "同一活动只能参加一次。"); //应该弹窗说明错误。 return(PartialView(order.OrderDetails.Count)); } if (order == null) { order = new OrderModel(); order.Username = userName; order.User = db.Users.Where(t => t.Username == User.Identity.Name).FirstOrDefault(); order.UserID = order.User.UserID.ToString(); order.DateCreated = DateTime.Now; order.IsFinished = false; db.Orders.Add(order); } var orderDetail = new OrderDetailModel { Order = order, OrderID = order.OrderID.ToString(), UnitPrice = activity.Price, ActivityId = actId }; db.OrderDetails.Add(orderDetail); db.SaveChanges(); return(PartialView(order.OrderDetails.Count)); }
public ActionResult Register(RegisterVM model) { if (ModelState.IsValid) { //int userId = (from x in db.Users // where x.Username == user.Username // select x.UserID).SingleOrDefault(); //if (userId > 0){ // // user exists //} //else { // // user does not exist //} var user = db.Users.Where(u => u.Username == model.Username).FirstOrDefault(); if (user == null) { UserModel addUser = new UserModel(); addUser.Username = model.Username; addUser.Password = model.Password; addUser.UserRole = "RegularUser"; db.Users.Add(addUser); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = model.Username + " Successfully Registered."; } else { ModelState.AddModelError("", "Username already exists"); } } return(View()); }
public bool UpdateFundAccount(string userName, decimal balance) { try { var userfund = _userdbset.Include(t => t.FundAccount).Where(t => t.Username == userName).FirstOrDefault(); userfund.FundAccount.Balance = balance; _userdbset.Attach(userfund); _dataContext.Entry(userfund).State = EntityState.Modified; _dataContext.SaveChanges(); return(true); } catch (Exception ex) { } return(false); }