public ActionResult searchDescripcionHechura()
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var lenght = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchv = Request.Form.GetValues("search[value]").FirstOrDefault();
int pagesize = lenght != null?Convert.ToInt32(lenght) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int totalRecords = 0;
using (db)
{
var v = (from a in db.DescripcionHechura.Where(w => w.regAnulado == false) select new { a.IdDescripcionHechura, a.IdCotizacion, a.IdPieza, a.IdTela, a.CantidadRequerida, Color = db.fn_ObtenerColoresDescHechura(a.IdDescripcionHechura), Pieza = a.Pieza.Nombre + " (" + a.Pieza.SexoPieza + ")", Tela = a.Tela.Nombre, a.Descripcion, a.Duracion });
if (!(string.IsNullOrEmpty(searchv)))
{
v = v.Where(a => a.IdCotizacion.ToString().Contains(searchv));
}
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
totalRecords = v.Count();
var data = v.Skip(skip).Take(pagesize).ToList();
return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet));
}
}
