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();
}
}
void LoadData()
{
Queries.getCars();
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, 5, 6);
}
void LoadData()
{
Queries.getCargo();
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
dataGridView1.Columns[i].Width = dataGridView1.Width / dataGridView1.Columns.Count - 8;
}
dataGridView1.Columns[dataGridView1.Columns.Count - 1].Width += 4;
Functions.TranslateTrueFalse(dataGridView1, 3);
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
for (int r = 0; r < dataGridView1.RowCount; r++)
{
if (Types.Contains(dataGridView1.Rows[r].Cells[i].Value + ""))
{
dataGridView1.Rows[r].Cells[i].Value = TypesPL[(int)(Functions.Types)Enum.Parse(typeof(Functions.Types), dataGridView1.Rows[r].Cells[i].Value + "")];
}
}
}
}