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