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);
}
private void LoadPrivateLesson(int id)
{
using (var DB = new PrivateLessonsEntities())
{
LessonToEdit = DB.PrivateLessonHour.Single(h => h.Id == id);
}
}
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);
}
}
}
}