//SELECT * FROM TABLA WHERE Id = 1
public DataResult GetById(int id)
{
DataResult result = new DataResult();
try
{
result.Data = dbSet.Find(id);
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
//SELECT * FROM Tabla
public DataResult GetAll()
{
DataResult result = new DataResult();
try
{
result.Data = dbSet.ToList();
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
//DELETE FROM TABLA
public DataResult Delete(T entity)
{
DataResult result = new DataResult();
try
{
dbSet.Remove(entity);
context.SaveChanges();
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
//UPDATE TABLE SET field1 = value1, field2 = value2
public DataResult Update(T entity)
{
DataResult result = new DataResult();
try
{
context.SaveChanges();
result.Data = entity;
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
public DataResult Insert(T[] entities)
{
DataResult result = new DataResult();
try
{
dbSet.AddRange(entities);
context.SaveChanges();
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
public DataResult GetById(int id)
{
DataResult result = new DataResult();
try
{
result.Success = true;
//Select * from Table where id = x
result.Data = dbSet.Find(id);
}
catch (Exception ex)
{
result.Success = false;
result.LogError(ex);
}
return(result);
}
public DataResult GetAll(Expression <Func <T, bool> > query)
{
DataResult result = new DataResult();
try
{
result.Success = true;
//Select * from Table where ...
result.Data = dbSet.Where(query).ToList();
}
catch (Exception ex)
{
result.Success = false;
result.LogError(ex);
}
return(result);
}
public DataResult GetAll()
{
DataResult result = new DataResult();
try
{
result.Success = true;
//Select * from Table
result.Data = dbSet.ToList();
}
catch (Exception ex)
{
result.Success = false;
result.LogError(ex);
}
return(result);
}
public DataResult GetAll()
{
DataResult result = new DataResult();
try
{
result.Data = dbSet.ToList();
result.Success = true;
// SELECT * FROM TABLE
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult GetAll(Expression <Func <T, bool> > specification)
{
DataResult result = new DataResult();
try
{
result.Data = dbSet.Where(specification).ToList();
result.Success = true;
// SELECT * FROM TABLE WHERE NAME = Junier
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult GetById(int id)
{
DataResult result = new DataResult();
try
{
result.Data = dbSet.Find(id);
result.Success = true;
// SELECT * FROM TABLE WHERE ID = @id
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult SaveChanges()
{
DataResult result = new DataResult();
try
{
result.Success = true;
result.Data = context.SaveChanges();
//SAVE ENTITY STATE
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult GetAll(Expression <Func <T, bool> > specification, params Expression <Func <T, object> >[] includeProperties)
{
DataResult result = new DataResult();
try
{
IQueryable resultado = dbSet.Select(specification);
result.Data = (IEnumerable <T>)dbSet.Where(specification).ToList();
result.Successfull = true;
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
public DataResult Update(T entity)
{
DataResult result = new DataResult();
try
{
result.Success = true;
//update TABLE set(field = value) where ... id = var
context.SaveChanges();
result.Data = entity;
}
catch (Exception ex)
{
result.Success = false;
result.LogError(ex);
}
return(result);
}
public DataResult Insert(T entity)
{
DataResult result = new DataResult();
try
{
result.Success = true;
//Insert into TABLE (field, field1, field2) values (value, value1, value2)
dbSet.Add(entity);
context.SaveChanges();
result.Data = entity;
}
catch (Exception ex)
{
result.Success = false;
result.LogError(ex);
}
return(result);
}
public DataResult Insert(T entity)
{
DataResult result = new DataResult();
try
{
dbSet.Add(entity);
context.SaveChanges();
result.Data = entity;
result.Success = true;
// INSERT INTO TABLE (ID, USERNAME, PASS) VALUES (1, JUNIER, 123456)
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult GetAll(Expression <Func <T, bool> > specification, params Expression <Func <T, object> >[] includeProperties)
{
DataResult result = new DataResult();
try
{
if (includeProperties.Length > 0)
{
result.Data = GetAllIncluding(includeProperties).Where(specification).ToList();
result.Successfull = true;
}
}
catch (Exception ex)
{
result.LogError(ex);
result.Successfull = false;
}
return(result);
}
public DataResult Update(T entity)
{
DataResult result = new DataResult();
try
{
result.Success = true;
context.SaveChanges();
result.Data = entity;
//UDATE TABLE SET Campo1 = OFrometa WHERE Id = @Id
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult Update(T entity)
{
DataResult result = new DataResult();
try
{
context.SaveChanges();
result.Data = entity;
result.Success = true;
// UPDATE TABLE SET USERNAME = '******' WHERE ID = @ID
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult Delete(T entity)
{
DataResult result = new DataResult();
try
{
result.Success = true;
dbSet.Remove(entity);
context.SaveChanges();
result.Data = entity;
//DELETE FROM TABLE WHERE Id = @Id
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
public DataResult Insert(T entity)
{
DataResult result = new DataResult();
try
{
result.Success = true;
dbSet.Add(entity);
context.SaveChanges();
result.Data = entity;
//INSERT INTO TABLE(Id, UserName, Password) VALUES (1, OFrometa, miClave)
}
catch (Exception ex)
{
result.LogError(ex);
}
return(result);
}
