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));
}
