public EmployeeDetailsDTO GetEmployeeDetails(string ConnectionString, long contactid)
{
string Query = string.Empty;
EmployeeDetailsDTO _EmployeeDetailsDTO = new EmployeeDetailsDTO();
string applicationid = string.Empty;
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select contactid,rolename ,designation ,to_char(dateofjoining,'dd/MM/yyyy') dateofjoining , basicsalary , allowanceorvariablepay ,totalcosttocompany,statusname from tblmstemployeeemploymentdetails t1 join tblmstemployee t2 on t1.employeeid =t2.employeeid join tblmststatus t3 on t2.statusid=t3.statusid where t2.statusid=1 and contactid=" + contactid + "; "))
{
if (dr.Read())
{
_EmployeeDetailsDTO = new EmployeeDetailsDTO
{
prolename = dr["rolename"],
pStatusName = dr["statusname"],
pdesignation = dr["designation"],
pdateofjoining = dr["dateofjoining"],
pbasicsalary = Convert.ToDecimal(dr["basicsalary"]),
pallowanceorvariablepay = dr["allowanceorvariablepay"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["allowanceorvariablepay"]),
ptotalcosttocompany = dr["totalcosttocompany"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["totalcosttocompany"]),
};
}
}
}
catch (Exception)
{
throw;
}
return(_EmployeeDetailsDTO);
}
public async Task UpdateAccount(EmployeeDetailsDTO dto)
{
var employee = await _dbContext.Employees.FindAsync(dto.Login);
if (employee == null)
{
throw new NotFoundException("Pracownik nie został znaleziony");
}
employee.FirstName = dto.FirstName;
employee.LastName = dto.LastName;
employee.PersonalId = dto.PersonalId;
_dbContext.Employees.Update(employee);
await _dbContext.SaveChangesAsync();
}
public EmployeeDetailsDTO GetEmployee(int id)
{
EmployeeDetailsDTO employee = _context.Employees.Select(e => new EmployeeDetailsDTO
{
EmployeeId = e.EmployeeId,
FirstName = e.FirstName,
LastName = e.LastName,
HiredDate = e.HiredDate,
Tasks = e.Tasks.ToList()
}).ToList().First(i => i.EmployeeId == id);
if (employee == null)
{
return(null);
}
return(employee);
}
public async Task <ActionResult> Update([FromBody] EmployeeDetailsDTO dto)
{
await _accountService.UpdateAccount(dto);
return(NoContent());
}
