public ActionResult Add(tblEmployee employee, FormCollection collection)
{
using (dbEmployeeEntities entities = new dbEmployeeEntities())
{
tblEmployee addedEmployee = new tblEmployee();
addedEmployee.FirstName = employee.FirstName;
addedEmployee.LastName = employee.LastName;
addedEmployee.City = employee.City;
//addedEmployee.DepartmentID = employee.DepartmentID;
addedEmployee.Gender = employee.Gender;
addedEmployee.DepartmentID = Convert.ToInt32(collection["DepartmentName"]);
addedEmployee.SalaryID = Convert.ToInt32(collection["Salary"]);
addedEmployee.State = employee.State;
//var count = entities.tblEmployee.Count(p => p.FirstName == employee.FirstName && p.LastName == employee.LastName);
//if (count > 0)
//{
// ModelState.AddModelError("", "Employee with same name already exists");
// GetDepartmentsAndSalaries();
// return View();
//}
//else
{
entities.tblEmployee.Add(addedEmployee);
entities.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
using (dbEmployeeEntities db = new dbEmployeeEntities())
{
tblEmployee emp = db.tblEmployee.FirstOrDefault(p => p.ID == id);
if (emp != null)
{
db.tblEmployee.Remove(emp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Edit(int ID, tblEmployee employee, FormCollection collection)
{
using (dbEmployeeEntities entities = new dbEmployeeEntities())
{
tblEmployee updatedEmployee = (from c in entities.tblEmployee
where c.ID == ID
select c).FirstOrDefault();
updatedEmployee.FirstName = employee.FirstName;
updatedEmployee.LastName = employee.LastName;
updatedEmployee.City = employee.City;
updatedEmployee.DepartmentID = Convert.ToInt32(collection["DepartmentName"]);
updatedEmployee.SalaryID = Convert.ToInt32(collection["Salary"]);
updatedEmployee.Gender = employee.Gender;
updatedEmployee.State = employee.State;
entities.SaveChanges();
}
return(RedirectToAction(
"Index"));
}
