public static object GetPersonByID(ListEditItemRequestedByValueEventArgs args)
{
int id;
if (args.Value == null || !int.TryParse(args.Value.ToString(), out id))
return null;
return DB.IsEmri.Where(p => p.IsEmriId == id).Take(1);
}
public ro_rubro_tipo_Info get_info_bajo_demanda_rubro(ListEditItemRequestedByValueEventArgs args)
{
return(bus_rubro.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args));
}
public in_Motivo_Inven_Info get_info_bajo_demanda_motivo(ListEditItemRequestedByValueEventArgs args)
{
return(bus_motivo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public tb_TarjetaCredito_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args)
{
return(odata.get_info_bajo_demanda(args));
}
public tb_parroquia_Info get_info_bajo_demanda_parroquia(ListEditItemRequestedByValueEventArgs args)
{
return(bus_parroquia.get_info_bajo_demanda(args, Convert.ToString(SessionFixed.IdCiudad)));
}
public tb_parroquia_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, string IdCiudad)
{
return(get_info(args.Value == null ? "" : (string)args.Value, IdCiudad));
}
public tb_bodega_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa, int IdSucursal)
{
return(get_info(IdEmpresa, args.Value == null ? 0 : (int)args.Value, IdSucursal));
}
protected void cboLegalInvoiceArtifactType_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
ASPxComboBox comboItemUnit = source as ASPxComboBox;
try
{
NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType obj = session.GetObjectByKey <NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType>(Guid.Parse(e.Value.ToString()));
if (obj != null)
{
comboItemUnit.DataSource = new NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType[] { obj };
comboItemUnit.DataBindItems();
}
}
catch
{
}
}
public tb_persona_Info get_info_bajo_demanda_cliente_x_tipo(ListEditItemRequestedByValueEventArgs args)
{
return(bus_persona.get_info_bajo_demanda_cliente_x_tipo(args, Convert.ToInt32(SessionFixed.IdEmpresa), Convert.ToInt32(SessionFixed.Idtipo_cliente)));
}
void dropDown_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) {
}
public tb_bodega_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa)
{
return(get_info_demanda(IdEmpresa, args.Value == null ? "" : args.Value.ToString()));
}
public cp_proveedor_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa)
{
return(odata.get_info_bajo_demanda(args, IdEmpresa));
}
protected void dxcboNewVessel_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
Int32 _id = 0;
if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); }
//use datareaders - much faster than loading into collections
string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" };
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView").WhereExpression("VoyageID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "VoyageID";
_combo.TextField = "Joined";
_combo.DataBindItems();
}
//14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED
//can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive
//incremental filtering for large datasets on combos
/// <summary>
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// company name is only available to publiship users
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcboCountry_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
Int32 _id = 0;
if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); }
string[] _cols = { "CountryID, CountryName" };
string[] _order = { "CountryName" };
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).WhereExpression("CountryID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.ValueField = "CountryID";
_combo.ValueType = typeof(int);
_combo.TextField = "CountryName";
_combo.DataBindItems();
}
public Af_Activo_fijo_Info get_info_bajo_demanda_af(ListEditItemRequestedByValueEventArgs args)
{
return(bus_activo.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args));
}
public tb_persona_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args)
{
return(Bus_persona.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoPersona.EMPLEA.ToString()));
}
public caj_Caja_Movimiento_Tipo_Info get_info_bajo_demanda_TipoMovimiento_Egreso(ListEditItemRequestedByValueEventArgs args)
{
return(bus_tipo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
protected void dxcbocompany_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
Int32 _id = 0;
//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)
// {
if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); }
//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).WhereExpression("CompanyID").IsEqualTo(_id);
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("view_delivery_address").WhereExpression("CompanyID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "CompanyID";
_combo.ValueType = typeof(int);
_combo.TextField = "CompanyName";
_combo.DataBindItems();
// }
//}
}
public static MonitorOperators GetEehMonitorOperatorsByOperator(this ICoreDataSource db, ListEditItemRequestedByValueEventArgs args)
{
if (args.Value == null)
{
return((MonitorOperators)null);
}
// db must be CorePortalEntities:
var dbCPE = (CorePortalEntities)db;
var tranDT = new ObjectParameter("tranDT", typeof(DateTime?));
var result = new ObjectParameter("result", typeof(int?));
var debugMsg = new ObjectParameter("debugMsg", typeof(string));
return(dbCPE.GetEehMonitorOperator(args.Value.ToString(), tranDT, result, 0, debugMsg)
.SingleOrDefault());
}
//14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED
//can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive
//incremental filtering for large datasets on combos
/// <summary>
/// incremental filtering and partial loading of name and address book for speed
/// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
/// company name is only available to publiship users
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcboVesselID_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;
Int32 _id = 0;
if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); }
//use datareaders - much faster than loading into collections
string[] _cols = { "VesselID", "VesselName" };
//SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).WhereExpression("CompanyID").IsEqualTo(_id);
SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VesselTable).WhereExpression("VesselID").IsEqualTo(_id);
IDataReader _rd = _query.ExecuteReader();
_combo.DataSource = _rd;
_combo.ValueField = "VesselID";
_combo.TextField = "VesselName";
_combo.DataBindItems();
}
public ro_area_Info get_info_bajo_demanda_individual(ListEditItemRequestedByValueEventArgs args, int IdEmpresa)
{
return(get_info(IdEmpresa, args.Value == null ? 0 : (int)args.Value));
}
public tb_ciudad_Info get_info_bajo_demanda_ciudad(ListEditItemRequestedByValueEventArgs args)
{
return(bus_ciudad.get_info_bajo_demanda(args));
}
public ct_punto_cargo_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa)
{
//La variable args del devexpress ya trae el ID seleccionado en la propiedad Value, se pasa el IdEmpresa porque es un filtro que no tiene
return(GetInfo(IdEmpresa, args.Value == null ? 0 : Convert.ToInt32(args.Value.ToString())));
}
public Producto_Info GetInfo(ListEditItemRequestedByValueEventArgs args)
{
return(odata.GetInfo(args));
}
public tb_sucursal_Info get_info_bajo_demanda(int IdEmpresa, ListEditItemRequestedByValueEventArgs args)
{
return(odata.get_info_bajo_demanda(IdEmpresa, args));
}
public ct_CentroCosto_Info get_info_bajo_demandaEg(ListEditItemRequestedByValueEventArgs args)
{
return(bus_cc.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public seg_usuario_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args)
{
return(bus_usuario.get_info_bajo_demanda(args));
}
public tb_persona_Info get_info_bajo_demanda_persona(ListEditItemRequestedByValueEventArgs args)
{
return(bus_persona.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), "PERSONA"));
}
protected void cboProductManufacturer_OnItemRequestedByValue_SQL(object source, ListEditItemRequestedByValueEventArgs e)
{
ASPxComboBox comboBox = (ASPxComboBox)source;
try
{
NAS.DAL.Nomenclature.Organization.ManufacturerOrg obj = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.ManufacturerOrg>(Guid.Parse(e.Value.ToString()));
if (obj != null)
{
comboBox.DataSource = new NAS.DAL.Nomenclature.Organization.ManufacturerOrg[] { obj };
comboBox.DataBindItems();
}
}
catch {
}
}
public tb_sucursal_Info get_info_bajo_demanda_sucursal(ListEditItemRequestedByValueEventArgs args)
{
return(bus_sucursal.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args));
}
public Proveedor_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, string Tipo)
{
//La variable args del devexpress ya trae el ID seleccionado en la propiedad Value, se pasa el IdEmpresa porque es un filtro que no tiene
return(get_info(Tipo, args.Value == null ? "" : args.Value.ToString()));
}
//end incremental filtering agentarorigin
/// <summary>
/// destinatiobn controller
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void dxcboDestControl_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
ASPxComboBox _combo = (ASPxComboBox)source;
ASPxComboBox _destinationagent = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboAgentAtDestinationIDEdit");
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);
if (_destinationagent != null && _destinationagent.SelectedItem != null && _destinationagent.Value != null)
{
int _filter = wwi_func.vint(_destinationagent.SelectedItem.GetValue("CountryID").ToString());
if (_filter > 0) { _qry.Where("CountryID").IsEqualTo(_filter); }
}
_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();
}
}
protected void ASPxComboBox_OnItemRequestedByValue_SQL(object source, ListEditItemRequestedByValueEventArgs e)
{
}
public ba_TipoFlujo_Info get_info_bajo_demandaFlujo(ListEditItemRequestedByValueEventArgs args)
{
return(bus_tipo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public ct_plancta_Info get_info_bajo_demanda_ctacble_Anticipo(ListEditItemRequestedByValueEventArgs args)
{
var IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa);
return(bus_plancta.get_info_bajo_demanda(args, IdEmpresa));
}
public ct_plancta_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args)
{
return(bus_plancta.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)));
}
public tb_empresa_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args)
{
return(bus_empresa.get_info_bajo_demanda(args));
}