public static bool DeleteArticulo(int IdArticulo)
{
using (InventioEntities context = new InventioEntities())
{
Articulo data = (from datos in context.Articulo
where datos.ID == IdArticulo
select datos).First<Articulo>();
if (data != null)
{
context.Articulo.DeleteObject(data);
context.SaveChanges();
}
// Eliminamos los comentarios del artículo ?
List<Comentario> comentarios = (from datos in context.Comentarios
where datos.IDArticulo == IdArticulo
select datos).ToList<Comentario>();
if (comentarios != null)
{
foreach (Comentario comentario in comentarios)
{
ComentarioDal.DeleteComentario(comentario.ID);
}
}
}
return true;
}
public static bool AddWidGet(WidGet data)
{
using (InventioEntities context = new InventioEntities())
{
context.AddToWidGet(data);
context.SaveChanges();
}
return true;
}
public static bool InsertComentario(Comentario data)
{
using (InventioEntities context = new InventioEntities())
{
context.AddToComentarios(data);
context.SaveChanges();
}
return true;
}
public static bool UpdateUsuario(Usuario data)
{
using (InventioEntities context = new InventioEntities())
{
//data.EntityKey = new EntityKey("InventioEntities.Usuario", "UserName", data.UserName);
context.Attach(data);
context.ObjectStateManager.GetObjectStateEntry(data).SetModified();
context.Refresh(RefreshMode.ClientWins, data);
context.SaveChanges();
}
return true;
}
public static bool DeleteComentario(int IdComentario)
{
using (InventioEntities context = new InventioEntities())
{
Comentario data = (from datos in context.Comentarios
where datos.ID == IdComentario
select datos).First<Comentario>();
if (data != null)
{
context.Comentarios.DeleteObject(data);
context.SaveChanges();
}
}
return true;
}
public static bool DeleteWidGet(int IdWidGet)
{
using (InventioEntities context = new InventioEntities())
{
WidGet data = (from datos in context.WidGet
where datos.ID == IdWidGet
select datos).First<WidGet>();
if (data != null)
{
context.WidGet.DeleteObject(data);
context.SaveChanges();
}
}
return true;
}
public static bool Destacado(int IdArticulo)
{
Articulo data = null;
using (InventioEntities context = new InventioEntities())
{
data = (from datos in context.Articulo
where datos.ID == IdArticulo
select datos).First<Articulo>();
if (data != null)
{
data.Destacado = true;
context.SaveChanges();
}
}
return true;
}
public static bool UpdateWidGet(WidGet data)
{
using (InventioEntities context = new InventioEntities())
{
data.EntityKey = new EntityKey("InventioEntities.WidGet", "ID", data.ID);
context.Attach(data);
context.ObjectStateManager.GetObjectStateEntry(data).SetModified();
context.Refresh(RefreshMode.ClientWins, data);
context.SaveChanges();
}
return true;
}
public static bool Publicar(int IdArticulo)
{
Articulo data = null;
using (InventioEntities context = new InventioEntities())
{
data = (from datos in context.Articulo
where datos.ID == IdArticulo
select datos).First<Articulo>();
if (data != null)
{
data.FechaPublicacion = DateTime.UtcNow;
data.Borrador = false;
context.SaveChanges();
}
}
return true;
}
public static bool InsertArticulo(Articulo data)
{
using (InventioEntities context = new InventioEntities())
{
context.AddToArticulo(data);
context.SaveChanges();
}
return true;
}
