Ejemplo n.º 1
0
        public CompaniesForm(int?id = null)
        {
            InitializeComponent();
            context = new projektEntities();
            Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
            dataGridView = dataGridView1;
            LoadData();
            if (id.HasValue && id.Value >= 0)
            {
                try
                {
                    Functions.FindCompanies((int)id);
                    this.id.Text = id + "";
                    ShowCompanies(id.Value);
                }
                catch (Exception e)
                {
                    MessageBox.Show("Nie znaleziono takiego rekordu");
                }
            }

            cities.Items.Clear();
            var query1 = (from city in context.cities_list
                          select new
            {
                city.City, city.Id
            });

            foreach (var item in query1)
            {
                cities.Items.Add(new Transport()
                {
                    Name = item.City,
                    Id   = item.Id
                });
            }

            companies.Items.Clear();
            var query2 = from company in context.company_name_list
                         select new
            {
                company
            };

            foreach (var item in query2)
            {
                companies.Items.Add(new Transport()
                {
                    Name = item.company.Company,
                    Id   = item.company.Id
                });
            }
        }