public void Test_UpdateSAQuestion() { SAQuestionDAO saQuest2 = new SAQuestionDAO() { ID = 2, SAQuestionID = 2, SAQuestionDescription = "TestDesc2" }; Assert.IsTrue(SAQService.UpdateSAQuestion(saQuest2)); Assert.AreEqual(SAQService.GetSAQuestionByID(2).SAQuestionDescription, "TestDesc2"); }
public void Test_CreateSAQuestion() { SAQuestionDAO saQuest3 = new SAQuestionDAO() { ID = 3, SAQuestionID = 3, SAQuestionDescription = "Desc3" }; Assert.IsTrue(SAQService.CreateSAQuestion(saQuest3)); Assert.AreEqual(SAQService.GetSAQuestions().Count, 4); }
internal void SetUp() { SAQuestionDAO saQuest0 = new SAQuestionDAO() { ID = 0, SAQuestionID = 0, SAQuestionDescription = "Desc0" }; SAQuestionDAO saQuest1 = new SAQuestionDAO() { ID = 1, SAQuestionID = 1, SAQuestionDescription = "Desc1" }; SAQuestionDAO saQuest2 = new SAQuestionDAO() { ID = 2, SAQuestionID = 2, SAQuestionDescription = "Desc2" }; SAQuestions.Add(saQuest0); SAQuestions.Add(saQuest1); SAQuestions.Add(saQuest2); }
public bool UpdateSAQuestion(SAQuestionDAO newSAQuestion) { foreach (var value in SAQuestions) if (value.SAQuestionID == newSAQuestion.SAQuestionID) { SAQuestions.Remove(value); SAQuestions.Add(newSAQuestion); return true; } return false; }
private void Initialize( SAQuestionDAO SAQuestion, int id, int saQuestionID, string saQuestionDesc ) { SAQuestion.ID = id; SAQuestion.SAQuestionID = saQuestionID; SAQuestion.SAQuestionDescription = saQuestionDesc; }
public bool CreateSAQuestion(SAQuestionDAO e) { SAQuestions.Add(e); return true; }
public bool CreateSAQuestion(SAQuestionDAO s) { SAQuestion sAQuestion = new SAQuestion { SAQuestion_ID = s.SAQuestionID, SAQuestionDescription = s.SAQuestionDescription }; using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { db.SAQuestions.InsertOnSubmit(sAQuestion); try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public bool UpdateSAQuestion(SAQuestionDAO newSAQuestion) { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { SAQuestion sAQuestion = db.SAQuestions.Single(s => s.SAQuestion_ID == newSAQuestion.SAQuestionID); sAQuestion.SAQuestion_ID = newSAQuestion.SAQuestionID; sAQuestion.SAQuestionDescription = newSAQuestion.SAQuestionDescription; try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public IList<SAQuestionDAO> GetSAQuestions() { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { IList<SAQuestion> sAQuestions = db.SAQuestions.ToList(); List<SAQuestionDAO> result = new List<SAQuestionDAO>(); foreach (var sAQuestion in sAQuestions) { SAQuestionDAO temp = new SAQuestionDAO { ID = sAQuestion.SAQuestion_ID, SAQuestionID = sAQuestion.SAQuestion_ID, SAQuestionDescription = sAQuestion.SAQuestionDescription }; result.Add(temp); } return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }
public SAQuestionDAO GetSAQuestionByID(int id) { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { SAQuestion sAQuestion = (from saqu in db.SAQuestions where saqu.SAQuestion_ID == id select saqu).FirstOrDefault(); SAQuestionDAO result = new SAQuestionDAO { ID = sAQuestion.SAQuestion_ID, SAQuestionID = sAQuestion.SAQuestion_ID, SAQuestionDescription = sAQuestion.SAQuestionDescription }; return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }