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 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);
}
}