/// <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>
/// 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>
/// 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);
}
