/// <summary>
/// Update a New
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public bool Update(Enews e)
{
bool res = false;
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var query = (from x in db.News where x.IdNews == e.IdNews select x).FirstOrDefault();
if (query != null)
{
query.Title = e.Tittle;
query.Description = e.Description;
db.News.Update(query);
db.SaveChanges();
res = true;
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Get by IdCategory
/// </summary>
/// <returns></returns>
public List <Enews> GetAllByCategories(int id)
{
List <Enews> res = new List <Enews>();
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var query = (from x in db.News where x.IdCategory == id select x).ToList();
if (query.Any())
{
foreach (var i in query)
{
Enews e = new Enews();
e.Tittle = i.Title;
e.Description = i.Description;
res.Add(e);
}
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Devuelve todas las categorias
/// </summary>
/// <returns></returns>
public List <ECategories> GetAll()
{
List <ECategories> res = new List <ECategories>();
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var query = (from x in db.Categories select x).ToList();
if (query.Any())
{
foreach (var i in query)
{
ECategories e = new ECategories();
e.IdCategory = i.IdCategory;
e.Name = i.Name;
e.Description = i.Description;
res.Add(e);
}
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Create a category
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public int Create(ECategories e)
{
int res = 0;
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
DataAccess.Models.Categories obj = new Categories();
obj.Name = e.Name;
obj.Description = e.Description;
db.Categories.Add(obj);
db.SaveChanges();
res = obj.IdCategory;
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// update a category created
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public bool Update(ECategories e)
{
bool res = false;
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var query = (from x in db.Categories where x.IdCategory == e.IdCategory select x).FirstOrDefault();
query.Name = e.Name;
query.Description = e.Description;
db.Categories.Update(query);
db.SaveChanges();
res = true;
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Get a New by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Enews Get(int id)
{
Enews res = new Enews();
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var q = (from x in db.News where x.IdCategory == id select x).FirstOrDefault();
if (q != null)
{
res.IdCategory = q.IdCategory;
res.Tittle = q.Title;
res.Description = q.Description;
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Detele a news by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Delete(int id)
{
var res = false;
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var q = (from x in db.News where x.IdCategory == id select x).FirstOrDefault();
if (q != null)
{
db.News.Remove(q);
db.SaveChanges();
res = true;
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
/// <summary>
/// Create a News
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public int Create(Enews e)
{
var res = 0;
try
{
using (var db = new DataAccess.Models.NewsDBContext())
{
var obj = new DataAccess.Models.News();
obj.Title = e.Tittle;
obj.Description = e.Description;
db.News.Add(obj);
db.SaveChanges();
res = obj.IdNews;
}
}
catch (Exception)
{
throw;
}
return(res);
}
