public StudentList() { using (var StudentsDB = new PrivateLessonsEntities()) { StudentsPickList = StudentsDB.Students.ToList(); } }
private void pb_Search_Click(object sender, EventArgs e) { var searchValue = tb_Search.Text; using (var DB = new PrivateLessonsEntities()) { var searchList = DB.Students.Where( s => s.Name.Contains(searchValue) || s.Surname.Contains(searchValue) || s.City.Contains(searchValue) || s.Street.Contains(searchValue) || s.Level.Contains(searchValue) || s.Comment.Contains(searchValue) ); lv_StudentList.Items.Clear(); foreach (var student in searchList) { var item = new ListViewItem(student.Id.ToString()); item.SubItems.Add(student.Name); item.SubItems.Add(student.Surname); item.SubItems.Add(student.PhoneNumber.ToString()); item.SubItems.Add(student.City); item.SubItems.Add(student.Street); item.SubItems.Add(student.Level); item.SubItems.Add(student.SchoolClass.ToString()); item.SubItems.Add(student.CreatedDate.ToString("dd-MM-yyyy")); lv_StudentList.Items.Add(item); } } }
private void LoadPrivateLesson(int id) { using (var DB = new PrivateLessonsEntities()) { LessonToEdit = DB.PrivateLessonHour.Single(h => h.Id == id); } }
public static bool HourOnHour(PrivateLessonHour privateLesson) { using (var PrivateLessonsDB = new PrivateLessonsEntities()) { var validateHour = PrivateLessonsDB.PrivateLessonHour.Where(h => h.StartDate.Day == privateLesson.StartDate.Day && h.StartDate.Month == privateLesson.StartDate.Month && h.StartDate.Year == privateLesson.StartDate.Year); int checkValidate = 0; foreach (var hour in validateHour) { if (((privateLesson.StartDate > hour.StartDate) && (privateLesson.EndDate < hour.EndDate)) || (privateLesson.StartDate == hour.StartDate && privateLesson.EndDate == hour.EndDate) || (privateLesson.EndDate <= hour.EndDate && privateLesson.EndDate > hour.StartDate) || (privateLesson.StartDate < hour.EndDate && privateLesson.StartDate >= hour.StartDate) || (hour.StartDate > privateLesson.StartDate && hour.EndDate < privateLesson.EndDate) ) { checkValidate++; } } if (checkValidate > 0) { return(false); } } return(true); }
public PrivateLessonsHoursList(DateTime Date, bool showByStudent, int studentId) { if (showByStudent == true) { using (var DB = new PrivateLessonsEntities()) { PrivateLessonsList = DB.PrivateLessonHour .Where(d => d.StartDate.Day == Date.Day && d.StartDate.Month == Date.Month && d.StartDate.Year == Date.Year) .Where(s => s.StudentId == studentId) .ToList(); } } else { using (var DB = new PrivateLessonsEntities()) { PrivateLessonsList = DB.PrivateLessonHour.Where(d => d.StartDate.Day == Date.Day && d.StartDate.Month == Date.Month && d.StartDate.Year == Date.Year) .ToList(); } } }
private void FillComboBoxWithStudents() { using (var PrivateLessonsDb = new PrivateLessonsEntities()) { cb_UsersList.DataSource = PrivateLessonsDb.Students.ToList(); cb_UsersList.ValueMember = "Id"; cb_UsersList.DisplayMember = "StudentDescription"; } }
private void Submit_Click(object sender, EventArgs e) { if (AddStudentValidation.ValidateStudentData(tb_Name, tb_Surname, tb_PhoneNumber, tb_City, tb_Street, cb_Level, cb_Class)) { string message = "Czy wszystkie wprowadzone zmiany są poprawne?"; const string caption = "Form Closing"; var result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (var DB = new PrivateLessonsEntities()) { var StudentToEdit = DB.Students.Single(s => s.Id == StudentId); if (tb_Name.Enabled == true) { StudentToEdit.Name = tb_Name.Text; } if (tb_Surname.Enabled == true) { StudentToEdit.Surname = tb_Surname.Text; } if (tb_PhoneNumber.Enabled == true) { StudentToEdit.PhoneNumber = int.Parse(tb_PhoneNumber.Text); } if (tb_Street.Enabled == true && tb_City.Enabled == true) { StudentToEdit.Street = tb_Street.Text; StudentToEdit.City = tb_Street.Text; } if (cb_Level.Enabled == true) { StudentToEdit.Level = cb_Level.Text; } if (cb_Class.Enabled == true) { StudentToEdit.SchoolClass = int.Parse(cb_Class.Text); } if (tb_Comment.Enabled == true) { StudentToEdit.Comment = tb_Comment.Text; } StudentToEdit.StudentDescription = StudentToEdit.Surname + " " + StudentToEdit.Name + " " + StudentToEdit.City; DB.SaveChanges(); } result = MessageBox.Show("Pomyślnie edytowano dane ucznia"); } } }
private void usuńToolStripMenuItem_Click(object sender, EventArgs e) { using (var DB = new PrivateLessonsEntities()) { var studentId = int.Parse(lv_StudentList.SelectedItems[0].Text); var StudentToRemove = DB.Students.FirstOrDefault(s => s.Id == studentId); DB.Students.Remove(StudentToRemove); DB.SaveChanges(); } FillStudentsTable(lv_StudentList); }
private void Submit_Click(object sender, EventArgs e) { using (var DB = new PrivateLessonsEntities()) { var studentIdList = new List <int>(); foreach (var student in StudentsSelectedList) { studentIdList.Add(student.Id); } foreach (var id in studentIdList) { var studentToDelete = DB.Students.FirstOrDefault(i => i.Id == id); DB.Students.Remove(studentToDelete); } DB.SaveChanges(); } StudentsSelectedList.Clear(); ClearListboxex(); }
private void Submit_Click(object sender, EventArgs e) { using (var DB = new PrivateLessonsEntities()) { var IdListToDelete = new List <int>(); foreach (var hour in SelectedHourList) { IdListToDelete.Add(hour.Id); } foreach (var id in IdListToDelete) { var hourToDelete = DB.PrivateLessonHour.FirstOrDefault(i => i.Id == id); DB.PrivateLessonHour.Remove(hourToDelete); } DB.SaveChanges(); SelectedHourList.Clear(); ClearListboxex(); } }
private void ScheduleFill(ListView ListView, DateTime Date) { ListView.Items.Clear(); var PrivateLessonsList = new List <PrivateLessonHour>(); using (var DB = new PrivateLessonsEntities()) { PrivateLessonsList = DB.PrivateLessonHour.Where(d => d.StartDate.Day == Date.Day && d.StartDate.Month == Date.Month && d.StartDate.Year == Date.Year) .ToList(); } PrivateLessonsList.Sort((d1, d2) => d1.StartDate.CompareTo(d2.StartDate)); foreach (var hour in PrivateLessonsList) { string lessonPlace; if (hour.IsHome == true) { lessonPlace = "U mnie w domu"; } else { lessonPlace = "DOJAZD DO UCZNIA"; } var item = new ListViewItem(hour.Id.ToString()); item.SubItems.Add(hour.StartDate.ToString("HH:mm")); item.SubItems.Add(hour.EndDate.ToString("HH:mm")); item.SubItems.Add(hour.HourDescriptionSchedule); item.ToolTipText = $"{hour.HourDescriptionSchedule} \n" + $"{hour.Subject}\n" + $"{hour.Topic}\n" + $"{lessonPlace}\n" + $"{hour.Comment}\n" + $"PPM - Edytuj"; ListView.Items.Add(item); } }
private void b_save_Click(object sender, EventArgs e) { var culture = new CultureInfo("pl-PL"); if (AddHourValidation.HourDataValidation(tb_Subject, cb_StartMin, cb_startDateHour, cb_Duration)) { using (var DB = new PrivateLessonsEntities()) { var HourToUpdate = DB.PrivateLessonHour.Single(h => h.Id == LessonToEdit.Id); if (cb_UsersList.Enabled == true) { HourToUpdate.StudentId = int.Parse(cb_UsersList.SelectedValue.ToString()); HourToUpdate.HourDescriptionSchedule = cb_UsersList.Text; } if (cb_startDateHour.Enabled == true && cb_StartMin.Enabled == true) { var startDate = HourToUpdate.StartDate.Date .AddHours(int.Parse(cb_startDateHour.Text)) .AddMinutes(int.Parse(cb_StartMin.Text)); var duration = (int)HourToUpdate.EndDate.TimeOfDay.TotalMinutes - (int)HourToUpdate.StartDate.TimeOfDay.TotalMinutes; HourToUpdate.StartDate = startDate; HourToUpdate.EndDate = startDate.AddMinutes(duration); HourToUpdate.HourDescription = HourToUpdate.StartDate.ToString("HH:mm") + " | " + cb_UsersList.Text + " | " + culture.DateTimeFormat.GetDayName(HourToUpdate.StartDate.DayOfWeek) + " " + HourToUpdate.StartDate.Day + "-" + HourToUpdate.StartDate.Month + "-" + HourToUpdate.StartDate.Year; } if (cb_Duration.Enabled == true) { var mins = (int)HourToUpdate.StartDate.TimeOfDay.TotalMinutes; HourToUpdate.EndDate = HourToUpdate.StartDate.Date.AddMinutes(mins + int.Parse(cb_Duration.Text)); HourToUpdate.HourDescription = HourToUpdate.StartDate.ToString("HH:mm") + " | " + cb_UsersList.Text + " | " + culture.DateTimeFormat.GetDayName(HourToUpdate.StartDate.DayOfWeek) + " " + HourToUpdate.StartDate.Day + "-" + HourToUpdate.StartDate.Month + "-" + HourToUpdate.StartDate.Year; } if (gb_Place.Enabled == true) { var isHome = true; if (rb_StudentHome.Checked == true) { isHome = false; } HourToUpdate.IsHome = isHome; } if (gb_Subject.Enabled == true) { var subject = "Matematyka"; if (rb_OtherTopic.Checked == true) { subject = tb_Subject.Text; } HourToUpdate.Subject = subject; } if (dtp_StartDate.Enabled == true) { var mins = (int)HourToUpdate.StartDate.TimeOfDay.TotalMinutes; var duration = (int)HourToUpdate.EndDate.TimeOfDay.TotalMinutes - (int)HourToUpdate.StartDate.TimeOfDay.TotalMinutes; HourToUpdate.StartDate = DateTime.Parse(dtp_StartDate.Text); HourToUpdate.StartDate = HourToUpdate.StartDate.AddMinutes(mins); HourToUpdate.EndDate = DateTime.Parse(dtp_StartDate.Text); HourToUpdate.EndDate = HourToUpdate.StartDate.AddMinutes(duration); HourToUpdate.HourDescription = HourToUpdate.StartDate.ToString("HH:mm") + " | " + cb_UsersList.Text + " | " + culture.DateTimeFormat.GetDayName(HourToUpdate.StartDate.DayOfWeek) + " " + HourToUpdate.StartDate.Day + "-" + HourToUpdate.StartDate.Month + "-" + HourToUpdate.StartDate.Year; } if (tb_Topic.Enabled == true) { HourToUpdate.Topic = tb_Topic.Text; } if (tb_Comment.Enabled == true) { HourToUpdate.Comment = tb_Comment.Text; } if (AddHourValidation.HourOnHour(HourToUpdate)) { DB.SaveChanges(); var finishMessage = MessageBox.Show("Pomyślnie edytowano dane korepetycji"); } else { var errorMessage = MessageBox.Show("Nowa godzina korepetycji pokrywa się z już istniejącą"); } } } }
private void Submit_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(tb_Name.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Podaj imię ucznia!"); return; } if (string.IsNullOrWhiteSpace(tb_Surname.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Podaj nazwisko ucznia!"); return; } int value; if (string.IsNullOrWhiteSpace(tb_PhoneNumber.Text) || tb_PhoneNumber.Text.Length != 9 || !int.TryParse(tb_PhoneNumber.Text, out value)) { var errorNullOrwhiteSpace = MessageBox.Show("Podaj 9 cyfrowy numer telefonu " + "(musi się składać tylko z cyfr, bez spacji)"); return; } if (string.IsNullOrWhiteSpace(tb_City.Text) || string.IsNullOrWhiteSpace(tb_Street.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Podaj pełny adres ucznia"); return; } if (string.IsNullOrWhiteSpace(cb_Level.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Wybierz poziom nauczania ucznia!"); return; } if ((cb_Level.SelectedIndex == 0 || cb_Level.SelectedIndex == 1 || cb_Level.SelectedIndex == 2 || cb_Level.SelectedIndex == 3) && string.IsNullOrWhiteSpace(cb_Class.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Wybierz klasę ucznia!"); return; } var student = new Students() { Name = tb_Name.Text, Surname = tb_Surname.Text, PhoneNumber = int.Parse(tb_PhoneNumber.Text), City = tb_City.Text, Street = tb_Street.Text, Level = cb_Level.Text, SchoolClass = int.Parse(cb_Class.Text), Comment = tb_Comment.Text, CreatedDate = DateTime.Now, StudentDescription = tb_Surname.Text + " " + tb_Name.Text + " " + tb_City.Text }; string message = $"Czy na pewno chcesz dodać ucznia: \n" + $" {student.Name.ToUpper()} {student.Surname.ToUpper()}\n" + $"numer telefonu: {student.PhoneNumber}\n" + $"Adres: {student.City} {student.Street}\n" + $"poziom nauczania: {student.Level} klasa: {student.SchoolClass}\n" + $"Komentarz: {student.Comment}"; const string caption = "Form Closing"; var result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (var PrivateLessonsDB = new PrivateLessonsEntities()) { PrivateLessonsDB.Students.Add(student); PrivateLessonsDB.SaveChanges(); } result = MessageBox.Show("Pomyślnie dodano ucznia!"); } }
private void b_save_Click(object sender, EventArgs e) { if (tb_Subject.Visible == true && string.IsNullOrWhiteSpace(tb_Subject.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Należy wybrać przedmiot lub wpisać go ręcznie!"); return; } if (string.IsNullOrWhiteSpace(cb_StartMin.Text) || string.IsNullOrWhiteSpace(cb_startDateHour.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Wybierz godzinę rozpoczęcia zajęć!"); return; } if (string.IsNullOrWhiteSpace(cb_Duration.Text)) { var errorNullOrwhiteSpace = MessageBox.Show("Wybierz czas trwania zajęć!"); return; } var startDate = DateTime.Parse(dtp_StartDate.Text) .AddHours(int.Parse(cb_startDateHour.Text)) .AddMinutes(int.Parse(cb_StartMin.Text)); var isHome = true; if (rb_StudentHome.Checked == true) { isHome = false; } var subject = "Matematyka"; if (rb_OtherTopic.Checked == true) { subject = tb_Subject.Text; } var culture = new CultureInfo("pl-PL"); var privateLesson = new PrivateLessonHour() { StudentId = int.Parse(cb_UsersList.SelectedValue.ToString()), StartDate = startDate, EndDate = startDate.AddMinutes(int.Parse(cb_Duration.Text)), IsHome = isHome, Subject = subject, Topic = tb_Topic.Text, Comment = tb_Comment.Text, HourDescription = startDate.ToString("HH:mm") + " | " + cb_UsersList.Text + " | " + culture.DateTimeFormat.GetDayName(startDate.DayOfWeek) + " " + startDate.Day + "-" + startDate.Month + "-" + startDate.Year, HourDescriptionSchedule = cb_UsersList.Text }; if (string.IsNullOrWhiteSpace(privateLesson.Topic)) { privateLesson.Topic = "brak tematu"; } if (string.IsNullOrWhiteSpace(privateLesson.Comment)) { privateLesson.Comment = "brak komentarza"; } string WhereLesson = "u mnie w domu"; if (privateLesson.IsHome == false) { WhereLesson = "u ucznia w domu"; } string message = $"Czy na pewno chcesz dodać godzinę korepetycji dla: \n" + $" {privateLesson.HourDescriptionSchedule.ToUpper()} \n" + $"rozpoczynającą się: {privateLesson.StartDate.ToString("HH:mm dddd dd MMMM")} \n" + $"konczącą sie: {privateLesson.EndDate.ToString("HH:mm dddd dd MMMM")} \n" + $"odbywającą się: {WhereLesson} \n" + $"Przedmiot: {privateLesson.Subject} - {privateLesson.Topic} \n" + $"Komentarz: {privateLesson.Comment}"; const string caption = "Form Closing"; var result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (var PrivateLessonsDB = new PrivateLessonsEntities()) { var validateHour = PrivateLessonsDB.PrivateLessonHour.Where(h => h.StartDate.Day == privateLesson.StartDate.Day && h.StartDate.Month == privateLesson.StartDate.Month && h.StartDate.Year == privateLesson.StartDate.Year); int checkValidate = 0; foreach (var hour in validateHour) { if (((privateLesson.StartDate > hour.StartDate) && (privateLesson.EndDate < hour.EndDate)) || (privateLesson.StartDate == hour.StartDate && privateLesson.EndDate == hour.EndDate) || (privateLesson.EndDate <= hour.EndDate && privateLesson.EndDate > hour.StartDate) || (privateLesson.StartDate < hour.EndDate && privateLesson.StartDate >= hour.StartDate) || (hour.StartDate > privateLesson.StartDate && hour.EndDate < privateLesson.EndDate) ) { checkValidate++; } } if (checkValidate == 0) { PrivateLessonsDB.PrivateLessonHour.Add(privateLesson); PrivateLessonsDB.SaveChanges(); string finishMessage = "Pomyślnie dodano godzinę do bazy danych"; result = MessageBox.Show(finishMessage); } else { string errorMessage = "Nowa godzina korepetycji pokrywa się z aktualnie istniejącą"; result = MessageBox.Show(errorMessage); } } } }