protected async Task <FindResult <T> > _Get(Conditions conditions, int page = 0, int itemsByPage = 0, string sortBy = "", bool descending = false)
{
using (var manager = CrudManagerFactory.GetCrudManager <T>())
{
var result = await manager.FindAsync(conditions, page, itemsByPage, sortBy, descending);
return(result);
}
}
public virtual async Task <ObjectResult> Delete([FromBody] T value)
{
try
{
using (var manager = CrudManagerFactory.GetCrudManager <T>())
{
await manager.DeleteAsync(value);
}
return(Ok("La entidad se eliminó correctamente"));
}
catch (Exception ex)
{
await Logger.ErrorAsync($"Error eliminado elementos de {typeof(T).Name}", ex);
throw;
}
}
public virtual async Task <T> Put([FromBody] T value)
{
try
{
using (var manager = CrudManagerFactory.GetCrudManager <T>())
{
value.CreatedBy = User.Identity.Name;
value.CreatedOn = DateTime.Now;;
return(await manager.InsertAsync(value));
}
//return Ok("La entidad se almacenó correctamente");
}
catch (Exception ex)
{
await Logger.ErrorAsync($"Error insertando elementos de {typeof(T).Name}", ex);
throw;
}
}
public virtual async Task <Customer> Get(int id)
{
try
{
var conditions = new Conditions();
conditions.AddCondition("CustomerId", Helper.Lambda.ComparisonOperator.Equal, id);
using (var manager = CrudManagerFactory.GetCrudManager <Customer>())
{
var result = await manager.FindAsync(conditions, 0, 0, "CustomerId");
return(result.ResultList.FirstOrDefault());
}
}
catch (Exception ex)
{
await Logger.ErrorAsync($"Error obteniendo elementos de {typeof(Customer).Name}", ex);
throw;
}
}
public virtual async Task <FindResult <T> > Get(string filter = "", string sortBy = "", int page = 1, int itemsByPage = 50, bool descending = false)
{
try
{
var conditions = new Conditions();
conditions.AddFilter(filter);
using (var manager = CrudManagerFactory.GetCrudManager <T>())
{
var result = await manager.FindAsync(conditions, page, itemsByPage, sortBy, descending);
return(result);
}
}
catch (Exception ex)
{
await Logger.ErrorAsync($"Error obteniendo elementos de {typeof(T).Name}", ex);
throw;
}
}
public virtual async Task <FindResult <object> > Get(string select, string filter = "", string sortBy = "", int page = 1, int itemsByPage = 50, bool descending = false)
{
if (select == null)
{
throw new LogicException("El parámetro select es requerido.");
}
try
{
var conditions = new Conditions();
conditions.AddFilter(filter);
using (var manager = CrudManagerFactory.GetCrudManager <T>())
{
var result = await manager.FindSelectAsync(conditions, select, page, itemsByPage, sortBy, descending);
return(result);
}
}
catch (Exception ex)
{
await Logger.ErrorAsync($"Error obteniendo elementos de {typeof(T).Name}", ex);
throw;
}
}
