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