Beispiel #1
0
        public static List <MadeService> getMadeServices(string filename)
        {
            FileInfo           file         = new FileInfo(filename);
            List <MadeService> madeServList = new List <MadeService>();

            using (ExcelPackage package = new ExcelPackage(file))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault();
                int            rowCount  = worksheet.Dimension.Rows;
                int            startRow  = 6;
                string         dtFormat  = "dd-MM-yyyy";

                for (int row = startRow; row <= rowCount; row++)
                {
                    MadeService ms = new MadeService();
                    ms.Id           = Int32.Parse(worksheet.Cells[row, 1].Value.ToString());
                    ms.Date         = DateTime.ParseExact(worksheet.Cells[row, 2].Value.ToString(), dtFormat, CultureInfo.InvariantCulture);
                    ms.PatientName  = worksheet.Cells[row, 6].Value.ToString();
                    ms.PatientPesel = worksheet.Cells[row, 8].Value.ToString();
                    ms.ServiceCode  = ms.getServiceCode(worksheet.Cells[row, 11].Value.ToString());
                    ms.Unit         = ms.getUnit(worksheet.Cells[row, 10].Value.ToString());

                    madeServList.Add(ms);
                }
            }
            return(madeServList);
        }
Beispiel #2
0
        List <MadeService> getMadeServices(string filename)
        {
            List <MadeService> madeServList = new List <MadeService> ();
            int rowsToCut = 4;
            int rowCount  = excelWorksheet.Dimension.Rows - rowsToCut;
            int startRow  = 6;

            for (int row = startRow; row <= rowCount; row++)
            {
                MadeService ms = new MadeService();
                ms.Id           = Int32.Parse(excelWorksheet.Cells[row, 1].Value.ToString());
                ms.Date         = parseDateTime(excelWorksheet.Cells[row, 2].Value.ToString());
                ms.PatientName  = excelWorksheet.Cells[row, 6].Value.ToString();
                ms.PatientPesel = excelWorksheet.Cells[row, 8].Value.ToString();
                ms.ServiceCode  = ms.getServiceCode(excelWorksheet.Cells[row, 11].Value.ToString());
                ms.Unit         = ms.getUnit(excelWorksheet.Cells[row, 10].Value.ToString());

                madeServList.Add(ms);
            }

            return(madeServList);
        }