public static object GetPersonsRange(ListEditItemsRequestedByFilterConditionEventArgs args)
{
var skip = args.BeginIndex;
var take = args.EndIndex - args.BeginIndex + 1;
return (from person in DB.IsEmri
where (person.IsEmriId + " " + person.IsNo+ " " + person.Adi).StartsWith(args.Filter)
orderby person.IsEmriId
select person
).Skip(skip).Take(take);
}
public List <ba_TipoFlujo_Info> get_list_bajo_demandaFlujo(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_tipo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoIngEgr.ING.ToString()));
}
public List <ct_plancta_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_plancta.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), false));
}
public List <tb_sucursal_Info> get_list_bajo_demanda_sucursal(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_sucursal.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public List <tb_banco_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_banco.get_list_bajo_demanda(args));
}
public object FiltrirajDobavljace(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(fRepository.VratiDobavljace(args.Filter, args.BeginIndex, args.EndIndex));
}
public List <ct_punto_cargo_grupo_Info> get_list_bajo_demanda_grupo(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_grupo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
protected void dxcboVesselID_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
//use datareaders - much faster than loading into collections
string[] _cols = { "VesselID", "VesselName" };
string[] _sort = { "VesselName" };
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VesselTable).Paged(e.BeginIndex + 1, e.EndIndex + 1).Where("VesselName").StartsWith(string.Format("{0}%", _filter));
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "VesselID";
_combo.TextField = "VesselName";
_combo.DataBindItems();
}
public List <Proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(data_proveedor.get_list_bajo_demanda(args));
}
public List <in_Producto_Info> get_list_bajo_demanda_productos(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.PORMODULO, cl_enumeradores.eModulo.COM, 0, 0));
}
protected void colBillActorTypeItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
ASPxComboBox comboItemUnit = source as ASPxComboBox;
XPCollection <BillActorType> collection = new XPCollection <BillActorType>(session);
collection.SkipReturnedObjects = e.BeginIndex;
collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1;
CriteriaOperator criteria = CriteriaOperator.And(
new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", 1, BinaryOperatorType.GreaterOrEqual));
collection.Criteria = criteria;
collection.Sorting.Add(new SortProperty("Name", DevExpress.Xpo.DB.SortingDirection.Ascending));
comboItemUnit.DataSource = collection;
comboItemUnit.DataBindItems();
}
public List <ba_tipo_nota_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, string Tipo)
{
return(odata.get_list_bajo_demanda(args, IdEmpresa, Tipo));
}
public List <tb_persona_Info> get_list_bajo_demanda_cliente_x_tipo(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, int Idtipo_cliente)
{
return(odata.get_list_bajo_demanda_cliente_x_tipo(args, IdEmpresa, Idtipo_cliente));
}
//end incremental filtering of voyage name
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// for devan warehouse the company list is limted to company typeid = 5
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcbocompany_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
//if (Page.Session["user"] != null) //if publiship user allow filter to be used otherwise filter null
//{
// Int32 _companyid = wwi_func.vint(((UserClass)Page.Session["user"]).CompanyId.ToString());
// if (_companyid == -1)
// {
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
//use datareaders - much faster than loading into collections
string[] _cols = { "CompanyID, CompanyName", "Address1", "Address2", "Address3", "CountryName", "TelNo", "Customer" };
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("view_delivery_address").Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("{0}%", e.Filter.ToString()));
switch (_combo.ID)
{
case "dxcboAgentAtDestinationID":
{
int[] _vals = { 3, 6 };
_query.And("TypeID").In(_vals);
break;
}
case "dxcboConsigneeID":
{
_query.And("Consignee").IsEqualTo(1);
break;
}
default:
{
break;
}
}
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.ValueType = typeof(int);
_combo.TextField = "CompanyName";
_combo.DataBindItems();
// }
//}
}
public List <in_Producto_Info> get_list_ProductoHijo_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.PORSUCURSAL, cl_enumeradores.eModulo.INV, Convert.ToInt32(SessionFixed.IdSucursal)));
}
public List <tb_persona_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_persona.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoPersona.EMPLEA.ToString()));
}
protected void CBUserPermissionType_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
if (!string.IsNullOrEmpty(e.Filter))
{
SqlDataSourceUserPermissionType.SelectParameters.Clear(); // force query to server
SqlDataSourceUserPermissionType.SelectParameters.Add(
new Parameter {
Name = "search", DbType = DbType.AnsiString, Size = 60, DefaultValue = e.Filter.ToString().Replace("*", "%")
}
);
(source as ASPxComboBox).DataBindItems();
}
}
protected void dxcboVesselID_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
//use datareaders - much faster than loading into collections
string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" };
string[] _sort = { "Joined" };
//additional filters on this dll
string _originportid = ""; //get_token("pstart").ToString();
string _destportid = "";//get_token("pend").ToString();
ASPxComboBox _cbo = (ASPxComboBox)this.fmvBol.FindControl("dxcboOriginPort");
if(_cbo != null && _cbo.SelectedItem != null){ _originportid = _cbo.SelectedItem.Value.ToString(); }
_cbo = (ASPxComboBox)this.fmvBol.FindControl("dxcboDestinationPort");
if(_cbo != null && _cbo.SelectedItem != null){ _destportid = _cbo.SelectedItem.Value.ToString(); }
//
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView").Paged(e.BeginIndex + 1, e.EndIndex + 1, "VoyageID").Where("Joined").Like(string.Format("{0}%", e.Filter.ToString()));
if(_originportid != "" && _destportid != ""){
_query.And("DestinationPortID").IsEqualTo(_destportid).And("OriginPortID").IsEqualTo(_originportid).OrderAsc(_sort);
}
string test = _query.ToString();
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "VoyageID";
_combo.TextField = "Joined";
_combo.DataBindItems();
}
protected void comboOrganization_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
ASPxComboBox combo = source as ASPxComboBox;
XPCollection <Organization> collection = new XPCollection <Organization>(session);
collection.SkipReturnedObjects = e.BeginIndex;
collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1;
//Get SUPPLIER trading type
TradingCategory supplierTradingCategory =
session.FindObject <TradingCategory>(new BinaryOperator("Code", "SUPPLIER"));
CriteriaOperator criteria = CriteriaOperator.And(
//row status is active
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE),
CriteriaOperator.Or(
//find code contains the filter
new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like),
//find name contains the filter
new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like)
),
//find customer and supplier
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId", supplierTradingCategory),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
)
);
collection.Criteria = criteria;
collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending));
combo.DataSource = collection;
combo.DataBindItems();
}
public List <Af_Activo_fijo_Info> get_list_bajo_demanda_af(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_activo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public List <cp_proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_proveedor.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public List <cp_proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa)
{
return(odata.get_list_bajo_demanda(args, IdEmpresa));
}
public List <in_Producto_Info> get_list_ProductoPadre_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.SOLOPADRES, cl_enumeradores.eModulo.INV, 0));
}
public List <ct_plancta_Info> get_list_bajo_demanda_ctacble_cxp(ListEditItemsRequestedByFilterConditionEventArgs args)
{
var IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa);
return(bus_cuenta.get_list_bajo_demanda(args, IdEmpresa, false));
}
public List <in_Producto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, cl_enumeradores.eTipoBusquedaProducto Busqueda, cl_enumeradores.eModulo Modulo, int IdSucursal, int IdBodega = 0)
{
return(odata.get_list_bajo_demanda(args, IdEmpresa, Busqueda, Modulo, IdSucursal, IdBodega));
}
public List <in_Producto_Info> get_list_bajo_demandaProducto(ListEditItemsRequestedByFilterConditionEventArgs args)
{
List <in_Producto_Info> Lista = bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.SOLOSERVICIOS, cl_enumeradores.eModulo.FAC, Convert.ToInt32(SessionFixed.IdSucursal));
return(Lista);
}
public List <ba_tipo_nota_Info> get_list_bajo_TipoNota(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_tipo_nota.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoCbteBancario.NDBA.ToString()));
}
public List <ct_CentroCosto_Info> get_list_bajo_demandaCC(ListEditItemsRequestedByFilterConditionEventArgs args)
{
List <ct_CentroCosto_Info> Lista = bus_cc.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), false);
return(Lista);
}
public List <ct_CentroCosto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_centrocosto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), true));
}
void dropDown_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) {
if (String.IsNullOrEmpty(e.Filter) || e.Filter.Length < NUMBER_CHAR_SEARCH)
return;
var editor = ((ASPxComboBox)source);
editor.DataSource = GetLookupSource(e.Filter);
editor.DataBind();
}
/// <summary>
/// new vessel selection
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcboNewVessel_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";
//if (_filter != "")
//{
//use datareaders - much faster than loading into collections
string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" };
string[] _sort = { "Joined" };
//additional filters on this dll
string _originportid = this.dxhfContainer.Contains("ptstart") ? this.dxhfContainer.Get("ptstart").ToString() : "0";
string _destportid = this.dxhfContainer.Contains("ptend") ? this.dxhfContainer.Get("ptend").ToString() : "0";
//
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView").
Paged(e.BeginIndex + 1, e.EndIndex + 1, "VoyageID").Where("Joined").Like(string.Format("{0}%", e.Filter.ToString())).And("DestinationPortID").IsEqualTo(_destportid).And("OriginPortID").IsEqualTo(_originportid).OrderAsc(_sort);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "VoyageID";
_combo.TextField = "Joined";
_combo.DataBindItems();
//} //endif
}
public List <ro_rubro_tipo_Info> get_list_bajo_demanda_rubro(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_rubro.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public List <ct_grupo_x_Tipo_Gasto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_GrupoPorTipoGasto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public List <tb_persona_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_persona.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.TipoPersona));
}
public List <caj_Caja_Movimiento_Tipo_Info> get_list_bajo_demanda_TipoMovimiento_Egreso(ListEditItemsRequestedByFilterConditionEventArgs args)
{
return(bus_tipo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), "-"));
}
protected void dxcboDestControl_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
ASPxComboBox _combo = (ASPxComboBox)source;
if (_combo != null)
{
string[] _cols = { "EmployeesTable.EmployeeID, EmployeesTable.Name", "EmployeesTable.DepartmentID", "OfficeTable.OfficeID", " NameAndAddressBook.CompanyID" };
string[] _order = { "Name" };
SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.EmployeesTable).
InnerJoin(DAL.Logistics.OfficeTable.OfficeIDColumn, DAL.Logistics.EmployeesTable.OfficeIDColumn).
InnerJoin(DAL.Logistics.NameAndAddressBook.CountryIDColumn, DAL.Logistics.OfficeTable.CountryIDColumn);
_qry.And(DAL.Logistics.EmployeesTable.LiveColumn).IsEqualTo(true).OrderAsc(_order);
IDataReader _rd1 = _qry.ExecuteReader();
_combo.DataSource = _rd1;
_combo.ValueField = "EmployeeID";
_combo.ValueType = typeof(int);
_combo.TextField = "Name";
_combo.DataBindItems();
}
}
public List <ba_TipoFlujo_Info> get_list_bajo_demanda_tipoflujo(ListEditItemsRequestedByFilterConditionEventArgs args)
{
var TipoFlujo_GetList = bus_TipoFlujo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa));
return(TipoFlujo_GetList);
}
