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