/// <summary> /// Initialize DAO /// </summary> /// <param name="connexionString">Connection chain</param> public static void DAOInitialize(string connexionString) { _objDaoLogin = DAOLogin.getInstance(); _objDaoLogin.ConnectionString = connexionString; _objDaoTopic = DAOTopic.getInstance(); _objDaoTopic.ConnectionString = connexionString; _objDaoRubric = DAORubric.getInstance(); _objDaoRubric.ConnectionString = connexionString; _objDaoTopicReply = DAOTopicReply.getInstance(); _objDaoTopicReply.ConnectionString = connexionString; }
public void Test_DeleteTopic() { // Arrange DAOTopic objDaoTopic = DAOTopic.getInstance(); Controller.DAOInitialize("Data Source=176.31.248.137;Initial Catalog=user19;Persist Security Info=True;User ID=user19;Password=274user19"); // Look at TOPIC table for initialize topicId int topicId = 1; // Act // Assert Assert.IsTrue(objDaoTopic.DeleteTopicInDb(topicId)); }
public void Test_GetTopicById() { // Arrange DAOTopic objDaoTopic = DAOTopic.getInstance(); Controller.DAOInitialize("Data Source=176.31.248.137;Initial Catalog=user19;Persist Security Info=True;User ID=user19;Password=274user19"); Topic topic = new Topic(); // Act topic = objDaoTopic.GetTopicById(3); // Assert Assert.IsTrue(topic.TopicId == 3); }
public void Test_EditTopic() { // Arrange DAOTopic objDaoTopic = DAOTopic.getInstance(); Controller.DAOInitialize("Data Source=176.31.248.137;Initial Catalog=user19;Persist Security Info=True;User ID=user19;Password=274user19"); Topic topic = new Topic(); topic.TopicId = 3; topic.Title = "UnitTest Title Edit"; topic.Description = "UnitTest Description Edit"; topic.DateUp = DateTime.Now; // Act // Assert Assert.IsTrue(objDaoTopic.EditTopicInDb(topic)); }
public void Test_CreateTopic() { // Arrange string replyContent Controller.DAOInitialize("Data Source=176.31.248.137;Initial Catalog=user19;Persist Security Info=True;User ID=user19;Password=274user19"); DAOTopic objDaoTopic = DAOTopic.getInstance(); Topic newTopic = new Topic(); newTopic.Person.PersonId = 1; newTopic.TypeTopic = 1; newTopic.Rubric.RubricId = 1; newTopic.Title = "UnitTest Title"; newTopic.Description = "UnitTest Description"; newTopic.DateAdd = DateTime.Now; newTopic.DateUp = newTopic.DateAdd; newTopic.Message = "UnitTest Message"; // Act // Assert Assert.IsTrue(objDaoTopic.CreateTopic(newTopic, newTopic.Person.PersonId)); }
/// <summary> /// Uses the method of creating a topic in the db /// </summary> /// <param name="topic">the topic</param> /// <param name="personId">user id</param> public static void CreateTopic(Topic topic, int personId) { _objDaoTopic = DAOTopic.getInstance(); _objDaoTopic.CreateTopic(topic, personId); }
/// <summary> /// Uses the method of retrieval the last ten topics from the rubric in the db /// </summary> /// <param name="rubricId">id of the rubric</param> /// <returns>topic list</returns> public static List <Topic> GetLastTopicTop10ById(int rubricId) { _objDaoTopic = DAOTopic.getInstance(); return(_objDaoTopic.GetLastTopicTop10ById(rubricId)); }
/// <summary> /// Uses the method of retrieval latest ten topic in the db /// </summary> /// <returns>topic list</returns> public static List <Topic> GetLastTopicTop10() { _objDaoTopic = DAOTopic.getInstance(); return(_objDaoTopic.GetLastTopicTop10()); }
/// <summary> /// Uses the method of deleting a topic in db /// </summary> /// <param name="topicId">topic id</param> public static void DeleteTopicInDb(int topicId) { _objDaoTopic = DAOTopic.getInstance(); _objDaoTopic.DeleteTopicInDb(topicId); }
/// <summary> /// Uses the method of editing a topic in db /// </summary> /// <param name="topic">topic</param> public static void EditTopicInDb(Topic topic) { _objDaoTopic = DAOTopic.getInstance(); _objDaoTopic.EditTopicInDb(topic); }
/// <summary> /// Uses the method of retrieving a topic in db /// </summary> /// <param name="topicId">topic id</param> /// <returns>topic</returns> public static Topic GetTopicById(int topicId) { _objDaoTopic = DAOTopic.getInstance(); return(_objDaoTopic.GetTopicById(topicId)); }