protected void dlCargo_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) CargoId,CargoName FROM [tblCargo] WHERE CargoName LIKE '%" + e.Text.ToUpper() + "%'"; cargoSource.SelectCommand = sql; dlCargo.DataBind(); }
protected void ddlStakeHolder_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { try { var stockholderTypeId = ddlStakeHolderType.SelectedValue.Trim(); if (stockholderTypeId == "1" || stockholderTypeId == "14") { //string sqlSelectCommand = @"Select InstitutionID,InstitutionName from Institution_Master_Info"; //SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, connectionString); ////adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text); //DataTable dataTable = new DataTable(); //adapter.Fill(dataTable); DataTable dataTable = pbUtility.GetDataByProc("sp_getInstitutionMaster"); foreach (DataRow dataRow in dataTable.Rows) { RadComboBoxItem item = new RadComboBoxItem(); item.Text = (string)dataRow["InstitutionName"]; item.Value = dataRow["InstitutionID"].ToString(); item.Attributes.Add("InstitutionName", dataRow["InstitutionName"].ToString()); ddlStakeHolder.Items.Add(item); item.DataBind(); } } else { ClearStakeHolder(); } } catch (Exception ex) { Alert.Show(ex.Message); } }
protected void ddlStakeHolderType_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { try { //string sqlSelectCommand = @"Select StakeholderTypeID,StakeholderTypeName from [dbo].[CmnStakeholderType]"; //SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, connectionString); ////adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text); //DataTable dataTable = new DataTable(); //adapter.Fill(dataTable); //Hashtable ht = new Hashtable(); //ht.Add("EnterpriseCategoryId", 1); // 1 for Yarn DataTable dataTable = pbUtility.GetDataByProc("sp_getStakeholderType"); foreach (DataRow dataRow in dataTable.Rows) { RadComboBoxItem item = new RadComboBoxItem(); item.Text = (string)dataRow["StakeholderTypeName"]; item.Value = dataRow["StakeholderTypeID"].ToString(); item.Attributes.Add("StakeholderTypeName", dataRow["StakeholderTypeName"].ToString()); ddlStakeHolderType.Items.Add(item); item.DataBind(); } } catch (Exception ex) { Alert.Show(ex.Message); } }
private void list_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { ((RadComboBox)o).DataTextField = DataField; ((RadComboBox)o).DataValueField = DataField; ((RadComboBox)o).DataSource = GetDataTable("SELECT DISTINCT " + UniqueName + " FROM Customers WHERE " + UniqueName + " LIKE '" + e.Text + "%'"); ((RadComboBox)o).DataBind(); }
protected void RcbAuditingItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { var combo = (RadComboBox)sender; combo.Items.Clear(); if (!string.IsNullOrEmpty(e.Text)) { string key = e.Text; IList <PersonnelInfo> personnelList = _personnelManager.GetList().Where(p => p.RealName.IndexOf(key, StringComparison.Ordinal) > -1).ToList(); Int32 totalCount = personnelList.Count; if (e.NumberOfItems >= totalCount) { e.EndOfItems = true; } else { foreach (PersonnelInfo personnelInfo in personnelList) { var item = new RadComboBoxItem { Text = personnelInfo.RealName, Value = personnelInfo.PersonnelId.ToString() }; combo.Items.Add(item); } } } }
protected void atiRadComboBoxSearchMessageInbox_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { // TODO: we need to search "reply" text and add those messages to the results. RadComboBox atiRadComboBoxSearchMessageInbox = (RadComboBox)sender; atiRadComboBoxSearchMessageInbox.Items.Clear(); const int TAKE = 5; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; IQueryable<Message> messagesQuery = entities.MessageRecipiants.Where( m => m.UserSettingsKey == this.UserSettings.Id ).Select( m => m.Message ).OrderBy(m => m.DateTime); int length = messagesQuery.Count(); messagesQuery = string.IsNullOrEmpty(e.Text) ? messagesQuery.Where(m => m.UserSetting.Id != this.UserSettings.Id).Skip(itemOffset).Take(TAKE) : messagesQuery.Where(m => m.UserSetting.Id != this.UserSettings.Id && m.Subject.ToLower().Contains(e.Text) || m.Text.ToLower().Contains(e.Text)).Skip(itemOffset).Take(TAKE); Message[] messages = messagesQuery.ToArray(); foreach (Message m in messages) { RadComboBoxItem item = new RadComboBoxItem(m.Subject); item.Value = "" + m.Id; // item.ImageUrl = ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?u=" + g.UserKey + "&p=" + g.PortalKey; atiRadComboBoxSearchMessageInbox.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
public virtual void OnRouteItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (this.RouteItemsRequested != null) { this.RouteItemsRequested(sender, e); } }
protected void ComboControl_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { People candidates = null; if (e.Text.Replace(" ", "").Length >= 4) { candidates = People.FromNamePattern(e.Text); } if (candidates == null) { candidates = new People(); } candidates = candidates.GetVisiblePeopleByAuthority(this.authority); candidates.Sort(); int itemOffset = e.NumberOfItems; int itemCount = Math.Min(itemOffset + initialItemCount, candidates.Count); e.EndOfItems = (itemCount == candidates.Count ? true : false); for (int i = itemOffset; i < itemCount; i++) { string descriptionString = candidates[i].Canonical; RadComboBoxItem comboItem = new RadComboBoxItem(descriptionString, candidates[i].Identity.ToString()); comboItem.ImageUrl = "/Images/Public/Fugue/icons-shadowless/" + PersonIcon.ForPerson(candidates[i], Organizations.FromSingle(Organization.PPSE)).Image; this.ComboControl.Items.Add(comboItem); } e.Message = GetStatusMessage(itemCount, candidates.Count); }
protected void dlGang_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) GangId,GangName FROM [tblGangs] WHERE GangName LIKE '%" + e.Text.ToUpper() + "%'"; gangSource.SelectCommand = sql; dlGang.DataBind(); }
protected void cboSeguros_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { //long idEmpresa = long.Parse(e.Text); ///// Cargo los seguros dados de alta para la empresa seleccionada //var Seguros = (from s in Contexto.Seguros // where s.EmpresaContratista == idEmpresa // select new // { // Descripcion = s.objCompañia.Descripcion + " " + s.NroPoliza + " " + s.objTipoSeguro.Descripcion, // s.IdSeguro // }).Distinct(); //cboSeguro.Items.Clear(); //if (Seguros.Count() > 0) //{ // foreach (var item in Seguros) // { // cboSeguro.Items.Add(new RadComboBoxItem(item.Descripcion, item.IdSeguro.ToString())); // } //} //else //{ // cboSeguro.Items.Add(new RadComboBoxItem("No se encontraron resultados", "-1")); //} }
protected void dlCompany_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) DLEcodeCompanyID,DLEcodeCompanyName FROM [tblDLECompany] WHERE Active = 1 AND DLEcodeCompanyName LIKE '%" + e.Text.ToUpper() + "%'"; dleSource.SelectCommand = sql; dlCompany.DataBind(); }
protected void ddlEquipamentoTipo_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { Dictionary <int, string> dicEquipamentoTipo = null; string sTexto = e.Text.Trim(); int itemOffset = 0; int endOffset = 0; try { ddlEquipamentoTipo.Items.Clear(); using (UnitOfWork oUnitOfWork = new UnitOfWork()) { dicEquipamentoTipo = oUnitOfWork.EquipamentoTipoREP.BuscarTodosKeyValue(sTexto); } itemOffset = e.NumberOfItems; endOffset = Math.Min(itemOffset + 10, dicEquipamentoTipo.Count); e.EndOfItems = endOffset == dicEquipamentoTipo.Count; for (int i = itemOffset; i < endOffset; i++) { var item = dicEquipamentoTipo.ElementAt(i); ddlEquipamentoTipo.Items.Add(new RadComboBoxItem(item.Value, item.Key.ToString())); } e.Message = Utils.GetStatusMessage(endOffset, dicEquipamentoTipo.Count); } catch (Exception ex) { Log.Trace(ex, true); Utils.Notificar(ntfGeral, "Falha ao tentar carregar dados de equipamentos. Contate o administrador", Enums.TipoNotificacao.Erro); } }
protected void cboContratos_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { long idEmpresa = long.Parse(e.Text); DateTime fechaAlta = DateTime.Parse("10/10/2080"); /// Cargo los contratos para la empresa seleccionada var Contratos = (from c in Contexto.ContratoEmpresas where c.IdEmpresa == idEmpresa select new { c.Contrato.Codigo, c.Contrato.IdContrato, FechaVencimiento = c.Contrato != null ? (c.Contrato.Prorroga != null && c.Contrato.Prorroga > c.Contrato.FechaVencimiento ? c.Contrato.Prorroga : c.Contrato.FechaVencimiento) : fechaAlta, }).Distinct(); cboContrato.Items.Clear(); if (Contratos.Count() > 0) { foreach (var item in Contratos) { RadComboBoxItem a = new RadComboBoxItem("", ""); a.Value = item.IdContrato.ToString(); a.Text = item.Codigo + " - FV: " + item.FechaVencimiento.Value.ToShortDateString(); a.Attributes.Add("FechaMinima", item.FechaVencimiento.Value.ToShortDateString()); cboContrato.Items.Add(a); } } else { cboContrato.Items.Add(new RadComboBoxItem("No se encontraron resultados", "-1")); } }
protected void dlReportingPoint_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) ReportingPointId,ReportingPoint FROM [tblReportingPoint] WHERE ReportingPoint LIKE '%" + e.Text.ToUpper() + "%'"; repPointSource.SelectCommand = sql; dlReportingPoint.DataBind(); }
protected void atiRadComboBoxSearchAffiliate_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboSearchWorkouts = (RadComboBox)sender; atiRadComboSearchAffiliates.Items.Clear(); const int TAKE = 10; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; IQueryable <CompetitionAffiliate> affiliates = null; affiliates = entities.CompetitionAffiliates.OrderBy(a => a.Name); int length = affiliates.Count(); affiliates = string.IsNullOrEmpty(e.Text) ? affiliates.Skip(itemOffset).Take(TAKE) : affiliates.Where(w => w.Name.ToLower().StartsWith(e.Text)).Skip(itemOffset).Take(TAKE); CompetitionAffiliate[] afArray = affiliates.ToArray(); foreach (CompetitionAffiliate a in afArray) { RadComboBoxItem item = new RadComboBoxItem(a.Name); item.Value = "" + a.Id; atiRadComboSearchWorkouts.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
void cboClient_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { cboClient.Items.Clear(); Orchestrator.Facade.IReferenceData facRefData = new Orchestrator.Facade.ReferenceData(); DataSet ds = facRefData.GetAllClientsFiltered("%" + e.Text); DataTable dt = ds.Tables[0]; DataTable boundResults = dt.Clone(); int itemsPerRequest = 20; int itemOffset = e.NumberOfItems; int endOffset = itemOffset + itemsPerRequest; if (endOffset > dt.Rows.Count) { endOffset = dt.Rows.Count; } for (int i = itemOffset; i < endOffset; i++) { boundResults.ImportRow(dt.Rows[i]); } cboClient.DataSource = boundResults; cboClient.DataBind(); if (dt.Rows.Count > 0) { e.Message = string.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", endOffset.ToString(), dt.Rows.Count.ToString()); } }
private void list_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { ((RadComboBox)o).DataTextField = this.DataField; ((RadComboBox)o).DataValueField = this.DataField; ((RadComboBox)o).DataSource = BLL.Users.DataSource(); ((RadComboBox)o).DataBind(); }
private void list_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { ((RadComboBox)o).DataTextField = this.DataField; ((RadComboBox)o).DataValueField = this.DataField; ((RadComboBox)o).DataSource = GetDataTable("SELECT DISTINCT " + this.UniqueName + " FROM tblmenutimetable WHERE " + this.UniqueName + " LIKE '" + e.Text + "%'"); ((RadComboBox)o).DataBind(); }
protected void dlVessel1_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) VesselId, VesselName FROM tblVessel WHERE VesselName LIKE '%" + e.Text.ToUpper() + "%'"; vesselSource.SelectCommand = sql; dlVessel1.DataBind(); }
protected void cmbCentro_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { try { capascccmex.biz.centro obj = new capascccmex.biz.centro(); List <capascccmex.metadatos.centro> listaCampos = new List <capascccmex.metadatos.centro>(); listaCampos = obj.GetBizCentro(null, 0, 0); RadComboBox rcmb = (RadComboBox)sender; foreach (var _row in listaCampos) { RadComboBoxItem item = new RadComboBoxItem(); //{ //Text=_row.Nombre,Value=_row.IdPerito.ToString() //}; item.Text = _row.Centro; item.Value = _row.IdCentro.ToString(); string _centro = _row.Centro; string _idcentro = _row.IdCentro.ToString(); //string _rf = _row.RegimenFiscal; item.Attributes.Add("Codigo", _idcentro); item.Attributes.Add("Nombre", _centro); //item.Attributes.Add("RegimenFiscal", _rf); rcmb.Items.Add(item); item.DataBind(); } } catch (Exception ex) { windowManager1.RadAlert("Error: " + ex.Message.ToString(), 400, 100, "Cargando Centros", null); } }
protected void dlLocation_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { String sql = "SELECT top(30) LocationId,Location FROM [tblLocation] WHERE Location LIKE '%" + e.Text.ToUpper() + "%'"; locationSource.SelectCommand = sql; dlLocation.DataBind(); }
protected void atiRadComboBoxSearchFollower_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { /* RadComboBox atiRadComboSearchFriends = (RadComboBox)sender; atiRadComboSearchFriends.Items.Clear(); const int TAKE = 5; aqufitEntities entities = new aqufitEntities(); long[] friendIds = entities.UserFriends.Where(f => (f.SrcUserSettingKey == this.ProfileSettings.Id) && f.Relationship == (int)Affine.Utils.ConstsUtil.Relationships.FOLLOW).Select(f => f.SrcUserSettingKey == this.ProfileSettings.Id ? f.DestUserSettingKey : f.SrcUserSettingKey).ToArray(); int itemOffset = e.NumberOfItems; IQueryable<User> friends = entities.UserSettings.OfType<User>().Where(Affine.Utils.Linq.LinqUtils.BuildContainsExpression<User, long>(w => w.Id, friendIds)).OrderBy(w => w.UserName); int length = friends.Count(); friends = string.IsNullOrEmpty(e.Text) ? friends.Skip(itemOffset).Take(TAKE) : friends.Where(w => w.UserName.ToLower().StartsWith(e.Text) || w.UserFirstName.ToLower().StartsWith(e.Text) || w.UserLastName.ToLower().StartsWith(e.Text)).Skip(itemOffset).Take(TAKE); User[] users = friends.ToArray(); foreach (User u in users) { RadComboBoxItem item = new RadComboBoxItem(u.UserFirstName + " (" + u.UserFirstName + " " + u.UserLastName + ")"); item.Value = "" + u.UserName; item.ImageUrl = ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?u=" + u.UserKey + "&p=" + u.PortalKey; atiRadComboSearchFriends.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); */ }
void box_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (itemRequested != null) { itemRequested(this, e); } }
/// <summary>会员搜索 /// </summary> protected void RCB_MemberItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { var combo = (RadComboBox)o; combo.Items.Clear(); string userName = e.Text.Trim(); if (!string.IsNullOrEmpty(userName) && userName.Length >= 2) { var salePlatformId = new Guid(RCB_SalePlatform.SelectedValue); var list = MemberCenterSao.GetUserToDic(salePlatformId, userName); var totalCount = list.Count; if (e.NumberOfItems >= totalCount) { e.EndOfItems = true; } else { foreach (var item in list) { var rcb = new RadComboBoxItem { Text = item.Value, Value = item.Key.ToString() }; combo.Items.Add(rcb); } } } }
protected void RCB_CompanyList_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { var combo = (RadComboBox)sender; combo.Items.Clear(); if (!string.IsNullOrEmpty(e.Text)) { string key = e.Text; var companyList = (IList <CompanyCussentInfo>)CompanyCussentList().Where(p => p.CompanyName.IndexOf(key, StringComparison.Ordinal) > -1).ToList(); if (e.NumberOfItems >= companyList.Count) { e.EndOfItems = true; } else { foreach (CompanyCussentInfo i in companyList) { var item = new RadComboBoxItem { Text = i.CompanyName, Value = i.CompanyId.ToString() }; combo.Items.Add(item); } } } }
protected void ProductDDL2_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { ////get all customers whose name starts with e.Text //string sql = "SELECT * from Customers WHERE ContactName LIKE '" + e.Text + "%'"; //SessionDataSource1.SelectCommand = sql; //RadComboBox1.DataBind(); }
protected void cboCopyFromTable_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { int tariffVersionID = 0; int.TryParse(e.Text, out tariffVersionID); LoadCopyFromTables(tariffVersionID); }
protected void cbxNhanVien_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { //var dt = from q in _entities.GetAllCV() // where q.TenNV.Contains(e.Text) // select q; //cbxNhanVien.DataSource = dt; //cbxNhanVien.DataBind(); }
protected void cmbEquipo_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (cmbInstalacion.SelectedValue.Length > 0) { int _idInstalacion = Convert.ToInt16(cmbInstalacion.SelectedValue); EquipoByInstalacion(_idInstalacion); } }
protected void RCB_Company_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { if (!string.IsNullOrEmpty(e.Text)) { RCB_Company.Items.Clear(); BindCompany(CompanyList.Where(c => c.CompanyName.Contains(e.Text)).ToList()); } }
protected void cmbInstalacion_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (cmbcentro.SelectedValue.Length > 0) { int _idCentro = Convert.ToInt16(cmbcentro.SelectedValue); InstalacionesbyCentro(_idCentro); } }
protected void m_cboExceptionTypes_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox cboExceptionTypes = sender as RadComboBox; foreach (var entity in CoreLib.AttendanceExceptionType.All) { cboExceptionTypes.Items.Add(new RadComboBoxItem(entity.Name, entity.ID.ToString())); } }
protected void m_cboEntities_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { foreach (var entity in BusinessEntity.All) { var cboItem = new RadComboBoxItem(entity.Name, entity.ID.ToString()); cboItem.ImageUrl = entity.Type == BusinessEntityType.Company ? "Images/headquater.png" : "Images/branch.png"; m_cboEntities.Items.Add(cboItem); } }
protected void drpBoard_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { DataSet ds = objglcode.fetchComboData("FETCH_ALL_GL_CODE_FOR_REPORT", e.Text); DataTable dt = ds.Tables[0]; onitemrequest(drpBoard, dt, e.NumberOfItems); }
protected void m_cboContactDetails_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox cboContactFields = sender as RadComboBox; foreach (var profileField in CoreLib.Profile.Contact.Fields) { cboContactFields.Items.Add(new RadComboBoxItem(profileField.Name, profileField.ID.ToString())); } }
protected void OnDropdownCompany_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { string companyName = e.Text; if (!string.IsNullOrEmpty(companyName)) { List<Company> list = new CompanyRepository().FindByName(companyName); ddlCompany.DataSource = list; ddlCompany.DataBind(); } }
protected void RadComboBox1_ItemsRequested1(object sender, RadComboBoxItemsRequestedEventArgs e) { if (e.Text == "") return; RadComboBox combo = (RadComboBox)sender; var rs = from p in ctx.Patients where p.FullName.StartsWith(e.Text) select p; foreach (Patient pat in rs) { combo.Items.Add(new RadComboBoxItem(pat.FullName, pat.PersonId.ToString())); } }
//private const string CompetencyTrackingReport = "Competency Tracking Report"; //private const string CompetencyTrackingReport_NoSpaces = "CompetencyTrackingReport"; #region search criteria event protected void ddlSchoolType_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { this.ddlSchoolType.DataSource = null; this.ddlSchoolType.DataBind(); if (this.SessionObject != null && this.SessionObject.LoggedInUser != null) { var loggedInUser = this.SessionObject.LoggedInUser; if (loggedInUser.Roles != null && loggedInUser.Roles.Any()) { this.ddlSchoolType.DataSource = this.ViewModel.GetAllSchoolType(loggedInUser).Select(c => new { Text = string.Format("{0}", c.Name), Value = c.Name }); this.ddlSchoolType.DataBind(); } } }
protected void OnDropdownCandidate_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { string name = e.Text; if (!string.IsNullOrEmpty(name)) { if(name.Length >= 3) { List<Candidate> list = new CandidateRepository().SearchCandidatesOnName(name); ddlCandidate.DataTextField = "FullName"; ddlCandidate.DataValueField = "CandidateId"; ddlCandidate.DataSource = list; ddlCandidate.DataBind(); } } }
protected void cboTitular_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeTitular>()) { cboTitular.Items.Clear(); foreach (var titular in servico.ObtenhaPorNomeComoFiltro(e.Text, 50)) { var item = new RadComboBoxItem(titular.Pessoa.Nome, titular.Pessoa.ID.ToString()); item.Attributes.Add("DataDoCadastro", titular.DataDoCadastro.Value.ToString("dd/MM/yyyy")); item.Attributes.Add("InformacoesAdicionais", titular.InformacoesAdicionais); cboTitular.Items.Add(item); item.DataBind(); } } }
protected void RadComboBox2_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { DataTable data = Peerfx_DB.SPs.ViewUsersAllAdminDeposits(e.Text).GetDataSet().Tables[0]; int itemOffset = e.NumberOfItems; int endOffset = Math.Min(itemOffset + 10, data.Rows.Count); e.EndOfItems = endOffset == data.Rows.Count; RadComboBox rdc = (RadComboBox)sender; for (int i = itemOffset; i < endOffset; i++) { rdc.Items.Add(new RadComboBoxItem(data.Rows[i]["user_info_full"].ToString(), data.Rows[i]["user_key"].ToString())); } //e.Message = GetStatusMessage(endOffset, data.Rows.Count); }
protected void cboNCL_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { var ncls = NCL.ObtenhaPorCodigoComoFiltro(e.Text); if (ncls.Count > 0) { foreach (var ncl in ncls) { var item = new RadComboBoxItem(ncl.Codigo, ncl.Codigo); item.Attributes.Add("Descricao", ncl.Descricao); item.Attributes.Add("Natureza", ncl.NaturezaDeMarca.Nome); cboNCL.Items.Add(item); item.DataBind(); } } }
protected void cboProcedimentosInternos_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { IList<ITipoDeProcedimentoInterno> listaProcedimentosInternos = new List<ITipoDeProcedimentoInterno>(); using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeTipoDeProcedimentoInterno>()) { listaProcedimentosInternos = servico.obtenhaTipoProcedimentoInternoPelaDescricao(e.Text); } if (listaProcedimentosInternos.Count > 0) { foreach (var procedimentoInterno in listaProcedimentosInternos) { var item = new RadComboBoxItem(procedimentoInterno.Descricao, procedimentoInterno.Id.Value.ToString()); item.Attributes.Add("ID", procedimentoInterno.Id.ToString()); cboTipoDeProcedimentosInternos.Items.Add(item); item.DataBind(); } } }
protected void atiRadComboBoxSearchRoutes_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboSearchWorkouts = (RadComboBox)sender; atiRadComboSearchWorkouts.Items.Clear(); const int TAKE = 5; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; IQueryable<MapRoute> routes = entities.User2MapRouteFav.Where(r => r.UserSettingsKey == UserSettings.Id).Select(w => w.MapRoute); routes = routes.OrderBy(r => r.Name); int length = routes.Count(); routes = string.IsNullOrEmpty(e.Text) ? routes.Skip(itemOffset).Take(TAKE) : routes.Where(r => r.Name.ToLower().StartsWith(e.Text)).Skip(itemOffset).Take(TAKE); MapRoute[] routeArray = routes.ToArray(); foreach (MapRoute r in routeArray) { RadComboBoxItem item = new RadComboBoxItem(r.Name); item.Value = "" + r.Id; atiRadComboSearchWorkouts.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
protected void rdcProfessional_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (e.Text == "") return; RadComboBox combo = (RadComboBox)sender; combo.Items.Clear(); var rs = from p in ctx.Professionals where p.ComercialName.StartsWith(e.Text) select p; foreach (Professional professional in rs) { if (!professional.Inactive) combo.Items.Add(new RadComboBoxItem(professional.ComercialName, professional.PersonId.ToString())); } }
//protected void CboProcedimentos_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) //{ // //DataSet ls = m_oSumario.ListaProcedimentos(); // RadComboBox Combo = (RadComboBox)sender; // Combo.Items.Clear(); // DataRow[] rows; // RadComboBoxItem item; // string m_sTexto = e.Text.Replace("*", ""); // m_sTexto = m_sTexto.Replace("%", ""); // m_sTexto = m_sTexto.Replace("[", ""); // m_sTexto = m_sTexto.Replace("]", ""); // rows = ls.Tables[0].Select("(DESCRICAO LIKE '" + m_sTexto + "*')"); // for (int i = 0; i < rows.Count(); i++) // { // item = new RadComboBoxItem(); // item.Text = rows[i]["DESCRICAO"].ToString(); // item.Value = rows[i]["IDDWD016"].ToString(); // Combo.Items.Add(item); // } //} protected void CboProcedimentos_ItemsRequested1(object o, RadComboBoxItemsRequestedEventArgs e) { DataSet ls = m_oSumario.ListaProcedimentos(); RadComboBox Combo = (RadComboBox)o; Combo.Items.Clear(); DataRow[] rows; RadComboBoxItem item; string m_sTexto = e.Text.Replace("*", ""); m_sTexto = m_sTexto.Replace("%", ""); m_sTexto = m_sTexto.Replace("[", ""); m_sTexto = m_sTexto.Replace("]", ""); rows = ls.Tables[0].Select("(DESCRICAO LIKE '*" + m_sTexto + "*')"); for (int i = 0; i < rows.Count(); i++) { item = new RadComboBoxItem(); item.Text = rows[i]["DESCRICAO"].ToString(); item.Value = rows[i]["IDDWD016"].ToString(); Combo.Items.Add(item); } }
protected virtual void OnItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { this.InitDDLInternal(); }
protected void atiRadComboBoxSearchAffiliate_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboSearchWorkouts = (RadComboBox)sender; atiRadComboSearchAffiliates.Items.Clear(); const int TAKE = 10; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; IQueryable<CompetitionAffiliate> affiliates = null; affiliates = entities.CompetitionAffiliates.OrderBy( a => a.Name ); int length = affiliates.Count(); affiliates = string.IsNullOrEmpty(e.Text) ? affiliates.Skip(itemOffset).Take(TAKE) : affiliates.Where(w => w.Name.ToLower().StartsWith(e.Text)).Skip(itemOffset).Take(TAKE); CompetitionAffiliate[] afArray = affiliates.ToArray(); foreach (CompetitionAffiliate a in afArray) { RadComboBoxItem item = new RadComboBoxItem(a.Name); item.Value = "" + a.Id; atiRadComboSearchWorkouts.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
protected void GetAllInvoiceTypes_Selecting(object sender, RadComboBoxItemsRequestedEventArgs e) { DataClasses1DataContext dbContext = new DataClasses1DataContext(); RadComboBox rcbInvoiceType = ((RadComboBox)sender); rcbInvoiceType.Items.Clear(); var types = from tp in dbContext.InvoiceTypes select new { Key = tp.ID, Value = tp.InvoiceTypeName }; rcbInvoiceType.DataSource = types; rcbInvoiceType.DataBind(); }
protected void rdcExamination_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (e.Text == "") return; RadComboBox combo = (RadComboBox)sender; combo.Items.Clear(); var rs = from d in ctx.Examinations where d.Name.StartsWith(e.Text) && d.ExaminationType.Code == "biometry" select d; foreach (Examination dia in rs) { combo.Items.Add(new RadComboBoxItem(dia.Name, dia.ExaminationId.ToString())); } }
protected void LoadCapabilityValues(object source, RadComboBoxItemsRequestedEventArgs e) { BindCapabilityValues(e.Text); SetCapabilityAndValue(); }
protected void atiWorkout_WodItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboBoxCrossfitWorkouts = (RadComboBox)sender; const int TAKE = 10; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; if (itemOffset == 0) { RadComboBoxItem item = new RadComboBoxItem("Create a New Workout"); item.Value = "{'Id':0, 'Type':'0'}"; atiRadComboBoxCrossfitWorkouts.Items.Add(item); } IQueryable<WOD> wods = entities.User2WODFav.Where(w => w.UserSetting.Id == UserSettings.Id).Select(w => w.WOD); wods = wods.Union<WOD>(entities.WODs.Where(w => w.Standard > 0)); wods.Select(w => w.WODType).ToArray(); // hydrate WODTypes long[] groupIds = null; groupIds = entities.UserFriends.Where(f => (f.SrcUserSettingKey == UserSettings.Id || f.DestUserSettingKey == UserSettings.Id) && f.Relationship >= (int)Affine.Utils.ConstsUtil.Relationships.GROUP_OWNER).Select(f => f.SrcUserSettingKey == UserSettings.Id ? f.DestUserSettingKey : f.SrcUserSettingKey).ToArray(); // OK this is a bit of a trick... this query hydrates only the "WODSchedule" in the above WOD query.. so we will get the wods we are looking for.. IEnumerable< WODSchedule >[] workoutSchedule = entities.UserSettings.OfType<Group>().Where(LinqUtils.BuildContainsExpression<UserSettings, long>(us => us.Id, groupIds)).Select(g => g.WODSchedules.Where(ws => ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0)).ToArray(); string lowerTxt = e.Text.ToLower(); if (!string.IsNullOrWhiteSpace(e.Text)) { wods = wods.Where(w => w.Name.ToLower().StartsWith(lowerTxt) || w.WODSchedules.Where(ws => ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0).Any(ws => ws.HiddenName.ToLower().StartsWith(lowerTxt))).OrderBy(w => w.Name); } else { wods = wods.OrderByDescending(w => w.CreationDate); } int length = wods.Count(); wods = wods.Skip(itemOffset).Take(TAKE); WOD[] wodList = wods.ToArray(); int endOffset = Math.Min(itemOffset + TAKE, length); e.EndOfItems = endOffset == length; for (int i = 0; i < wodList.Length; i++) { WOD w = wodList[i]; if (w.WODSchedules != null && w.WODSchedules.Count > 0) { WODSchedule ws = w.WODSchedules.OrderByDescending( s => s.HideTillDate ).First(); if (ws.HideTillDate.HasValue && DateTime.Now.CompareTo(ws.HideTillDate.Value) < 0) { if (string.IsNullOrWhiteSpace(e.Text)) { atiRadComboBoxCrossfitWorkouts.Items.Add(new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}")); if (w.Standard > 0 || w.WODSchedules.Count > 1) { // CA - here is what is going on here. If the workout is suppost to be hidden until a date (common for crossfit gyms) then we just put a date name like up // top. But if it is a standard WOD (or a wod that they have done before (w.WODSchedules.Count > 1) then we still need to add the WOD atiRadComboBoxCrossfitWorkouts.Items.Add(new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}")); } } else if (ws.HiddenName.ToLower().StartsWith(lowerTxt)) { atiRadComboBoxCrossfitWorkouts.Items.Add(new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString(ws.HiddenName), "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}")); } } else { atiRadComboBoxCrossfitWorkouts.Items.Add(new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}")); } } else { atiRadComboBoxCrossfitWorkouts.Items.Add(new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString(w.Name), "{ 'Id':" + w.Id + ", 'Type':" + w.WODType.Id + "}")); } } e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
protected void atiWorkout_RouteItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboBoxCrossfitWorkouts = (RadComboBox)sender; atiRadComboBoxCrossfitWorkouts.Items.Clear(); const int TAKE = 9; aqufitEntities entities = new aqufitEntities(); IQueryable<MapRoute> mapRoutesQuery = string.IsNullOrEmpty(e.Text) ? entities.User2MapRouteFav.Include("MapRoutes").Where(r => r.UserSettingsKey == UserSettings.Id ).Select( r => r.MapRoute ).OrderBy(w => w.Name) : entities.User2MapRouteFav.Include("MapRoutes").Where(r => r.UserSettingsKey == UserSettings.Id ).Select( r => r.MapRoute ).Where(r => r.Name.ToLower().StartsWith(e.Text)).OrderBy(r => r.Name); int itemOffset = e.NumberOfItems > 0 ? e.NumberOfItems-1 : 0; List<MapRoute> mapRoutes = mapRoutesQuery.Skip(itemOffset).Take(TAKE).ToList(); string mapIcon = ResolveUrl("~/DesktopModules/ATI_Base/resources/images/iMap.png"); if (itemOffset == 0) { RadComboBoxItem item = new RadComboBoxItem("Add New Map"); item.Value = "{'Id':0, 'Dist':'0'}"; item.ImageUrl = mapIcon; atiRadComboBoxCrossfitWorkouts.Items.Add(item); } Affine.Utils.UnitsUtil.MeasureUnit unit = base.UserSettings.DistanceUnits != null ? Affine.Utils.UnitsUtil.ToUnit(Convert.ToInt32(base.UserSettings.DistanceUnits)) : UnitsUtil.MeasureUnit.UNIT_MILES; string unitName = Affine.Utils.UnitsUtil.unitToStringName(unit); foreach (MapRoute mr in mapRoutes) { double dist = Affine.Utils.UnitsUtil.systemDefaultToUnits( mr.RouteDistance, unit); dist = Math.Round(dist, 2); RadComboBoxItem item = new RadComboBoxItem(Affine.Utils.Web.WebUtils.FromWebSafeString( mr.Name ) + " (" + dist + " " +unitName+ ")"); item.Value = "{ 'Id':" + mr.Id + ", 'Dist':" + mr.RouteDistance + "}"; item.ImageUrl = Affine.Utils.ImageUtil.GetGoogleMapsStaticImage(mr, 200, 150); atiRadComboBoxCrossfitWorkouts.Items.Add(item); } int length = mapRoutesQuery.Count(); int endOffset = Math.Min(itemOffset + TAKE+1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
protected void cmbErloeskonten_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { DataClasses1DataContext dbContext = new DataClasses1DataContext(); RadComboBox cmbErloeskonten = ((RadComboBox)sender); Label lbl = cmbErloeskonten.Parent.FindControl("lblId") as Label; cmbErloeskonten.Items.Clear(); cmbErloeskonten.Text = string.Empty; var myErloeskonten = from _accounts in dbContext.Accounts where _accounts.CustomerId == Int32.Parse(lbl.Text) group _accounts by _accounts.AccountNumber into count select new { count.Key }; foreach (var myItem in myErloeskonten) { cmbErloeskonten.Items.Add(new RadComboBoxItem(myItem.Key)); } }
protected void ZipCodes_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { DataClasses1DataContext dbContext = new DataClasses1DataContext(); RadComboBox cmbZipCode = ((RadComboBox)sender); cmbZipCode.Items.Clear(); var myzipCodes = from zipCodes in dbContext.Adress group zipCodes by zipCodes.Zipcode into z select new { z.Key }; foreach (var myItem in myzipCodes) { cmbZipCode.Items.Add(new RadComboBoxItem(myItem.Key)); } }
protected void rdcVisitReason_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (e.Text == "") return; RadComboBox combo = (RadComboBox)sender; combo.Items.Clear(); var rs = from d in ctx.VisitReasons where d.Name.StartsWith(e.Text) select d; foreach (VisitReason dia in rs) { combo.Items.Add(new RadComboBoxItem(dia.Name, dia.VisitReasonId.ToString())); } }
protected void rdcAppointmentType_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { if (e.Text == "") return; RadComboBox combo = (RadComboBox)sender; combo.Items.Clear(); var rs = from apt in ctx.AppointmentTypes where apt.Name.StartsWith(e.Text) select apt; foreach (AppointmentType apt in rs) { combo.Items.Add(new RadComboBoxItem(apt.Name, apt.AppointmentTypeId.ToString())); } }
protected void atiRadComboBoxSearchGroups_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { RadComboBox atiRadComboBoxSearchGroups = (RadComboBox)sender; atiRadComboBoxSearchGroups.Items.Clear(); const int TAKE = 15; aqufitEntities entities = new aqufitEntities(); int itemOffset = e.NumberOfItems; IQueryable<Group> friends = entities.UserSettings.OfType<Group>().OrderBy(w => w.UserName); if( !string.IsNullOrEmpty(e.Text) ){ friends = friends.Where(w => w.UserName.ToLower().Contains(e.Text) || w.UserFirstName.ToLower().Contains(e.Text)); } int length = friends.Count(); friends = friends.Skip(itemOffset).Take(TAKE); Group[] groups = friends.ToArray(); foreach (Group g in groups) { RadComboBoxItem item = new RadComboBoxItem(g.UserFirstName); item.Value = " { 'Address': '', 'GroupKey':" + g.Id + ", 'Lat':" + g.DefaultMapLat + ", 'Lng':" + g.DefaultMapLng + " , 'Name':'" + g.UserFirstName + "', 'UserName':'******'","") + "', 'UserKey':" + g.UserKey + ", 'ImageId':0, 'Description':'' }"; // item.ImageUrl = ResolveUrl("~/DesktopModules/ATI_Base/services/images/profile.aspx") + "?u=" + g.UserKey + "&p=" + g.PortalKey; atiRadComboBoxSearchGroups.Items.Add(item); } int endOffset = Math.Min(itemOffset + TAKE + 1, length); e.EndOfItems = endOffset == length; e.Message = (length <= 0) ? "No matches" : String.Format("Items <b>1</b>-<b>{0}</b> of {1}", endOffset, length); }
protected void OnCompanyDropdownItemRequested(object o, RadComboBoxItemsRequestedEventArgs e) { string companyName = e.Text; if (!string.IsNullOrEmpty(companyName)) { CompanyRepository companyRepo = new CompanyRepository(); ddlCompany.DataTextField = "CompanyName"; ddlCompany.DataValueField = "CompanyID"; ddlCompany.DataSource = companyRepo.FindByName(companyName);// .GetAllCompanies(); ddlCompany.DataBind(); } }
protected void Country_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { DataClasses1DataContext dbContext = new DataClasses1DataContext(); RadComboBox cmbCountry = ((RadComboBox)sender); cmbCountry.Items.Clear(); var myCountrys = from countrys in dbContext.Adress group countrys by countrys.Country into count select new { count.Key }; foreach (var myItem in myCountrys) { cmbCountry.Items.Add(new RadComboBoxItem(myItem.Key)); } }