using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Globalization;
using System.IO;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Iris.Collection;
using Iris.Command.Item;
using Iris.Command.Order;
using Iris.Command.Product;
using Iris.Command.User;
using Iris.Command.Util;
using Iris.Constants;
using Iris.Controller;
using Iris.Controls;
using Iris.DAO.Helper;
using Iris.Model.Dataset.Typed.Item;
using Iris.Model.Dataset.Typed.Location;
using Iris.Model.Dataset.Typed.Order;
using Iris.Model.Dataset.Typed.Product;
using Iris.Model.Dataset.Typed.User;
using Iris.Model.Dataset.Typed.UserCabinet;
using Iris.PageTemplate;
using Iris.Utility;
using IrisWeb.UserControls.Common;
using IRISWeb;
using log4net;


using Telerik.Web.UI;

namespace IrisWeb.SupplyTracking
{
    public partial class TelerikGrid : Iris.PageTemplate.PageBaseItem
    {
        protected DisplayMaterialMessagesDSNew materialMessagesNewDS;
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void GridDataBinding(object sender, GridNeedDataSourceEventArgs e)
        {

            string query = string.Format("SELECT* FROM Students");
            String ConnString = ConfigurationManager.AppSettings["CONNECTION_STRING_StudentDB"];
            SqlConnection conn = new SqlConnection(ConnString);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(query, conn);
            DataTable myDataTable = new DataTable();
            conn.Open();
            adapter.Fill(myDataTable);
            SampleGrid.DataSource = myDataTable;

        }
        protected void ColumnData(object sender, GridFilterCheckListItemsRequestedEventArgs e)
        {

            string DataField = (e.Column as IGridDataColumn).GetActiveDataField();
            e.ListBox.DataSource = GetDataTable1(DataField);
            e.ListBox.DataKeyField = DataField;
            e.ListBox.DataTextField = DataField;
            e.ListBox.DataValueField = DataField;
            e.ListBox.DataBind();
        }

        public DataTable GetDataTable1(string field)
        {
            string fieldname = "[" + field + "]";
            string query = string.Format("SELECT DISTINCT {0} FROM STUDENT", fieldname);

            String ConnString = ConfigurationManager.AppSettings["CONNECTION_STRING_STUDENTDB"];
            SqlConnection conn = new SqlConnection(ConnString);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(query, conn);

            DataTable myDataTable = new DataTable();

            conn.Open();
            try
            {
                adapter.Fill(myDataTable);
            }
            finally
            {
                conn.Close();
            }

            return myDataTable;
        }
    }
}