public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } passport passport = db.passports.Find(id); if (passport == null) { return(HttpNotFound()); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); var alist = this.db.master_file.OrderBy(e => e.employee_no).ToList(); var afinallist = new List <master_file>(); foreach (var file in alist) { if (afinallist.Count == 0) { afinallist.Add(file); } if (!afinallist.Exists(x => x.employee_no == file.employee_no)) { afinallist.Add(file); } } this.ViewBag.employee_no = new SelectList(afinallist, "employee_id", "employee_no"); ViewBag.employee_no1 = new SelectList(afinallist.OrderBy(e => e.employee_name), "employee_id", "employee_name"); return(View(passport)); }
public ActionResult DeleteConfirmed(int id) { passport passport = db.passports.Find(id); db.passports.Remove(passport); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } passport passport = db.passports.Find(id); if (passport == null) { return(HttpNotFound()); } return(View(passport)); }
public ActionResult Edit([Bind(Include = "employee_id,employee_no,company_code,passport_no,passport_expiry,passport_issue_date,passport_return_date,passport_remarks,status,rv_expiry,vl_start,vl_end,imgpath")] passport passport, HttpPostedFileBase fileBase) { string serverfile; if (fileBase != null) { var a = db.master_file.Find(passport.employee_no); int i = 0; var imgname = System.IO.Path.GetFileName(fileBase.FileName); var fileexe = System.IO.Path.GetExtension(fileBase.FileName); DirectoryInfo filepath = new DirectoryInfo("D:/HR/img/passport/"); serverfile = "D:/HR/img/passport/" + a.employee_no;/*+ "/"+ passport.employee_no + fileexe;*/ filepath = Directory.CreateDirectory(serverfile); do { serverfile = "D:/HR/img/passport/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe; i++; } while (System.IO.File.Exists( serverfile = "D:/HR/img/passport/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe)); fileBase.SaveAs(serverfile); } else { serverfile = null; } if (ModelState.IsValid) { var img = new passport(); img = db.passports.Find(passport.employee_id); img.employee_id = passport.employee_id; img.employee_no = passport.employee_no; img.company_code = passport.company_code; img.passport_no = passport.passport_no; img.passport_expiry = passport.passport_expiry; img.passport_issue_date = passport.passport_issue_date; img.passport_return_date = passport.passport_return_date; img.passport_remarks = passport.passport_remarks; img.status = passport.status; img.imgpath = serverfile; img.changed_by = User.Identity.Name; img.date_changed = DateTime.Now; passport = img; db.passports.Add(img); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); var alist = this.db.master_file.OrderBy(e => e.employee_no).ToList(); var afinallist = new List <master_file>(); foreach (var file in alist) { if (afinallist.Count == 0) { afinallist.Add(file); } if (!afinallist.Exists(x => x.employee_no == file.employee_no)) { afinallist.Add(file); } } this.ViewBag.employee_no = new SelectList(afinallist, "employee_id", "employee_no"); ViewBag.employee_no1 = new SelectList(afinallist.OrderBy(e => e.employee_name), "employee_id", "employee_name"); return(View(passport)); }