private void BindList() { DataTable tblIncluded = CDL.GetDSIncludedEmployee(_strCDLCode); lvIncluded.Items.Clear(); foreach (DataRow drw in tblIncluded.Rows) { ListViewItem lvi = new ListViewItem(); lvi.Tag = drw["username"].ToString(); lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString(); lvIncluded.Items.Add(lvi); } DataTable tblExclude = CDL.GetDSExcludedEmployee(_strCDLCode); lvExcluded.Items.Clear(); foreach (DataRow drw in tblExclude.Rows) { ListViewItem lvi = new ListViewItem(); lvi.Tag = drw["username"].ToString(); lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString(); lvi.SubItems.Add(LeaveApplicationBalance.GetRemainingBalance(drw["username"].ToString(), cmbLeaveType.SelectedValue.ToString()).ToString()); lvExcluded.Items.Add(lvi); } }
private void cmbLeaveType_SelectedIndexChanged(object sender, EventArgs e) { try { DataTable tblExclude = CDL.GetDSExcludedEmployee(_strCDLCode); lvExcluded.Items.Clear(); foreach (DataRow drw in tblExclude.Rows) { ListViewItem lvi = new ListViewItem(); lvi.Tag = drw["username"].ToString(); lvi.Text = drw["lastname"].ToString() + ", " + drw["firname"].ToString(); lvi.SubItems.Add(LeaveApplicationBalance.GetRemainingBalance(drw["username"].ToString(), cmbLeaveType.SelectedValue.ToString()).ToString()); lvExcluded.Items.Add(lvi); } } catch { } }