[EnableCors("AllowAll")] public IActionResult GetById(int id)
{
Employee objEmployees = _employeeservice.GetById(id);
EmployeesDto objEmployeesDto = _mapper.Map <EmployeesDto> (objEmployees);
return(Ok(objEmployeesDto));
}
public HttpResponseMessage Edit(EmployeesDto employee, int id)
{
var repository = new EmployeesRepository();
var result = repository.Edit(employee, id);
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
/// <summary>
/// Edit department
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public IActionResult Edit(EmployeesDto dto)
{
if (!ModelState.IsValid)
{
return(Json(new
{
Result = "Faild",
Message = GetModelStateError()
}));
}
try
{
if (dto.Id == Guid.Empty)
{
dto.Id = Guid.NewGuid();
dto.CreatedTime = DateTime.Now;
dto.ModifiedTime = DateTime.Now;
}
else if (dto.Id != Guid.Empty)
{
dto.ModifiedTime = DateTime.Now;
}
if (_empAppservice.InsertOrUpdate(dto))
{
return(Json(new { Result = "Success" }));
}
return(Json(new { Result = "Faild" }));
}
catch (Exception ex)
{
return(Json(new { Result = "Faild", Message = ex.Message }));
}
}
public ResultDto UpdateEmployees([FromBody] EmployeesDto dto)
{
try
{
Employees f = _context.Employees.First(x => x.Id == dto.Id);
f.FullName = dto.FullName;
f.Position = dto.Position;
f.Phone = dto.Phone;
f.Image = dto.Image;
f.Description = dto.Description;
_context.SaveChanges();
return(new ResultDto
{
IsSuccessful = true,
Message = "Successfully created"
});
}
catch (Exception)
{
return(new ResultDto
{
IsSuccessful = false,
Message = "Something goes wrong!"
});
throw;
}
}
public async Task <IActionResult> AddEditEmployeesToStore([FromBody] JObject employeesObject)
{
var employees = new EmployeesDto(employeesObject);
var store = await ResolveStore();
await _userRepository.AddEditEmployeesToStore(store, employees.Employees);
return(Ok());
}
public HttpResponseMessage AddEmployee(EmployeesDto employee)
{
var repository = new EmployeesRepository();
var result = repository.Create(employee);
if (result)
{
return(Request.CreateResponse(HttpStatusCode.Created));
}
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "no!"));
}
public bool Edit(EmployeesDto employee, int id)
{
using (var db = GetConnection())
{
employee.EmployeeID = id;
db.Open();
var result = db.Execute(@"UPDATE [dbo].[Employee]
SET [FirstName] = @firstName
,[LastName] = @lastName
,[DepartmentID] = @departmentID
,[StartDate] = @startDate
WHERE employeeID = @employeeID", employee);
return(result == 1);
}
}
[EnableCors("AllowAll")] public IActionResult Update(string id, [FromBody] EmployeesDto employeesDto)
{
// map dto to entity and set id
Employee objEmployees = _mapper.Map <Employee> (employeesDto);
objEmployees.Id = new Guid(id);
try {
// save
_employeeservice.Update(objEmployees, employeesDto.Password);
return(Ok());
} catch (AppException ex) {
// return error message if there was an exception
return(BadRequest(ex.Message));
}
}
public bool Create(EmployeesDto employee)
{
using (var db = GetConnection())
{
db.Open();
var addEmployee = db.Execute(@"INSERT INTO [dbo].[Employee]
([FirstName]
,[LastName]
,[StartDate]
,[DepartmentID])
VALUES
(@FirstName,
@LastName,
@StartDate,
@DepartmentID)", employee);
return(addEmployee == 1);
}
}
public IActionResult GetAll([FromBody] DataTablecls objDataTablecls)
{
DataTablecls obj = objDataTablecls;
// get Start (paging start index) and length (page size for paging)
var draw = obj.draw;
var start = obj.start;
var length = obj.length;
////Get Sort columns value
var sortColumnDir = obj.order.FirstOrDefault().dir;
var index = obj.order.FirstOrDefault().column;
var sortColumn = obj.columns[index].data;
string search = obj.search.value;
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int totalRecords = 0;
var sEcho1 = Convert.ToInt32((Convert.ToInt32(start) + Convert.ToInt32(length)) / Convert.ToInt32(length));
int pageNo = !string.IsNullOrEmpty(search) ? 1 : sEcho1;
IEnumerable <Employee> lstEmployees = _employeeservice.GetAll(skip, pageSize, search);
IEnumerable <EmployeesDto> objCustomer = (from item in lstEmployees select new EmployeesDto {
Id = item.Id,
Email = item.Email,
Name = item.Name,
}).ToList();
var count = _employeeservice.GetEmployeeCount(search);
EmployeesDto UserDetails = new EmployeesDto();
UserDetails.data = objCustomer.ToList();
UserDetails.draw = draw;
UserDetails.recordsFiltered = count;
if (objCustomer.Count() > 0)
{
UserDetails.recordsTotal = count;
}
return(new ObjectResult(UserDetails));
}
public ResultDto AddEmployees([FromBody] EmployeesDto dto)
{
try
{
if (dto != null)
{
Employees newEmp = new Employees()
{
FullName = dto.FullName,
Position = dto.Position,
Phone = dto.Phone,
Image = dto.Image,
Description = dto.Description
};
_context.Employees.Add(newEmp);
_context.SaveChanges();
return(new ResultDto
{
IsSuccessful = true,
Message = "Sucessfuly add"
});
}
else
{
return(new ResultDto
{
IsSuccessful = false,
Message = "Model is null"
});
}
}
catch (Exception)
{
return(new ResultDto
{
IsSuccessful = false,
Message = "Something goes wrong"
});
}
}
/// <summary>
/// Insert or update
/// </summary>
/// <param name="dto">entity</param>
/// <returns></returns>
public bool InsertOrUpdate(EmployeesDto dto)
{
var menu = _repository.InsertOrUpdate(Mapper.Map <Employees>(dto));
return(menu == null ? false : true);
}
