public string GetUserName(string id) { TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); var query = from c in db.AspNetUsers where c.Id == id select new { c.UserName }; return(query.FirstOrDefault().UserName); }
public ActionResult GetUserNote() { string id = HttpContext.User.Identity.GetUserId(); TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); var query = from c in db.note.AsEnumerable() where c.mid == id select new { c.n_id, c.p_name, c.p_id, c.create_time, c.n_title, c.n_grade, c.mid, videotime = ChangeTime(Convert.ToInt32(c.videotime)), c.n_content }; return(Json(new { data = query.ToList() }, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(OrderViewModel orderView) { if (ModelState.IsValid) { var userId = HttpContext.User.Identity.GetUserId(); var currentCart = Models.Cart.Operation.GetCurrentCart(); List <CartItem> items = currentCart.GetCartItems(); Decimal totalPrice; totalPrice = currentCart.TotalAmount; //0 現金 //1 信用卡 PaymentEntity pe = new PaymentEntity(); int payId; payId = pe.Insert(orderView, userId, totalPrice, 1); BuyItemDetailEntify be = new BuyItemDetailEntify(); Boolean isInserted; isInserted = be.Insert(items, userId, payId); TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); foreach (var item in items) { db.producttbl.Find(item.Id).state += 1; } db.SaveChanges(); //移除購物車Session資料 HttpContext.Session.Remove("Cart"); //轉至訂單完成頁面 return(RedirectToAction("FinishOrdered")); //string msg; //msg=PrintOrderViewContent(orderView); //return Content(msg); } // todo error page return(Content("Error!")); //return View(); }
//[ValidateAntiForgeryToken] public ActionResult SendMsg(string id) { string[] msg = id.Split('/'); discuss model = new discuss(); model.p_id = Convert.ToInt32(msg[0]); model.d_content = msg[1]; var ID = HttpContext.User.Identity.GetUserId(); if (ID == null) { return(RedirectToAction("Login", "Account")); } int pid = Convert.ToInt32(model.p_id); TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); model.Id = ID; // model.d_crateDate =Convert.ToString( DateTime.Now.ToLocalTime()); model.d_crateDate = DateTime.Now.ToShortDateString(); db.discuss.Add(model); db.SaveChanges(); //var query = from c in db.producttbl.AsEnumerable() // where c.pid ==pid // select new TabkeFiveWebApplication.Models.ViewModels.ProductViewModels // { // PId = c.pid, // SelectedKinds =Convert.ToInt32( c.kind), // SelectedCategories = Convert.ToInt32(c.category), // MId = c.mid, // Intro = c.intro, // Price = Convert.ToInt32 (c.price), // State = Convert.ToInt32(c.state), // Score = Convert.ToInt32(c.score) // }; //return RedirectToAction("View", "ShoppingCart", new { id = pid }); //var query = from c in db.discuss // where c.p_id == model.p_id // select c; //return PartialView("_Discuss",query); return(Content(msg[0])); }
public ActionResult GetNoteByID(int nid) { TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); var query = from c in db.note where c.n_id == nid select c; string userid = HttpContext.User.Identity.GetUserId(); if (query.Count() > 0) { ViewBag.edit = query.First().mid == userid ? true:false; return(PartialView("_NoteBook", query)); } else { return(HttpNotFound()); } }
public IEnumerable <DiscussViewModel> Msg(int id) { TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); var query = from c in db.discuss where c.p_id == id orderby c.d_crateDate descending select new DiscussViewModel { DId = c.d_id, PId = c.p_id, MId = c.Id, DContent = c.d_content, DCrateDate = c.d_crateDate, DGreat = c.d_great, DModifyDate = c.d_modifyDate }; return(query); }
public ActionResult Index(int id) { TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities(); var query = from c in db.discuss where c.p_id == id orderby c.d_id descending select new DiscussViewModel { DId = c.d_id, PId = c.p_id, MId = c.Id, DContent = c.d_content, DCrateDate = c.d_crateDate, DGreat = c.d_great, DModifyDate = c.d_modifyDate }; if (query.Count() > 0) { return(PartialView("_Discuss", query)); } else { DiscussViewModel non = new DiscussViewModel(); non.PId = id; return(PartialView("_NonDiscuss", non)); } }