public void TestMessageStorageRepoWriting()
{
using (DatabaseEntities context = new DatabaseEntities())
{
MessageStorage message = new MessageStorage { ID = 100000, MsgOwner = "Srg", Data = "Hello", Name = "World" };
context.MessageStorages.Add(message);
context.SaveChanges();
context.MessageStorages.Remove(message);
context.SaveChanges();
}
}
public void TestForumFunctionality()
{
using (DatabaseEntities context = new DatabaseEntities())
{
News newsItm = new News { Date = DateTime.Now, ID = 356, Name = "Test", NewsContent = "Testing" };
context.News.Add(newsItm);
Theme newTheme = new Theme
{
Created_on = DateTime.Now,
ID = (new Random((int)DateTime.Now.Ticks)).Next(),
Name = "Test Theme",
Description = "Hello World",
Subgroup = "All"
};
Topic newTopic = new Topic()
{
Created_on = DateTime.Now,
Description = "Hello world topic",
ID = (new Random((int)DateTime.Now.Ticks)).Next(),
Name = "Test Topic",
Theme = newTheme.ID
};
Message newMessage = new Message()
{
Created_on = DateTime.Now,
ID = (new Random((int)DateTime.Now.Ticks)).Next(),
Text = "hello",
Topic = newTopic.ID
};
context.Themes.Add(newTheme);
context.Topics.Add(newTopic);
context.Messages.Add(newMessage);
context.SaveChanges();
Assert.IsTrue(context.Themes.Count(x => x.ID == newTheme.ID) > 0);
Assert.IsTrue(context.Topics.Count(x => x.ID == newTopic.ID) > 0);
Assert.IsTrue(context.Messages.Count(x => x.ID == newMessage.ID) > 0);
context.Themes.Remove(newTheme);
context.Topics.Remove(newTopic);
context.Messages.Remove(newMessage);
context.News.Remove(newsItm);
context.SaveChanges();
}
}
public void TestNewsAndUsrTbl()
{
using (DatabaseEntities context = new DatabaseEntities())
{
int count_news = (from msg in context.News select msg).Count();
Assert.IsTrue(count_news > 0);
}
}
public void TestNewsAndUsrTblWriting()
{
using (DatabaseEntities context = new DatabaseEntities())
{
News entity = new News { Date = DateTime.Now, ID = 123456, Name = "Hello", NewsContent = "World" };
context.News.Add(entity);
context.SaveChanges();
context.News.Remove(entity);
context.SaveChanges();
}
}
