//public static List<T1> Listar()
//{
// using (var db = new VENDIXEntities())
// {
// return db.Set<T1>().ToList();
// }
//}
public static List <T1> Listar(
Expression <Func <T1, bool> > filter = null,
Func <IQueryable <T1>, IOrderedQueryable <T1> > orderBy = null,
string includeProperties = "")
{
using (var db = new DREAEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
IQueryable <T1> query = db.Set <T1>();
if (filter != null)
{
query = query.Where(filter);
}
foreach (var includeProperty in includeProperties.Split
(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
query = query.Include(includeProperty);
}
if (orderBy != null)
{
return(orderBy(query).ToList());
}
return(query.ToList());
}
}
public static bool EjecutarSql(string query)
{
using (var db = new DREAEntities())
{
db.Database.ExecuteSqlCommand(query);
return(true);
}
}
public static T1 Obtener(int id)
{
using (var db = new DREAEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
return(db.Set <T1>().Find(id));
}
}
public static void Guardar(List <T1> entities)
{
using (var db = new DREAEntities())
{
foreach (var e in entities)
{
db.Set <T1>().AddOrUpdate(e);
}
db.SaveChanges();
}
}
public static T1 Guardar(T1 entity)
{
using (var db = new DREAEntities())
{
db.Set <T1>().AddOrUpdate(entity);
if (db.SaveChanges() > 0)
{
return(entity);
}
}
return(null);
}
public static bool Eliminar(int pId)
{
using (var db = new DREAEntities())
{
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 DREAEntities())
{
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 DREAEntities())
{
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 DREAEntities())
{
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();
}
}