static void Main() { var generator = new SimpleGenerator(); IList<Student> students = generator.Genereate(10); Console.WriteLine("Working with this set of students:\n"); foreach (var s in students) { Console.WriteLine(s); Console.WriteLine("Group: {0}\n", s.GroupNumber); } var textDocParser = new TextDocumentParser(); IList<XcelStudent> xcelStudents = textDocParser.Genereate(10, 10).Cast<XcelStudent>().ToList(); foreach (var s in xcelStudents) { Console.WriteLine(s); Console.WriteLine("Type: {0}\n", s.StudentType); } }
static void Main() { var generator = new SimpleGenerator(); IList <Student> students = generator.Genereate(10); Console.WriteLine("Working with this set of students:\n"); foreach (var s in students) { Console.WriteLine(s); Console.WriteLine("Group: {0}\n", s.GroupNumber); } var textDocParser = new TextDocumentParser(); IList <XcelStudent> xcelStudents = textDocParser.Genereate(10, 10).Cast <XcelStudent>().ToList(); foreach (var s in xcelStudents) { Console.WriteLine(s); Console.WriteLine("Type: {0}\n", s.StudentType); } }
public IList <Transaction> Parse(string statementFilePath) { if (!CanParse(statementFilePath)) { return(null); } var transactions = new List <Transaction>(); using (var textSource = new TextSource(statementFilePath)) { try { var parsedDocument = new TextDocumentParser <StatementModel>().Parse(textSource); transactions.AddRange(GetTransactions(parsedDocument)); } catch (TextException) { return(null); } } return(transactions); }
public IList <Transaction> Parse(string statementFilePath) { if (!CanParse(statementFilePath)) { return(null); } var transactions = new List <Transaction>(); using (var textSource = new TextSource(statementFilePath)) { try { var parsedDocument = new TextDocumentParser <StatementModel>().Parse(textSource); foreach (var transaction in parsedDocument.ActivityDividend) { if (transaction.ActivityType == "DIV") { transactions.Add(CreateDividendTransaction(transaction, parsedDocument.ActivityDividend)); } } } catch (TextException) { return(null); } } return(transactions); }
public IList <Transaction> Parse(string statementFilePath) { if (!CanParse(statementFilePath)) { return(null); } var transactions = new List <Transaction>(); using (var textSource = new TextSource(statementFilePath)) { try { var parsedDocument = new TextDocumentParser <StatementModel>().Parse(textSource); transactions.AddRange(parsedDocument.ActivityOther.Select(i => CreateOtherTransaction(i, parsedDocument.Year))); transactions.AddRange(parsedDocument.ActivityDividend.Select(i => CreateDividendTransaction(parsedDocument.ActivityTaxes, i, parsedDocument.Year))); transactions.AddRange(parsedDocument.ESPP.Select(i => CreateESPPTransaction(parsedDocument.ActivityBuy, i))); } catch (TextException) { return(null); } } return(transactions); }
static void Main() { helper.ConsoleMio.Setup(); helper.ConsoleMio.PrintHeading("LINQ to Excel "); var studentsExtractor = new TextDocumentParser(); IList <XcelStudent> students = studentsExtractor.Genereate(1000).Cast <XcelStudent>().ToList(); var sheet = new Worksheet("Online Students"); string[] sheetHeader = studentsExtractor.HeaderLine; for (int i = 0; i < sheetHeader.Length; i++) { sheet.Cells[0, i] = new Cell(sheetHeader[i]); } // Add the result filed in the end sheet.Cells[0, sheetHeader.Length] = new Cell("Result"); helper.ConsoleMio.PrintColorText("Proccessing information...\n\n", ConsoleColor.DarkCyan); var onlineStudents = students .Where(student => student.StudentType == StudentType.Online) .OrderByDescending(student => student.CalculateResult()) .ToArray(); for (int i = 0; i < onlineStudents.Length; i++) { XcelStudent student = onlineStudents[i]; AddStudentDataToSheet(sheet, i + 1, student); } var workbook = new Workbook(); workbook.Worksheets.Add(sheet); helper.ConsoleMio.PrintColorText( "Query Completed\n", ConsoleColor.Green); string saveLocation = helper.SelectSaveLocation("Xcel Files|*.xls"); workbook.Save(saveLocation); helper.ConsoleMio.PrintColorText("Done", ConsoleColor.Green); helper.ConsoleMio.Restart(Main); }
static void Main() { helper.ConsoleMio.Setup(); helper.ConsoleMio.PrintHeading("LINQ to Excel "); var studentsExtractor = new TextDocumentParser(); IList<XcelStudent> students = studentsExtractor.Genereate(1000).Cast<XcelStudent>().ToList(); var sheet = new Worksheet("Online Students"); string[] sheetHeader = studentsExtractor.HeaderLine; for (int i = 0; i < sheetHeader.Length; i++) { sheet.Cells[0, i] = new Cell(sheetHeader[i]); } // Add the result filed in the end sheet.Cells[0, sheetHeader.Length] = new Cell("Result"); helper.ConsoleMio.PrintColorText("Proccessing information...\n\n", ConsoleColor.DarkCyan); var onlineStudents = students .Where(student => student.StudentType == StudentType.Online) .OrderByDescending(student => student.CalculateResult()) .ToArray(); for (int i = 0; i < onlineStudents.Length; i++) { XcelStudent student = onlineStudents[i]; AddStudentDataToSheet(sheet, i + 1, student); } var workbook = new Workbook(); workbook.Worksheets.Add(sheet); helper.ConsoleMio.PrintColorText( "Query Completed\n", ConsoleColor.Green); string saveLocation = helper.SelectSaveLocation("Xcel Files|*.xls"); workbook.Save(saveLocation); helper.ConsoleMio.PrintColorText("Done", ConsoleColor.Green); helper.ConsoleMio.Restart(Main); }