public async Task OnPostAsync()
{
try
{
Connection.Open();
ExceptionMessage = null;
Objects.Clear();
ResultMessage = "Object was updated successfully";
switch (SelectedInfoType)
{
case null:
throw new Exception("type of information isn't chosed");
case "student":
if (IsAnyVisibleInputFieldNotFilled(6))
{
throw new Exception("all input fields must be filled (first field with non-zero value)");
}
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
SixthInputField = SixthInputField.Trim();
if (!IsValidFirstOrLastName(SecondInputField))
{
throw new Exception("incorrect first name");
}
if (!IsValidFirstOrLastName(ThirdInputField))
{
throw new Exception("incorrect last name");
}
if (!IsValidPhoneNumber(FourthInputField))
{
throw new Exception("incorrect phone number");
}
if (!IsValidEmailAddress(FifthInputField))
{
throw new Exception("incorrect email address");
}
var studentToUpdate = new Student
{
StudentID = FirstInputField,
FirstName = SecondInputField,
LastName = ThirdInputField,
PhoneNumber = FourthInputField,
Email = FifthInputField,
Github = SixthInputField
};
var numberOfAffectedStudentRows = await Repository.UpdateStudentAsync(Connection, studentToUpdate);
if (numberOfAffectedStudentRows == 0)
{
ResultMessage = "There isn't student with such ID in database";
}
else
{
Objects.AddRange(await Repository.GetAllStudentsAsync(Connection));
}
break;
case "course":
if (IsAnyVisibleInputFieldNotFilled(6))
{
throw new Exception("all input fields must be filled (first field with non-zero value)");
}
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(ThirdInputField, out DateTime resultStartDate))
{
throw new Exception("incorrect start date");
}
if (!ValidateDateTimeAndGetParsed(FourthInputField, out DateTime resultEndDate))
{
throw new Exception("incorrect end date");
}
if (!ValidateIntAndGetParsed(FifthInputField, out int resultPassingScore))
{
throw new Exception("incorrect passing score");
}
var courseToUpdate = new Course
{
CourseID = FirstInputField,
Name = SecondInputField,
StartDate = resultStartDate,
EndDate = resultEndDate,
PassingScore = resultPassingScore
};
var numberOfAffectedCourseRows = await Repository.UpdateCourseAsync(Connection, courseToUpdate);
if (numberOfAffectedCourseRows == 0)
{
ResultMessage = "There isn't course with such ID in database";
}
else
{
Objects.AddRange(await Repository.GetAllCoursesAsync(Connection));
}
break;
case "lecturer":
if (IsAnyVisibleInputFieldNotFilled(3))
{
throw new Exception("all input fields must be filled (first field with non-zero value)");
}
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
if (!IsValidFirstOrLastName(SecondInputField))
{
throw new Exception("incorrect name");
}
if (!ValidateDateTimeAndGetParsed(ThirdInputField, out DateTime resultBirthDate))
{
throw new Exception("incorrect birth date");
}
var lecturerToUpdate = new Lecturer
{
LecturerID = FirstInputField,
Name = SecondInputField,
BirthDate = resultBirthDate
};
var numberOfAffectedLecturerRows = await Repository.UpdateLecturerAsync(Connection, lecturerToUpdate);
if (numberOfAffectedLecturerRows == 0)
{
ResultMessage = "There isn't lecturer with such ID in database";
}
else
{
Objects.AddRange(await Repository.GetAllLecturersAsync(Connection));
}
break;
case "hometask":
if (IsAnyVisibleInputFieldNotFilled(6))
{
throw new Exception("all input fields must be filled (first field with non-zero value)");
}
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
SixthInputField = SixthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(FourthInputField, out DateTime resultTaskDate))
{
throw new Exception("incorrect task date");
}
if (!ValidateIntAndGetParsed(FifthInputField, out int resultSerialNumber))
{
throw new Exception("incorrect serial number");
}
if (!ValidateIntAndGetParsed(SixthInputField, out int resultCourseID))
{
throw new Exception("incorrect course ID input number");
}
var hometaskToUpdate = new HomeTask
{
HomeTaskID = FirstInputField,
Name = SecondInputField,
Description = ThirdInputField,
TaskDate = resultTaskDate,
SerialNumber = resultSerialNumber,
CourseID = resultCourseID
};
var numberOfAffectedHometaskRows = await Repository.UpdateHomeTaskAsync(Connection, hometaskToUpdate);
if (numberOfAffectedHometaskRows == 0)
{
ResultMessage = "There isn't hometask with such ID in database";
}
else
{
Objects.AddRange(await Repository.GetAllHomeTasksAsync(Connection));
}
break;
case "grade":
if (IsAnyVisibleInputFieldNotFilled(5))
{
throw new Exception("all input fields must be filled (first field with non-zero value)");
}
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(SecondInputField, out DateTime resultGradeDate))
{
throw new Exception("incorrect grade date");
}
if (!ValidateBoolAndGetParsed(ThirdInputField, out bool resultIsComplete))
{
throw new Exception("incorrect is complete");
}
if (!ValidateIntAndGetParsed(FourthInputField, out int resultHometaskID))
{
throw new Exception("incorrect hometask ID input number");
}
if (!ValidateIntAndGetParsed(FifthInputField, out int resultStudentID))
{
throw new Exception("incorrect student ID input number");
}
var gradeToUpdate = new Grade
{
GradeDate = resultGradeDate,
IsComplete = resultIsComplete,
HomeTaskID = resultHometaskID,
StudentID = resultStudentID
};
var numberOfAffectedGradeRows = await Repository.UpdateGradeAsync(Connection, gradeToUpdate);
if (numberOfAffectedGradeRows == 0)
{
ResultMessage = "There isn't grade with such ID in database";
}
else
{
Objects.AddRange(await Repository.GetAllGradesAsync(Connection));
}
break;
}
}
catch (Exception ex)
{
ExceptionMessage = "Error: " + ex.Message;
}
finally
{
Connection.Close();
}
}
public async Task OnPostAsync()
{
try
{
Connection.Open();
ExceptionMessage = null;
Objects.Clear();
switch (SelectedInfoType)
{
case null:
throw new Exception("type of information isn't chosed");
case "student":
if (IsAnyVisibleInputFieldNull(5))
{
throw new Exception("all input fields must be filled");
}
FirstInputField = FirstInputField.Trim();
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
if (!IsValidFirstOrLastName(FirstInputField))
{
throw new Exception("incorrect first name");
}
if (!IsValidFirstOrLastName(SecondInputField))
{
throw new Exception("incorrect last name");
}
if (!IsValidPhoneNumber(ThirdInputField))
{
throw new Exception("incorrect phone number");
}
if (!IsValidEmailAddress(FourthInputField))
{
throw new Exception("incorrect email address");
}
var newStudent = new Student
{
FirstName = FirstInputField,
LastName = SecondInputField,
PhoneNumber = ThirdInputField,
Email = FourthInputField,
Github = FifthInputField
};
await Repository.CreateStudentAsync(Connection, newStudent);
Objects.AddRange(await Repository.GetAllStudentsAsync(Connection));
break;
case "course":
if (IsAnyVisibleInputFieldNull(4))
{
throw new Exception("all input fields must be filled");
}
FirstInputField = FirstInputField.Trim();
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(SecondInputField, out DateTime resultStartDate))
{
throw new Exception("incorrect start date");
}
if (!ValidateDateTimeAndGetParsed(ThirdInputField, out DateTime resultEndDate))
{
throw new Exception("incorrect end date");
}
if (!ValidateIntAndGetParsed(FourthInputField, out int resultPassingScore))
{
throw new Exception("incorrect passing score");
}
var newCourse = new Course
{
Name = FirstInputField,
StartDate = resultStartDate,
EndDate = resultEndDate,
PassingScore = resultPassingScore
};
await Repository.CreateCourseAsync(Connection, newCourse);
Objects.AddRange(await Repository.GetAllCoursesAsync(Connection));
break;
case "lecturer":
if (IsAnyVisibleInputFieldNull(2))
{
throw new Exception("all input fields must be filled");
}
FirstInputField = FirstInputField.Trim();
SecondInputField = SecondInputField.Trim();
if (!IsValidFirstOrLastName(FirstInputField))
{
throw new Exception("incorrect name");
}
if (!ValidateDateTimeAndGetParsed(SecondInputField, out DateTime resultBirthDate))
{
throw new Exception("incorrect birth date");
}
var newLecturer = new Lecturer
{
Name = FirstInputField,
BirthDate = resultBirthDate
};
await Repository.CreateLecturerAsync(Connection, newLecturer);
Objects.AddRange(await Repository.GetAllLecturersAsync(Connection));
break;
case "hometask":
if (IsAnyVisibleInputFieldNull(5))
{
throw new Exception("all input fields must be filled");
}
FirstInputField = FirstInputField.Trim();
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
FifthInputField = FifthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(ThirdInputField, out DateTime resultTaskDate))
{
throw new Exception("incorrect task date");
}
if (!ValidateIntAndGetParsed(FourthInputField, out int resultSerialNumber))
{
throw new Exception("incorrect serial number");
}
if (!ValidateIntAndGetParsed(FifthInputField, out int resultCourseID))
{
throw new Exception("incorrect course ID input number");
}
var newHometask = new HomeTask
{
Name = FirstInputField,
Description = SecondInputField,
TaskDate = resultTaskDate,
SerialNumber = resultSerialNumber,
CourseID = resultCourseID
};
await Repository.CreateHomeTaskAsync(Connection, newHometask);
Objects.AddRange(await Repository.GetAllHomeTasksAsync(Connection));
break;
case "grade":
if (IsAnyVisibleInputFieldNull(4))
{
throw new Exception("all input fields must be filled");
}
FirstInputField = FirstInputField.Trim();
SecondInputField = SecondInputField.Trim();
ThirdInputField = ThirdInputField.Trim();
FourthInputField = FourthInputField.Trim();
if (!ValidateDateTimeAndGetParsed(FirstInputField, out DateTime resultGradeDate))
{
throw new Exception("incorrect grade date");
}
if (!ValidateBoolAndGetParsed(SecondInputField, out bool resultIsComplete))
{
throw new Exception("incorrect is complete");
}
if (!ValidateIntAndGetParsed(ThirdInputField, out int resultHometaskID))
{
throw new Exception("incorrect hometask ID input number");
}
if (!ValidateIntAndGetParsed(FourthInputField, out int resultStudentID))
{
throw new Exception("incorrect student ID input number");
}
var newGrade = new Grade
{
GradeDate = resultGradeDate,
IsComplete = resultIsComplete,
HomeTaskID = resultHometaskID,
StudentID = resultStudentID
};
await Repository.CreateGradeAsync(Connection, newGrade);
Objects.AddRange(await Repository.GetAllGradesAsync(Connection));
break;
}
}
catch (Exception ex)
{
ExceptionMessage = "Error: " + ex.Message;
}
finally
{
Connection.Close();
}
}
