public bool insertEmployees(tblEmployee objEmployee)
{
using (var dbcontext = new HRDBContext())
{
try
{
dbcontext.tblEmployees.Add(objEmployee);
dbcontext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool updateEmployees(tblEmployee objEmployee, int EmployeeId)
{
using (var dbcontext = new HRDBContext())
{
try
{
dbcontext.tblEmployees.Add(objEmployee);
dbcontext.Entry(objEmployee).State = System.Data.Entity.EntityState.Modified;
dbcontext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
tblEmployee HRWebServices.GetEmployeeInfo(int EmployeeId)
{
using (var dbcontext = new HRDBContext())
{
var Employee = dbcontext.tblEmployees.First(e => e.Emp_EmployeeId == EmployeeId);
if (Employee != null)
{
tblEmployee objEmployee = new tblEmployee();
objEmployee.Emp_EmployeeId = Employee.Emp_EmployeeId;
objEmployee.Cit_CityId = Employee.Cit_CityId;
objEmployee.Dep_DepartmentId = Employee.Dep_DepartmentId;
objEmployee.Emp_Address = Employee.Emp_Address;
objEmployee.Emp_AnualSalary = Employee.Emp_AnualSalary;
objEmployee.Emp_BirthOfDate = Employee.Emp_BirthOfDate;
objEmployee.Emp_CellPhone = Employee.Emp_CellPhone;
objEmployee.Emp_Email = Employee.Emp_Email;
objEmployee.Emp_FirstName = Employee.Emp_FirstName;
objEmployee.Emp_Gender = Employee.Emp_Gender;
objEmployee.Emp_HourlyRate = Employee.Emp_HourlyRate;
objEmployee.Emp_LastName = Employee.Emp_LastName;
objEmployee.Emp_Phone = Employee.Emp_Phone;
objEmployee.Emp_Photo = Employee.Emp_Photo;
objEmployee.Emp_PostalCode = Employee.Emp_PostalCode;
objEmployee.Emp_StartDate = Employee.Emp_StartDate;
objEmployee.Emp_TerminationDate = Employee.Emp_TerminationDate;
objEmployee.Pos_PositionId = Employee.Pos_PositionId;
objEmployee.Tit_TitleId = Employee.Tit_TitleId;
return(objEmployee);
}
else
{
return(null);
}
}
}
