public ActionResult Create([Bind(Include = "Id,EmployeeId,FromDesignationId,ToDesignationId,TransferDate")] DepartmentTransfer departmentTransfer)
{
if (Session["ADMIN"] != null || Session["ADMIN"].ToString() == "admin")
{
if (ModelState.IsValid)
{
int fromDesignationId = db.Employee.Where(i => i.Id == departmentTransfer.EmployeeId).Select(i => i.DesignationId).FirstOrDefault();
int toDesigantionId = Convert.ToInt32(Request["ToDesignationId"]);
departmentTransfer.FromDesignationId = fromDesignationId;
departmentTransfer.ToDesignationId = toDesigantionId;
departmentTransfer.TransferDate = DateTime.Now;
db.DepartmentTransfer.Add(departmentTransfer);
db.SaveChanges();
Employee emp = db.Employee.Find(departmentTransfer.EmployeeId);
emp.DesignationId = toDesigantionId;
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
List <Employee> employee = new List <Employee>();
employee = db.Employee.Where(i => i.Status == true).ToList();
List <Designation> designation = new List <Designation>();
designation = db.Designation.Where(i => i.Status == true).ToList();
ViewBag.EmployeeId = new SelectList(employee, "Id", "Name");
ViewBag.ToDesignationId = new SelectList(designation, "Id", "Name");
return(View(departmentTransfer));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
// GET: DepartmentTransfers/Edit/5
public ActionResult Edit(int?id)
{
if (Session["ADMIN"] != null || Session["ADMIN"].ToString() == "admin")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentTransfer departmentTransfer = db.DepartmentTransfer.Find(id);
ViewBag.Designation = db.Designation.Where(x => x.Id == departmentTransfer.ToDesignationId).Select(t => t.Name).FirstOrDefault();
int departmentId = db.Designation.Where(x => x.Id == departmentTransfer.ToDesignationId).Select(t => t.DepartmentId).FirstOrDefault();
ViewBag.Department = db.Department.Where(x => x.Id == departmentId).Select(t => t.Name).FirstOrDefault();
int departmentGroupId = db.Department.Where(x => x.Id == departmentId).Select(t => t.DepartmentGroupId).FirstOrDefault();
ViewBag.DepartmentGroup = db.DepartmentGroup.Where(x => x.Id == departmentGroupId).Select(t => t.Name).FirstOrDefault();
List <DepartmentGroup> departmentGroupList = new List <DepartmentGroup>();
departmentGroupList = db.DepartmentGroup.Where(i => i.Status == true).ToList();
ViewBag.DepartmentGroupId = new SelectList(departmentGroupList, "Id", "Name");
if (departmentTransfer == null)
{
return(HttpNotFound());
}
return(View(departmentTransfer));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["ADMIN"] != null || Session["ADMIN"].ToString() == "admin")
{
DepartmentTransfer departmentTransfer = db.DepartmentTransfer.Find(id);
db.DepartmentTransfer.Remove(departmentTransfer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
// GET: DepartmentTransfers/Details/5
public ActionResult Details(int?id)
{
if (Session["ADMIN"] != null || Session["ADMIN"].ToString() == "admin")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentTransfer departmentTransfer = db.DepartmentTransfer.Find(id);
if (departmentTransfer == null)
{
return(HttpNotFound());
}
return(View(departmentTransfer));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult Edit([Bind(Include = "Id,EmployeeId,FromDesignationId,ToDesignationId,TransferDate")] DepartmentTransfer departmentTransfer)
{
if (Session["ADMIN"] != null || Session["ADMIN"].ToString() == "admin")
{
if (ModelState.IsValid)
{
int fromDesignationId = db.Employee.Where(i => i.Id == departmentTransfer.Id).Select(i => i.DesignationId).FirstOrDefault();
int toDesignationId = Convert.ToInt32(Request["ToDesignationId"]);
departmentTransfer.FromDesignationId = fromDesignationId;
departmentTransfer.ToDesignationId = toDesignationId;
departmentTransfer.TransferDate = DateTime.Now;
db.Entry(departmentTransfer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeId = new SelectList(db.Employee, "Id", "Code", departmentTransfer.EmployeeId);;
ViewBag.ToDesignationId = new SelectList(db.Designation, "Id", "Code", departmentTransfer.ToDesignationId);
return(View(departmentTransfer));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
