Esempio n. 1
0
        public static void processFileListDelhi(object paramList)
        {
            starterParam p = (starterParam)paramList;

            for (int i = p.startIndex; i <= p.endIndex; i++)
            {
                NAMESTASIADataSet ds = new NAMESTASIADataSet();
                NAMESTASIADataSetTableAdapters.RAW_NAMESTableAdapter t = new NAMESTASIADataSetTableAdapters.RAW_NAMESTableAdapter();

                string f = p.fileList[i];

                FileInfo fi = new FileInfo(f);
                string fileName = fi.Name;
                int row = 1;

                StreamReader r = new StreamReader(f);

                while (r.Peek() >= 0 && row <= 1000)
                {
                    try
                    {
                        string l = r.ReadLine();

                        l = l.Trim();
                        if (l.Length <= 0) continue;

                        string[] tokens = l.Split(',');

                        if (tokens.Length < 3)
                        {
                            Debug.WriteLine("Bad Line: " + l); continue;
                        }

                        WriteToDb(tokens[0], tokens[1], "D", fileName, ds, t);

                        row++;
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message);
                        continue;
                    }

                }

                r.Close();

                ds.AcceptChanges();
            }
        }
Esempio n. 2
0
        public static void processFileListBangaloreMissed(object paramList)
        {
            // For bangalore
            starterParam p = (starterParam)paramList;
            int[] missedList = { 50, 100, 150, 200, 250, 300, 350, 400, 450, 500, 550, 600, 650, 700, 750, 800, 850, 900, 950, 1000, 1050, 1100, 1150, 1200, 1250, 1300, 1350, 1400, 1450 };
            foreach (int i in missedList)
            {
                NAMESTASIADataSet ds = new NAMESTASIADataSet();
                NAMESTASIADataSetTableAdapters.RAW_NAMESTableAdapter t = new NAMESTASIADataSetTableAdapters.RAW_NAMESTableAdapter();

                string f = p.fileList[i];

                FileInfo fi = new FileInfo(f);
                string fileName = fi.Name;
                int row = 1;

                StreamReader r = new StreamReader(f);

                while (r.Peek() >= 0 && row <= 1000)
                {
                    try
                    {
                        string l = r.ReadLine();
                        l = l.Trim();
                        if (l.Length <= 0) continue;

                        string[] tokens = l.Split('|');

                        if (tokens.Length != 3) continue;

                        WriteToDb(tokens[0], tokens[1], "B", fileName, ds, t);

                        row++;
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message);
                        continue;
                    }

                }

                r.Close();

                ds.AcceptChanges();
            }
        }