public async Task <entities.News> getNewsgById(Guid id)
{
using (var db = new MedellinTimesContext())
{
return(await db.News.FirstAsync(n => n.Id == id));
}
}
public entities.Advertising getAdvertisingById(Guid id)
{
using (var db = new MedellinTimesContext())
{
return(db.Advertising.First(a => a.Id == id));
}
}
public entities.Event getEventById(Guid id)
{
using (var db = new MedellinTimesContext())
{
return(db.Event.First(e => e.Id == id));
}
}
public async void updateNewa(entities.News news)
{
using (var db = new MedellinTimesContext())
{
db.Entry(news).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
public void saveAdvertising(entities.Advertising advertising)
{
using (var db = new MedellinTimesContext())
{
db.Advertising.Add(advertising);
db.SaveChanges();
}
}
public void saveNews(entities.News news)
{
using (var db = new MedellinTimesContext())
{
news.Id = Guid.NewGuid();
news.DatePublish = DateTime.Now;
db.News.Add(news);
db.SaveChanges();
}
}
public async Task <List <entities.News> > getAllNews()
{
using (var db = new MedellinTimesContext())
{
try
{
return(await db.News.ToListAsync());
}
catch (Exception e)
{
return(null);
}
}
}
public async Task <List <entities.Advertising> > getAllAdvertising()
{
using (var db = new MedellinTimesContext())
{
try
{
return(await db.Advertising.OrderByDescending(e => e.DateCreation).ToListAsync());
}
catch
{
return(null);
}
}
}
public void saveEvent(entities.Event evento)
{
using (var db = new MedellinTimesContext())
{
try
{
db.Event.Add(evento);
db.SaveChanges();
}
catch (Exception e)
{
var error = e.Message;
}
}
}
public async Task <entities.Advertising> deleteAdvertising(Guid Id)
{
using (var db = new MedellinTimesContext())
{
try
{
entities.Advertising deleteAdvertising = getAdvertisingById(Id);
db.Entry(deleteAdvertising).State = EntityState.Deleted;
await db.SaveChangesAsync();
return(deleteAdvertising);
}
catch (Exception e)
{
var error = e.Message;
return(null);
}
}
}
public async Task <entities.Event> deleteEvent(Guid Id)
{
var isDelete = false;
using (var db = new MedellinTimesContext())
{
try
{
var deleteEvent = getEventById(Id);
db.Entry(deleteEvent).State = EntityState.Deleted;
await db.SaveChangesAsync();
return(deleteEvent);
}
catch
{
return(null);
}
}
}
public async Task <entities.News> deleteNews(Guid id)
{
var isdelete = false;
using (var db = new MedellinTimesContext())
{
try
{
var deleteNews = await getNewsgById(id);
db.Entry(deleteNews).State = EntityState.Deleted;
await db.SaveChangesAsync();
return(deleteNews);
}
catch
{
return(null);
}
}
}
public async Task <Boolean> updateAdvertising(entities.Advertising advertising)
{
using (var db = new MedellinTimesContext())
{
try {
/*
* var updateAdvertising = await db.Advertising.FirstAsync(a => a.Id == advertising.Id);
* updateAdvertising.Title = advertising.Title;
* updateAdvertising.Descriotion = advertising.Descriotion;
* updateAdvertising.PathImage = advertising.PathImage;
*/
db.Entry(advertising).State = EntityState.Modified;
await db.SaveChangesAsync();
return(true);
}
catch {
return(false);
}
}
}
public async Task <bool> updateEvent(entities.Event evento)
{
var isupdtae = false;
using (var db = new MedellinTimesContext())
{
try
{
/* var updateEvent = await db.Event.FirstAsync(e => e.Id == evento.Id);
* updateEvent.Name = evento.Name;
* updateEvent.Description = evento.Description;
* updateEvent.Adress = evento.Adress;
*/
db.Entry(evento).State = EntityState.Modified;
await db.SaveChangesAsync();
return(isupdtae = true);
}
catch (Exception e)
{
return(isupdtae = false);
}
}
}
