public ActionResult DeleteConfirmed(int id) { TBL_EmployeeDetails tbl_employeedetails = db.TBL_EmployeeDetails.Find(id); db.TBL_EmployeeDetails.Remove(tbl_employeedetails); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /Employee/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TBL_EmployeeDetails tbl_employeedetails = db.TBL_EmployeeDetails.Find(id); if (tbl_employeedetails == null) { return(HttpNotFound()); } return(View(tbl_employeedetails)); }
public ActionResult Edit([Bind(Include = "EmpID,FirstName,LastName,GenderID,Designation,DepartmentID,Email,ContactNum,Address,City,DOB,DOA,DOJ,BloodGroup,Mode,OfficeLocationID,TeamLeaderID,ShiftPartnerID")] TBL_EmployeeDetails tbl_employeedetails) { if (ModelState.IsValid) { db.Entry(tbl_employeedetails).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DepartmentID = new SelectList(db.TBL_Department, "DepatmentID", "DepartmentName", tbl_employeedetails.DepartmentID); ViewBag.GenderID = new SelectList(db.TBL_Gender, "GenderID", "Gender", tbl_employeedetails.GenderID); ViewBag.OfficeLocationID = new SelectList(db.TBL_OfficeLocation, "OfficeLocationID", "OfficeLocation", tbl_employeedetails.OfficeLocationID); ViewBag.TeamLeaderID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName"); ViewBag.ShiftPartnerID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName"); return(View(tbl_employeedetails)); }
// GET: /Employee/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TBL_EmployeeDetails tbl_employeedetails = db.TBL_EmployeeDetails.Find(id); if (tbl_employeedetails == null) { return(HttpNotFound()); } int tlID = Convert.ToInt32(tbl_employeedetails.TeamLeaderID); var TL = db.TBL_EmployeeDetails.Find(tlID); if (TL != null) { ViewBag.TLName = TL.FirstName + " " + TL.LastName; } else { ViewBag.TLName = "N.A."; } int ShiftPartnerID = Convert.ToInt32(tbl_employeedetails.ShiftPartnerID); var ShiftPartner = db.TBL_EmployeeDetails.Find(ShiftPartnerID); if (ShiftPartner != null) { ViewBag.ShiftPartnerName = ShiftPartner.FirstName + " " + ShiftPartner.LastName; } else { ViewBag.ShiftPartnerName = "N.A."; } return(View(tbl_employeedetails)); }
// GET: /Employee/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TBL_EmployeeDetails tbl_employeedetails = db.TBL_EmployeeDetails.Find(id); if (tbl_employeedetails == null) { return(HttpNotFound()); } ViewBag.DepartmentID = new SelectList(db.TBL_Department, "DepatmentID", "DepartmentName", tbl_employeedetails.DepartmentID); ViewBag.GenderID = new SelectList(db.TBL_Gender, "GenderID", "Gender", tbl_employeedetails.GenderID); ViewBag.OfficeLocationID = new SelectList(db.TBL_OfficeLocation, "OfficeLocationID", "OfficeLocation", tbl_employeedetails.OfficeLocationID); //Get the TeamLeader ID and check is it zero or not? int tlID = Convert.ToInt32(tbl_employeedetails.TeamLeaderID); if (tlID != 0) { ViewBag.TeamLeaderID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName", tlID); } else { ViewBag.TeamLeaderID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName"); } int ShiftPartnerID = Convert.ToInt32(tbl_employeedetails.ShiftPartnerID); if (ShiftPartnerID != 0) { ViewBag.ShiftPartnerID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName", ShiftPartnerID); } else { ViewBag.ShiftPartnerID = new SelectList(db.TBL_EmployeeDetails, "EmpID", "FirstName"); } return(View(tbl_employeedetails)); }