public ActionResult DeleteConfirmed(int id) { tblemployee tblemployee = db.tblemployees.Find(id); db.tblemployees.Remove(tblemployee); db.SaveChanges(); return(RedirectToAction("Index")); }
public IEnumerable <tblemployee> YieldReadStudentsFromFile() { var lines = db.tblemployees.ToList(); foreach (var line in lines) { tblemployee em = line; yield return(em); } }
public ActionResult Edit([Bind(Include = "EmpId,Ename,DeptId")] tblemployee tblemployee) { if (ModelState.IsValid) { db.Entry(tblemployee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DeptId = new SelectList(db.tbldepartments, "Id", "Dname", tblemployee.DeptId); return(View(tblemployee)); }
public List <tblemployee> ReadStudentsFromFile() { var lines = db.tblemployees.ToList(); List <tblemployee> result = new List <tblemployee>(); //Tạo một list trống foreach (var line in lines) { tblemployee student = line; result.Add(student); //Thêm student vào list } return(result); // Trả list ra }
public ActionResult insert(tblemployee emp) { masterEntities2 entity = new masterEntities2(); tblemployee obj = new tblemployee(); obj.firstname = emp.firstname; obj.lastname = emp.lastname; obj.address = emp.address; obj.phone = emp.phone; entity.tblemployees.Add(obj); entity.SaveChanges(); return(RedirectToAction("show")); }
// GET: tblemployees/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblemployee tblemployee = db.tblemployees.Find(id); if (tblemployee == null) { return(HttpNotFound()); } return(View(tblemployee)); }
// GET: tblemployees/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblemployee tblemployee = db.tblemployees.Find(id); if (tblemployee == null) { return(HttpNotFound()); } ViewBag.DeptId = new SelectList(db.tbldepartments, "Id", "Dname", tblemployee.DeptId); return(View(tblemployee)); }
public ActionResult UserLogin(tblemployee objUser) { if (ModelState.IsValid) { tblemployee obj = Miscdb.tblemployees.Where(a => a.emp_cd.Equals(objUser.emp_cd) && a.pass.Equals(objUser.pass)).FirstOrDefault(); if (obj != null) { int emp = Convert.ToInt32(obj.emp_cd); obj_user.Emp_cd = emp; Session["LogIn"] = emp; obj_user.IsSuperAdmin = Convert.ToBoolean(obj.isSuperAdmin); obj_user.Name = obj.Name; obj_user.Branch_Code = Convert.ToInt32(obj.Branch_Code); SessionWrapper.User = obj_user; return(RedirectToAction("Home", "Dashboard")); } } return(View(objUser)); }
public string GetNameByID(int id) { string Name = ""; tblemployee obj = Miscdb.tblemployees.Where(a => a.emp_cd.Equals(id)).FirstOrDefault(); string filename = HttpContext.Current.Server.MapPath("~/Content/EmpImages/" + id + ".jpg"); if (obj != null) { Name = obj.Name; if (File.Exists(filename)) { Name = Name + "|True"; } else { Name = Name + "|False"; } } return(Name); }
public ActionResult AddEmployee(tblemployee obj) { return(View()); }