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 List <String> getDepartment()
{
List <String> myList = new List <String>();
DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities();
foreach (var d in obj.Departments)
{
myList.Add(d.dept_name.Trim());
}
return(myList);
}
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 List<String> getDepartment()
{
List<String> myList = new List<String>();
DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities();
foreach (var d in obj.Departments)
{
myList.Add(d.dept_name.Trim());
}
return myList;
}
public bool validateDept(String deptN)
{
using (DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities())
{
bool flag = false;
var result = from d in obj.Departments select d;
foreach (var e in result)
{
if (deptN.ToLower().Equals(e.dept_name.ToLower()))
{
flag = true;
}
}
return(flag);
}
}
public void getEmployee(Int32 _emp_code)
{
using (DataAcc.HR_DeptEntities objE = new DataAcc.HR_DeptEntities())
{
var result = from d in objE.sp_search_emp(_emp_code)
select d;
foreach (var t in result)
{
_Name = t.emp_name;
_Designation = t.emp_designation;
_deptName = t.dept_name;
_yearsOfService = Convert.ToInt32(t.Years_of_service);
}
}
}
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 searchEmp(Int32 _empCode)
{
using (DataAcc.HR_DeptEntities empObj = new DataAcc.HR_DeptEntities())
{
var result = from p in empObj.Employees
where (p.emp_code) == _empCode
select p;
foreach (var e in result)
{
if (e.emp_code == _empCode)
{
_Name = e.emp_name;
_Designation = e.emp_designation;
_dept_Code = Convert.ToInt32(e.dept_code);
}
}
}
}
public bool validateDept(String deptN)
{
using (DataAcc.HR_DeptEntities obj = new DataAcc.HR_DeptEntities())
{
bool flag = false;
var result = from d in obj.Departments select d;
foreach (var e in result)
{
if (deptN.ToLower().Equals(e.dept_name.ToLower()))
{
flag = true;
}
}
return flag;
}
}
public Boolean validateEmpCode(Int32 _code)
{
using (DataAcc.HR_DeptEntities myEnt = new DataAcc.HR_DeptEntities())
{
var result = from p in myEnt.Employees
select p;
bool found = false;
foreach (var d in result)
{
if (d.emp_code == _code)
{
found = true;
}
}
return(found);
}
}
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 searchEmp(Int32 _empCode)
{
using (DataAcc.HR_DeptEntities empObj = new DataAcc.HR_DeptEntities())
{
var result = from p in empObj.Employees
where (p.emp_code) == _empCode
select p;
foreach (var e in result)
{
if (e.emp_code == _empCode)
{
_Name = e.emp_name;
_Designation = e.emp_designation;
_dept_Code = Convert.ToInt32(e.dept_code);
}
}
}
}
public void getEmployee(Int32 _emp_code)
{
using (DataAcc.HR_DeptEntities objE = new DataAcc.HR_DeptEntities())
{
var result = from d in objE.sp_search_emp(_emp_code)
select d;
foreach (var t in result)
{
_Name = t.emp_name;
_Designation = t.emp_designation;
_deptName = t.dept_name;
_yearsOfService = Convert.ToInt32(t.Years_of_service);
}
}
}
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 Boolean validateEmpCode(Int32 _code)
{
using(DataAcc.HR_DeptEntities myEnt = new DataAcc.HR_DeptEntities())
{
var result = from p in myEnt.Employees
select p;
bool found = false;
foreach(var d in result)
{
if(d.emp_code == _code)
{
found = true;
}
}
return found;
}
}