public ActionResult Index(EmployeeViewModel employeeVM)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> listDep = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(listDep, "DepartmenId", "DepartmentName");
if (employeeVM.EmployeeID > 0)
{
WebMVC.DataBaseModels.Employee employee = db.Employee.SingleOrDefault(x => x.EmployeeID == employeeVM.EmployeeID);
employee.Address = employeeVM.Address;
employee.DepartmentId = employeeVM.DepartmentId;
employee.Name = employeeVM.Name;
db.SaveChanges();
}
else
{
WebMVC.DataBaseModels.Employee employee = new DataBaseModels.Employee();
employee.DepartmentId = employeeVM.DepartmentId;
employee.Address = employeeVM.Address;
employee.Name = employeeVM.Name;
employee.Sites = employee.Sites;
db.Employee.Add(employee);
db.SaveChanges();
}
return(View());
}
public JsonResult DeleteEmployee(int EmployeeId)
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
bool result = false;
DataBaseModels.Employee emp = db.Employee.SingleOrDefault(x => x.IsDeleted == false && x.EmployeeID == EmployeeId);
if (emp != null)
{
emp.IsDeleted = true;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(EmployeeViewModel employeeViewModel)
{
try
{
MVCDataBaseEntities db = new MVCDataBaseEntities();
List <Department> departmentList = db.Department.ToList();
ViewBag.DepartmentList = new SelectList(departmentList, "DepartmentID", "DepartmentName");
if (ModelState.IsValid)
{
DataBaseModels.Employee e = new DataBaseModels.Employee
{
Address = employeeViewModel.Address,
DepartmentId = employeeViewModel.DepartmentId,
Name = employeeViewModel.Name
};
db.Employee.Add(e);
db.SaveChanges();
int idEmp = e.EmployeeID;
DataBaseModels.Sites EmployeeSite = new DataBaseModels.Sites
{
EmployeeId = idEmp,
SiteName = employeeViewModel.SiteName
};
db.Sites.Add(EmployeeSite);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
return(View(employeeViewModel));
}
