private void btnRemove_Click(object sender, EventArgs e)
{
string Role = "";
string UserName = txtUserName.Text;
User_Group_Data UserGroupData = new User_Group_Data();
UserData u = new UserData();
Schedule_User_Data schedule_User_Data = new Schedule_User_Data();
try
{
UserGroupData.checkDeleteUser_Group_Foreign_Key(UserName);
schedule_User_Data.checkDeleteUser_ScheduleUser_Foreign_Key(UserName);
if (u.checkDeleteUser(UserName))
{
MessageBox.Show("Delete complete!");
if (CheckRoleStudent)
{
Role = "STUDENT";
}
else
{
Role = "TEACHER";
}
bsUser.DataSource = u.getListUser(Role);
GridViewGroup_SelectionChanged(null, null);
}
}
catch
{
MessageBox.Show("Can not find id to delete");
}
}
private void txtSearchNameGroup_TextChanged(object sender, EventArgs e)
{
User_Group_Data UserGroupData = new User_Group_Data();
DataView dv = UserGroupData.getListUser_Group(txtGroupID.Text).DefaultView;
dv.RowFilter = string.Format("Name like '%{0}%'", txtSearchNameGroup.Text);
GridViewDetail.DataSource = dv.ToTable();
}
private void GridViewGroup_SelectionChanged(object sender, EventArgs e)
{
string GroupID = GridViewGroup.Rows[GridViewGroup.CurrentCell.RowIndex].Cells["GroupID"].Value.ToString();
User_Group_Data user_Group_Data = new User_Group_Data();
bsDetailGroup.DataSource = user_Group_Data.getListUser_Group(GroupID);
GroupViewDetailStudent.DataSource = bsDetailGroup;
GroupViewDetailStudent.Columns["Gender"].Visible = false;
GroupViewDetailStudent.Columns["Email"].Visible = false;
GroupViewDetailStudent.Columns["DateOfBirth"].Visible = false;
}
private void GridViewGroup_SelectionChanged(object sender, EventArgs e)
{
string GroupID = txtGroupID.Text;
User_Group_Data UserGroupData = new User_Group_Data();
try
{
bsUser_Group.DataSource = UserGroupData.getListUser_Group(GroupID);
GridViewDetail.DataSource = bsUser_Group;
}
catch
{
}
}
private void btnAddStudentToGroup_Click(object sender, EventArgs e)
{
User_Group UserGroup = new User_Group();
UserGroup.UserName = txtUserName.Text;
UserGroup.GroupID = cbxGroupStudent.Text;
User_Group_Data UserGroupData = new User_Group_Data();
try
{
if (UserGroupData.checkInsertUser_Group(UserGroup))
{
MessageBox.Show("Insert Student To Group Complete");
}
}
catch
{
MessageBox.Show("Insert Student To Group Fail");
}
}
private void btnDeleteGroup_Click(object sender, EventArgs e)
{
string GroupID = txtGroupID.Text;
GroupData GroupData = new GroupData();
User_Group_Data user_Group_Data = new User_Group_Data();
try
{
user_Group_Data.checkDeleteGroup_UserGroup_Foreign_Key(GroupID);
GroupData.checkDeleteGroupID_Schedule_Foreign_Key(GroupID);
if (GroupData.checkDeleteGroup(GroupID))
{
MessageBox.Show("Delete Group Complete");
bsGroup.DataSource = GroupData.getListGroup();
setValuesForCombobox();
}
}
catch
{
MessageBox.Show("Delete Group fail");
}
}
private void btnDeleteStudentFormGroup_Click(object sender, EventArgs e)
{
User_Group UserGroup = new User_Group();
UserGroup.GroupID = txtGroupID.Text;
UserGroup.UserName = GridViewDetail.Rows[GridViewDetail.CurrentCell.RowIndex].Cells[0].Value.ToString().Trim();
User_Group_Data UserGroupData = new User_Group_Data();
try
{
if (UserGroupData.checkDeleteUser_Group(UserGroup))
{
MessageBox.Show("Delete Student in list Complete!");
bsUser_Group.DataSource = UserGroupData.getListUser_Group(UserGroup.GroupID);
GridViewDetail.DataSource = bsUser_Group;
}
}
catch
{
MessageBox.Show("Delete Student in list Fail!");
}
}
