public string AddSkills(Skills skills)
{
using (SkillTrackerDBContext db = new SkillTrackerDBContext())
{
db.SkillsCollection.Add(skills);
db.SaveChanges();
}
return("Skills added successfully");
}
public bool AddAssociate(Associate associate)
{
using (SkillTrackerDBContext db = new SkillTrackerDBContext())
{
db.AssociateCollection.Add(associate);
db.SaveChanges();
}
return(true);
}
public List <Skills> GetAllSkills()
{
List <Skills> skillsList = new List <Skills>();
using (SkillTrackerDBContext db = new SkillTrackerDBContext())
{
skillsList = db.SkillsCollection.ToList();
}
return(skillsList);
}
public Associate GetAssociateByID(string associateId)
{
Associate associate = new Associate();
using (SkillTrackerDBContext db = new SkillTrackerDBContext())
{
associate = db.AssociateCollection.FirstOrDefault(x => x.Associate_ID == associateId);
}
return(associate);
}
public List <Associate> GetAllAssociates()
{
List <Associate> associateList = new List <Associate>();
using (SkillTrackerDBContext db = new SkillTrackerDBContext())
{
associateList = db.AssociateCollection.ToList();
}
return(associateList);
}
