protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { Butonvisible(true); panelVisible(false, true, false, false); List <string> languageList = (from l in db.Language where l.IsActive == true select l.LanguageName).ToList(); ddlLanguage.DataSource = languageList; ddlLanguage.DataBind(); ddlFilterLanguage.DataSource = languageList; ddlFilterLanguage.DataBind(); ddlFilterLanguage.Items.Insert(0, new ListItem("Dil Seçiniz..", "0")); ddlFilterLanguage.SelectedIndex = 0; } ServiceList.DataSource = (from s in db.Services select s).ToList(); ServiceList.DataBind(); ((Master)this.Master).Path = "Hizmetler"; ((Master)this.Master).PathLink = "ServicesPage.aspx"; } catch (Exception) { Uyari("Bir Hata Oluştu!", false); pnlAlert.Visible = true; } }
public void Services() { DataSet ser = new DataSet(); ser = objsql.GetDataset("select * from tblService where Status='1' and Type='Study Abroad'"); if (ser.Tables[0].Rows.Count > 0) { ListedService.DataSource = ser; ListedService.DataBind(); ServiceList.DataSource = ser; ServiceList.DataBind(); } ser.Clear(); }
protected void ddlFilterLanguage_SelectedIndexChanged(object sender, EventArgs e) { try { string languageValue = ddlFilterLanguage.SelectedValue; if (languageValue != "0") { Language language = (from l in db.Language where l.LanguageName == languageValue select l).FirstOrDefault(); ServiceList.DataSource = (from s in db.Services where s.LanguageID == language.ID select s).ToList(); ServiceList.DataBind(); } else { ServiceList.DataSource = (from s in db.Services select s).ToList(); ServiceList.DataBind(); } } catch (Exception) { Uyari("Bir Hata Oluştu!", false); pnlAlert.Visible = true; } }