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