Example #1
0
        static void Main(string[] args)
        {
            string inputFile = "", outputFile = "", fileFormat = "";

            try
            {
                for (int i = 0; i < args.Length; i += 2)
                {
                    switch (args[i])
                    {
                    case "-i":
                        inputFile = args[i + 1];
                        break;

                    case "-o":
                        outputFile = args[i + 1];
                        break;

                    case "-f":
                        fileFormat = args[i + 1];
                        break;

                    default:
                        throw new Exception("Unknown flag");
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionProcessing.LogEx(ex);
            }
            //DataProcessing.Run("test.csv", "out", "json");
            DataProcessing.Run(inputFile, outputFile, fileFormat);
        }
Example #2
0
        public static void SaveGroup(Group group, string path)
        {
            var newFile = new FileInfo(path);

            using (ExcelPackage xlPackage = new ExcelPackage(newFile))
            {
                ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("Group");

                for (int i = 0; i < group.header.Length; i++)
                {
                    worksheet.Cells[1, i + 1].Value = group.header[i];
                    worksheet.Column(i + 1).Width   = 20;
                }
                worksheet.Cells[1, group.header.Length + 1].Value = "Average mark";
                worksheet.Column(group.header.Length + 1).Width   = 20;

                for (int i = 0, row = 2; i < group.students.Count; i++, row++)
                {
                    worksheet.Cells[row, 1].Value = group.students[i].name;
                    worksheet.Cells[row, 2].Value = group.students[i].surname;
                    worksheet.Cells[row, 3].Value = group.students[i].patronymic;
                    int col = 4;
                    for (int j = 0; j < group.students[i].subjects.Count; j++, col++)
                    {
                        worksheet.Cells[row, col].Value = group.students[i].subjects[j].mark;
                    }
                    worksheet.Cells[row, col].Value = group.students[i].averageMark;
                }

                int lastRow = group.students.Count + 2;


                worksheet.Cells[lastRow, 3].Value = "Average by group:";

                for (int i = 0; i < group.averageMarks.Count - 1; i++)
                {
                    worksheet.Cells[lastRow, i + 4].Value = group.averageMarks[group.header[i + 3]];
                }


                worksheet.Cells[lastRow, group.averageMarks.Count + 3].Value = group.averageMarks["Average"];



                try
                {
                    if (File.Exists(path))
                    {
                        File.Delete(path);
                    }
                    xlPackage.Save();
                }
                catch
                {
                    ExceptionProcessing.LogEx(new Exception("Invalid file format or path."));
                }
            }
        }
Example #3
0
 public static void SaveGroup(Group group, string path)
 {
     try
     {
         using (FileStream fs = new FileStream(path, FileMode.Create))
         {
             DataContractJsonSerializer jsonFormatter = new DataContractJsonSerializer(typeof(Group));
             jsonFormatter.WriteObject(fs, group);
         }
     }
     catch
     {
         ExceptionProcessing.LogEx(new Exception("Invalid file format or path."));
     }
 }
Example #4
0
        public static List <string[]> ReadData(string path)
        {
            List <string[]> CSVData = new List <string[]>();

            try
            {
                using (StreamReader sr = new StreamReader(path))
                {
                    string line;
                    while ((line = sr.ReadLine()) != null)
                    {
                        Regex    CSVParser = new Regex("[,;]");
                        string[] X         = CSVParser.Split(line);
                        CSVData.Add(X);
                    }
                }
            }
            catch
            {
                ExceptionProcessing.LogEx(new Exception("Invalid file format or path."));
            }

            return(CSVData);
        }