public ActionResult DeleteConfirmed(int id)
        {
            labour_card labour_card = db.labour_card.Find(id);

            db.labour_card.Remove(labour_card);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Create(labour_card labour_card, HttpPostedFileBase fileBase)
        {
            string serverfile;

            if (fileBase != null)
            {
                var           a        = db.master_file.Find(labour_card.emp_no);
                var           imgname  = System.IO.Path.GetFileName(fileBase.FileName);
                var           fileexe  = System.IO.Path.GetExtension(fileBase.FileName);
                DirectoryInfo filepath = new DirectoryInfo("D:/HR/img/labour_card/" + fileexe);
                serverfile = "D:/HR/img/labour_card/" + a.employee_no; /*+ "/"+ passport.employee_no + fileexe;*/
                filepath   = Directory.CreateDirectory(serverfile);
                int i = 0;
                do
                {
                    serverfile = "D:/HR/img/labour_card/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe;
                    i++;
                } while (System.IO.File.Exists(serverfile =
                                                   "D:/HR/img/labour_card/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe));

                fileBase.SaveAs(serverfile);
            }
            else
            {
                serverfile = null;
            }

            if (ModelState.IsValid)
            {
                var img = new labour_card();
                img.work_permit_no = labour_card.work_permit_no;
                img.personal_no    = labour_card.personal_no;
                img.emp_no         = labour_card.emp_no;
                img.proffession    = labour_card.proffession;
                img.establishment  = labour_card.establishment;
                img.lc_expiry      = labour_card.lc_expiry;
                img.imgpath        = serverfile;
                img.changed_by     = User.Identity.Name;
                img.date_changed   = DateTime.Now;
                var master = new master_file();
                master = db.master_file.Find(labour_card.emp_no);
                if (master.visas.Count != 0)
                {
                    labour_card.master_file        = master;
                    labour_card.master_file.status = "active";
                }
                db.labour_card.Add(img);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.gender  = new SelectList(db.Tables, "gender", "gender");
            ViewBag.emp_no  = new SelectList(db.master_file, "employee_id", "employee_no");
            ViewBag.emp_no1 = new SelectList(db.master_file, "employee_id", "employee_name");
            return(View(labour_card));
        }
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            labour_card labour_card = db.labour_card.Find(id);

            if (labour_card == null)
            {
                return(HttpNotFound());
            }

            return(View(labour_card));
        }
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            labour_card labour_card = db.labour_card.Find(id);

            if (labour_card == null)
            {
                return(HttpNotFound());
            }

            ViewBag.emp_no = new SelectList(db.master_file, "employee_id", "employee_name", labour_card.emp_no);
            return(View(labour_card));
        }