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