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;
}
}
