public List <StudentsList> DataBaseShowStudentsList()
{
command = new MySqlCommand("SELECT * FROM dane_studentow_view", this.conection);
reader = command.ExecuteReader();
List <StudentsList> studentListDatas = new List <StudentsList>();
if (reader.HasRows)
{
while (reader.Read())
{
StudentsList studentListData = new StudentsList();
studentListData.UserID = int.Parse(reader.GetValue(0).ToString());
studentListData.IndexNumber = int.Parse(reader.GetValue(1).ToString());
studentListData.Name = reader.GetValue(2).ToString();
studentListData.Surname = reader.GetValue(3).ToString();
studentListData.Pesel = reader.GetValue(4).ToString();
studentListData.StudyFiled = reader.GetValue(5).ToString();
studentListData.Degree = int.Parse(reader.GetValue(6).ToString());
studentListData.Semestr = int.Parse(reader.GetValue(7).ToString());
studentListData.ContactNumber = reader.GetValue(8).ToString();
studentListDatas.Add(studentListData);
}
}
reader.Close();
return(studentListDatas);
}
public async Task <IActionResult> Edit(int id, [Bind("StudentsListId,studentname,password,completeCourse,DuePoints")] StudentsList studentsList)
{
if (id != studentsList.StudentsListId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(studentsList);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentsListExists(studentsList.StudentsListId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(studentsList));
}
public virtual ActionResult StudentsList()
{
var studentsList = _studentRepository.GetAll().ToList();
var studentsListVm = new StudentsList
{
subscribedStudents = new List <ViewModels.Student.Index>(),
notSubscribedStudents = new List <ViewModels.Student.Index>()
};
foreach (var student in studentsList)
{
var studentVm = Mapper.Map <ViewModels.Student.Index>(student);
if (IsNumeric(student.Identifier))
{
studentsListVm.notSubscribedStudents.Add(studentVm);
}
else
{
studentsListVm.subscribedStudents.Add(studentVm);
}
}
return(View(MVC.Coordinator.Views.ViewNames.StudentsList, studentsListVm));
}
private void TypesOfData(int data, int noOfEntries)
{
for (int i = 0; i < noOfEntries; i++)
{
if (data == 1)
{
List <Trainer> trainers = new List <Trainer>();
TrainersList trainerList = new TrainersList();
trainers.Add(trainerList.GetTrainerDetails());
trainerList.PrintTrainersList(trainers);
}
else if (data == 2)
{
List <Students> students = new List <Students>();
StudentsList studentsList = new StudentsList();
students.Add(studentsList.GetStudentDetails());
studentsList.PrintStudentList(students);
}
else if (data == 3)
{
List <Courses> courses = new List <Courses>();
CoursesList courseList = new CoursesList();
courses.Add(courseList.GetCourseDetails());
courseList.PrintCoursesList(courses);
}
else
{
List <Assignments> Assignment = new List <Assignments>();
AssignmentList assignmentList = new AssignmentList();
Assignment.Add(assignmentList.GetAssignmentDetails());
assignmentList.PrintAssignmentList(Assignment);
}
}
}
public ActionResult StudentForms(StudentsList studentsList, string request, string formGroup)
{
try
{
var student = studentsList.CurrentStudent;
studentsList.CurrentStudent.IDGroup = storage.GetGroups(formGroup).First().IDGroup;
if (request.Equals("Create"))
{
storage.CreateStudent(student.FirstName, student.LastName, student.IndexNo, student.IDGroup, student.BirthPlace, student.BirthDate);
}
else if (request.Equals("Edit"))
{
storage.UpdateStudent(student);
}
else if (request.Equals("Delete"))
{
storage.DeleteStudent(student);
}
return(RedirectToAction("Index", new { page = studentsList.Page }));
}
catch (Exception ex)
{
return(RedirectToAction("Index", new { page = 1, errMsg = ex.Message }));
}
}
/// <summary>
/// Выполняет сохранение списка студентов в базу данных
/// </summary>
protected void SaveStudents()
{
try
{
foreach (StudentViewModel student in StudentsList)
{
context.Students.Add(new Student
{
StudentId = 0,
Name = student.Name,
Phone = student.Phone,
Description = student.Description,
Group = context.Groups.Where(p => p.GroupName == student.GroupName).FirstOrDefault()
});
}
context.SaveChanges();
StudentsList.Clear();
OnPropertyChanged(nameof(StudentsList));
FileName = string.Empty;
ErrorMessage = string.Empty;
}
catch (Exception)
{
ErrorMessage = "Произошла ошибка при сохранении.";
}
}
public void Serialize_StudentList_In_Xml_File(StudentsList student)
{
//act
bool actual = Serializer <StudentsList> .Serialize(student, "xmlfileList.xml", SerializeType.XmlFile);
//assert
Assert.IsTrue(actual);
}
public MainWindow()
{
InitializeComponent();
this.DataContext = this;
StudentsList.Add(new Student("Paul", "LName1", "FName1"));
StudentsList.Add(new Student("Alex", "LName2", "FName2"));
StudentsList.Add(new Student("Steve", "LName3", "FName3"));
}
public void Serialize_StudentList_In_Json_File(StudentsList student)
{
//act
bool actual = Serializer <StudentsList> .Serialize(student, "textjsonList.json", SerializeType.JsonFile);
//assert
Assert.IsTrue(actual);
}
public void Serialize_StudentList_In_Binary_File(StudentsList student)
{
//act
bool actual = Serializer <StudentsList> .Serialize(student, "binaryList.dat", SerializeType.BinaryFile);
//assert
Assert.IsTrue(actual);
}
public ProfessorForm()
{
InitializeComponent();
//Project List:A list that displays the professor's projects
ProjectList.Bounds = new Rectangle(new Point(150, 12), new Size(250, 500));
ProjectList.View = View.Details;
ProjectList.FullRowSelect = true;
ProjectList.GridLines = true;
ProjectList.Sorting = SortOrder.Ascending;
ProjectList.Columns.Add("Project Name", -2, HorizontalAlignment.Left);
ProjectList.Columns.Add("Max Grade", -2, HorizontalAlignment.Left);
//==========================================================================
//Students List: A list that displays each teams infos
StudentsList.Bounds = new Rectangle(new Point(150, 12), new Size(375, 500));
StudentsList.View = View.Details;
StudentsList.FullRowSelect = true;
StudentsList.GridLines = true;
StudentsList.Sorting = SortOrder.Ascending;
StudentsList.Columns.Add("Team", -2, HorizontalAlignment.Left);
StudentsList.Columns.Add("Registration Number", -2, HorizontalAlignment.Left);
StudentsList.Columns.Add("Email", -2, HorizontalAlignment.Left);
//=============================================================================
//Grade List: A list that displays the team with its project an the grade
GradeList.Bounds = new Rectangle(new Point(150, 12), new Size(275, 500));
GradeList.View = View.Details;
GradeList.FullRowSelect = true;
GradeList.GridLines = true;
GradeList.Sorting = SortOrder.Ascending;
GradeList.Columns.Add("Team", -2, HorizontalAlignment.Left);
GradeList.Columns.Add("Project", -2, HorizontalAlignment.Left);
GradeList.Columns.Add("Grade", -2, HorizontalAlignment.Left);
//==============================================================================
TeamGroupBox.Text = "";
ProjectGroupBox.Text = "";
GradeGroupBox.Text = "";
TeamGroupBox.Bounds = new Rectangle(new Point(550, 12), new Size(320, 320));
TeamGroupBox.Show();
StudentsList.Show();
GradeList.Hide();
GradeGroupBox.Hide();
AssignToWhomLabel.Hide();
AssignProjectBtn.Hide();
ProjectGroupBox.Hide();
ProjectList.Hide();
}
public void SortStudentsByGradeDescending()
{
List <Student> descendingSortedListStudentsByGrade = StudentsList.OrderByDescending(stud => stud.Grade).ToList();
foreach (var student in descendingSortedListStudentsByGrade)
{
student.Print();
}
}
public void StudentSelectedAsync(ViewStudent vstudent)
{
//Deselect Item
SelectedStudent = null;
AddOrRemoveStudentFromInviteList(vstudent.Student.Id);
StudentsList.Find(vs => vs.Student.Id == vstudent.Student.Id)
.IsImageVisible = !StudentsList.Find(vs => vs.Student.Id == vstudent.Student.Id).IsImageVisible;
}
public void GroupNameWrongTest()
{
string inputText = GetInputText("WrongGroupName.txt");
List <StudentsList> stByGroups = Parser.TransformRecevedInformation(inputText);
StudentsList group0 = stByGroups.FirstOrDefault(g => g.GroupNumber == 0);
Assert.True(group0 != null);
Assert.AreEqual(10, group0.StudentsByGoup.Count);
}
public void SortStudentsByGrade()
{
List <Student> sortedListStudentsByGrade =
StudentsList.OrderBy(stud => stud.Grade).ToList(); // order list using Orderby();
foreach (var student in sortedListStudentsByGrade)
{
student.Print();
}
}
private void WybierzUzytkownika_SelectionChanged(object sender, MouseButtonEventArgs e)
{
if (this.contentDataGrid.SelectedIndex >= 0 && this.contentDataGrid.AlternationCount >= 0)
{
StudentsList student = (StudentsList)this.contentDataGrid.SelectedItems[0];
choosenIndexNumber = student.IndexNumber;
choosenUserID = student.UserID;
CreateStudenciStudent();
}
}
public async Task <IActionResult> Create([Bind("StudentsListId,studentname,password,completeCourse,DuePoints")] StudentsList studentsList)
{
if (ModelState.IsValid)
{
_context.Add(studentsList);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(studentsList));
}
private void button2_Click(object sender, EventArgs e)
{
string fileName = Directory.GetCurrentDirectory() + "\\SerializedData.json";
string json = File.ReadAllText(fileName);
students = JsonConvert.DeserializeObject <List <Student> >(json);
foreach (var item in students)
{
StudentsList.Items.Add(item);
}
StudentsList.Refresh();
}
public void Add()
{
ValidationErrors = null;
var duplicates = new List <string>();
foreach (var studentId in SelectedStudents)
{
var student = StudentsList.FirstOrDefault(_ => _.Id == studentId);
foreach (var courseInstanceIds in SelectedCourseInstances)
{
var courseInstance = CourseInstancesList.FirstOrDefault(_ => _.Value.SemesterId == courseInstanceIds.SemesterId &&
_.Value.CourseId == courseInstanceIds.CourseId);
if (NewEnrolments.Any(_ => _.Student.Id == student.Id &&
_.Semester.Id == courseInstance.Semester.Id &&
_.Course.Id == courseInstance.Course.Id))
{
duplicates.Add(string.Format($"{student.UserFriendly} - {courseInstance.UserFriendly}"));
continue;
}
NewEnrolments.Add(new EnrolmentCreateListModel
{
Student = student,
Course = courseInstance.Course,
Semester = courseInstance.Semester,
Enrolment = new EnrolmentCreate
{
StudentId = student.Id,
CourseInstance = new CourseInstanceBase
{
CourseId = courseInstance.Course.Id,
SemesterId = courseInstance.Semester.Id
}
}
});
}
}
if (duplicates.Any())
{
ValidationErrors = new List <string>
{
"Duplikati :"
};
duplicates.ForEach(_ => ValidationErrors.Add(_));
ValidationErrors.Add("nisu dodani ponovno.");
}
}
public Handler(string sCourseXMLPath, string sStudentXMLPath)
{
Handler.sCourseXMLPath = sCourseXMLPath;
Handler.sStudentXMLPath = sStudentXMLPath;
this.objStudensList = StudentsList.getListFromXML(Handler.sStudentXMLPath);
this.objCourseList = CoursesList.getListFromXML(Handler.sCourseXMLPath);
this.objCourseList.repair();
this.objStudensList.repair();
this.cCalculate = 0;//Inital Set off calculate
}
public void Deserialize_StudentList_From_Json_File()
{
//arrange
StudentsList expected = new StudentsList(new Student("Петров", "Петр", 19), new Student("Борисов", "Борис", 18));
//act
StudentsList actual = Serializer <StudentsList> .Deserialize("textjsonList.json", Version.Parse("1.0.0.0"), SerializeType.JsonFile);
//assert
Assert.AreEqual(expected, actual);
}
private void ModifyProjectMnBtn_Click(object sender, EventArgs e)
{
StudentsList.Hide();
TeamGroupBox.Hide();
AssignToWhomLabel.Hide();
AssignProjectBtn.Hide();
GradeList.Hide();
GradeGroupBox.Hide();
ProjectList.Show();
ProjectGroupBox.Show();
ProjectGroupBox.Location = new Point(450, 12);
}
public void CreateStudentsFromFullNameList_Returns_ExpectedStudentsModelListAndType()
{
StudentsList studentsList = new StudentsList();
StudentServices studentServices = new StudentServices();
List <string> returnedStudentList = studentsList.GetStudentList();
returnedStudentList.Add("Prenume Nume");
List <StudentModel> returnedStudentModelList = studentServices.CreateStudentsFromFullNameList(returnedStudentList);
var studentToSearch = returnedStudentModelList.FirstOrDefault(s => s.FirstName == "Prenume" && s.LastName == "Nume");
Assert.IsNotNull(studentToSearch);
Assert.IsInstanceOfType(studentToSearch, typeof(StudentModel));
}
public void CreateStudent(Student st1)
{
Console.WriteLine("Please insert Student First Name:");
string studentfirstName = Console.ReadLine();
Console.WriteLine("Please insert Student Last Name:"); ///Second aproach : insert datas in the console
string studentlastName = Console.ReadLine();
Console.WriteLine("Please insert Student Grade:");
int studentgrade = Convert.ToInt32(Console.ReadLine());
st1.FirstName = studentfirstName;
st1.LastName = studentlastName;
st1.Grade = studentgrade;
StudentsList.Add(st1);
}
private void ModifyTeamMnBtn_Click(object sender, EventArgs e)
{
ProjectGroupBox.Hide();
ProjectList.Hide();
GradeList.Hide();
AssignToWhomLabel.Hide();
AssignProjectBtn.Hide();
GradeGroupBox.Hide();
StudentsList.Anchor = (AnchorStyles.Bottom | AnchorStyles.Left | AnchorStyles.Top);
TeamGroupBox.Show();
StudentsList.Show();
TeamGroupBox.Location = new Point(550, 12);
StudentsList.Location = new Point(150, 12);
}
private void AssignProjectMnBtn_Click(object sender, EventArgs e)
{
ProjectGroupBox.Hide();
TeamGroupBox.Hide();
GradeList.Hide();
GradeGroupBox.Hide();
StudentsList.Anchor = (AnchorStyles.Bottom | AnchorStyles.Right | AnchorStyles.Top);
AssignToWhomLabel.Show();
AssignProjectBtn.Show();
ProjectList.Show();
StudentsList.Show();
StudentsList.Location = new Point(635, 12);
AssignProjectBtn.Location = new Point(467, 100);
AssignToWhomLabel.Location = new Point(407, 50);
}
private void Deportaments_PreviewKeyDown(object sender, KeyEventArgs e)
{
var txt = SearchText.Text.Trim();
if (String.IsNullOrEmpty(txt))
{
//отобразить список полностью
StudentsList.Clear();
_tempStudents.ToList().ForEach(StudentsList.Add);
return;
}
var list = StudentsList.Where(s => s.LastName.StartsWith(txt)).ToList();
StudentsList.Clear();
list.ForEach(StudentsList.Add);
}
public void TestStudentsList(Student element)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
if (StudentsList.Contains(element))
{
stopwatch.Stop();
Console.WriteLine($"Елемент знайдено. Час: {stopwatch.ElapsedTicks} ticks");
}
else
{
stopwatch.Stop();
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine($"Елемент не знайдено. Час: {stopwatch.ElapsedTicks} ticks");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
public override void RefreshData()
{
var currentSchool = GetCurrentSchool();
var students = MembersRealm.GetAll(x => x.School == currentSchool).ToList();
var studentsContainer = new List <ViewModels.Controls.PrettyListViewItems.Student>();
var currentProfile = GetCurrentUser().Profile;
var currentMember = MembersRealm.Get(x => x.Profile == currentProfile);
students.Remove(currentMember);
foreach (var studentsModel in students)
{
studentsContainer.Add(new ViewModels.Controls.PrettyListViewItems.Student(studentsModel.Profile));
}
StudentsList.Clear();
StudentsList.AddRange(studentsContainer);
}
/// <summary>
/// Reads the details text file from the App_Data directory and parses each row to an object.
/// </summary>
private void ParseDetailsFile()
{
StreamReader file = new StreamReader(System.Web.HttpContext.Current.Server.MapPath("~/App_Data/studInfo.txt"));
var detailsLines = file.ReadLine();
//Loop through all the lines in the details file
while (detailsLines != null)
{
var studentSplitedLine = detailsLines.Split(' ');
StudentsList.Add(new Student
{
FirstName = studentSplitedLine[0],
LastName = studentSplitedLine[1],
Id = long.Parse(studentSplitedLine[2])
});
detailsLines = file.ReadLine();
}
file.Close();
}
public void Deserialize_StudentList_From_Binary_File(Version currVersion)
{
//arrange
StudentsList expected = new StudentsList(new Student("Петров", "Петр", 19), new Student("Борисов", "Борис", 18));
StudentsList actual = new StudentsList();
//act
if (currVersion == Version.Parse("1.0.0.1"))
{
Assert.ThrowsException <Exception>(() => { Serializer <Student> .Deserialize("binary.dat", currVersion, SerializeType.BinaryFile); });
}
else
{
actual = Serializer <StudentsList> .Deserialize("binaryList.dat", currVersion, SerializeType.BinaryFile);
Assert.AreEqual(expected, actual);
}
}
