/// <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);
}
public IActionResult Update([FromBody] Enews e)
{
var res = daNews.Update(e);
if (res)
{
return(Ok());
}
return(BadRequest());
}
public void Create()
{
DA.Business.DaNews _da = new DA.Business.DaNews();
Enews e = new Enews();
e.Tittle = "Categoria Prueba";
e.Description = "Descri Prueba";
var res = _da.Create(e);
Assert.IsNotNull(res);
}
public IActionResult Create([FromBody] Enews e, int IdCategories)
{
e.IdCategory = IdCategories;
var res = daNews.Create(e);
if (res > 0)
{
return(new CreatedAtRouteResult("CreateNews", new { id = res }, e));
}
return(BadRequest());
}
/// <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>
/// 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);
}
