public FileResult photo(int id) { TakeFiveDBEntities db = new TakeFiveDBEntities(); var x = db.producttbl.Find(id).picture; return(File(x, "image/jpeg")); }
public ActionResult Edit(int?id) { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); //if (Id == null) //{ // return Content("查無此員工編號"); //} string user = HttpContext.User.Identity.GetUserId(); var query = from c in db.AspNetUsers where c.Id == user select new ApplicationUser { Email = c.Email, phNumber = c.phNumber, Introduction = c.Introduction, Name = c.Name, Pic = c.Pic, Id = c.Id, Birthday = c.Birthday }; //Models.AspNetUsers emp = db.AspNetUsers.Find(UserName); if (query.FirstOrDefault() == null) { return(HttpNotFound()); } return(View(query.FirstOrDefault())); }
public string GetUserName(string id) { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); var query = from c in db.AspNetUsers where c.Id == id select c; return(query.First().Name); }
public string GetProductName(int pid) { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); var query = from c in db.producttbl where c.pid == pid select new { c.name }; return(query.First().name); }
public ActionResult GetUserAllProduct() { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); string userid = HttpContext.User.Identity.GetUserId(); var query = from c in db.buyitemdetailtbl.AsEnumerable() where c.mid == userid select new { c.mid, productname = GetProductName(c.pid), c.state, c.pprice, time = Convert.ToString(c.btime), c.pid }; return(Json(new { data = query.ToList() }, JsonRequestBehavior.AllowGet)); }
public ActionResult FindKor() { TakeFiveDBEntities db = new TakeFiveDBEntities(); var query = from x in db.producttbl.AsEnumerable() where x.category == 3 select x; ViewBag.kindt = query; return(PartialView("_FindkorPartial", query)); }
public ActionResult FindJap() { TakeFiveDBEntities db = new TakeFiveDBEntities(); var aquery = from x in db.producttbl.AsEnumerable() where x.category == 2 select x; ViewBag.kindt = aquery; return(PartialView("_FindjapPartial", aquery)); }
public ActionResult Index() { TakeFiveDBEntities db = new TakeFiveDBEntities(); var aquery = (from x in db.producttbl.AsEnumerable() where x.kind == 2 select x).Take(6); ViewBag.kindt = aquery; var query = (from x in db.producttbl.AsEnumerable() where x.category == 1 select x).Take(6); ViewBag.kind = query; return(View()); }
public string ShowPhoto(string id) { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); var query = from c in db.AspNetUsers where c.Id == id select new { Pic = c.Pic }; byte[] data = query.FirstOrDefault().Pic; string imgSrc = null; if (data != null) { using (MemoryStream ms = new MemoryStream()) { ms.Write(data, 0, data.Length); string imgBase64 = Convert.ToBase64String(ms.ToArray()); imgSrc = string.Format("data:image/jpg;base64,{0}", imgBase64); } } return(imgSrc); }
public ActionResult Edit(ApplicationUser emp) { TFDBLibrary.TakeFiveDBEntities db = new TakeFiveDBEntities(); if (ModelState.IsValid) { if (Request.Files["File1"] != null) { byte[] ImageContent = null; using (BinaryReader br = new BinaryReader(Request.Files["File1"].InputStream)) { ImageContent = br.ReadBytes( Request.Files["File1"].ContentLength); } emp.Pic = ImageContent; } TFDBLibrary.AspNetUsers user = new TFDBLibrary.AspNetUsers { Email = emp.Email, phNumber = emp.phNumber, Introduction = emp.Introduction, Birthday = emp.Birthday, Name = emp.Name, Pic = emp.Pic, Id = emp.Id }; var edituser = db.AspNetUsers.Find(user.Id); edituser.Introduction = user.Introduction; edituser.phNumber = user.phNumber; edituser.Name = user.Name; edituser.Pic = user.Pic; edituser.Birthday = user.Birthday; edituser.Email = user.Email; db.SaveChanges(); return(RedirectToAction("index", "Home")); } return(View(emp)); }