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