private void Initialize( ExpertiseDAO expertise, int id, int expertiseID, int applicantID, int skillID )
{
expertise.ID = id;
expertise.ExpertiseID = expertiseID;
expertise.ApplicantID = applicantID;
expertise.SkillID = skillID;
}
public void Test_UpdateExpertise()
{
ExpertiseDAO expertise4 = new ExpertiseDAO() { ID = 4, ExpertiseID = 3, ApplicantID = 4, SkillID = 4 };
expertiseService.UpdateExpertise(expertise4);
Assert.AreEqual(expertiseService.GetExpertiseByID(3).ApplicantID, 4);
Assert.AreEqual(expertiseService.GetExpertises().Count, 3);
}
public void Test_CreateExpertise()
{
ExpertiseDAO expertise4 = new ExpertiseDAO() { ID = 4, ExpertiseID = 4, ApplicantID = 4, SkillID = 4 };
expertiseService.CreateExpertise(expertise4);
Assert.IsNotNull(expertiseService.GetExpertiseByID(3));
Assert.AreEqual(expertiseService.GetExpertises().Count, 4);
}
internal void SetUp()
{
ExpertiseDAO expertise1 = new ExpertiseDAO() { ID = 1, ExpertiseID = 1, ApplicantID = 1, SkillID = 1 };
ExpertiseDAO expertise2 = new ExpertiseDAO() { ID = 2, ExpertiseID = 2, ApplicantID = 2, SkillID = 2 };
ExpertiseDAO expertise3 = new ExpertiseDAO() { ID = 3, ExpertiseID = 3, ApplicantID = 3, SkillID = 3 };
Expertises.Add(expertise1);
Expertises.Add(expertise2);
Expertises.Add(expertise3);
}
public bool UpdateExpertise(ExpertiseDAO newExp)
{
foreach(var expertise in Expertises)
if(expertise.ExpertiseID == newExp.ExpertiseID)
{
Expertises.Remove(expertise);
Expertises.Add(newExp);
return true;
}
return false;
}
public bool CreateExpertise(ExpertiseDAO e)
{
Expertises.Add(e);
return true;
}
public bool UpdateExpertise(ExpertiseDAO newExp)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason("Unsupported Method"));
}
public bool CreateExpertise(ExpertiseDAO exp)
{
Expertise e = new Expertise
{
Applicant_ID = exp.ApplicantID,
Expertise_ID = exp.ExpertiseID,
Skill_ID = exp.SkillID
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.Expertises.InsertOnSubmit(e);
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(ex.Message));
}
}
return true;
}
public IList<ExpertiseDAO> GetExpertises()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Expertise> exps = db.Expertises.ToList();
List<ExpertiseDAO> result = new List<ExpertiseDAO>();
foreach (var e in exps)
{
ExpertiseDAO temp = new ExpertiseDAO
{
ID = e.Expertise_ID,
ExpertiseID = e.Expertise_ID,
ApplicantID = e.Applicant_ID,
SkillID = e.Skill_ID
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public ExpertiseDAO GetExpertiseByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Expertise expertise = (from exp in db.Expertises where exp.Expertise_ID == id select exp).FirstOrDefault();
ExpertiseDAO result = new ExpertiseDAO
{
ID = expertise.Expertise_ID,
ExpertiseID = expertise.Expertise_ID,
ApplicantID = expertise.Applicant_ID,
SkillID = expertise.Skill_ID
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
