public PartialViewResult RemoveEducation(int id) { var edu = new Models.Education() { ID = id }; var tblEdu = new TblEducation(); tblEdu.Delete(edu); return PartialView("_PartialEducation", tblEdu.GetAll()); }
public PartialViewResult UpdateEducation(Models.Education e) { var edu = new Models.Education() { ID = e.ID, University = HttpUtility.UrlDecode(e.University), Faculty = HttpUtility.UrlDecode(e.Faculty), Department = HttpUtility.UrlDecode(e.Department), Date = HttpUtility.UrlDecode(e.Date) }; var tblEdu = new TblEducation(); tblEdu.Update(edu); return PartialView("_PartialEducation", tblEdu.GetAll()); }
public ActionResult DeleteConfirmed(Guid id, List <Guid> ids) { if (Session["Login"] == null) { return(RedirectToAction("Index", "Login")); } foreach (var eduid in ids) { Models.Education edu = db.Educations.Find(eduid); db.Educations.Remove(edu); db.SaveChanges(); } //foreach (var eduEdit in employeeViewModel.Educations) //{ // Models.Education edus = db.Educations.Find(Guid.Parse(eduEdit.EducationId)); // var schoolname = eduEdit.SchoolName; // var department = eduEdit.Department; // var dgreee = eduEdit.Drgree; // var sdate = eduEdit.StartDate; // var enddate = eduEdit.EndDate; // //Models.Education eduss = new Models.Education(); // //edus.EducationId = Guid.NewGuid(); // //edus.SchoolName = schoolname; // //edus.Department = department; // //edus.Degree = dgreee; // //edus.StartDate = DateTime.Parse(sdate); // //edus.EndDate = DateTime.Parse(enddate); // //edus.EmployeeId = employee.EmployeeId; // //db.Educations.Add(edus); // db.Educations.Remove(edus); // db.SaveChanges(); //} Employee employee = db.Employees.Find(id); db.Employees.Remove(employee); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(EmployeeViewModel employeeViewModel, HttpPostedFileBase PhotoPath) { //if (Session["Login"] == null) //{ // return RedirectToAction("Index", "Login"); //} if (ModelState.IsValid) { string strPath = ""; string newfilename = ""; if (PhotoPath != null) { int startindex = PhotoPath.ContentType.LastIndexOf('/') + 1; string filetype = PhotoPath.ContentType.Substring(startindex); //取得副檔名 newfilename = Guid.NewGuid() + "." + filetype; strPath = Request.PhysicalApplicationPath + @"images\Employees\" + newfilename; PhotoPath.SaveAs(strPath); } // Address Address address = new Address(); address.AddressId = Guid.NewGuid(); address.CityId = Guid.Parse(employeeViewModel.CitySelectedValue); address.DistrictId = Guid.Parse(employeeViewModel.DistrictSelectedValue); address.AddressLine = employeeViewModel.AddressLine; db.Addresses.Add(address); db.SaveChanges(); //Residential Address Address ResidentialAddress = new Address(); ResidentialAddress.AddressId = Guid.NewGuid(); ResidentialAddress.CityId = Guid.Parse(employeeViewModel.ResidentialCitySelectedValue); ResidentialAddress.DistrictId = Guid.Parse(employeeViewModel.ResidentialDistrictSelectedValue); ResidentialAddress.AddressLine = employeeViewModel.ResidentialAddressLine; db.Addresses.Add(ResidentialAddress); db.SaveChanges(); //Employee Employee emp = new Employee(); emp.EmployeeId = Guid.NewGuid(); emp.EmployeeName = employeeViewModel.EmployeeName; emp.EmployeeNameEn = employeeViewModel.EmployeeNameEn; emp.BirthDate = employeeViewModel.BirthDate; emp.IdCardNum = employeeViewModel.IdCardNum; emp.Gender = (int)employeeViewModel.Gender == 1; emp.BloodType = employeeViewModel.BloodType; emp.MobilePhone = employeeViewModel.MobilePhone; emp.PermanentAddressId = address.AddressId; emp.ResidentialAddressId = ResidentialAddress.AddressId; emp.Email = employeeViewModel.Email; emp.PermanentTel = employeeViewModel.PermanentTel; emp.ResidentialTel = employeeViewModel.ResidentialTel; emp.PhotoPath = newfilename; emp.OnBoardDate = employeeViewModel.OnBoardDate; emp.EmpId = employeeViewModel.EmpId; emp.IsMarried = (int)employeeViewModel.IsMarried == 1; emp.CreateOn = DateTime.Now; emp.HasChild = (int)employeeViewModel.HasChild == 1; emp.ModifiedOn = DateTime.Now; emp.EmployeeStatusesId = db.EmployeeStatuses.Single(x => x.Name == "Active").EmployeeStatusId; emp.IsDisability = (int)employeeViewModel.IsDisability == 1; emp.IsAboriginal = (int)employeeViewModel.IsAboriginal == 1; db.Employees.Add(emp); db.SaveChanges(); //Education //var q = new List<ViewModel.Education>(); foreach (var edu in employeeViewModel.Educations) { var schoolname = edu.SchoolName; var department = edu.Department; var dgreee = edu.Drgree; var sdate = edu.StartDate; var enddate = edu.EndDate; Models.Education edus = new Models.Education(); edus.EducationId = Guid.NewGuid(); edus.SchoolName = schoolname; edus.Department = department; edus.Degree = dgreee; edus.StartDate = DateTime.Parse(sdate); edus.EndDate = DateTime.Parse(enddate); edus.EmployeeId = emp.EmployeeId; db.Educations.Add(edus); db.SaveChanges(); } //emp.Educations.Where(x=>x.EducationId) = Guid.NewGuid(); return(RedirectToAction("Index")); } return(RedirectToAction("Create")); }