public IEnumerable <TeamDetailDto> GetAllTeams()
{
List <TeamDetailDto> TeamList = new List <TeamDetailDto>();
try
{
var allTeam = Context.TeamDetails.ToList();
foreach (TeamDetails teamDetail in allTeam)
{
TeamDetailDto team = new TeamDetailDto();
team.TeamId = teamDetail.TeamID;
team.TeamName = teamDetail.TeamName;
team.TeamDicription = teamDetail.TeamDiscription;
team.LeadName = teamDetail.TeamLeadName;
TeamList.Add(team);
}
}
catch (SqlException expSql)
{
throw expSql;
}
catch (NullReferenceException expNull)
{
throw expNull;
}
return(TeamList);
}
public IActionResult AddNewTeam([FromBody] TeamDetailDto newTeam,
[FromHeader(Name = "id_token")] string googleToken)
{
try
{
if (googleAuth.ProcessRequestAtGoogle(googleToken))
{
var TeamAddStatus = empRepository.AddTeam(newTeam);
return(Ok(Json(TeamAddStatus)));
}
else
{
return(BadRequest());
}
}
catch (Exception exp)
{
return(NotFound(@"Can't add the given Team"));
}
}
/*
* This method to add new team to the Db with given Details
*/
public int AddTeam(TeamDetailDto toAddTeam)
{
TeamDetails teamData = new TeamDetails();
try
{
teamData.TeamDiscription = toAddTeam.TeamDicription;
teamData.TeamLeadName = toAddTeam.LeadName;
teamData.TeamName = toAddTeam.TeamName;
Context.TeamDetails.Add(teamData);
Context.SaveChanges();
}
catch (SqlException sqlExp)
{
throw sqlExp;
}
catch (NullReferenceException expNull)
{
throw expNull;
}
return(teamData.TeamID);
}
/*
* This method returns only the Employee Details of given employeeID
*/
public EmployeeDto EmployeeDetails(int emplId)
{
try
{
var Employee = Context.Employees
.Include(emp => emp.ContactDetails)
.Include(emp => emp.DepartmentDetails)
.Include(emp => emp.EmployeeBiography)
.Include(emp => emp.employeeRoles)
.Include(emp => emp.TeamDetails)
.Include(emp => emp.EmployeeBiography)
.FirstOrDefault(emp => emp.EmployeeId == emplId);
var skills = Context.EmployeeSkills
.Include(s => s.skills)
.Where(s => s.EmployeeId == Employee.EmployeeId)
.Select(s => new EmployeeSkillsDto
{
SkillName = s.skills.SkillName,
SkillLevel = s.SkillLevel,
EmployeeId = s.EmployeeId,
SkillId = s.SkillId
}).ToList();
EmployeeDto empl = new EmployeeDto();
RolesDto role = new RolesDto();
DepartmentDetailsDto depart = new DepartmentDetailsDto();
TeamDetailDto team = new TeamDetailDto();
ContactDto contact = new ContactDto();
BioGraphyDto bio = new BioGraphyDto();
empl.FirstName = Employee.FirstName;
empl.LastName = Employee.LastName;
empl.EmployeeId = Employee.EmployeeId;
empl.Dob = Employee.Dob;
empl.JoiningDate = Employee.JoiningDate;
empl.EmailId = Employee.EmailID;
empl.PhotoUrl = Employee.EmployeePhotoURL;
empl.SPOC = Employee.SPOC;
role.RoleName = Employee.employeeRoles.RoleName;
empl.Role = role;
depart.DepartmentName = Employee.DepartmentDetails.DepartmentName;
empl.Departmnent = depart;
team.TeamName = Employee.TeamDetails.TeamName;
team.LeadName = Employee.TeamDetails.TeamLeadName;
empl.Team = team;
contact.Address = Employee.ContactDetails.Address;
contact.MobileOffice = Employee.ContactDetails.MobNumberOff;
contact.MobilePersonal = Employee.ContactDetails.MobNumberPersonal;
contact.SkypeId = Employee.ContactDetails.SkypeID;
contact.SlackId = Employee.ContactDetails.SlackID;
contact.FBLink = Employee.ContactDetails.FBLink;
contact.TwitterLink = Employee.ContactDetails.TwitterLink;
contact.GitHubLink = Employee.ContactDetails.GitHubLink;
contact.LinkdinLink = Employee.ContactDetails.linkdinLink;
empl.ContactDetail = contact;
bio.About = Employee.EmployeeBiography.About;
bio.Hobbies = Employee.EmployeeBiography.Hobbies;
bio.Interests = Employee.EmployeeBiography.Interests;
empl.Bio = bio;
foreach (EmployeeSkillsDto empSkill in skills)
{
empl.EmployeeSkills.Add(empSkill);
}
return(empl);
}
catch (SqlException exSql)
{
throw exSql;
}
catch (NullReferenceException expNull)
{
throw expNull;
}
}