public int AddResearcherExpertise(int researcherId, int expertiseId, string affilicatedOrgName)
{
using (ScheduleExEntities ctx = new ScheduleExEntities())
{
DataAccess.ResearcherExpertise re = new DataAccess.ResearcherExpertise();
re.ResearcherId = researcherId;
re.ExpertiseId = expertiseId;
re.AffiliatedOrgName = affilicatedOrgName;
ctx.ResearcherExpertises.Add(re);
ctx.SaveChanges();
return(re.ResearchExpertiseId);
}
}
public bool DeleteResearcherExpertise(int researcherExpertiseId)
{
using (ScheduleExEntities ctx = new ScheduleExEntities())
{
DataAccess.ResearcherExpertise re = ctx.ResearcherExpertises.FirstOrDefault(r => r.ResearchExpertiseId == researcherExpertiseId);
if (re == null)
{
return(false);
}
else
{
ctx.ResearcherExpertises.Remove(re);
ctx.SaveChanges();
return(true);
}
}
}
public bool UpdateResearcherExpertise(int researcherExpertiseId, int expertiseId, string affilicatedOrgName)
{
using (ScheduleExEntities ctx = new ScheduleExEntities())
{
DataAccess.ResearcherExpertise re = ctx.ResearcherExpertises.FirstOrDefault(r => r.ResearchExpertiseId == researcherExpertiseId);
if (re == null)
{
return(false);
}
else
{
re.ExpertiseId = expertiseId;
re.AffiliatedOrgName = affilicatedOrgName;
return(true);
}
}
}
