public string GetAdvanceFilter(CalendarioAdvanceSearchModel filter)
{
var where = "";
if (!string.IsNullOrEmpty(filter.FromClave) || !string.IsNullOrEmpty(filter.ToClave))
{
if (!string.IsNullOrEmpty(filter.FromClave))
{
where += " AND Calendario.Clave >= " + filter.FromClave;
}
if (!string.IsNullOrEmpty(filter.ToClave))
{
where += " AND Calendario.Clave <= " + filter.ToClave;
}
}
if (!string.IsNullOrEmpty(filter.FromUsuario_que_Registra) || !string.IsNullOrEmpty(filter.ToUsuario_que_Registra))
{
if (!string.IsNullOrEmpty(filter.FromUsuario_que_Registra))
{
where += " AND Calendario.Usuario_que_Registra >= " + filter.FromUsuario_que_Registra;
}
if (!string.IsNullOrEmpty(filter.ToUsuario_que_Registra))
{
where += " AND Calendario.Usuario_que_Registra <= " + filter.ToUsuario_que_Registra;
}
}
where = new Regex(Regex.Escape("AND ")).Replace(where, "", 1);
return(where);
}
public ActionResult ShowAdvanceFilter(CalendarioAdvanceSearchModel model, int idFilter = -1)
{
if (ModelState.IsValid)
{
Session["AdvanceSearch"] = model;
if (idFilter != -1)
{
Session["AdvanceReportFilter"] = GetAdvanceFilter(model);
return(RedirectToAction("Index", "Report", new { id = idFilter }));
}
return(RedirectToAction("Index"));
}
ViewBag.Filter = new List <SelectListItem>
{
new SelectListItem()
{
Text = Resources.Resources.BeginWith, Value = "1"
},
new SelectListItem()
{
Text = Resources.Resources.EndWith, Value = "2"
},
new SelectListItem()
{
Text = Resources.Resources.Contains, Value = "4"
},
new SelectListItem()
{
Text = Resources.Resources.Exact, Value = "3"
},
};
if (!_tokenManager.GenerateToken())
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
return(View(model));
}
public ActionResult ShowAdvanceFilter(string previousFilters = "")
{
if (!_tokenManager.GenerateToken())
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
var previousFiltersObj = new CalendarioAdvanceSearchModel();
if (previousFilters != "")
{
previousFiltersObj = (CalendarioAdvanceSearchModel)(Session["AdvanceSearch"] ?? new CalendarioAdvanceSearchModel());
}
ViewBag.Filter = new List <SelectListItem>
{
new SelectListItem()
{
Text = Resources.Resources.BeginWith, Value = "1"
},
new SelectListItem()
{
Text = Resources.Resources.EndWith, Value = "2"
},
new SelectListItem()
{
Text = Resources.Resources.Contains, Value = "4"
},
new SelectListItem()
{
Text = Resources.Resources.Exact, Value = "3"
},
};
return(View(previousFiltersObj));
}
