internal List <SchoolSubject> GetListSchoolSubjects(bool IncludeANullObject)
{
List <SchoolSubject> lss = new List <SchoolSubject>();
if (IncludeANullObject)
{
SchoolSubject ss = new SchoolSubject();
ss.IdSchoolSubject = "";
lss.Add(ss);
}
DbDataReader dRead;
DbCommand cmd;
string query;
using (DbConnection conn = Connect())
{
try
{
query = "SELECT * FROM SchoolSubjects" +
" ORDER BY orderOfVisualization, name";
cmd = new SQLiteCommand(query);
cmd.Connection = conn;
dRead = cmd.ExecuteReader();
while (dRead.Read())
{
SchoolSubject subject = new SchoolSubject();
subject.IdSchoolSubject = dRead["IdSchoolSubject"].ToString();
subject.Name = dRead["Name"].ToString();
subject.Desc = dRead["Desc"].ToString();
subject.Color = Safe.Int(dRead["color"]);
subject.OrderOfVisualization = Safe.Int(dRead["orderOfVisualization"]);
subject.OldId = subject.IdSchoolSubject; // to check if the user changes IdSchoolSubject
lss.Add(subject);
}
}
catch
{ // if database is old, dont use orderOfVisualization
query = "SELECT * FROM SchoolSubjects;";
cmd = new SQLiteCommand(query);
cmd.Connection = conn;
dRead = cmd.ExecuteReader();
while (dRead.Read())
{
SchoolSubject subject = new SchoolSubject();
subject.IdSchoolSubject = dRead["IdSchoolSubject"].ToString();
subject.Name = dRead["Name"].ToString();
subject.Desc = dRead["Desc"].ToString();
subject.Color = Safe.Int(dRead["color"]);
subject.OldId = subject.IdSchoolSubject; // to check if the user changes IdSchoolSubject
lss.Add(subject);
}
}
}
cmd.Dispose();
dRead.Dispose();
return(lss);
}
private void button1_Click(object sender, EventArgs e)
{
if ((textBoxPESEL.Text == "") || (textBoxNazwisko.Text == "") || (textBoxImie.Text == ""))
{
MessageBox.Show("Nie prowadzono danej w polu PESEL, Imie lub Nazwisko!", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Reset();
}
int grade = int.Parse(checkedListBoxOcena.SelectedItem.ToString());
SchoolSubject schoolSubject = (SchoolSubject)Enum.Parse(typeof(SchoolSubject), checkedListBoxPrzedmiot.SelectedItem.ToString(), false);
SchoolClass schoolClass = (SchoolClass)Enum.Parse(typeof(SchoolClass), checkedListBoxClass.SelectedItem.ToString(), false);
string name = textBoxImie.Text;
string secondName = textBoxNazwisko.Text;
string id = textBoxPESEL.Text;
int idInt;
//MessageBox.Show(grade + ""+ schoolClass +""+ schoolSubject + name + secondName + id);
//sprawdzenie czy pesel jest liczba, jesli nie = komunikat
if (!int.TryParse(id, out idInt))
{
MessageBox.Show("Pesel nie zawiera samych liczb, czyżby nastąpił błąd?", "Uwaga", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Warning);
}
//tworzenie obiektu
PreparedLineFormatFile preparedLineFormatFile = new PreparedLineFormatFile(idInt, name + secondName, schoolClass, schoolSubject, grade);
//wysylanie do pliku
LineObject.SendLineToFile(preparedLineFormatFile);
Reset();
}
internal Grade LastOpenGradeOfStudent(Student Student, string IdSchoolYear,
SchoolSubject SchoolSubject, string IdGradeType)
{
DbDataReader dRead;
DbCommand cmd;
Grade g = new Grade();
using (DbConnection conn = Connect())
{
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT Grades.* FROM Grades" +
" WHERE Grades.idStudent=" + Student.IdStudent.ToString() +
" AND Grades.idSchoolSubject='" + SchoolSubject.IdSchoolSubject + "'" +
" AND Grades.idGradeType='" + IdGradeType + "'" +
" AND Grades.idSchoolYear='" + IdSchoolYear + "'" +
" AND (Grades.value=0 OR Grades.value IS NULL)" +
" ORDER BY Grades.idGrade DESC;";
// !!!! changed name from LastGradeOfStudent and query changed,that was WRONG, this change must be brought to every branch !!!!
dRead = cmd.ExecuteReader();
while (dRead.Read())
{
g = GetGradeFromRow(dRead);
break; // just the first!
}
dRead.Dispose();
cmd.Dispose();
}
return(g);
}
internal SchoolSubject GetSchoolSubject(string IdSchoolSubject)
{
SchoolSubject subject = new SchoolSubject();
DbDataReader dRead;
DbCommand cmd;
string query;
using (DbConnection conn = Connect())
{
query = "SELECT * FROM SchoolSubjects" +
" WHERE IdSchoolSubject='" + IdSchoolSubject + "'";
cmd = new SQLiteCommand(query);
cmd.Connection = conn;
dRead = cmd.ExecuteReader();
while (dRead.Read()) // just the first row
{
subject.Name = dRead["Name"].ToString();
subject.Desc = dRead["Desc"].ToString();
subject.Color = Safe.Int(dRead["Color"]);
subject.IdSchoolSubject = IdSchoolSubject;
subject.OldId = IdSchoolSubject;
}
}
cmd.Dispose();
dRead.Dispose();
return(subject);
}
public TeacherSchoolSubjectDTO CreateTeacherSchoolSubject(TeacherSchoolSubjectCreateAndEditDTO dto)
{
Teacher teacher = db.TeachersRepository.GetByID(dto.TeacherId);
SchoolSubject subject = db.SchoolSubjectsRepository.GetByID(dto.SchoolSubjectId);
if (teacher == null)
{
logger.Warn("No such teacher found. id {0}", dto.TeacherId);
throw new KeyNotFoundException("No teacher with that id");
}
if (subject == null)
{
logger.Warn("No such subject found. id {0}", dto.SchoolSubjectId);
throw new KeyNotFoundException("No subject with that id");
}
TeacherSchoolSubject tss = TeacherSchoolSubjectToTeacherSchoolSubjectDTOConverters.TeacherSchoolSubjectCreateAndEditDTOToTeacherSchoolSubject(teacher, subject);
db.TeacherSchoolSubjectSRepository.Insert(tss);
db.Save();
logger.Info("Creating new teacherschoolsubject. teacherId: {0}, subjectId: {1}", dto.TeacherId, dto.SchoolSubjectId);
return(TeacherSchoolSubjectToTeacherSchoolSubjectDTOConverters.TeacherSchoolSubjectToTeacherSchoolSubjectDTO(tss));
}
private void btnAdd_Click(object sender, EventArgs e)
{
SchoolSubject ss = new SchoolSubject();
subjectList.Add(ss);
DgwSubjects.DataSource = null;
DgwSubjects.DataSource = subjectList;
}
internal List <Question> GetFilteredQuestionsNotAskedToStudent(Student Student, Class Class,
SchoolSubject Subject, string IdQuestionType, List <Tag> TagsList,
Topic Topic, bool QueryManyTopics, bool TagsAnd, string SearchString,
DateTime DateFrom, DateTime DateTo)
{
return(dl.GetFilteredQuestionsNotAsked(Student, Class, Subject,
IdQuestionType, TagsList, Topic, QueryManyTopics, TagsAnd, SearchString, DateFrom, DateTo));
}
public PreparedLineFormatFile(int id, string name, SchoolClass schoolClass, SchoolSubject schoolSubject, int grade)
{
ID = id;
Name = name;
SchoolClass = schoolClass;
SchoolSubject = schoolSubject;
Grade = grade;
}
public void GivenNonExistingSubject_WhenRemove_ThenFalse()
{
SchoolSubject subject = new SchoolSubject("Informatyka", 10, 10);
Teacher teacher = new Teacher(subject);
bool result = teacher.Remove("Matematyka");
Assert.IsFalse(result);
}
public void Create_SchoolSubject_Created()
{
var schoolSubject = new SchoolSubject();
_unitOfWorkMock.Setup(uof => uof.SchoolSubjectGenericRepository.Create(schoolSubject));
_sut.Create(schoolSubject);
_unitOfWorkMock.Verify(uof => uof.SchoolSubjectGenericRepository.Create(It.IsAny <SchoolSubject>()), Times.AtLeastOnce);
}
public frmTopicChooseByPeriod(TopicChooseFormType FormType,
Class Class, SchoolSubject Subject)
{
InitializeComponent();
currentClass = Class;
currentSubject = Subject;
formType = FormType;
TopicChosen = new Topic();
TopicChosen.Id = 0;
}
public SchoolSubjectWithWeeklyClassesDTO CreateSchoolSubject(SchoolSubjectCreateAndEditDTO dto)
{
SchoolSubject subject = SchoolSubjectToSchoolSubjectDTOConverters.SchoolSubjectCreateAndEditDTOToSchoolSubject(dto);
db.SchoolSubjectsRepository.Insert(subject);
db.Save();
//TODO 12: check if the returned object has ID!!
return(SchoolSubjectToSchoolSubjectDTOConverters.SchoolSubjectToSchoolSubjectWithWeeklyClassesDTO(subject));
}
public void TestNoGrades()
{
SchoolSubject math = new SchoolSubject
{
Name = "Mathe",
};
var result = math.CalculateAverage();
Assert.AreEqual(0, result);
}
public static SchoolSubjectBasicDTO SchoolSubjectToSchoolSubjectDTO(SchoolSubject subject)
{
SchoolSubjectBasicDTO retVal = new SchoolSubjectBasicDTO()
{
Id = subject.Id,
Name = subject.Name
};
logger.Info("Converting SchoolSubject to SchoolSubjectDTO");
return(retVal);
}
public static SchoolSubject SchoolSubjectWithWeeklyClassesDTOToSchoolSubject(SchoolSubjectWithWeeklyClassesDTO dto)
{
SchoolSubject retVal = new SchoolSubject();
retVal.Id = dto.Id;
retVal.Name = dto.Name;
retVal.WeeklyClasses = dto.WeeklyClasses;
logger.Info("Coverting SchoolSubjectWithWeeklyClassesDTO To SchoolSubject");
return(retVal);
}
internal static bool CheckIfSubjectChosen(SchoolSubject SchoolSubject)
{
if (SchoolSubject == null)
//if (cmbSchoolSubject.SelectedItem == null || cmbSchoolSubject.Text == "")
{
MessageBox.Show("Scegliere una materia", "Operazione non possibile",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
return(true);
}
public ActionResult SchoolSubjectEdit(SchoolSubject schoolSubject)
{
if (!ModelState.IsValid)
{
return(View(schoolSubject));
}
_schoolSubjectsService.Update(schoolSubject);
return(RedirectToAction("GetSchoolSubjects", "SchoolSubject", new { area = "Operator" }));
}
public static SchoolSubject SchoolSubjectCreateAndEditDTOToSchoolSubject(SchoolSubjectCreateAndEditDTO dto)
{
SchoolSubject retVal = new SchoolSubject()
{
Name = dto.Name,
WeeklyClasses = dto.WeeklyClasses
};
logger.Info("Converting SchoolSubjectCreateAndEditDTO to SchoolSubject.");
return(retVal);
}
internal frmMicroAssessment(frmMain CallingForm, Class Class, Student Student,
GradeType GradeType, SchoolSubject Subject, Question Question)
{
InitializeComponent();
callingForm = CallingForm;
currentClass = Class;
currentStudent = Student;
currentGradeType = GradeType;
currentSchoolSubject = Subject;
currentQuestion = Question;
}
private void ContextMenuCopyButton_Click(object sender, RoutedEventArgs e)
{
if (SubjectsList.SelectedItems != null)
{
foreach (SchoolSubject item in SubjectsList.SelectedItems)
{
var subject = new SchoolSubject(item.Name, item.Complexity);
SchoolSubjectDict.dictionaryList.Add(subject);
SubjectsList.Items.Add(subject);
}
}
}
public frmTopicChooseByPeriod(TopicChooseFormType FormType,
Class Class, SchoolSubject Subject)
{
InitializeComponent();
db = new DbAndBusiness(Commons.PathAndFileDatabase);
currentClass = Class;
currentSubject = Subject;
formType = FormType;
TopicChosen = new Topic();
TopicChosen.Id = 0;
}
public frmGradesStudentsSummary(Student Student, string IdSchoolYear,
GradeType GradeType, SchoolSubject SchoolSubject)
{
InitializeComponent();
currentStudent = Student;
currentSchoolYear = IdSchoolYear;
currentGradeType = GradeType;
currentSchoolSubject = SchoolSubject;
lblCurrentStudent.Text = $"{Student.LastName} {Student.FirstName}";
currentAnnotation = new StudentAnnotation();
}
public void TestEmptyGrades()
{
SchoolSubject math = new SchoolSubject
{
Name = "Mathe",
};
math.Grades = new double[4];
var result = math.CalculateAverage();
Assert.AreEqual(0, result);
}
public frmGradesStudentsSummary(Student Student, string IdSchoolYear,
GradeType GradeType, SchoolSubject SchoolSubject)
{
InitializeComponent();
db = new DbAndBusiness(Commons.PathAndFileDatabase);
currentStudent = Student;
currentSchoolYear = IdSchoolYear;
currentGradeType = GradeType;
currentSchoolSubject = SchoolSubject;
lblCurrentStudent.Text = $"{Student.LastName} {Student.FirstName}";
currentAnnotation = new StudentAnnotation();
}
public void GivenExistingSubject_WhenRemove_ThenRemoveAndTrue()
{
string subjectName = "Informatyka";
SchoolSubject subject = new SchoolSubject(subjectName, 10, 10);
Teacher teacher = new Teacher(subject);
bool result = teacher.Remove(subjectName);
Assert.IsTrue(result);
CollectionAssert.DoesNotContain(
new List <SchoolSubject> (teacher.GetAllSubjects()),
subject);
}
internal static Color ColorFromNumber(SchoolSubject Subject)
{
if (Subject == null || Subject.Color == null || Subject.Color == 0)
{
return(Commons.ColorNoSubject);
}
// extract the color components from the RGB number
Color bgColor = Color.FromArgb((int)(Subject.Color & 0xFF0000) >> 16,
(int)(Subject.Color & 0xFF00) >> 8,
(int)Subject.Color & 0xFF);
return(bgColor);
}
private void DgwSubjects_CellClick(object sender, DataGridViewCellEventArgs e)
{
int?index;
if (e.RowIndex > -1)
{
DgwSubjects.Rows[e.RowIndex].Selected = true;
subjectList = ((List <SchoolSubject>)DgwSubjects.DataSource);
currentSubject = subjectList[e.RowIndex];
int color = (int)currentSubject.Color;
picSubjectColor.BackColor = Color.FromArgb((color & 0xFF0000) >> 16, (color & 0xFF00) >> 8, color & 0xFF);
}
}
public ActionResult SchoolSubjectCreate(SchoolSubject schoolSubject)
{
if (!ModelState.IsValid | _schoolSubjectsService.Find(s => s.Name == schoolSubject.Name).Any())
{
ModelState.AddModelError("SchoolSubjectError", "This exam subject already exists.");
return(View(schoolSubject));
}
_schoolSubjectsService.Create(schoolSubject);
return(RedirectToAction("GetSchoolSubjects", "SchoolSubject", new { area = "Operator" }));
}
public void Add_Click(object sender, RoutedEventArgs e)
{
if (!IsWrongTextBoxValue())
{
var OwnerWindowInstance = this.Owner as SubjectsWindow;
var subject = new SchoolSubject(NameTextBox.Text, int.Parse(ComplexityTextBox.Text));
OwnerWindowInstance.SchoolSubjectDict.dictionaryList.Add(subject);
OwnerWindowInstance.SubjectsList.Items.Add(subject);
((Owner as SubjectsWindow).Owner as EditorWindow).HomePage.SubjectsIndicator.Fill = ColorPalette.GetPredefinedColor(PredefinedColors.Green);
ElementsModification.ResetControlText <TextBox>(this);
}
}
public JsonResult SaveSubject(SchoolSubjectVM obj)
{
JsonResponse <bool> Response = new JsonResponse <bool>();
try
{
SchoolSubject schoolSubject = new SchoolSubject();
if (!String.IsNullOrEmpty(obj.SchoolSubjectId))
{
using (var _db = new SchoolMSEntities())
{
schoolSubject = _db.SchoolSubjects.Find(obj.SchoolSubjectId);
if (schoolSubject == null)
{
Response.IsError = true;
Response.Message = "School subject not found";
return(Json(Response, JsonRequestBehavior.AllowGet));
}
schoolSubject.GradeId = obj.GradeId;
schoolSubject.Subject = obj.Subject;
schoolSubject.UpdateBy = ApplicationSession.Current.UserID;
schoolSubject.UpdateDate = DateTime.Now;
_db.SaveChanges();
}
}
else
{
schoolSubject.GradeId = obj.GradeId;
schoolSubject.Subject = obj.Subject;
schoolSubject.Id = Guid.NewGuid().ToString();
schoolSubject.CreateBy = ApplicationSession.Current.UserID;
schoolSubject.CreateDate = DateTime.Now;
schoolSubject.IsDelete = false;
using (var _db = new SchoolMSEntities())
{
_db.SchoolSubjects.Add(schoolSubject);
_db.SaveChanges();
}
}
}
catch (Exception ex)
{
Response.IsError = true;
Response.Message = "Internal server error";
}
return(Json(Response, JsonRequestBehavior.AllowGet));
}
