static CommentPersistence()
{
comments = new List <Comment>();
String sql = "select * from COMMENT";
List <object[]> rows = RepositoryManager.Repository.DoQuery(sql);
foreach (object[] dataRow in rows)
{
Comment comment = new Comment
{
CommentId = (long)dataRow[0],
Title = (string)dataRow[1],
Content = (string)dataRow[2],
Writer = UserPersistence.GetUser((String)dataRow[3]),
Service = ServicePersistence.GetService((String)dataRow[4])
};
comments.Add(comment);
}
}
static ServicePersistence()
{
services = new List <Service>();
String sql = "select * from SERVICE";
List <object[]> rows = RepositoryManager.Repository.DoQuery(sql);
foreach (object[] dataRow in rows)
{
DateTime addDate = Convert.ToDateTime(dataRow[4]);
Service service = new Service
{
Title = (string)dataRow[0],
Description = (string)dataRow[1],
Owner = UserPersistence.GetUser(dataRow[2].ToString()),
Category = (string)dataRow[3],
Comments = null,//will change!!!!!
date = addDate
};
service.Comments = CommentPersistence.getCommentsForaService(service);
services.Add(service);
}
}