public void Create(Entity entity)
{
try
{
_sqlServerContext.Set <Entity>().Add(entity);
_sqlServerContext.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
//public UserController (DataContext context)
//{
// _db = context;
//}
public IActionResult Index(int id)
{
var sql = Repositories.RepositoryFctory.GetSqlServer;
var list = sql.FindList <Users>(PredicateBuilder.True <Users>());
var list1 = sql.FindList <Users>(PredicateBuilder.True <Users>().And(ff => ff.Id == 1));
var entity = sql.ExecuteSql <Users>("select * from users where id=@id", new SqlParameter("id", "2"));
var entity1 = sql.ExecuteSql <Users>("select * from users ");
//var entity3 = sql.ExecuteSqlCommand("update users set id=@id where id=@id", new SqlParameter("id", "2"));
var entity4 = sql.ExecuteSqlCommand("select count(*) from users");
var enti5 = _db.Set <Users>().FromSql("select * from users ").ToList().Count();
int pageIndex = id == 0 ? 1 : id;
int pageSize = 1;
//var predicate = PredicateBuilder.True<Users>()
// .And(aa => aa.Id > 0);
var userList = _db.Users.AsNoTracking()
//.Where(predicate)
.OrderBy(m => m.Id)
.OrderByDescending(m => m.Age)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize)
.ToList();
var count = _db.Users.AsNoTracking()
//.Where(predicate)
.Count();
//Common.EnumResult dd = sql.Insert<Users>(null);
ViewBag.ListCount = count;
ViewBag.PageIndex = pageIndex;
var s = EnumResult.Error.GetResultString("Ìí¼Ó");
return(View(userList));
}
public virtual async Task <IEnumerable <TEntity> > FindAll()
{
using (SqlServerContext entityContext = ContextCreator())
{
return(await entityContext.Set <TEntity>().ToListAsync());
}
}
public virtual void Update(int id, TEntity obj)
{
//DbSet.Find(id);
if (Db.Entry(obj).State == EntityState.Detached)
{
Db.Set <TEntity>().Attach(obj);
}
Db.Entry(obj).State = EntityState.Modified;
}
public virtual void Add(TEntity entity)
{
entity = entity.DeleteNestedProperties();
using (SqlServerContext entityContext = ContextCreator())
{
entityContext.Set <TEntity>().AddAsync(entity);
entityContext.SaveChanges();
}
}
public virtual void Remove(Guid id)
{
using (SqlServerContext entityContext = ContextCreator())
{
TEntity entity = entityContext.Set <TEntity>().Find(id);
if (entity == null)
{
return;
}
entityContext.Entry(entity).State = EntityState.Deleted;
entityContext.SaveChanges();
}
}
public virtual void AddRange(IEnumerable <TEntity> entityList)
{
entityList = entityList.Select(entity =>
{
entity = entity.DeleteNestedProperties();
return(entity);
});
using (SqlServerContext entityContext = ContextCreator())
{
entityContext.Set <TEntity>().AddRange(entityList);
entityContext.SaveChanges();
}
}
public virtual async Task <int> Count()
{
using (SqlServerContext context = ContextCreator())
{
try
{
return(await context.Set <TEntity>().CountAsync());
}
catch (Exception ex)
{
throw new ApplicationException(
String.Format("It was not possible to find the data: {0}", ex.Message));
}
}
}
public virtual void Update(TEntity entity)
{
entity = entity.DeleteNestedProperties();
using (SqlServerContext entityContext = ContextCreator())
{
TEntity existingEntity =
entityContext.Set <TEntity>().FirstOrDefault(e => e.Id == entity.Id);
if (existingEntity == null)
{
return;
}
SimpleMapper.PropertyMap(entity, existingEntity);
entityContext.SaveChanges();
}
}
public bool Create(ControleAcessoVO controleAcessoVO)
{
DbSet <Usuario> dsUsuario = null;
using (_context)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
dsUsuario = _context.Set <Usuario>();
Usuario usuario = new Usuario
{
Nome = controleAcessoVO.Nome,
sobreNome = controleAcessoVO.SobreNome,
Email = controleAcessoVO.Email,
telefone = controleAcessoVO.Telefone
};
dsUsuario.Add(usuario);
_context.SaveChanges();
string sql = "INSERT INTO[dbo].[ControleAcesso] ([login], [senha], [idUsuario]) VALUES (@login, @senha, @idUsuario)";
_context.Database.ExecuteSqlCommand(sql, new SqlParameter("@login", usuario.Email), new SqlParameter("@senha", controleAcessoVO.Senha), new SqlParameter("@idUsuario", usuario.Id.Value));
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
return(false);
}
public virtual List <TEntity> FindAll()
{
return(context.Set <TEntity>()
.ToList());
}
public Repository(SqlServerContext context)
{
this.context = context;
_dbSet = context.Set <T>();
}
public void Insert(T obj)
{
context.Set <T>().Add(obj);
context.SaveChanges();
}
public void Remover(int id)
{
_context.Set <T>().Remove(Buscar(id));
_context.SaveChanges();
}
public GenericRepository(SqlServerContext context)
{
_context = context;
dataset = _context.Set <T>();
}
public async Task <IReadOnlyList <T> > GetAllAsync()
{
return(await _dbContext.Set <T>().AsNoTracking().ToListAsync());
}
public GenericRepository(SqlServerContext sqlServerContext)
{
this.sqlServerContext = sqlServerContext;
this.dataSet = sqlServerContext.Set <T>();
}
public async Task Insert(T obj)
{
context.Set <T>().Add(obj);
await context.SaveChangesAsync();
}
public RepositorioGenerico(SqlServerContext _context)
{
context = _context;
dbSet = context.Set <T>();
}
public Fornecedor GetByCpf(string cpf)
{
return(context.Set <Fornecedor>().Find(cpf));
}
public Socio GetByCpf(string cpf)
{
return(context.Set <Socio>().Find(cpf));
}
public List <T> GetAll()
{
return(context.Set <T>().ToList());
}
public void Insert(Brand brand)
{
context.Set <Brand>().Add(brand);
context.SaveChanges();
}
protected virtual void Insert(TEntity obj)
{
_sqlContext.Set <TEntity>().Add(obj);
_sqlContext.SaveChanges();
}
public void Create(T obj)
{
dbContext.Set <T>().Add(obj);
dbContext.SaveChanges();
}
public Cliente GetByCpf(string cpf)
{
return(context.Set <Cliente>().FirstOrDefault(c => c.Cpf == cpf));
}
public virtual List <TEntity> GetAll()
{
return(sqlContext
.Set <TEntity>()
.ToList());
}
public Repository(SqlServerContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public void Insert(Department department)
{
context.Set <Department>().Add(department);
context.SaveChanges();
}
public void Insert(Country country)
{
context.Set <Country>().Add(country);
context.SaveChanges();
}
