public ActionResult Find(RecetaFindViewModel model)
{
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller Begin"));
//int totalCount = 0;
try
{
// Add find logic here
if (ModelState.IsValid)
{
if (model.OrderBy == null)
{
model.OrderBy = "Id";
}
string sort = "Id";
var filtros = GenerateExpression(model);
var pagedResult = _serviceReceta.FindPagedByFilter(filtros, null, 1, model.PageSize, model.OrderBy, "Asc", null, null);
model.Paginate(pagedResult, "");
//var RecetaDetails = _serviceAlim.Query(
// new RecetaQuery().Withfilter(filtros))
// .OrderBy(n => n.OrderBy("Id", "Asc"))
// .SelectPage(1, model.PageSize, out totalCount);
//var pagelist = new { total = totalCount, rows = RecetaDetails.ToList() };
//var pagedResult = _serviceReceta.FindPagedByFilter(expression, includes, 1, model.PageSize, "Id", model.OrderBy, model.Ascendent, null, null);
//model.Paginate(pagedResult, expression.SerializedExpression);
TempData.Clear();
TempData.Add("FilterReceta", model);
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller End"));
return(PartialView("_RecetaFindPartialView", model));
}
}
catch (Exception ex)
{
//LoggerFactory.CreateLog().Error(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller ERROR"), ex);
}
ModelState.AddModelError("", PresentationResources.Error);
return(View("RecetaFindView", new RecetaFindViewModel(_serviceReceta, _serviceFamRec, _serviceRecProd)));
}
// GET
public ActionResult Find(int?page = 1, string sort = "Id", string sortDir = "ASC")
{
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller Begin"));
try
{
// Add find logic here
RecetaFindViewModel model;
if (Request.IsAjaxRequest() && TempData.ContainsKey("FilterReceta"))
{
model = (RecetaFindViewModel)TempData.Peek("FilterReceta");
var filtros = GenerateExpression(model);
var pagedResult = _serviceReceta.FindPagedByFilter(filtros, null, page != null ? (int)page : model.PageIndex, model.PageSize, sort, sortDir, null, null);
model.Paginate(pagedResult, "");
//var pagedResult = _serviceReceta.FindPagedByFilter(new CustomQuery<Receta> { SerializedExpression = model.Filter }, null, page != null ? (int)page : model.PageIndex, model.PageSize, sort, sortDir == "ASC", null);
//model.Paginate(pagedResult, model.Filter);
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindPagedReceta Controller End"));
return(PartialView("_RecetaFindPartialView", model));
}
else
{
TempData.Remove("FilterReceta");
model = new RecetaFindViewModel(_serviceReceta, _serviceFamRec, _serviceRecProd);
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller End"));
return(View("RecetaFindView", model));
}
}
catch (Exception ex)
{
//LoggerFactory.CreateLog().Error(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindReceta Controller ERROR"), ex);
}
return(RedirectToAction("Index", "Home"));
}
//private static QueryObject<Receta> GenerateExpression(RecetaFindViewModel model)
private static IEnumerable <filterRule> GenerateExpression(RecetaFindViewModel model)
{
//LoggerFactory.CreateLog().Debug(string.Format(CultureInfo.InvariantCulture, "Presentation Layer - FindAlim Controller Begin"));
//var filters = JsonConvert.DeserializeObject<IEnumerable<filterRule>>(filterRules);
//return Json(pagelist, JsonRequestBehavior.AllowGet);
IList <filterRule> filtros = new List <filterRule>();
if (model != null)
{
if (model.Receta.Id.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "Id", value = model.Receta.Id.Value.ToString()
});
}
//And(d => d.Id == model.Receta.Id.Value);
if (model.Receta.IdFamRec.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "IdFamRec", value = model.Receta.IdFamRec.Value.ToString()
});
}
//And(d => d.IdFamRec == model.Receta.IdFamRec.Value);
if (model.Receta.IdRecetaBase.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "IdRecetaBase", value = model.Receta.IdRecetaBase.Value.ToString()
});
}
//And(d => d.IdRecetaBase == model.Receta.IdRecetaBase.Value);
if (!string.IsNullOrEmpty(model.Receta.Nombre))
{
filtros.Add(new filterRule()
{
op = "equal", field = "Nombre", value = model.Receta.Nombre
});
}
//And(d => d.Nombre.Contains(model.Receta.Nombre));
if (!string.IsNullOrEmpty(model.Receta.Alias))
{
filtros.Add(new filterRule()
{
op = "equal", field = "Alias", value = model.Receta.Alias
});
}
//And(d => d.Alias.Contains(model.Receta.Alias));
if (model.Receta.Ubicacion.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "Ubicacion", value = model.Receta.Ubicacion.Value.ToString()
});
}
//And(d => d.Ubicacion == model.Receta.Ubicacion.Value);
if (!string.IsNullOrEmpty(model.Receta.Descripcion))
{
filtros.Add(new filterRule()
{
op = "equal", field = "Descripcion", value = model.Receta.Descripcion
});
}
//And(d => d.Descripcion.Contains(model.Receta.Descripcion));
if (!string.IsNullOrEmpty(model.Receta.Preparacion))
{
filtros.Add(new filterRule()
{
op = "equal", field = "Preparacion", value = model.Receta.Preparacion
});
}
//And(d => d.Preparacion.Contains(model.Receta.Preparacion));
if (model.Receta.IdFoto.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "IdFoto", value = model.Receta.IdFoto.Value.ToString()
});
}
//And(d => d.IdFoto == model.Receta.IdFoto.Value);
if (model.Receta.IdEstado.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "IdEstado", value = model.Receta.IdEstado.Value.ToString()
});
}
//And(d => d.IdEstado == model.Receta.IdEstado.Value);
if (model.Receta.FechaRegistro.HasValue)
{
filtros.Add(new filterRule()
{
op = "equal", field = "FechaRegistro", value = model.Receta.FechaRegistro.Value.ToString()
});
}
//And(d => d.FechaRegistro == model.Receta.FechaRegistro.Value);
}
return(filtros);
//return new QueryObject<Receta>(expression ?? (d => true));
}
