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)); } }