protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, cbEmpresa.Selected);
data.AddStatic(FilterData.StaticBase, cbLinea.Selected);
data.Add("DESDE", dtpDesde.SelectedDate);
data.Add("HASTA", dtpHasta.SelectedDate);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, ddlLocacion.Selected);
data.Add("ESTADO", cbEstado.SelectedIndex);
data.Add("DESDE", dtDesde.SelectedDate);
data.Add("HASTA", dtHasta.SelectedDate);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, cbEmpresa.Selected);
data.AddStatic(FilterData.StaticBase, cbLinea.Selected);
data.Add("TIPO", ddlTipo.Selected);
data.Add("DISPOSITIVOS", lbDispositivos.SelectedValues);
data.Add("PARAMETROS", lbParametros.SelectedValues);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, cbEmpresa.Selected);
data.AddStatic(FilterData.StaticBase, cbLinea.Selected);
data.AddStatic(FilterData.StaticTransportista, cbTransportista.Selected);
data.AddStatic(FilterData.StaticVehiculo, cbMovil.Selected);
data.Add("ESTADO", cbEstado.Selected);
data.Add("DESDE", dtpDesde.SelectedDate);
data.Add("HASTA", dtpHasta.SelectedDate);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, cbEmpresa.Selected);
data.AddStatic(FilterData.StaticBase, cbLinea.Selected);
data.AddStatic(FilterData.StaticCliente, cbCliente.Selected);
data.AddStatic(FilterData.StaticPuntoEntrega, cbPuntoEntrega.Selected);
data.AddStatic(FilterData.StaticProducto, cbProducto.Selected);
data.Add("desde", dtDesde.SelectedDate);
data.Add("hasta", dtHasta.SelectedDate);
data.Add("estado", cbEstado.Selected);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, ddlDistrito.Selected);
data.AddStatic(FilterData.StaticBase, ddlPlanta.Selected);
data.AddStatic(FilterData.StaticTransportista, cbTransportistas.Selected);
data.AddStatic(FilterData.StaticVehiculo, ddlMovil.Selected);
data.AddStatic(FilterData.StaticEquipo, ddlEquipo.Selected);
data.Add("ESTADO", cbEstado.SelectedIndex);
data.Add("DESDE", dtInicio.SelectedDate);
data.Add("HASTA", dtFin.SelectedDate);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, cbEmpresa.Selected);
data.AddStatic(FilterData.StaticBase, cbLinea.Selected);
data.AddStatic(FilterData.StaticTransportista, cbTransportista.Selected);
data.AddStatic(FilterData.StaticVehiculo, cbMovil.Selected);
data.AddStatic(FilterData.StaticTipoProveedor, cbTipoProveedor.Selected);
data.AddStatic(FilterData.StaticProveedor, cbProveedor.Selected);
data.AddStatic(FilterData.StaticDeposito, cbDepositoOrigen.Selected);
data.Add("DESDE", dtpDesde.SelectedDate);
data.Add("HASTA", dtpHasta.SelectedDate);
return(data);
}
protected override FilterData GetFilters(FilterData data)
{
data.AddStatic(FilterData.StaticDistrito, ddlLocacion.Selected);
data.AddStatic(FilterData.StaticBase, ddlPlanta.Selected);
data.AddStatic(FilterData.StaticTipoDispositivo, ddlTipoDispositivo.Selected);
data.Add("SIN_ASIGNAR", chkSoloSinAsignar.Checked);
return(data);
}
private void BindData(String sortExpression,
enumSortOrder sortOrder, string Company)
{
var context = new ProductContext();
var data = (from p in context.Products
from d in context.Drivers.Where(x => x.ProductName == p.ProductName).DefaultIfEmpty()
from r in context.ReleaseDates.Where(x => x.ProductId == p.ProductId).DefaultIfEmpty()
select new ProductwithCategory
{
Name = p.ProductName,
CompanyName = d != null ? d.CompanyName : default(string),
Version = d != null ? d.Version : default(string),
Size = d != null ? d.Size : default(long),
ReleaseData = r != null ? r.RealeseOn : default(DateTime),
URL = p.Url,
Vendor = p.VendorContact,
Categories = d != null ? d.ProductCategory : default(string)
}).ToList();
int nocorrectdatatobottom = 1;
#region sortdata
switch (sortExpression)
{
case "Name":
data.Sort((a, b) => (int)sortOrder * a.Name.CompareTo(b.Name));
break;
case "CompanyName":
data.Sort((a, b) => a.CompanyName == null ? nocorrectdatatobottom :
b.CompanyName == null ? -nocorrectdatatobottom :
(int)sortOrder * a.CompanyName.CompareTo(b.CompanyName));
break;
case "Version":
data.Sort((a, b) => a.Version == null ? nocorrectdatatobottom :
b.Version == null ? -nocorrectdatatobottom :
(int)sortOrder * a.Version.CompareTo(b.Version));
break;
case "Size":
data.Sort((a, b) => (int)sortOrder * a.Size.CompareTo(b.Size));
break;
case "ReleaseData":
data.Sort((a, b) => a.ReleaseData == null ? nocorrectdatatobottom :
b.ReleaseData == null ? -nocorrectdatatobottom :
(int)sortOrder * a.ReleaseData.CompareTo(b.ReleaseData));
break;
case "URL":
data.Sort((a, b) => a.URL == null ? nocorrectdatatobottom :
b.URL == null ? -nocorrectdatatobottom :
(int)sortOrder * a.URL.CompareTo(b.URL));
break;
case "Vendor":
data.Sort((a, b) => a.Vendor == null ? nocorrectdatatobottom :
b.Vendor == null ? -nocorrectdatatobottom :
(int)sortOrder * a.Vendor.CompareTo(b.Vendor));
break;
}
#endregion
#region FiterByCategory
string[] Categories = GetCategories();
List <ProductwithCategory> FilterData = new List <ProductwithCategory>();
if (Categories.Length == 0)
{
FilterData = new List <ProductwithCategory>(data);
}
else
{
foreach (ProductwithCategory element in data)
{
foreach (string category in Categories)
{
if (element.Categories != null && element.Categories.IndexOf(category) != -1)
{
FilterData.Add(element);
break;
}
}
}
}
#endregion
if (Company != ALL)
{
FilterData = (from d in FilterData
where d.CompanyName == Company
select d).ToList();
}
datagrid.DataSource = (from d in FilterData
select new
{
Name = d.Name,
CompanyName = d.CompanyName,
Version = d.Version,
Size = d.Size,
ReleaseData = d.ReleaseData,
URL = d.URL,
Vendor = d.Vendor,
}).ToList();
datagrid.DataBind();
}