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