public AssociateDetails GetAssociateDetails(int associateId)
{
AssociateDetails associateDetails = new AssociateDetails();
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
associateDetails.Associate = contextObj.Associate.SingleOrDefault(x => x.AssociateId == associateId);
associateDetails.AssociateSkills = contextObj.AssociateSkills.Where(x => x.associateId == associateId).ToList();
}
return(associateDetails);
}
public IHttpActionResult UpdateAssociate([FromBody] AssociateDetails associateDetails)
{
int rowAffected = dataLayer.UpdateAssociate(associateDetails);
if (rowAffected > 0)
{
return(Ok("Add Success"));
}
else
{
return(NotFound());
}
}
public List <AssociateDetails> GetAllAssociateDetails()
{
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
List <AssociateDetails> associateDetailsList = new List <AssociateDetails>();
IList <Associate> associates = contextObj.Associate.ToList();
foreach (Associate associate in associates)
{
AssociateDetails associateDetails = new AssociateDetails();
associateDetails.Associate = contextObj.Associate.SingleOrDefault(x => x.AssociateId == associate.AssociateId);
associateDetails.AssociateSkills = contextObj.AssociateSkills.Where(x => x.associateId == associate.AssociateId).ToList();
associateDetailsList.Add(associateDetails);
}
return(associateDetailsList);
}
}
public int UpdateAssociate(AssociateDetails associateDetails)
{
int returnValue = 0;
Associate associate = associateDetails.Associate;
List <AssociateSkills> associateskills = associateDetails.AssociateSkills;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
Associate empDetails = contextObj.Associate.SingleOrDefault(e => e.AssociateId == associate.AssociateId);
empDetails.Name = associate.Name;
empDetails.Email = associate.Email;
empDetails.MobileNo = associate.MobileNo;
empDetails.Image = associate.Image;
empDetails.StatusGreen = associate.StatusGreen;
empDetails.StatusBlue = associate.StatusBlue;
empDetails.StatusRed = associate.StatusRed;
empDetails.Level1 = associate.Level1;
empDetails.Level2 = associate.Level2;
empDetails.Level3 = associate.Level3;
empDetails.Remarks = associate.Remarks;
empDetails.Strength = associate.Strength;
empDetails.Weakness = associate.Weakness;
if (associateskills != null)
{
foreach (AssociateSkills associateskill in associateskills)
{
AssociateSkills empSkill = contextObj.AssociateSkills.SingleOrDefault(x => x.associateId == associateskill.associateId && x.skillid == associateskill.skillid);
if (empSkill != null)
{
empSkill.rating = associateskill.rating;
}
else
{
contextObj.AssociateSkills.Add(associateskill);
}
}
}
returnValue = contextObj.SaveChanges();
}
return(returnValue);
}
public int AddAssociate(AssociateDetails associateDetails)
{
int returnValue = 0;
Associate associate = associateDetails.Associate;
List <AssociateSkills> associateskills = associateDetails.AssociateSkills;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
contextObj.Associate.Add(associate);
if (associateskills != null)
{
foreach (AssociateSkills associateskill in associateskills)
{
contextObj.AssociateSkills.Add(associateskill);
}
}
returnValue = contextObj.SaveChanges();
}
return(returnValue);
}
public AssociateDetails Post([FromBody] AssociateDetails request)
{
var response = this.mediator.Send(new CreateAssociateDetailsRequest(request));
return(response.Result);
}
