Exemplo n.º 1
0
        public void ImportData()
        {
            string name;
            string surname;
            string team;

            string read_string;

            string csvFile = @"C:\Shootapp1991\ImportCSV\ShootersTeams.csv";

            try
            {
                using (StreamReader sr = new StreamReader(csvFile))
                {
                    while ((read_string = sr.ReadLine()) != null)
                    {
                        string[] split_string = read_string.Split(',');

                        name    = split_string[0];
                        surname = split_string[1];
                        team    = split_string[2];

                        if (name.ToLower() == "name" && surname.ToLower() == "surname" && team.ToLower() == "team")
                        {
                            continue;
                        }

                        if (name != String.Empty && surname != String.Empty && team != String.Empty)
                        {
                            team teamIn = new team();
                            teamIn.name = team;

                            using (ShootappDBEntities context = new ShootappDBEntities())
                            {
                                context.teams.Add(teamIn);
                                try
                                {
                                    context.SaveChanges();
                                }
                                catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException e)
                                {
                                    //Do nothing
                                }
                            }

                            using (ShootappDBEntities context = new ShootappDBEntities())
                            {
                                teamIn = context.teams.FirstOrDefault(t => t.name == teamIn.name);

                                shooter shooter1 = new shooter();
                                shooter1.name    = name;
                                shooter1.surname = surname;
                                shooter1.tid     = teamIn.id;

                                context.shooters.Add(shooter1);

                                try
                                {
                                    context.SaveChanges();
                                }
                                catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException e)
                                {
                                    //Do nothing
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString() + "\n" + e.Message, "Warning");
            }
        }
Exemplo n.º 2
0
        public void ImportData()
        {
            string name;
            string surname;
            string team;

            string[] split_string;
            string   read_string;
            string   csvFile = null;

            OpenFileDialog openFileDialog = new OpenFileDialog();

            if (openFileDialog.ShowDialog() == true)
            {
                csvFile = openFileDialog.FileName;
            }

            if (csvFile == null)
            {
                return;
            }

            try
            {
                using (StreamReader sr = new StreamReader(csvFile))
                {
                    // Checks if file has right structure
                    if ((read_string = sr.ReadLine()) != null)
                    {
                        split_string = read_string.Split(',');

                        name    = split_string[0];
                        surname = split_string[1];
                        team    = split_string[2];

                        if (name != "NAME" || surname != "SURNAME" || team != "TEAM")
                        {
                            return;
                        }
                    }
                    else
                    {
                        return;
                    }

                    while ((read_string = sr.ReadLine()) != null)
                    {
                        split_string = read_string.Split(',');

                        name    = split_string[0];
                        surname = split_string[1];
                        team    = split_string[2];

                        if (name != String.Empty && surname != String.Empty && team != String.Empty)
                        {
                            team teamIn = new team();
                            teamIn.name = team;

                            using (ShootappDBEntities context = new ShootappDBEntities())
                            {
                                context.teams.Add(teamIn);
                                try
                                {
                                    context.SaveChanges();
                                }
                                catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException)
                                {
                                    //Do nothing
                                }
                            }

                            using (ShootappDBEntities context = new ShootappDBEntities())
                            {
                                teamIn = context.teams.FirstOrDefault(t => t.name == teamIn.name);

                                shooter shooter1 = new shooter();
                                shooter1.name    = name;
                                shooter1.surname = surname;
                                shooter1.tid     = teamIn.id;

                                context.shooters.Add(shooter1);

                                try
                                {
                                    context.SaveChanges();
                                }
                                catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException)
                                {
                                    //Do nothing
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString() + "\n" + e.Message, "Warning");
            }
        }