public EmployeeModels GetEmployee(int id)
{
using (var context = new empdbEntities())
{
var result = context.Employee
.Where(x => x.Id == id)
.Select(x => new EmployeeModels()
{
Id = x.Id,
Addressid = x.Addressid,
Code = x.Code,
Email = x.Email,
FirstName = x.FirstName,
LastName = x.LastName,
Address = new AddressModel()
{
Id = x.Address.Id,
Details = x.Address.Details,
Country = x.Address.Country,
state = x.Address.state
}
}).FirstOrDefault();
return(result);
}
}
public bool DeleteEmployee(int id)
{
using (var context = new empdbEntities())
{
var emp = new Employee()
{
Id = id
};
context.Entry(emp).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
return(false);
}
}
public int AddEmployee(EmployeeModels model)
{
using (var context = new empdbEntities())
{
Employee emp = new Employee()
{
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
Code = model.Code
};
context.Employee.Add(emp);
context.SaveChanges();
return(emp.Id);
}
}
public ActionResult Create(FormCollection collection)
{
try
{
employee emp = new employee();
emp.empname = collection["empname"];
emp.email = collection["email"];
emp.phoneno = collection["phoneno"];
empdbEntities userRegistrationEntities = new empdbEntities();
userRegistrationEntities.employees.Add(emp);
userRegistrationEntities.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public bool UpdateEmployee(int id, EmployeeModels models)
{
using (var context = new empdbEntities())
{
var employee = new Employee();
if (employee != null)
{
employee.FirstName = models.FirstName;
employee.LastName = models.LastName;
employee.Email = models.Email;
employee.Code = models.Code;
employee.Addressid = models.Addressid;
}
context.Entry(employee).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
public List <EmployeeModels> GetAllEmployees()
{
using (var context = new empdbEntities())
{
var result = context.Employee
.Select(x => new EmployeeModels()
{
Id = x.Id,
Addressid = x.Addressid,
Code = x.Code,
Email = x.Email,
FirstName = x.FirstName,
LastName = x.LastName,
Address = new AddressModel()
{
Id = x.Address.Id,
Details = x.Address.Details,
Country = x.Address.Country,
state = x.Address.state
}
}).ToList();
return(result);
}
}
