public int AddSkills(SkillSet skill)
{
int returnValue = 0;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
contextObj.SkillSet.Add(skill);
returnValue = contextObj.SaveChanges();
}
return(returnValue);
}
public int DeleteSkills(int skillId)
{
int returnValue = 0;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
SkillSet skillToDelete = contextObj.SkillSet.SingleOrDefault(x => x.Skillid == skillId);
contextObj.SkillSet.Remove(skillToDelete);
returnValue = contextObj.SaveChanges();
}
return(returnValue);
}
public int UpdateSkills(SkillSet skill)
{
int returnValue = 0;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
SkillSet skillToUpdate = contextObj.SkillSet.SingleOrDefault(x => x.Skillid == skill.Skillid);
skillToUpdate.Skillname = skill.Skillname;
returnValue = contextObj.SaveChanges();
}
return(returnValue);
}
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 DeleteAssociateDetails(int associateId)
{
int returnValue = 0;
using (SkillTrackerDBFunctions contextObj = new SkillTrackerDBFunctions())
{
Associate associate = contextObj.Associate.SingleOrDefault(s => s.AssociateId == associateId);
contextObj.Associate.Remove(associate);
List <AssociateSkills> associateSkill = contextObj.AssociateSkills.Where(s => s.associateId == associateId).ToList();
if (associateSkill != null)
{
contextObj.AssociateSkills.RemoveRange(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);
}
