Exemple #1
0
        public void DeleteData(DataConfig.Lists sheetName = DataConfig.Lists.Main, int row = -1)
        {
            if (row == -1)
            {
                throw new CustomException(ErrorCodes.Codes.NotExistingData);
            }

            List <List <object> > data = ReadData(sheetName);

            data.RemoveAt(row);
            WriteData(data);
        }
Exemple #2
0
        public List <List <object> > ReadData(DataConfig.Lists sheetName = DataConfig.Lists.Main)
        {
            List <List <object> > info = new List <List <object> >();

            if (sheetName == DataConfig.Lists.Prices)
            {
                csvPath   = Path.Combine(assemblyPath, "shadec-prices.csv");
                separator = ";";
            }

            try
            {
                using (TextFieldParser parser = new TextFieldParser(csvPath))
                {
                    parser.TextFieldType = FieldType.Delimited;
                    parser.SetDelimiters(separator);

                    while (!parser.EndOfData)
                    {
                        List <object> row = new List <object>();

                        try
                        {
                            row.AddRange(
                                (parser.ReadFields() ??
                                 throw new CustomException(ErrorCodes.Codes.DataReading))
                                .Cast <object>());
                        }
                        catch (NullReferenceException e)
                        {
                            throw new CustomException(ErrorCodes.Codes.DataReading);
                        }

                        info.Add(row);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new CustomException(ErrorCodes.Codes.DataFileNotFound);
            }

            return(info);
        }
Exemple #3
0
        public void UpdateData(List <object> dataNew,
                               List <object> dataOld,
                               DataConfig.Lists sheetName = DataConfig.Lists.Main)
        {
            List <List <object> > data = ReadData(sheetName);

            int oldDataIndex = data.FindIndex(el
                                              => el[0].ToString() == dataOld[0].ToString());

            if (oldDataIndex != -1)
            {
                data[oldDataIndex] = dataNew;
                File.WriteAllLines(csvPath, PrepareData(data));
            }
            else
            {
                throw new CustomException(ErrorCodes.Codes.NotExistingData);
            }
        }
Exemple #4
0
        public List <List <object> > ReadData(DataConfig.Lists sheetName = DataConfig.Lists.Main)
        {
            List <List <object> > info = new List <List <object> >();

            if (sheetName == DataConfig.Lists.Prices)
            {
                csvPath   = Path.Combine(assemblyPath, "shadec-prices.csv");
                separator = ",";
            }

            try
            {
                using (TextFieldParser parser = new TextFieldParser(csvPath))
                {
                    parser.TextFieldType = FieldType.Delimited;
                    parser.SetDelimiters(separator);
                    while (!parser.EndOfData)
                    {
                        List <object> row = new List <object>();
                        try
                        {
                            foreach (string field in parser.ReadFields())
                            {
                                row.Add(field);
                            }
                        }
                        catch (Exception)
                        {
                            throw new CustomException(ErrorCodes.Codes.DataReading);
                        }

                        info.Add(row);
                    }
                }
            }
            catch (Exception)
            {
                throw new CustomException(ErrorCodes.Codes.DataReading);
            }

            return(info);
        }
Exemple #5
0
        public void WriteData(List <List <object> > data,
                              DataConfig.Lists sheetName = DataConfig.Lists.Main)
        {
            if (sheetName == DataConfig.Lists.Prices)
            {
                csvPath   = Path.Combine(assemblyPath, "shadec-prices.csv");
                separator = ";";
            }
            List <string> allLines = PrepareData(data);

            try
            {
                File.AppendAllLines(csvPath, allLines);
            }
            catch (FileNotFoundException e)
            {
                throw new CustomException(ErrorCodes.Codes.DataFileNotFound);
            }
            catch (Exception)
            {
                throw new CustomException(ErrorCodes.Codes.DataWriting);
            }
        }