public ActionResult Create([Bind(Include = "EmployeeID,EmployeeName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,HomePhone,PhotoPath,Extension,Notes,ManagerID,Salary")] Employees employees, HttpPostedFileBase file) { if (file != null) { if (file.ContentLength > 0) { //判斷檔案名稱 // 取得副檔名 string fileType = file.FileName.Split('.').Last().ToUpper(); if (!(fileType.Equals("JPG") || fileType.Equals("PNG") || fileType.Equals("GIF"))) { TempData["Message"] = "只接受jpg,png,gif等圖片類型"; return(View(employees)); } TempData["Message"] = ""; var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/UploadedImages"), fileName); Session["path"] = fileName;//儲存檔案名稱 file.SaveAs(path); } } if (ModelState.IsValid) { employees.PhotoPath = Session["path"].ToString(); db.Employees.Add(employees); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employees)); }
//儲存修改 public ActionResult SaveEdit(int id, string name, string title, string titlec, string bdate, string hdate, string address, string hphone, string ex, string photopath, string notes, int mgid, int salary) { DateTime birthdate = DateTime.Parse(bdate); DateTime hiredate = DateTime.Parse(hdate); using (NorthwindChineseEntities db = new NorthwindChineseEntities()) { Employees e = db.Employees.Find(id); e.EmployeeName = name; e.Title = title; e.TitleOfCourtesy = titlec; e.BirthDate = birthdate; e.HireDate = hiredate; e.Address = address; e.HomePhone = hphone; e.Extension = ex; e.PhotoPath = photopath; e.Notes = notes; e.ManagerID = mgid; e.Salary = salary; db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } return(Json("成功儲存修改")); }
//刪除 public ActionResult Delete(string id) { using (NorthwindChineseEntities db = new NorthwindChineseEntities()) { Employees e = db.Employees.Find(id); db.Employees.Remove(e); db.SaveChanges(); } return(Json("成功刪除")); }
//儲存新增 public ActionResult New(string name, string title, string titlec, string bdate, string hdate, string address, string hphone, string ex, string photopath, string notes, int mgid, int salary) { using (NorthwindChineseEntities db = new NorthwindChineseEntities()) { DateTime birthdate = DateTime.Parse(bdate); DateTime hiredate = DateTime.Parse(hdate); Employees newem = new Employees() { EmployeeName = name, Title = title, TitleOfCourtesy = titlec, BirthDate = birthdate, HireDate = hiredate, Address = address, HomePhone = hphone, Extension = ex, PhotoPath = photopath, Notes = notes, ManagerID = mgid, Salary = salary }; // if (ModelState.IsValid) // { db.Employees.Add(newem); db.SaveChanges(); //} // string birthdate = DateTime.Parse(bdate).ToString("yyyy/MM/dd"); // string hiredate = DateTime.Parse(hdate).ToString("yyyy/MM/dd"); } return(Json("新增成功")); }