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