public CargoForm(int?id = null)
{
CheckBoxList = new List <CheckBox>();
InitializeComponent();
context = new projektEntities();
Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
dataGridView = dataGridView1;
DrawADRCheckBoxes();
LoadData();
//Console.WriteLine("laweta ma numer " + Functions.FindStringIndex(TypesPL,"a"));
type.Items.Clear();
type.Items.AddRange(TypesPL);
type.Text = "Kontener";
if (id.HasValue && id.Value >= 0)
{
try
{
Functions.FindCargo((int)id);
this.id.Text = id + "";
ShowCargo(id.Value);
}
catch (Exception e)
{
MessageBox.Show("Nie znaleziono takiego rekordu");
}
}
}
void LoadData()
{
try
{
var query = from car in context.cars
select new
{
Car = car
};
Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
dataGridView1.Rows.Clear();
foreach (var result in query)
{
Functions.fillDataGridView(dataGridView1, result.Car.Id, result.Car.Number_plate, result.Car.Make, result.Car.Model, result.Car.Carry, result.Car.IsUsed, result.Car.Sold, result.Car.Comment);
}
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
dataGridView1.Columns[i].Width = dataGridView1.Width / dataGridView1.Columns.Count - 6;
}
dataGridView1.Columns[dataGridView1.Columns.Count - 1].Width += 4;
Functions.TranslateTrueFalse(dataGridView1);
}
catch (Exception ex)
{
MessageBox.Show("Wystąpił błąd w połączeniu z bazą.");
//this.Close();
}
}
public ShippingForm()
{
InitializeComponent();
context = new projektEntities();
Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
dataGridView = dataGridView1;
LoadData();
updateResources();
}
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
});
}
}
public CarsForm(int?id = null)
{
InitializeComponent();
context = new projektEntities();
make.Leave += Functions.textBox_Leave;
model.Leave += Functions.textBox_Leave;
Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
dataGridView = dataGridView1;
LoadData();
if (id.HasValue && id.Value >= 0)
{
try
{
Functions.FindCar((int)id);
this.id.Text = id + "";
ShowCar(id.Value);
}
catch (Exception e)
{
MessageBox.Show("Nie znaleziono takiego rekordu");
}
}
}
public FreightsForm(int?id = null)
{
InitializeComponent();
date.Value = DateTime.Now;
context = new projektEntities();
Functions.addColumnsToDataGridView(dataGridView1, ColumnNames);
dataGridView = dataGridView1;
LoadData();
cargo.Items.Clear();
var query1 = from c in context.cargo
select new
{
Cargo = c
};
foreach (var result in query1)
{
cargo.Items.Add(new Transport
{
Id = result.Cargo.Id,
Name = result.Cargo.Name + " - " + //CargoForm.TypesPL[
CargoForm.TypesPL[(int)Enum.Parse(typeof(Functions.Types), result.Cargo.Type)]
});
}
destination.Items.Clear();
start.Items.Clear();
var query2 = from c in context.companies
join ci in context.cities_list on c.CityId equals ci.Id
join co in context.company_name_list on c.CompanyId equals co.Id
select new
{
Company = c.Id,
Address = c.Address,
City = ci.City,
Name = co.Company
};
foreach (var result in query2)
{
Transport t = new Transport
{
Id = result.Company,
Name = result.Name + ", " + result.City + ", " + result.Address
};
destination.Items.Add(t);
start.Items.Add(t);
}
if (id.HasValue && id.Value >= 0)
{
try
{
Functions.FindFreights((int)id);
this.id.Text = id + "";
ShowFreight(id.Value);
}
catch (Exception e)
{
MessageBox.Show("Nie znaleziono takiego rekordu");
}
}
}