public IHttpActionResult UpdateEmployee(EmployeeMasterDs employee, int?id) { var isupdate = _employeeRepository.UpdateEmployee(employee, id); if (isupdate == true) { return(Ok(isupdate)); } return(BadRequest()); }
public IHttpActionResult CreateEmployee(EmployeeMasterDs employee) { var isSave = _employeeRepository.CreateEmployee(employee); if (isSave == true) { return(Ok(isSave)); } return(BadRequest()); }
public bool UpdateEmployee(EmployeeMasterDs employee, int?id) { employee.CreatedDate = now; employee.LastUpdatedDate = now; employee.DOB = now; int rowsAffected = this._db.Execute("UPDATE EmployeeMaster SET EmpNumber=@EmpNumber,EmpFirstName=@EmpFirstName,EmpLastName=@EmpLastName,DOB=@DOB,BloodGroup=@BloodGroup,MaritalStatus=@MaritalStatus,EmailId=@EmailId,WorkPhone=@WorkPhone,LastUpdatedDate=@LastUpdatedDate,CreatedDate=@CreatedDate WHERE EmpId =" + employee.EmpId, employee); if (rowsAffected > 0) { return(true); } return(false); }
public bool CreateEmployee(EmployeeMasterDs employee) { if (employee != null) { employee.CreatedDate = now; employee.LastUpdatedDate = now; employee.DOB = now; int rowsAffected = this._db.Execute(@"INSERT EmployeeMaster(EmpNumber,EmpFirstName,EmpLastName,DOB,BloodGroup,MaritalStatus,EmailId,WorkPhone,IsActive,LastUpdatedBy,LastUpdatedDate,CreatedBy,CreatedDate) values (@EmpNumber,@EmpFirstName,@EmpLastName,@DOB,@BloodGroup,@MaritalStatus,@EmailId,@WorkPhone,1,1,@LastUpdatedDate,1,@CreatedDate)", new { EmpNumber = employee.EmpNumber, EmpFirstName = employee.EmpFirstName, EmpLastName = employee.EmpLastName, DOB = employee.DOB, BloodGroup = employee.BloodGroup, MaritalStatus = employee.MaritalStatus, EmailId = employee.EmailId, WorkPhone = employee.WorkPhone, IsActive = 1, LastUpdatedBy = 1, LastUpdatedDate = employee.LastUpdatedDate, CreatedBy = 1, CreatedDate = employee.CreatedDate }); if (rowsAffected > 0) { return(true); } } return(false); }