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