public string UpdateSkill(SkillDetailsModel skill)
{
using (var dbContext = new SkillTrackerDBContext())
{
var sk = dbContext.SkillDetails.Where(a => a.Skill_Id.Equals(skill.SkillId)).SingleOrDefault();
sk.Skill_Name = skill.SkillName;
dbContext.SaveChanges();
return("Skill Successfully Updated");
}
}
public string AddSkill(SkillDetailsModel skill)
{
using (var dbContext = new SkillTrackerDBContext())
{
var addskill = new skill_details()
{
Skill_Id = skill.SkillId, Skill_Name = skill.SkillName
};
dbContext.SkillDetails.Add(addskill);
dbContext.SaveChanges();
return("Skill Successfully Inserted");
}
}
public List <SkillDetailsModel> GetAllSkillDetails()
{
var model = new List <SkillDetailsModel>();
using (var dbContext = new SkillTrackerDBContext())
{
model = dbContext.SkillDetails
.Select(x => new SkillDetailsModel()
{
SkillId = x.Skill_Id, SkillName = x.Skill_Name
})
.ToList();
}
return(model);
}
public string DeleteSkill(SkillDetailsModel skill)
{
using (var dbContext = new SkillTrackerDBContext())
{
var skilldet = dbContext.SkillDetails.Where(a => a.Skill_Id.Equals(skill.SkillId))
.SingleOrDefault();
var associateskills = dbContext.AssociateSkill.Where(i => i.Skill_Id == skill.SkillId).ToList();
foreach (var it in associateskills)
{
var associate = dbContext.AssociateSkill.Where(i => i.Associate_SkillID == it.Associate_SkillID);
dbContext.AssociateSkill.Remove(it);
}
dbContext.SkillDetails.Remove(skilldet);
dbContext.SaveChanges();
return("Skill Details Successfully deleted");
}
}
public AssociateSkillsModel GetAssociateSkillDetails(int associateId)
{
var model = new AssociateSkillsModel();
using (var dbContext = new SkillTrackerDBContext())
{
if (associateId == 0)
{
model.AssociateDetails = new AssociateModel();
model.Skills = dbContext.SkillDetails
.Select(x => new AssociateSkillMappingModel()
{
AssociateSkillID = 0,
AssociateID = associateId,
SkillId = x.Skill_Id,
SkillName = x.Skill_Name,
SkillRate = 0
})
.ToList();
}
else
{
model.AssociateDetails = new AssociateModel();
model.Skills = dbContext.SkillDetails
.Select(x => new AssociateSkillMappingModel()
{
AssociateSkillID = 0,
AssociateID = associateId,
SkillId = x.Skill_Id,
SkillName = x.Skill_Name,
SkillRate = 0
})
.ToList();
}
}
return(model);
}