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