public static void Guardar(List <T1> entities)
{
using (var db = new YARIEntities())
{
foreach (var e in entities)
{
db.Set <T1>().AddOrUpdate(e);
}
db.SaveChanges();
}
}
public static T1 Guardar(T1 entity)
{
using (var db = new YARIEntities())
{
db.Set <T1>().AddOrUpdate(entity);
if (db.SaveChanges() > 0)
{
return(entity);
}
}
return(null);
}
public static bool Eliminar(int pId)
{
using (var db = new YARIEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
Eliminar(db, pId);
if (db.SaveChanges() > 0)
{
return(true);
}
}
return(false);
}
public static bool Actualizar(T1 entity)
{
using (var db = new YARIEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
Actualizar(db, entity);
if (db.SaveChanges() > 0)
{
return(true);
}
}
return(false);
}
public static T1 Crear(T1 entity)
{
using (var db = new YARIEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
Crear(db, entity);
if (db.SaveChanges() > 0)
{
return(entity);
}
}
return(null);
}
public static void ActualizarParcial(T1 entity, params Expression <Func <T1, object> >[] properties)
{
using (var db = new YARIEntities())
{
db.Configuration.ValidateOnSaveEnabled = false;
var entry = db.Entry(entity);
if (entry.State == EntityState.Detached)
{
db.Set <T1>().Attach(entity);
}
if (properties != null)
{
foreach (var p in properties)
{
entry.Property(p).IsModified = true;
}
}
db.SaveChanges();
}
}