/// <summary>
/// Deprecated Method for adding a new object to the histories EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTohistories(histories histories)
{
base.AddObject("histories", histories);
}
/// <summary>
/// Create a new histories object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
public static histories Createhistories(global::System.Int64 id)
{
histories histories = new histories();
histories.id = id;
return histories;
}
public void AddToHistory(Episode episode, NzbInfo nzb)
{
using (SABSyncEntities sabSyncEntities = new SABSyncEntities())
{
var data = (from e in sabSyncEntities.episodes.AsEnumerable()
where
e.shows.show_name.Equals(episode.ShowName, StringComparison.InvariantCultureIgnoreCase) && e.episode_number == episode.EpisodeNumber &&
e.season_number == episode.SeasonNumber
select new
{
ShowId = e.shows.id,
EpisodeId = e.id
}).FirstOrDefault();
if (data == null)
{
data = (from e in sabSyncEntities.episodes.AsEnumerable()
where
e.shows.show_name.Equals(episode.ShowName, StringComparison.InvariantCultureIgnoreCase) &&
Convert.ToDateTime(e.air_date) == episode.AirDate
select new
{
ShowId = e.shows.id,
EpisodeId = e.id
}).FirstOrDefault();
}
histories newItem = new histories
{
id = new long(),
show_id = data.ShowId,
episode_id = data.EpisodeId,
feed_title = episode.FeedItem.Title,
quality = episode.Quality,
proper = Convert.ToInt32(episode.IsProper),
provider = nzb.Site.Name,
date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")
};
Logger.Log("Episode added to History Database: {0} - S{1}E{2}", episode.ShowName, episode.SeasonNumber.ToString("00"), episode.EpisodeNumber.ToString("00"));
sabSyncEntities.AddTohistories(newItem);
sabSyncEntities.SaveChanges();
}
}
