public bool DeleteRecord(int id)
{
using (var context = new EmplyeeEntities())
{
var emp = context.tbl_Employee.Where(x => x.ID == id).FirstOrDefault();
if (emp != null)
{
context.tbl_Employee.Remove(emp);
context.SaveChanges();
}
return(true);
}
}
public Employee GetEmployeeDetails(int id)
{
using (var context = new EmplyeeEntities())
{
var result = context.tbl_Employee.Where(x => x.ID == id).
Select(x => new Employee()
{
FirstName = x.FirstName,
LastName = x.LastName,
City = x.City,
ZipCode = x.ZipCode
}).FirstOrDefault();
return(result);
}
}
public List <Employee> GetAllData()
{
using (var context = new EmplyeeEntities())
{
var list = context.tbl_Employee.
Select(x => new Employee()
{
ID = x.ID,
FirstName = x.FirstName,
LastName = x.LastName,
City = x.City,
ZipCode = x.ZipCode
}).ToList();
return(list);
}
}
public bool UpdateRecord(Employee employee)
{
using (var context = new EmplyeeEntities())
{
var emp = context.tbl_Employee.Where(x => x.ID == employee.ID).FirstOrDefault();
if (emp != null)
{
emp.FirstName = employee.FirstName;
emp.LastName = employee.LastName;
emp.City = employee.City;
emp.ZipCode = employee.ZipCode;
}
context.SaveChanges();
return(true);
}
}
public int AddEmployee(Employee employee)
{
using (var context = new EmplyeeEntities())
{
tbl_Employee _Employee = new tbl_Employee()
{
FirstName = employee.FirstName,
LastName = employee.LastName,
City = employee.City,
ZipCode = employee.ZipCode
};
context.tbl_Employee.Add(_Employee);
context.SaveChanges();
return(_Employee.ID);
}
}
