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