public void deleteEmployee(Int32 _code)
{
using (DataAcc.HR_DeptEntities context = new DataAcc.HR_DeptEntities())
{
var per = context.Employees.Where(p => p.emp_code == _code).First();
context.DeleteObject(per);
context.SaveChanges();
}
}
public void Update(Int32 _code, String _name, String _designation, String depnm)
{
using (DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities())
{
var emp = obj.Employees.Where(x => x.emp_code == _code).First();
emp.emp_name = _name;
emp.emp_designation = _designation;
emp.dept_code = converterDep(depnm);
obj.SaveChanges();
}
}
public void AddEmployee()
{
using (DataAcc.HR_DeptEntities myEnt = new DataAcc.HR_DeptEntities())
{
DataAcc.Employee newEmployee = new DataAcc.Employee()
{
emp_code = _Code,
emp_name = _Name,
emp_designation = _Designation,
emp_date_appointed = _Date_Appointed,
dept_code = _dept_Code
};
myEnt.AddToEmployees(newEmployee);
myEnt.SaveChanges();
}
}
public void AddEmployee()
{
using (DataAcc.HR_DeptEntities myEnt = new DataAcc.HR_DeptEntities())
{
DataAcc.Employee newEmployee = new DataAcc.Employee()
{
emp_code = _Code,
emp_name = _Name,
emp_designation = _Designation,
emp_date_appointed = _Date_Appointed,
dept_code = _dept_Code
};
myEnt.AddToEmployees(newEmployee);
myEnt.SaveChanges();
}
}
public void deleteEmployee(Int32 _code)
{
using (DataAcc.HR_DeptEntities context = new DataAcc.HR_DeptEntities())
{
var per = context.Employees.Where(p => p.emp_code == _code).First();
context.DeleteObject(per);
context.SaveChanges();
}
}
public void Update(Int32 _code, String _name, String _designation, String depnm)
{
using (DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities())
{
var emp = obj.Employees.Where(x => x.emp_code == _code).First();
emp.emp_name = _name;
emp.emp_designation = _designation;
emp.dept_code = converterDep(depnm);
obj.SaveChanges();
}
}
