public void setdepartment()
{
DBFunctions db = new DBFunctions();
DeptList.DataSource = db.getalldepartments();
DeptList.DataTextField = "Department";
DeptList.DataValueField = "ID";
DeptList.DataBind();
}
protected void populateDeptList()
{
string getDeptsQuery = DataProvider.DiscDeptWard.getDepartments();
DataTable dt = HospitalClass.getDataTable(getDeptsQuery);
DeptList.DataSource = dt;
DeptList.DataTextField = "DEPT_NAME";
DeptList.DataBind();
DeptList.Items.Insert(0, new ListItem("Please select..."));
}
private void PopulateDropdown()
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["developmentserver"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand fetchCommand = new SqlCommand("Select * from DEPT", conn);
SqlDataReader reader = fetchCommand.ExecuteReader();
DeptList.DataSource = reader;
DeptList.DataTextField = "DNAME";
DeptList.DataValueField = "DEPTNO";
DeptList.DataBind();
PopulateGrid(this, null);
}
protected void deptdatafilter()
{
if (EntiyList.SelectedValue != null && EntiyList.SelectedIndex != 0)
{
DeptList.Enabled = true;
Edit_Entity_btn.Enabled = true;
DeptList.DataSource = deptds(Convert.ToInt16(EntiyList.SelectedValue.ToString()));
DeptList.DataValueField = "ID";
DeptList.DataTextField = "Department Name";
DeptList.DataBind();
DeptList.Items.Insert(0, "Select the Department");
}
else
{
DeptList.Enabled = false;
Edit_Entity_btn.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (LastADEntities b = new LastADEntities())
{
//To generate data for DropDownList1
var itemcat = (from ic in b.ItemCategories select ic.CategoryName).ToList();
itemcat.Insert(0, "---Select---");
//DropDownList1.SelectedIndex = 0;
DropDownList1.DataSource = itemcat;
DropDownList1.DataBind();
//To generate the options for departments
var depts = from dept in b.Departments select dept.DepartmentName;
DeptList.DataSource = depts.ToArray();
DeptList.DataBind();
DeptList.Items.Remove(DeptList.Items.FindByText("Stationary Store Dept"));
}
}
}
