private void PopulateDataGrid() { // Bind users to Grid. List <StaffingData> staffingData = staffingDataDA.GetAllStaffing(); //Populate the ward name foreach (var item in staffingData) { item.WardName = staffingDataDA.GetWardNameByWardCode(item.WardCode); } // Select rows which has WardName, ignore the rest List <StaffingData> staffingDataToDisplay = staffingData.Where(data => data.WardName != string.Empty).ToList(); if (null != staffingDataToDisplay) { StaffingData_Grid.DataSource = staffingDataToDisplay; StaffingData_Grid.DataBind(); BindWardNames(staffingDataToDisplay); BindShifts(staffingDataToDisplay); BindDays(); InsertDropdownDefaultValue(); } }
private void FilterDataGrid() { // Bind users to Grid. List <StaffingData> staffingData = staffingDataDA.GetAllStaffing(); //Populate the ward name foreach (var item in staffingData) { item.WardName = staffingDataDA.GetWardNameByWardCode(item.WardCode); } // Select rows which has WardName, ignore the rest List <StaffingData> staffingDataToDisplay = staffingData.Where(data => data.WardName != string.Empty).ToList(); // Filter data if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["DropDownAllText"])) { // Filter by Ward Name if (!WardName_DropDownList.SelectedValue.Equals(ConfigurationManager.AppSettings["DropDownAllText"])) { staffingDataToDisplay = staffingDataToDisplay.Where(data => data.WardName.Equals(WardName_DropDownList.SelectedValue)).ToList(); } // FIlter by Shift if (!Shift_DropDownList.SelectedValue.Equals(ConfigurationManager.AppSettings["DropDownAllText"])) { staffingDataToDisplay = staffingDataToDisplay.Where(data => data.Shift.Equals(Shift_DropDownList.SelectedValue)).ToList(); } // Filter by Day if (!Day_DropDownList.SelectedValue.Equals(ConfigurationManager.AppSettings["DropDownAllText"])) { staffingDataToDisplay = staffingDataToDisplay.Where(data => data.StaffingDate.Equals(Day_DropDownList.SelectedValue)).ToList(); } } if (null != staffingDataToDisplay) { StaffingData_Grid.DataSource = staffingDataToDisplay; StaffingData_Grid.DataBind(); StaffingData_Grid.PageIndex = 0; } }