public Film GetFilInfo(int id)
{
using (StarWarsEntities1 ent = new StarWarsEntities1())
{
return(ent.Film.Where(x => x.Id == id).FirstOrDefault());
}
}
public List <Film> GetLastVisited()
{
using (StarWarsEntities1 ent = new StarWarsEntities1())
{
return(ent.Film.Where(x => x.visited).OrderByDescending(x => x.edited).Take(2).ToList());
}
}
public bool CheckLastUpdate()
{
using (StarWarsEntities1 ent = new StarWarsEntities1())
{
var Check = ent.Film.OrderBy(x => x.edited).Select(x => x.edited).FirstOrDefault();
if (Check == null)
{
return(true);
}
return(DateTime.Parse(Check.Value.ToShortDateString()) < DateTime.Parse(DateTime.UtcNow.ToShortDateString()));
}
}
public void UpdateData()
{
try
{
if (_dataAcces.CheckLastUpdate())
{
string json = _dataAcces.GetData();
var data = MapData(json);
using (Data.Entity.StarWarsEntities1 ent = new StarWarsEntities1())
{
foreach (var item in data)
{
var id = int.Parse(item.episode_id);
var film = ent.Film.Where(x => x.Id == id).FirstOrDefault();
if (film != null)
{
film.opening_crawl = item.opening_crawl;
film.director = item.director;
film.producer = item.producer;
film.url = item.url;
film.Title = item.title;
film.edited = DateTime.Now;
film.releasedate = DateTime.Parse(item.release_date.Replace('-', '/'));
film.visited = false;
}
else
{
ent.Film.Add(new Film()
{
Id = int.Parse(item.episode_id),
opening_crawl = item.opening_crawl,
director = item.director,
producer = item.producer,
url = item.url,
Title = item.title,
created = DateTime.Now,
edited = DateTime.Now,
releasedate = DateTime.Parse(item.release_date.Replace('-', '/'))
});
}
}
ent.SaveChanges();
}
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
string mess = e.InnerException.ToString();
}
}
}
public List <Film> GetResults(String Title)
{
using (StarWarsEntities1 ent = new StarWarsEntities1())
{
var List = ent.Film.Where(x => x.Title.ToLower().Contains(Title.ToLower())).ToList();
if (List.Count > 0)
{
foreach (var it in List)
{
var film = ent.Film.Where(x => x.Id == it.Id).FirstOrDefault();
film.edited = DateTime.Now;
film.visited = true;
}
}
ent.SaveChanges();
return(List);
}
}