public void consultacoddes(string cod, int suc, string des)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_cod.Substring(0, suc) == cod && di.diw_des.Contains(des))
.OrderBy(di => di.diw_cod)
.ToList();
}
}
public void consultafechas(DateTime fed, DateTime feh)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_fec >= fed && di.diw_fec <= feh)
.OrderBy(di => di.diw_cod)
.ToList();
}
}
public void consultadescripcion(string des)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_des.Contains(des))
.OrderBy(di => di.diw_cod)
.ToList();
}
}
public void consultacodigo(string cod, int suc)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_cod.Substring(0, suc) == cod)
.OrderBy(di => di.diw_cod)
.ToList();
}
}
public void consultadirdesfec(string dir, string des, DateTime fed, DateTime feh)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_dir.Contains(dir) && di.diw_des.Contains(des) && di.diw_fec >= fed && di.diw_fec <= feh)
.OrderBy(di => di.diw_cod)
.ToList();
}
}
public void consultacoddirfec(string cod, int suc, string dir, DateTime fed, DateTime feh)
{
using (websEntities dw = new websEntities())
{
_dirweb = dw.direccioneswebs
.Where(di => di.diw_cod.Substring(0, suc) == cod && di.diw_dir.Contains(dir) && di.diw_fec >= fed && di.diw_fec <= feh)
.OrderBy(di => di.diw_cod)
.ToList();
}
}