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