public static bool DeleteNewsModifiaction(int modificationId)
{
ISession session = null;
bool result = false;
try
{
session = DataLayer.GetSession();
NewsModified modification = session.Load <NewsModified>(modificationId);
session.Delete(modification);
session.Flush();
session.Close();
result = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public SimpleNewsDTO UpdateNews(SimpleNewsDTO simpleDTO, int userId)
{
SimpleNewsDTO result = null;
ISession session = null;
try
{
session = DataLayer.GetSession();
User user = session.Load <User>(userId);
News news = session.Load <News>(simpleDTO.Id);
news.Title = simpleDTO.Title;
news.Content = simpleDTO.Content;
if (simpleDTO.BackgroundPicture != null && news.BackgroundPicture == null)
{
news.BackgroundPicture = ExpandBackgroundPicture(simpleDTO.BackgroundPicture);
}
else if (simpleDTO.BackgroundPicture == null)
{
news.BackgroundPicture = null;
}
news.LastModified = DateTime.Now;
NewsModified modification = new NewsModified();
modification.ModificationDate = DateTime.Now;
modification.News = news;
modification.User = user;
session.SaveOrUpdate(news);
session.Save(modification);
session.Flush();
result = new SimpleNewsDTO(news);
session.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public static bool CreateNews(string title, string content,
int userId)
{
bool result = false;
ISession session = null;
try
{
session = DataLayer.GetSession();
News news = new News();
User user = session.Load <User>(userId);
NewsModified modifiaction = new NewsModified();
modifiaction.ModificationDate = DateTime.Now;
modifiaction.User = user;
modifiaction.News = news;
news.LastModified = DateTime.Now;
news.Title = title;
news.Content = content;
//news.Pictures = new List<Picture>();
//news.AudioRecordings = new List<Audio>();
news.Modifications = new List <NewsModified>();
news.Modifications.Add(modifiaction);
ITransaction transaction = session.BeginTransaction();
session.Save(news);
session.Save(modifiaction);
session.Flush();
transaction.Commit();
session.Close();
result = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
//postoji li nacin da se naprave vrste modifikacija i da se u runtime odredjuje tip, pa da se i to nekako loguje
//slicno kao command pattern
public static bool UpdateNews(int userId, int newsId,
string title, string content)
{
bool result = false;
ISession session = null;
try
{
session = DataLayer.GetSession();
User user = session.Load <User>(userId);
News news = session.Load <News>(newsId);
news.Title = title;
news.Content = content;
news.LastModified = DateTime.Now;
NewsModified modification = new NewsModified();
modification.ModificationDate = DateTime.Now;
modification.News = news;
modification.User = user;
session.SaveOrUpdate(news);
session.Save(modification);
session.Flush();
session.Close();
result = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}
public NewsDTO CreateNews(NewsDTO news, int userId)
{
NewsDTO result = null;
ISession session = null;
try
{
session = DataLayer.GetSession();
News newNews = ExpandDTO(news);
newNews.LastModified = DateTime.Now;
User user = session.Load <User>(userId);
NewsModified modified = new NewsModified();
modified.News = newNews;
modified.User = user;
modified.ModificationDate = DateTime.Now;
modified.News = newNews;
newNews.Modifications.Add(modified);
ITransaction transaction = session.BeginTransaction();
session.SaveOrUpdate(newNews);
// session.Save(modified);
session.Flush();
transaction.Commit();
result = new NewsDTO(newNews);
session.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
if (session != null)
{
session.Close();
}
}
return(result);
}