public ActionResult Create(visa visa, HttpPostedFileBase fileBase) { string serverfile; if (fileBase != null) { var a = db.master_file.Find(visa.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/visa/" + fileexe); serverfile = "D:/HR/img/visa/" + a.employee_no; /*+ "/"+ passport.employee_no + fileexe;*/ filepath = Directory.CreateDirectory(serverfile); int i = 0; do { serverfile = "D:/HR/img/visa/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe; i++; } while (System.IO.File.Exists(serverfile = "D:/HR/img/visa/" + a.employee_no + "/" + a.employee_no + "_" + i + fileexe)); fileBase.SaveAs(serverfile); } else { serverfile = null; } if (ModelState.IsValid) { var img = new visa(); img.file_no = visa.file_no; img.place_of_issue = visa.place_of_issue; img.accompanied_by = visa.accompanied_by; img.rv_issue = visa.rv_issue; img.sponsor = visa.sponsor; img.uid_no = visa.uid_no; img.emp_no = visa.emp_no; img.rv_expiry = visa.rv_expiry; img.proff_as_per_visa = visa.proff_as_per_visa; img.imgpath = serverfile; img.changed_by = User.Identity.Name; img.date_changed = DateTime.Now; var master = new master_file(); master = db.master_file.Find(visa.emp_no); if (master.labour_card.Count != 0) { visa.master_file = master; visa.master_file.status = "active"; } db.visas.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(visa)); }
public ActionResult DeleteConfirmed(int id) { master_file master_file = db.master_file.Find(id); db.master_file.Remove(master_file); 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 Create([Bind(Include = "employee_no,employee_name,nationality,dob,date_joined,last_working_day,gender,IBAN,account_no,bank_name,img,id")] master_file master_file, HttpPostedFileBase fileBase) { // if (ModelState.IsValid) // { // db.master_file.Add(master_file); // db.SaveChanges(); // return RedirectToAction("Index"); // } string serverfile; if (fileBase != null) { var imgname = System.IO.Path.GetFileName(fileBase.FileName); var fileexe = System.IO.Path.GetExtension(fileBase.FileName); DirectoryInfo filepath = new DirectoryInfo("D:/HR/img/masterfile/" + fileexe); serverfile = "D:/HR/img/masterfile/" + master_file.employee_no;/*+ "/"+ passport.employee_no + fileexe;*/ filepath = Directory.CreateDirectory(serverfile); int i = 0; do { serverfile = "D:/HR/img/masterfile/" + master_file.employee_no + "/" + master_file.employee_no + "_" + i + fileexe; i++; } while (System.IO.File.Exists(serverfile = "D:/HR/img/masterfile/" + master_file.employee_no + "/" + master_file.employee_no + "_" + i + fileexe)); fileBase.SaveAs(serverfile); } else { serverfile = null; } if (ModelState.IsValid) { var current = DateTime.Now; var img = new master_file(); img.employee_no = master_file.employee_no; img.employee_name = master_file.employee_name; img.nationality = master_file.nationality; img.dob = master_file.dob; img.date_joined = master_file.date_joined; img.last_working_day = master_file.last_working_day; img.gender = master_file.gender; img.changed_by = User.Identity.Name; img.date_changed = current; img.status = "in process"; img.img = serverfile; db.master_file.Add(img); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); return(View(master_file)); }
public Form1() { InitializeComponent(); PersonEntities ente = new PersonEntities(); master_file master_file = (new master_file() { firstname = "My", lastname = "Lastname", function = EFunction.Interessent, aktiv = true, deleted_inaktiv = false, newsletter_flag = true }); ente.master_file.Add(master_file); ente.SaveChanges(); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } master_file master_file = db.master_file.Find(id); if (master_file == null) { return(HttpNotFound()); } return(View(master_file)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } master_file master_file = db.master_file.Find(id); if (master_file == null) { return(HttpNotFound()); } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); return(View(master_file)); }
public ActionResult Edit([Bind(Include = "employee_no,employee_name,nationality,dob,date_joined,last_working_day,gender,IBAN,account_no,bank_name,img,id,status")] master_file master_file, HttpPostedFileBase fileBase) { var imglist = this.db.master_file.ToList(); string serverfile; var img = imglist.Find(x => x.employee_no == master_file.employee_no); if (fileBase != null) { var imgname = System.IO.Path.GetFileName(fileBase.FileName); var fileexe = System.IO.Path.GetExtension(fileBase.FileName); DirectoryInfo filepath = new DirectoryInfo("D:/HR/img/masterfile/" + fileexe); serverfile = "D:/HR/img/masterfile/" + master_file.employee_no;/*+ "/"+ passport.employee_no + fileexe;*/ filepath = Directory.CreateDirectory(serverfile); int i = 0; do { serverfile = "D:/HR/img/masterfile/" + master_file.employee_no + "/" + master_file.employee_no + "_" + i + fileexe; i++; } while (System.IO.File.Exists(serverfile = "D:/HR/img/masterfile/" + master_file.employee_no + "/" + master_file.employee_no + "_" + i + fileexe)); fileBase.SaveAs(serverfile); } else { if (img.img != null) { serverfile = img.img; } else { serverfile = null; } } if (ModelState.IsValid) { try { /*var img = new master_file(); * // img.emirates_id = master_file.emirates_id; * // img.employee_no = master_file.employee_no; * // img.employee_name = master_file.employee_name; * // img.nationality = master_file.nationality; * // img.dob = master_file.dob; * // img.date_joined = master_file.date_joined; * // img.last_working_day = master_file.last_working_day; * // img.gender = master_file.gender; * master_file.img = serverfile; * master_file.img = serverfile; * master_file.changed_by = User.Identity.Name; * master_file.date_changed = DateTime.Now; * db.master_file.Add(master_file);*/ var current = DateTime.Now; img.employee_no = master_file.employee_no; img.employee_name = master_file.employee_name; img.nationality = master_file.nationality; img.dob = master_file.dob; img.date_joined = master_file.date_joined; img.last_working_day = master_file.last_working_day; img.gender = master_file.gender; img.changed_by = User.Identity.Name; img.date_changed = current; if (!master_file.status.IsNullOrWhiteSpace()) { img.status = master_file.status; } else { if (img.labour_card.Count != 0 || img.labour_card.Count != 0) { img.status = "active"; } } img.img = serverfile; this.db.Entry(img).State = EntityState.Modified; this.db.SaveChanges(); /* * db.master_file.Add(img); * db.SaveChanges();*/ return(RedirectToAction("Index")); }/* * catch (Exception e) * { * System.Diagnostics.Debug.WriteLine(e); * return Content(e.ToString()); * throw; * }*/ catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"", ve.PropertyName, eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName), ve.ErrorMessage); } } return(Content(e.ToString())); throw; } } ViewBag.gender = new SelectList(db.Tables, "gender", "gender"); ViewBag.employee_no = new SelectList(db.emirates_id, "id", "id", master_file.employee_no); return(View(master_file)); }