private void Form1_Load(object sender, EventArgs e) { var studentReader = new StudentReader(); studentsComboBox.DataSource = studentReader.GetActiveStudentsForComboBox(); studentsComboBox.DisplayMember = "MatchCode"; studentsComboBox.ValueMember = "Id"; }
public static void Main(string[] args) { using (StudentReader studentReader = new StudentReader("students.txt")) { double averageGpa = GetAverageGpa(studentReader); foreach (var item in studentReader.GetStudentsWithGreaterGpa(averageGpa)) { Console.WriteLine(item); } } }
private static double GetAverageGpa(StudentReader studentReader) { double averageGpa = .0; int studentsCount = 0; foreach (var item in studentReader) { averageGpa += item.Gpa; studentsCount += 1; } averageGpa /= studentsCount; return(averageGpa); }
private void studentsComboBox_SelectedIndexChanged(object sender, EventArgs e) { var studentReader = new StudentReader(); var currentSelectedItem = studentsComboBox.SelectedItem; if (currentSelectedItem is StudentImport) { currentStudentInComboBox = (StudentImport)currentSelectedItem; } else { throw new Exception("Selected Item is no student!"); } var currentStudent = StudentReader.GetStudentsByCustomerNo((currentStudentInComboBox.CustomerNo)); StudentTextBox.Text = currentStudent.FirstOrDefault().ToAddressString(); importRefId = currentStudentInComboBox.Id; }
private void ImportAllAccountingsButton_Click(object sender, EventArgs e) { var studentReader = new StudentReader(); var debitWriter = new DebitWriter(); var paymentWriter = new PaymentWriter(); var sb = new StringBuilder(); var allStudents = studentReader.GetActiveStudentsForComboBox(); try { foreach (var customer in allStudents) { var accountLoader = new AccountLoader(); var excelFilePath = accountLoader.GetExcelSheetFullPath(customer.CustomerNo); if (excelFilePath.Contains("not found")) { sb.AppendLine(excelFilePath); continue; } var dataSet = accountLoader.ExcelToDataSet(excelFilePath); balancesTable = dataSet.Tables["Saldenliste"]; var balanceImporter = new BalanceImporter(balancesTable); var debitEntries = balanceImporter.ReadDebits(customer.CustomerNo, excelFilePath, customer.Id); foreach (var debit in debitEntries) { debitWriter.AddDebit(debit); } var paymentEntries = balanceImporter.ReadPayments(customer.CustomerNo, excelFilePath, customer.Id); foreach (var payment in paymentEntries) { paymentWriter.AddPayment(payment); } } } finally { Console.WriteLine(sb.ToString()); informationsTextBox.Text = sb.ToString(); } }
public async Task <IActionResult> Import(IFormFile file) { var stream = file.OpenReadStream(); var reader = new StudentReader(stream); var models = reader.Parse(); var list = new List <StudentBuffer>(); var data = await _service.GetStudentDataForAction(); if (!models.Any()) { return(BadRequest("File trống")); } foreach (var model in models) { var row = model.Row; var student = model.Model; var buffer = new StudentBuffer { Student = new Student(), Errors = new List <string>() }; if (string.IsNullOrEmpty(student.Code)) { buffer.Errors.Add("Mã sinh viên trống."); buffer.Index = row; } else { buffer.Student.DefCode = student.Code; } if (string.IsNullOrEmpty(student.Name)) { buffer.Errors.Add("Tên sinh viên trống."); buffer.Index = row; } else { buffer.Student.Name = student.Name; } buffer.Student.DateOfBirth = student.DateOfBirth; buffer.Student.Email = student.Email; buffer.Student.Phone = student.Phone; buffer.Student.CreatedDate = DateTime.Now; buffer.Student.LastModified = DateTime.Now; buffer.Student.IsPublished = true; if (string.IsNullOrEmpty(student.CenterCode)) { buffer.Errors.Add("Mã trường trống"); buffer.Index = row; } else { var center = data?.Centers.ToList()?.FirstOrDefault(x => x.DefCode == student.CenterCode); if (center == null) { buffer.Errors.Add("Không tìm thấy trường trên hệ thống"); buffer.Index = row; } else { buffer.Student.CenterCode = center.Id.ToObjectId(); } } if (string.IsNullOrEmpty(student.MajorCode)) { buffer.Errors.Add("Mã chuyên môn trống"); buffer.Index = row; } else { var major = data?.Majors.ToList()?.FirstOrDefault(x => x.DefCode == student.MajorCode); if (major == null) { buffer.Errors.Add("Không tìm thấy chuyên môn trên hệ thống"); buffer.Index = row; } else { buffer.Student.MajorCode = major.Id.ToObjectId(); } } if (string.IsNullOrEmpty(student.ClassCode)) { buffer.Errors.Add("Mã lớp trống"); buffer.Index = row; } else { var classroom = data?.Classrooms.ToList()?.FirstOrDefault(x => x.DefCode == student.ClassCode); if (classroom == null) { buffer.Errors.Add("Không tìm thấy lớp trên hệ thống"); buffer.Index = row; } else { buffer.Student.ClassroomCode = classroom.Id.ToObjectId(); } } list.Add(buffer); } if (list.Any(x => x.Errors.Any())) { return(BadRequest(new { Errors = list.Where(x => x.Errors.Any()).ToList() })); } var listToInsert = list.Select(x => x.Student).ToList(); await _service.Import(listToInsert); return(Ok()); }