public EmployeeViewModel CreateEmp(EmployeeViewModel model)
{
CrudDemoDBEntities db = new CrudDemoDBEntities();
if (model.EmpId > 0)
{
//update
Employee emp = db.Employees.SingleOrDefault(x => x.EmpId == model.EmpId && x.IsActive == true);
emp.Name = model.Name;
emp.Gender = model.Gender;
emp.DOB = Convert.ToDateTime(model.DOB);
emp.Address = model.Address;
emp.CityId = model.CityId;
emp.DepartmentId = model.DepartmentId;
emp.IsActive = model.IsActive;
db.SaveChanges();
//Employee emp = new Employee();
//emp.Address = model.Address;
//emp.Name = model.Name;
//emp.DepartmentId = model.DepartmentId;
//db.Employees.Add(emp);
//db.SaveChanges();
//int latestEmpId = emp.EmployeeId;
//Site site = new Site();
//site.SiteName = model.SiteName;
//site.EmployeeId = latestEmpId;
//db.Sites.Add(site);
//db.SaveChanges();
}
else
{
//Insert
Employee emp = new Employee();
emp.Name = model.Name;
emp.Gender = model.Gender;
emp.DOB = Convert.ToDateTime(model.DOB);
emp.Address = model.Address;
emp.CityId = model.CityId;
emp.DepartmentId = model.DepartmentId;
emp.IsActive = model.IsActive;
db.Employees.Add(emp);
db.SaveChanges();
}
return(model);
}
public void DeleteEmp(int EmployeeId)
{
CrudDemoDBEntities db = new CrudDemoDBEntities();
Employee emp = db.Employees.SingleOrDefault(x => x.IsActive == true && x.EmpId == EmployeeId);
if (emp != null)
{
emp.IsActive = false;
db.SaveChanges();
}
// return RedirectToAction("Index");
}