示例#1
0
        public void StartFilter()
        {
            int        i;
            int        key;
            int        objecyID_Index    = r_DbfReader.IndexOfFieldName("OBJECTID");
            int        site_Name_Index   = r_DbfReader.IndexOfFieldName("Hel_Name");
            int        region_Name_Index = r_DbfReader.IndexOfFieldName("Ezor");
            int        site_Dunam_Index  = r_DbfReader.IndexOfFieldName("Dunam");
            Site       current_site;
            string     current_crop_name;
            Coordinate current_coordinate;
            SiteByYear current_site_by_year;
            Crop       current_crop;
            string     current_sug;
            Dictionary <int, Layer>   layers_dicitonary = new Dictionary <int, Layer>();
            Dictionary <string, Crop> crops_dictionary  = new Dictionary <string, Crop>();
            Dictionary <int, Dictionary <string, int> > site_by_year_indexes = new Dictionary <int, Dictionary <string, int> >();

            using (EntitiesNegev4 context = new EntitiesNegev4())
            {
                context.Configuration.AutoDetectChangesEnabled = false;

                initializeRepositories(context);

                for (i = 13; i < 18; i++)
                {
                    key = 2000 + i;

                    layers_dicitonary.Add(key, new Layer()
                    {
                        Id          = m_LayersId++,
                        Name        = key.ToString(),
                        Year        = key,
                        SiteByYears = new List <SiteByYear>()
                    });

                    site_by_year_indexes.Add(key, new Dictionary <string, int>());

                    site_by_year_indexes[key].Add("Gidul1", r_DbfReader.IndexOfFieldName("Gidul_I_" + i.ToString()));
                    site_by_year_indexes[key].Add("Gidul2", r_DbfReader.IndexOfFieldName("Gidul_II_" + (17 - i).ToString()));
                    site_by_year_indexes[key].Add("Sug1", r_DbfReader.IndexOfFieldName("Sug_I_" + i.ToString()));
                    site_by_year_indexes[key].Add("Sug2", r_DbfReader.IndexOfFieldName("Sug_II_" + i.ToString()));
                    site_by_year_indexes[key].Add("Details", r_DbfReader.IndexOfFieldName("Details_" + i.ToString()));
                }

                for (int recorde_index = 0; recorde_index < r_DbfReader.GetRecords(objecyID_Index).Length; recorde_index++, m_SiteID++)
                {
                    current_site = new Site()
                    {
                        Dunam       = int.Parse(r_DbfReader.GetField(recorde_index, site_Dunam_Index)),
                        Region      = r_DbfReader.GetField(recorde_index, region_Name_Index).Trim(),
                        Name        = r_DbfReader.GetField(recorde_index, site_Name_Index).Trim(),
                        Id          = m_SiteID,
                        Coordinates = new List <Coordinate>(),
                        SiteByYears = new List <SiteByYear>()
                    };

                    //adding

                    m_SiteRepository.AddRow(current_site);

                    for (i = 0; i < getShapeCoordinates(recorde_index)[0].Length; i++)
                    {
                        current_coordinate = new Coordinate()
                        {
                            ID   = m_CoordinateID,
                            X    = getShapeCoordinates(recorde_index)[0][i].X,
                            Y    = getShapeCoordinates(recorde_index)[0][i].Y,
                            Site = current_site
                        };

                        if (!isCoordinateExistsInSite(current_coordinate, current_site))
                        {
                            //adding
                            current_site.Coordinates.Add(current_coordinate);
                            m_CoordinateReository.AddRow(current_coordinate);
                            m_CoordinateID++;
                        }
                    }

                    for (int year = 2013; year < 2018; year++)
                    {
                        for (int j = 1; j <= 2; j++)
                        {
                            try
                            {
                                current_crop_name = r_DbfReader.GetField(recorde_index, site_by_year_indexes[year]["Gidul" + j.ToString()]).Trim();
                            }
                            catch (Exception ex)
                            {
                                current_crop_name = null;
                            }
                            if (!string.IsNullOrWhiteSpace(current_crop_name))
                            {
                                try
                                {
                                    current_sug = r_DbfReader.GetField(recorde_index, site_by_year_indexes[year]["Sug" + j.ToString()]).Trim();
                                }
                                catch (Exception ex)
                                {
                                    current_sug = null;
                                }
                                if (!string.IsNullOrWhiteSpace(current_sug))
                                {
                                    current_crop_name += " " + current_sug;
                                }

                                if (!crops_dictionary.ContainsKey(current_crop_name))
                                {
                                    current_crop = new Crop()
                                    {
                                        ID          = m_CropId++,
                                        Name        = current_crop_name,
                                        Description = "",
                                        Quantity    = 0,
                                        SiteByYears = new List <SiteByYear>()
                                    };
                                    crops_dictionary.Add(current_crop_name, current_crop);
                                }
                                else
                                {
                                    current_crop = crops_dictionary[current_crop_name];
                                }

                                current_site_by_year = new SiteByYear()
                                {
                                    Id           = m_SiteByYearID++,
                                    CurrentCrop  = current_crop,
                                    CurrentSite  = current_site,
                                    CurrentLayer = layers_dicitonary[year]
                                };

                                current_crop.SiteByYears.Add(current_site_by_year);
                                current_site.SiteByYears.Add(current_site_by_year);
                                layers_dicitonary[year].SiteByYears.Add(current_site_by_year);

                                //adding
                                m_siteByYearRepository.AddRow(current_site_by_year);
                            }
                        }
                    }
                }

                foreach (KeyValuePair <string, Crop> crop in crops_dictionary)
                {
                    //adding
                    m_CropRepository.AddRow(crop.Value);
                }

                foreach (KeyValuePair <int, Layer> layer in layers_dicitonary)
                {
                    //adding
                    m_LayerRepository.AddRow(layer.Value);
                }

                context.Configuration.AutoDetectChangesEnabled = true;
                m_CoordinateReository.Save();
            }
        }