public ActionResult Activity_Create(Act_pho ap1, HttpPostedFileBase photo) { //將檔案轉成二進位存進資料庫中 var imgSize = photo.ContentLength; byte[] imgByte = new byte[imgSize]; photo.InputStream.Read(imgByte, 0, imgSize); ap1.activity_photo.Activity_photo1 = imgByte; //product.BytesImage = imgByte; //新增到資料庫中 db.Activities.Add(ap1.activity); db.Activity_photo.Add(ap1.activity_photo); db.SaveChanges(); ap1.activity.Activity_Photo_id = ap1.activity_photo.Activity_photo_id; var q = db.Activity_photo.Select(n => n.Activity_photo_id).ToList().LastOrDefault(); var x = db.Activities.Select(c => c.Activity_Photo_id).ToList().LastOrDefault(); x = q; var a = db.Activities.Select(k => k.Activity_no).ToList().LastOrDefault(); var p = db.Activities.Find(a); db.Entry(p).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Activity_Browse")); }
public ActionResult Activity_Create() { ViewBag.Activity_Type = db.Activity_type.ToList(); ViewBag.Activity_Group = db.Service_group.ToList(); ViewBag.Activity_VS = db.Volunteer_supervision.ToList(); Activity ap = new Activity(); Act_pho ap1 = new Act_pho(); return(View(ap1)); }