public void FillCombobox(Telerik.Web.UI.RadComboBox RCBPurchaseOrder, string argClientCode, string argInBDeliveryDocTypeCode, string argToDocType)
{
RCBPurchaseOrder.Items.Clear();
foreach (DataRow dr in GetPurchaseOrder4InBDC(argClientCode, argInBDeliveryDocTypeCode, argToDocType).Tables[0].Rows)
{
String itemText = dr["PODocCode"].ToString().Trim();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["PODocCode"].ToString().Trim()
};
itemCollection.Attributes.Add("PODocCode", dr["PODocCode"].ToString().Trim());
itemCollection.Attributes.Add("PODocDate", dr["PODocumentDate"].ToString());
itemCollection.Attributes.Add("POTypeCode", dr["POTypeCode"].ToString());
itemCollection.Attributes.Add("VendorCode", dr["VendorCode"].ToString());
itemCollection.Attributes.Add("VendorName", dr["Name1"].ToString());
itemCollection.Attributes.Add("PurchaseOrgCode", dr["PurchaseOrgCode"].ToString());
itemCollection.Attributes.Add("CompanyCode", dr["CompanyCode"].ToString());
itemCollection.Attributes.Add("SourcePlantCode", dr["SourcePlantCode"].ToString());
itemCollection.Attributes.Add("POStatus", dr["POStatus"].ToString());
RCBPurchaseOrder.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox4BD(Telerik.Web.UI.RadComboBox RCBSalesOrder, string argClientCode, string argBillingDocTypeCode, string argToDocType)
{
RCBSalesOrder.Items.Clear();
foreach (DataRow dr in GetSalesOrder4BD(argClientCode, argBillingDocTypeCode, argToDocType).Tables[0].Rows)
{
String itemText = dr["SODocCode"].ToString().Trim();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["SODocCode"].ToString().Trim()
};
itemCollection.Attributes.Add("SODocCode", dr["SODocCode"].ToString().Trim());
itemCollection.Attributes.Add("SODocDate", dr["SODocDate"].ToString());
itemCollection.Attributes.Add("SOTypeCode", dr["SOTypeCode"].ToString());
itemCollection.Attributes.Add("BillToParty", dr["BillToParty"].ToString());
itemCollection.Attributes.Add("BillToPartyName", dr["BillToPartyName"].ToString());
itemCollection.Attributes.Add("DocumentCode", dr["DocumentCode"].ToString().Trim());
itemCollection.Attributes.Add("SalesOrganizationCode", dr["SalesOrganizationCode"].ToString());
itemCollection.Attributes.Add("DistChannelCode", dr["DistChannelCode"].ToString());
itemCollection.Attributes.Add("DivisionCode", dr["DivisionCode"].ToString());
itemCollection.Attributes.Add("SOStatus", dr["SOStatus"].ToString());
RCBSalesOrder.Items.Add(itemCollection);
itemCollection.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 RadComboBoxFirma_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
if (e.Text.Length > 3)
{
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [UserID],[UserName] from [telerik_Users] ORDER BY [UserName]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string UserName = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["UserName"].ToString();
item.Value = dataRow["UserId"].ToString();
UserName = (string)dataRow["UserName"];
if (dataRow["UserName"] != System.DBNull.Value)
{
UserName = (string)dataRow["UserName"];
}
//item.Attributes.Add("FIRMAADI", FirmaAdi);
//item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
lbl.Text = "Bulunan kayıt sayısı:" + " " + dataTable.Rows.Count.ToString();
}
}
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 RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
//string BolgeKodu = Session["BolgeKodu"].ToString();
//string bak = e.Text;
if (e.Text.Length > 2)
{
string BolgeKodu = intBolgeKodu.ToString();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string IlIlce = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["MUSTNO"].ToString();
item.Value = dataRow["FIRMAID"].ToString();
string FirmaAdi = (string)dataRow["FIRMAADI"];
if (dataRow["IL_ILCE"] != System.DBNull.Value)
{
IlIlce = (string)dataRow["IL_ILCE"];
}
item.Attributes.Add("FIRMAADI", FirmaAdi);
item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
lbl.Text = "Bulunan kayıt sayısı:" + " " + dataTable.Rows.Count.ToString();
}
}
protected void RadComboBox1_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
string sql = "SELECT [SupplierID], [CompanyName], [ContactName], [City] FROM [Suppliers] WHERE CompanyName LIKE @CompanyName + '%'";
SqlDataAdapter adapter = new SqlDataAdapter(sql,
ConfigurationManager.ConnectionStrings["TelerikVSXConnectionString"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@CompanyName", e.Text);
DataTable dt = new DataTable();
adapter.Fill(dt);
RadComboBox comboBox = (RadComboBox)sender;
// Clear the default Item that has been re-created from ViewState at this point.
comboBox.Items.Clear();
foreach (DataRow row in dt.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = row["CompanyName"].ToString();
item.Value = row["SupplierID"].ToString();
item.Attributes.Add("ContactName", row["ContactName"].ToString());
comboBox.Items.Add(item);
item.DataBind();
}
}
protected void RadComboBoxFirma_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
if (e.Text.Length > 3)
{
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [UserID],[UserName] from [telerik_Users] ORDER BY [UserName]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string UserName = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["UserName"].ToString();
item.Value = dataRow["UserId"].ToString();
UserName = (string)dataRow["UserName"];
if (dataRow["UserName"] != System.DBNull.Value)
{
UserName = (string)dataRow["UserName"];
}
//item.Attributes.Add("FIRMAADI", FirmaAdi);
//item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
lbl.Text = "Bulunan kayıt sayısı:" + " " + dataTable.Rows.Count.ToString();
}
}
public static void FillDropdownList(RadComboBox rcbMe, DataTable contents, string textField, string valueField, bool AddBlankItem, string valueSelected)
{
RadComboBoxItem itemEmpty = new RadComboBoxItem();
rcbMe.Items.Clear();
if (AddBlankItem == true)
{
itemEmpty.Text = "All";
itemEmpty.Value = "All";
rcbMe.Items.Add(itemEmpty);
itemEmpty.DataBind();
}
foreach (DataRow dataRow in contents.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow[textField];
item.Value = dataRow[valueField].ToString();
rcbMe.Items.Add(item);
item.DataBind();
}
if (valueSelected != null)
{
rcbMe.SelectedValue = valueSelected;
}
}
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);
}
}
protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
if (e.Text.Length > 3)
{
using (Service1Client client = new Service1Client())
{
intBolgeKodu = client.BolgeKoduDon(Context.User.Identity.Name);
}
string BolgeKodu = intBolgeKodu.ToString();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string IlIlce = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["MUSTNO"].ToString();
item.Value = dataRow["FIRMAID"].ToString();
string FirmaAdi = (string)dataRow["FIRMAADI"];
if (dataRow["IL_ILCE"] != System.DBNull.Value)
{
IlIlce = (string)dataRow["IL_ILCE"];
}
item.Attributes.Add("FIRMAADI", FirmaAdi);
item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
}
}
protected void RadComboBoxCihaz_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
RadComboBoxCihaz.Items.Clear();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [ID],[CIHAZADI], [LAB] from [cihaz] WHERE [CIHAZADI] LIKE '%'+ @text + '%' ORDER BY [CIHAZADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxCihaz.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string Lab = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["CIHAZADI"].ToString();
item.Value = dataRow["ID"].ToString();
Lab = (string)dataRow["LAB"];
item.Attributes.Add("LAB", Lab);
RadComboBoxCihaz.Items.Add(item);
item.DataBind();
}
}
private void CarregueCombo()
{
foreach (EnumeradorFiltroPatente enumerador in EnumeradorFiltroPatente.ObtenhaTodos())
{
var item = new RadComboBoxItem(enumerador.Descricao, enumerador.Id.ToString());
item.Attributes.Add("Codigo", enumerador.Id.ToString());
cboFiltroPatente.Items.Add(item);
item.DataBind();
}
}
private void CarregueCombo()
{
foreach (var mes in Mes.ObtenhaTodas())
{
var item = new RadComboBoxItem(mes.Descricao, mes.Codigo.ToString());
item.Attributes.Add("Codigo", mes.Codigo.ToString());
cboMes.Items.Add(item);
item.DataBind();
}
}
public static void ComboBox_BindLevelData(RadComboBox cmb)
{
string[] levelText = { "请选择", "低", "中", "高" };
for (int i = 0; i < levelText.Length; i++)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Value = i.ToString();
item.Text = levelText[i];
cmb.Items.Add(item);
item.DataBind();
}
}
private void CarregueCombo()
{
foreach (var apresentacao in Apresentacao.ObtenhaTodas())
{
var item = new RadComboBoxItem(apresentacao.Nome, apresentacao.Codigo.ToString());
item.Attributes.Add("Codigo", apresentacao.Codigo.ToString());
cboApresentacao.Items.Add(item);
item.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();
}
}
}
public void FillComboboxFields(Telerik.Web.UI.RadComboBox RCBTableField, string argTableName)
{
RCBTableField.Items.Clear();
foreach (DataColumn dc in GetDBTableFields(argTableName).Tables[0].Columns)
{
string itemText = dc.ColumnName.ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dc.ColumnName.ToString()
};
RCBTableField.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
private void CarregueComboClasseViena(ILeituraRevistaDeMarcas processo)
{
cboClassificacaoViena.Items.Clear();
cboClassificacaoViena.Attributes.Clear();
foreach (var codigo in processo.ClasseViena.ListaDeCodigosClasseViena)
{
var item = new RadComboBoxItem(processo.ClasseViena.EdicaoClasseViena, processo.ClasseViena.EdicaoClasseViena);
item.Attributes.Add("Codigo",
codigo ?? "Não informada");
this.cboClassificacaoViena.Items.Add(item);
item.DataBind();
}
}
protected void RadComboBoxTask_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
IQueryable <Task> tasks = (IQueryable <Task>)_db.Tasks.Where(p => p.projectId == projectID);
RadComboBox comboBox = (RadComboBox)sender;
comboBox.Items.Clear();
foreach (Task t in tasks)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = t.name;
item.Value = t.taskId.ToString();
comboBox.Items.Add(item);
item.DataBind();
}
}
protected void RadComboBoxProject_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
IQueryable <Project> projects = (IQueryable <Project>)_db.Projects;
RadComboBox comboBox = (RadComboBox)sender;
comboBox.Items.Clear();
foreach (Project p in projects)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = p.name;
item.Value = p.projectId.ToString();
comboBox.Items.Add(item);
item.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBTableStructure)
{
RCBTableStructure.Items.Clear();
foreach (DataRow dr in GetDBTableStructure().Tables[0].Rows)
{
String itemText = dr["TableName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["TableName"].ToString()
};
itemCollection.Attributes.Add("TableName", dr["TableName"].ToString());
RCBTableStructure.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBSalesOrderDetailItemNo, string argClientCode, string argSODocCode)
{
RCBSalesOrderDetailItemNo.Items.Clear();
foreach (DataRow dr in GetSalesOrderDetailsItemNo(argSODocCode, argClientCode).Tables[0].Rows)
{
String itemText = dr["SOItemNo"].ToString().Trim();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["SOItemNo"].ToString().Trim()
};
itemCollection.Attributes.Add("SOItemNo", dr["SOItemNo"].ToString().Trim());
RCBSalesOrderDetailItemNo.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillModuleType(Telerik.Web.UI.RadComboBox RCBModuleType, string argClientCode)
{
RCBModuleType.Items.Clear();
foreach (DataRow dr in GetModuleType(argClientCode).Tables[0].Rows)
{
String itemText = dr["ModuleType"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["ModuleType"].ToString().Trim()
};
itemCollection.Attributes.Add("ModuleType", dr["ModuleType"].ToString());
RCBModuleType.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
protected void OnItemDataBoundHandler(object sender, GridItemEventArgs e)
{
if (e.Item.IsInEditMode)
{
GridEditableItem item = (GridEditableItem)e.Item;
if (!(e.Item is IGridInsertItem))
{
RadComboBox combo = (RadComboBox)item.FindControl("RadComboBox1");
RadComboBoxItem selectedItem = new RadComboBoxItem();
selectedItem.Text = ((DataRowView)e.Item.DataItem)["CompanyName"].ToString();
selectedItem.Value = ((DataRowView)e.Item.DataItem)["SupplierID"].ToString();
selectedItem.Attributes.Add("ContactName", ((DataRowView)e.Item.DataItem)["ContactName"].ToString());
combo.Items.Add(selectedItem);
selectedItem.DataBind();
Session["SupplierID"] = selectedItem.Value;
}
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBFiledName, int iIsDeleted)
{
RCBFiledName.Items.Clear();
foreach (DataRow dr in GetFieldMaster(iIsDeleted).Tables[0].Rows)
{
String itemText = dr["FieldName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["FieldName"].ToString()
};
itemCollection.Attributes.Add("FieldName", dr["FieldName"].ToString());
RCBFiledName.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCbCRLimitCheck, string argClientCode, int iIsDeleted)
{
RCbCRLimitCheck.Items.Clear();
foreach (DataRow dr in GetCRLimitCheck(iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["CRLimitCheckType"].ToString().Trim() + " " + dr["CRLimitCheckDesc"].ToString().Trim();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["CRLimitCheckType"].ToString().Trim()
};
itemCollection.Attributes.Add("CRLimitCheckType", dr["CRLimitCheckType"].ToString().Trim());
itemCollection.Attributes.Add("CRLimitCheckDesc", dr["CRLimitCheckDesc"].ToString().Trim());
RCbCRLimitCheck.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
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();
}
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBIndustryMaster, string argClientCode, int iIsDeleted)
{
RCBIndustryMaster.Items.Clear();
foreach (DataRow dr in GetIndustryMaster(iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["IndustryName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["IndustryName"].ToString().Trim()
};
itemCollection.Attributes.Add("IndustryName", dr["IndustryName"].ToString());
RCBIndustryMaster.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(RadComboBox RCBPartnerStore, string argClientCode, int iIsDeleted)
{
RCBPartnerStore.Items.Clear();
foreach (DataRow dr in GetPartnerStorageLocation(iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["StoreCode"].ToString() + " " + dr["StoreName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["StoreCode"].ToString().Trim()
};
itemCollection.Attributes.Add("StoreCode", dr["StoreCode"].ToString());
itemCollection.Attributes.Add("StoreName", dr["StoreName"].ToString());
RCBPartnerStore.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBItemType, int iIsDeleted)
{
RCBItemType.Items.Clear();
foreach (DataRow dr in GetItemType().Tables[0].Rows)
{
String itemText = dr["ItemTypeCode"].ToString().Trim() + " " + dr["ItemTypeDesc"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["ItemTypeCode"].ToString().Trim()
};
itemCollection.Attributes.Add("ItemTypeCode", dr["ItemTypeCode"].ToString().Trim());
itemCollection.Attributes.Add("ItemTypeDesc", dr["ItemTypeDesc"].ToString().Trim());
RCBItemType.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
private void CarregueComboClasseNacional(ILeituraRevistaDeMarcas processo)
{
cboClassificacaoNacional.Items.Clear();
cboClassificacaoNacional.Attributes.Clear();
foreach (var codigo in processo.ClasseNacional.listaDeCodigosDeSubClasse)
{
var item = new RadComboBoxItem(processo.ClasseNacional.CodigoClasseNacional, processo.ClasseNacional.CodigoClasseNacional);
item.Attributes.Add("Especificacao",
processo.ClasseNacional.EspecificacaoClasseNacional ?? "Não informada");
item.Attributes.Add("SubClasse",
codigo ?? "Não informada");
this.cboClassificacaoNacional.Items.Add(item);
item.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBVendorGroup, string argClientCode, int iIsDeleted)
{
RCBVendorGroup.Items.Clear();
foreach (DataRow dr in GetVendorGroup(iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["VendGroupCode"].ToString() + " " + dr["VendGroupDesc"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["VendGroupCode"].ToString()
};
itemCollection.Attributes.Add("VendGroupCode", dr["VendGroupCode"].ToString());
itemCollection.Attributes.Add("VendGroupDesc", dr["VendGroupDesc"].ToString());
RCBVendorGroup.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(RadComboBox RCBCondition, string argClientCode, int iIsDeleted)
{
RCBCondition.Items.Clear();
foreach (DataRow dr in GetConditionMaster(iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["ConditionCode"].ToString() + " " + dr["ConditionName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["ConditionCode"].ToString().Trim()
};
itemCollection.Attributes.Add("ConditionCode", dr["ConditionCode"].ToString());
itemCollection.Attributes.Add("ConditionName", dr["ConditionName"].ToString());
RCBCondition.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBOrderReason, string argClientCode)
{
RCBOrderReason.Items.Clear();
foreach (DataRow dr in GetOrderReason(argClientCode).Tables[0].Rows)
{
String itemText = dr["ReasonCode"].ToString() + " " + dr["ReasonDesc"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["ReasonCode"].ToString().Trim()
};
itemCollection.Attributes.Add("ReasonCode", dr["ReasonCode"].ToString());
itemCollection.Attributes.Add("ReasonDesc", dr["ReasonDesc"].ToString());
RCBOrderReason.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(RadComboBox RCBPartnerMaster, string argPartnerCode, string argClientCode, int iIsDeleted)
{
RCBPartnerMaster.Items.Clear();
foreach (DataRow dr in GetPartnerEmployee4Combo(argPartnerCode, argClientCode, iIsDeleted).Tables[0].Rows)
{
String itemText = dr["PartnerEmployeeCode"].ToString() + " " + dr["EmployeeName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["PartnerEmployeeCode"].ToString().Trim()
};
itemCollection.Attributes.Add("PartnerEmployeeCode", dr["PartnerEmployeeCode"].ToString());
itemCollection.Attributes.Add("EmployeeName", dr["EmployeeName"].ToString());
RCBPartnerMaster.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBGLAccountGroup, string argChartACCode, string argClientCode, int iIsDeleted)
{
RCBGLAccountGroup.Items.Clear();
foreach (DataRow dr in GetGLAccountGroups(argChartACCode, iIsDeleted, argClientCode).Tables[0].Rows)
{
String itemText = dr["ActGroup"].ToString() + " " + dr["GroupName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["ActGroup"].ToString()
};
itemCollection.Attributes.Add("ActGroup", dr["ActGroup"].ToString());
itemCollection.Attributes.Add("GroupName", dr["GroupName"].ToString());
RCBGLAccountGroup.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
public void FillCombobox(Telerik.Web.UI.RadComboBox RCBDivision, string argClientCode, string argSalesOrganizationCode)
{
RCBDivision.Items.Clear();
foreach (DataRow dr in GetDivision4SalesOrg(argSalesOrganizationCode, argClientCode).Tables[0].Rows)
{
String itemText = dr["DivisionCode"].ToString().Trim() + " " + dr["DivisionName"].ToString();
var itemCollection = new RadComboBoxItem
{
Text = itemText,
Value = dr["DivisionCode"].ToString().Trim()
};
itemCollection.Attributes.Add("DivisionCode", dr["DivisionCode"].ToString().Trim());
itemCollection.Attributes.Add("DivisionName", dr["DivisionName"].ToString());
RCBDivision.Items.Add(itemCollection);
itemCollection.DataBind();
}
}
protected void ddl_Roles_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
BallyliffinDataContext db = new BallyliffinDataContext();
List<sp_MembersByRole_ShortViewResult> roles = db.sp_MembersByRole_ShortView().ToList();
foreach (sp_MembersByRole_ShortViewResult role in roles)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)role.RoleDesc;
item.Value = role.RoleID.ToString();
item.Attributes.Add("RoleDesc", role.RoleDesc);
item.Attributes.Add("Total", role.Total.Value.ToString());
ddl_Roles.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();
}
}
}
private void CarregueComboTipoDeClassificacao()
{
var itemInternacional = new RadComboBoxItem(TipoClassificacaoPatente.Internacional.Descricao, TipoClassificacaoPatente.Internacional.Codigo.ToString());
var itemNacional = new RadComboBoxItem(TipoClassificacaoPatente.Nacional.Descricao, TipoClassificacaoPatente.Nacional.Codigo.ToString());
if (cboTipoDeClassificacao.Items.Count == 0)
{
cboTipoDeClassificacao.Items.Add(itemInternacional);
cboTipoDeClassificacao.Items.Add(itemNacional);
itemInternacional.DataBind();
itemNacional.DataBind();
}
}
private void CarregueCombo(IList<Situacao> situacoesADesconsiderar)
{
if (situacoesADesconsiderar == null) situacoesADesconsiderar = new List<Situacao>();
foreach (var situacao in Situacao.ObtenhaTodos())
{
if (!situacoesADesconsiderar.Contains(situacao))
{
var item = new RadComboBoxItem(situacao.Descricao, situacao.ID.ToString());
cboSituacao.Items.Add(item);
item.DataBind();
}
}
}
protected void cboDespachoDeMarcas_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
IList<IDespachoDeMarcas> listaDespachoDeMarcas = new List<IDespachoDeMarcas>();
using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeDespachoDeMarcas>())
listaDespachoDeMarcas = servico.ObtenhaPorDescricao(e.Text, 50);
if (listaDespachoDeMarcas.Count > 0)
{
foreach (var despachoDeMarcas in listaDespachoDeMarcas)
{
var item = new RadComboBoxItem(despachoDeMarcas.CodigoDespacho, despachoDeMarcas.IdDespacho.Value.ToString());
item.Attributes.Add("Descricao",despachoDeMarcas.DescricaoDespacho);
cboDespachoDeMarcas.Items.Add(item);
item.DataBind();
}
}
}
private void cargarProducto(string dispenserID)
{
try
{
Connection conexion = new Connection();
cmbProducto.EmptyMessage = "Seleccione un producto";
cmbProducto.Items.Clear();
string userCountry = conexion.getUserCountry(Session["userid"].ToString());
string query = String.Format("SELECT PRODUCT_ID, PRODUCT_DESCRIP FROM PRODUCTOS WHERE DISPENSER_ID = '{0}' AND COUNTRY_ID = '{1}'", dispenserID, userCountry);
try
{
SqlConnection bridge = new SqlConnection(conexion.getConnectionString());
SqlDataAdapter adapter = new SqlDataAdapter(query, bridge);
DataTable datatable = new DataTable();
adapter.Fill(datatable);
foreach (DataRow datarow in datatable.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = datarow["PRODUCT_ID"].ToString() + " " + datarow["PRODUCT_DESCRIP"].ToString();
item.Value = datarow["PRODUCT_ID"].ToString();
cmbProducto.Items.Add(item);
item.DataBind();
}
}
catch (SqlException)
{
radajaxmanager.ResponseScripts.Add(@"alert('Error inesperado de conexion, no se logro cargar la lista de productos refresque la pagina" +
" o intentelo mas tarde.');");
return;
}
}
catch (Exception error)
{
radajaxmanager.ResponseScripts.Add(String.Format("errorEnvio('{0}');", error.Message));
}
}
protected void cboPasta_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
IList<IPasta> pastas = new List<IPasta>();
using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDePasta>())
pastas = servico.obtenhaPeloCodigo(e.Text, 50);
if (pastas.Count > 0)
foreach (var pasta in pastas)
{
var item = new RadComboBoxItem(pasta.Codigo, pasta.ID.Value.ToString());
item.Attributes.Add("Nome", pasta.Nome);
cboPasta.Items.Add(item);
item.DataBind();
}
}
protected void cboMarca_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
IList<IMarcas> listaDeMarcas = new List<IMarcas>();
using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeMarcas>())
listaDeMarcas = servico.obtenhaMarcasPelaDescricaoComoFiltro(e.Text, 50);
if (listaDeMarcas.Count > 0)
{
foreach (var marca in listaDeMarcas)
{
var item = new RadComboBoxItem(marca.DescricaoDaMarca, marca.IdMarca.Value.ToString());
item.Attributes.Add("Apresentacao",
marca.Apresentacao.Nome ?? "Não informada");
item.Attributes.Add("Natureza",
marca.Natureza.Nome ?? "Não informada");
item.Attributes.Add("NCL",
marca.NCL.Codigo.ToString() ?? "Não informada");
this.cboMarcas.Items.Add(item);
item.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Menu menu = Master.FindControl("NavigationMenu") as Menu;
menu.Items[2].ChildItems[1].ChildItems.RemoveAt(1);
if (!IsPostBack)
{
if (Session.Contents["rol"].ToString().Equals("DSTADM"))
Response.Redirect("../Default.aspx");
Connection conexion = new Connection();
string query = String.Format("SELECT K.KAM_ID, K.KAM_NAME FROM KAM AS K WHERE K.COUNTRY = '{0}' AND 0 = (SELECT COUNT(U.USER_ID) FROM USUARIOS AS U WHERE U.USER_ID = K.KAM_ID AND U.STATUS = 1)"
, conexion.getUserCountry(Session.Contents["userid"].ToString()));
DataTable resultset = conexion.getGridDataSource(query);
foreach (DataRow fila in resultset.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = fila["KAM_NAME"].ToString();
item.Value = fila["KAM_ID"].ToString();
item.DataBind();
cmbKAM.Items.Add(item);
}
cargarCuentasDisponibles(conexion);
}
}
catch (Exception error)
{
RadAjaxManager1.ResponseScripts.Add(String.Format("errorEnvio('{0}');", error.Message));
}
}
protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
EFDal ed = new EFDal();
if (e.Text.Length > 2)
{
string BolgeKodu = ed.kal_BolgeKoduDon(Context.User.Identity.Name).ToString();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string IlIlce = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["MUSTNO"].ToString();
item.Value = dataRow["FIRMAID"].ToString();
string FirmaAdi = (string)dataRow["FIRMAADI"];
if (dataRow["IL_ILCE"] != System.DBNull.Value)
{
IlIlce = (string)dataRow["IL_ILCE"];
}
item.Attributes.Add("FIRMAADI", FirmaAdi);
item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
lbl.Text = "Bulunan kayıt sayısı:" + " " + dataTable.Rows.Count.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Menu menu = Master.FindControl("NavigationMenu") as Menu;
menu.Items[2].ChildItems[0].ChildItems.RemoveAt(0);
if (!IsPostBack)
{
Connection conexion = new Connection();
if (Session.Contents["rol"].ToString().Equals("DSTADM"))
Response.Redirect("../Default.aspx");
string query = String.Format("SELECT CLIENT_ID, CLIENT_NAME FROM CLIENTES_KC WHERE COUNTRY = '{0}' AND DIRECT_CUSTOMER = 0",
conexion.getUserCountry(Session.Contents["userid"].ToString()));
DataTable clientes = conexion.getGridDataSource(query);
RadComboBoxItem temp = new RadComboBoxItem();
temp.Value = "0";
temp.Text = "Kimberly-Clark";
temp.DataBind();
cmbUbicacion.Items.Add(temp);
foreach (DataRow fila in clientes.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = fila["CLIENT_ID"].ToString() + " | " + fila["CLIENT_NAME"].ToString();
item.Value = fila["CLIENT_ID"].ToString();
item.DataBind();
cmbUbicacion.Items.Add(item);
}
cargarRoles();
}
}
catch (Exception error)
{
RadAjaxManager1.ResponseScripts.Add(String.Format("errorEnvio('{0}');", error.Message));
}
}
private void CarregueComboSobrestadores(ILeituraRevistaDeMarcas processo)
{
cboSobrestador.Items.Clear();
cboSobrestador.Attributes.Clear();
foreach (var processoSobrestador in processo.DicionarioSobrestadores.Keys)
{
var item = new RadComboBoxItem(processoSobrestador, processoSobrestador);
item.Attributes.Add("Marca",
processo.DicionarioSobrestadores[processoSobrestador] ?? "Não informada");
this.cboSobrestador.Items.Add(item);
item.DataBind();
}
}
protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
if (e.Text.Length > 3)
{
using (Service1Client client = new Service1Client())
{
intBolgeKodu = client.BolgeKoduDon(Context.User.Identity.Name);
}
string BolgeKodu = intBolgeKodu.ToString();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string IlIlce = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["MUSTNO"].ToString();
item.Value = dataRow["FIRMAID"].ToString();
string FirmaAdi = (string)dataRow["FIRMAADI"];
if (dataRow["IL_ILCE"] != System.DBNull.Value)
{
IlIlce = (string)dataRow["IL_ILCE"];
}
item.Attributes.Add("FIRMAADI", FirmaAdi);
item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
}
}
private void CarregueCombo(IList<TipoLacamentoFinanceiroRecebimento> tiposADesconsiderar)
{
if (tiposADesconsiderar == null) tiposADesconsiderar = new List<TipoLacamentoFinanceiroRecebimento>();
foreach (var tipo in TipoLacamentoFinanceiroRecebimento.ObtenhaTodos())
{
if (!tiposADesconsiderar.Contains(tipo))
{
var item = new RadComboBoxItem(tipo.Descricao, tipo.ID.ToString());
cboTipoLacamento.Items.Add(item);
item.DataBind();
}
}
}
protected void cboPatente_OnItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDePatente>())
{
cboPatente.Items.Clear();
IList<IPatente> patentes = IdClienteSelecionado != 0 ? servico.ObtenhaPatentesDoCliente(e.Text, IdClienteSelecionado, 50)
: servico.ObtenhaPatentesPeloTitulo(e.Text, 50);
foreach (IPatente patente in patentes)
{
var item = new RadComboBoxItem(patente.TituloPatente, patente.Identificador.ToString());
item.Attributes.Add("TipoDePatente", patente.NaturezaPatente.SiglaNatureza);
item.Attributes.Add("DataDeCadastro", patente.DataCadastro != null ? patente.DataCadastro.Value.ToString("dd/MM/yyyy") : "Data não informada");
cboPatente.Items.Add(item);
item.DataBind();
}
}
}
protected void RadComboBoxCihaz_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
RadComboBoxCihaz.Items.Clear();
string sqlSelectCommand = "";
sqlSelectCommand = "SELECT [ID],[CIHAZADI], [LAB] from [cihaz] WHERE [CIHAZADI] LIKE '%'+ @text + '%' ORDER BY [CIHAZADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
RadComboBoxCihaz.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string Lab = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["CIHAZADI"].ToString();
item.Value = dataRow["ID"].ToString();
Lab = (string)dataRow["LAB"];
item.Attributes.Add("LAB", Lab);
RadComboBoxCihaz.Items.Add(item);
item.DataBind();
}
}
private void CarregueCombo()
{
foreach (var forma in FormaDeRecebimento.ObtenhaTodos())
{
var item = new RadComboBoxItem(forma.Descricao, forma.ID.ToString());
cboFormaDeRecebimento.Items.Add(item);
item.DataBind();
}
}
protected void RadComboBoxFirma_ItemsRequested(object o, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
//string BolgeKodu = Session["BolgeKodu"].ToString();
//string bak = e.Text;
if (e.Text.Length > 2)
{
string BolgeKodu = intBolgeKodu.ToString();
string sqlSelectCommand = "";
/*
if (rdbtnlstAramaTipi.SelectedIndex == 0)//isnodan arama
sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [isno] LIKE '%'+ @text + '%' ORDER BY [isno]";
if (rdbtnlstAramaTipi.SelectedIndex == 1)//is adından arama
sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [adi] LIKE '%'+ @text + '%' ORDER BY [adi]";
if (rdbtnlstAramaTipi.SelectedIndex == 2)//Birimden arama
sqlSelectCommand = "SELECT [ObjectID], [isno], [adi], [birim] from [tblIsEmri] WHERE [birim] LIKE '%'+ @text + '%' ORDER BY [birim]";
*/
sqlSelectCommand = "SELECT [FIRMAID],[MUSTNO], [FIRMAADI], [IL_ILCE] from [firma] WHERE [FIRMAADI] LIKE '%'+ @text + '%' and SILINDI=0 and BOLGEKODU=" + BolgeKodu + " ORDER BY [FIRMAADI]";
SqlDataAdapter adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["KalData"].ConnectionString);
adapter.SelectCommand.Parameters.AddWithValue("@text", e.Text);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
//lblBulunanIsSayisi.Text = dataTable.Rows.Count.ToString();
RadComboBoxFirma.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
string IlIlce = "";
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["MUSTNO"].ToString();
item.Value = dataRow["FIRMAID"].ToString();
string FirmaAdi = (string)dataRow["FIRMAADI"];
if (dataRow["IL_ILCE"] != System.DBNull.Value)
{
IlIlce = (string)dataRow["IL_ILCE"];
}
item.Attributes.Add("FIRMAADI", FirmaAdi);
item.Attributes.Add("IL_ILCE", IlIlce);
RadComboBoxFirma.Items.Add(item);
item.DataBind();
}
Label lbl = (Label)RadComboBoxFirma.Footer.FindControl("lblBulunanKayitSayisi");
lbl.Text = "Bulunan kayıt sayısı:" + " " + dataTable.Rows.Count.ToString();
}
}
protected void cboNaturezaPatente_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
IList<INaturezaPatente> listaNaturezaPatente = new List<INaturezaPatente>();
using (var servico = FabricaGenerica.GetInstancia().CrieObjeto<IServicoDeNaturezaPatente>())
listaNaturezaPatente = servico.obtenhaNaturezaPatentePelaSiglaComoFiltro(e.Text, 50);
if (listaNaturezaPatente.Count > 0)
{
foreach (var naturezaPatente in listaNaturezaPatente)
{
var item = new RadComboBoxItem(naturezaPatente.SiglaNatureza, naturezaPatente.IdNaturezaPatente.Value.ToString());
item.Attributes.Add("Descricao", naturezaPatente.DescricaoNaturezaPatente ?? "Não informada");
cboNaturezaPatente.Items.Add(item);
item.DataBind();
}
}
}