public void LoadData()
{
txtNameStudent.Text = User.Name;
if (User.Gender)
{
txtGenderStudent.Text = "Male";
}
else
{
txtGenderStudent.Text = "Female";
}
txtPhoneNumberStudent.Text = User.PhoneNumber;
txtEmailStudent.Text = User.Email;
txtDateOfBirth.Text = User.DateOfBirth.ToString("dd-MM-yyyy");
Schedule_User_Data SheduleUserData = new Schedule_User_Data();
loadSchedule();
Schedule_User_Data schedule_User_Data = new Schedule_User_Data();
DataCourse = schedule_User_Data.getListCourseID_GroupID(User.UserName);
bsCourseID.DataSource = DataCourse;
GridViewCourse.DataSource = bsCourseID;
GridViewCourse.Columns["CourseID"].Visible = false;
GridViewCourse.Columns["GroupID"].Visible = false;
}
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 txtSearchGroup_TextChanged(object sender, EventArgs e)
{
Schedule_User_Data SheduleUserData = new Schedule_User_Data();
DataView dv = SheduleUserData.getListGroup_User(User.UserName).DefaultView;
dv.RowFilter = string.Format("GroupID like '%{0}%'", txtSearchGroup.Text);
GridViewGroup.DataSource = dv.ToTable();
}
private void GridViewCourse_SelectionChanged(object sender, EventArgs e)
{
string CourseID = GridViewCourse.Rows[GridViewCourse.CurrentCell.RowIndex].Cells["CourseID"].Value.ToString();
Schedule_User_Data schedule_User_Data = new Schedule_User_Data();
schedule_User_Data.getListGroupID_From_CourseID(User.UserName, CourseID);
bsGroupID.DataSource = schedule_User_Data.getListGroupID_From_CourseID(User.UserName, CourseID);
GridViewGroup.DataSource = bsGroupID;
}
public void getAttendance(TextBox text, string slot)
{
if (text.Text != string.Empty)
{
string[] infoSlot_Day = text.Text.ToString().Split('\n');
string Group = infoSlot_Day[0];
DateTime Date = DateTime.ParseExact(infoSlot_Day[2], "dd-MM-yyyy", CultureInfo.InvariantCulture);
Schedule_User_Data ScheduleUser = new Schedule_User_Data();
CheckAttendance frmCheck = new CheckAttendance(ScheduleUser.getListStudentAttendance(Group, Date, slot));
frmCheck.ShowDialog();
}
}
public void LoadInfoUser()
{
txtNameTeacher.Text = User.Name;
txtDateOfBirth.Text = User.DateOfBirth.ToString("MM-dd-yyyy");
txtEmailTeacher.Text = User.Email;
txtPhoneNumberTeacher.Text = User.PhoneNumber;
Schedule_User_Data SheduleUserData = new Schedule_User_Data();
loadSchedule();
bsGroup_User.DataSource = SheduleUserData.getListGroup_User(User.UserName);
GridViewGroup.DataSource = bsGroup_User;
txtGroup.DataBindings.Clear();
txtGroup.DataBindings.Add("Text", bsGroup_User, "GroupID");
}
private void btnInsert_Click(object sender, EventArgs e)
{
bool check = false;
Schedule_User_Data ScheduleUserData = new Schedule_User_Data();
try
{
foreach (DataRow row in listAttendance.Rows)
{
check = ScheduleUserData.CheckUpdate(row["UserName"].ToString(), bool.Parse(row["Attendance"].ToString()));
}
if (check)
{
MessageBox.Show("Insert Complete");
}
}
catch
{
MessageBox.Show("Insert False");
}
}
public void loadSchedule()
{
clearSchedule();
DataTable Datatb = new DataTable();
Schedule_User_Data SheduleUserData = new Schedule_User_Data();
try
{
string newLine = Environment.NewLine;
Datatb = SheduleUserData.getListShedule_User(User.UserName, FirstDayOfWeek(Date), LastDayOfWeek(Date));
//MessageBox.Show(Datatb.Rows[1].Field<string>("SlotID"));
foreach (DataRow row in Datatb.Rows)
{
DateTime dateValue = DateTime.Parse(row["Date"].ToString());
if (dateValue.ToString("ddd").Equals("Mon"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Tue"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Wed"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Thu"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Fri"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Sat"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Sun"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
}
}
catch
{
MessageBox.Show("Loi");
}
}
