private void button4_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from f in context.shipping where f.Id == Id select new { Shipping = f }).First(); if (query.Shipping.ArriveTime.HasValue) { MessageBox.Show("To zlecenie zostało już ukończone"); return; } query.Shipping.Comment = comment.Text; query.Shipping.ArriveTime = DateTime.Now; context.Entry(query.Shipping).State = EntityState.Modified; context.SaveChanges(); updateResources(); ClearForm(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from f in context.shipping where f.Id == Id select new { Shipping = f }).First(); query.Shipping.Comment = comment.Text; context.Entry(query.Shipping).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { if (cargo.SelectedIndex < 0 || start.SelectedIndex < 0 || destination.SelectedIndex < 0) { MessageBox.Show("Towar, miejsce startowe i miejsce docelowe nie mogą być puste"); return; } freights Freight = new freights { Amount = (byte)amount.Value, CargoId = ((Transport)cargo.SelectedItem).Id, Comment = comment.Text, From = ((Transport)start.SelectedItem).Id, ScheduledArrive = date.Value, To = ((Transport)destination.SelectedItem).Id, Weight = (int)weight.Value }; projektEntities context = new projektEntities(); context.freights.Add(Freight); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Freight.Id.ToString(); }
private void button3_Click(object sender, EventArgs e) { if (Functions.AllowedPlate(plate.Text)) { cars Car = new cars { Make = make.Text, Model = model.Text, Comment = comment.Text, Number_plate = plate.Text, Carry = (int)carry.Value, IsUsed = false.ToString(), Sold = false.ToString() }; projektEntities context = new projektEntities(); context.cars.Add(Car); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Car.Id.ToString(); } else { MessageBox.Show("Istnieje już auto o takiej rejestracji"); } }
private void getOrAddCity(int index) { if (index < 0) { String name = Functions.TextFormat(cities.Text); if (name.Length == 0) { throw new Exception("Miasto nie może mieć pustej nazwy"); } cities_list newCity = new cities_list() { City = name }; context.cities_list.Add(newCity); context.SaveChanges(); cities.Items.Add(new Transport() { Name = newCity.City, Id = newCity.Id }); cities.SelectedIndex = cities.Items.Count - 1; } }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from c in context.cargo where c.Id == Id select new { Cargo = c }).First(); if (query.Cargo == null) { MessageBox.Show("Nie znaleziono auta o takim Id"); return; } query.Cargo.Name = name.Text; query.Cargo.ADR = adr.Checked.ToString(); query.Cargo.Type = Types[Functions.FindStringIndex(TypesPL, type.Text)]; query.Cargo.Comment = comment.Text; string adrClass = ""; foreach (var item in CheckBoxList) { if (item.Checked) { adrClass += Functions.classes[(int)item.Tag]; } adrClass += ","; //Cargo.AdrClass[(int)item.Tag] = item.Checked; } adrClass = adrClass.Remove(adrClass.LastIndexOf(',')); query.Cargo.ADR_Class = adrClass; context.Entry(query.Cargo).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { try { getOrAddCity(cities.SelectedIndex); getOrAddCompany(companies.SelectedIndex); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } companies Company = new companies { Address = address.Text, Comment = comment.Text, CityId = ((Transport)cities.SelectedItem).Id, CompanyId = ((Transport)companies.SelectedItem).Id }; projektEntities context = new projektEntities(); try { context.companies.Add(Company); context.SaveChanges(); LoadData(); int currentRow = dataGridView.RowCount - 2; for (int i = 0; i < dataGridView.RowCount; i++) { System.Console.WriteLine(dataGridView[0, i].Value.ToString()); if (int.Parse(dataGridView[0, i].Value.ToString()) == Company.Id) { currentRow = i; break; } } dataGridView.CurrentCell = dataGridView[0, currentRow]; id.Text = Company.Id.ToString(); } catch (Exception) { MessageBox.Show("Taka firma już istnieje"); } }
private void button3_Click(object sender, EventArgs e) { if (driver.SelectedIndex < 0 || car.SelectedIndex < 0 || freight.SelectedIndex < 0) { MessageBox.Show("Musi być określony kierowca, pojazd i zlecenie"); return; } shipping Shipping = new shipping { CarId = ((Transport)car.SelectedItem).Id, DriverId = ((Transport)driver.SelectedItem).Id, FreightId = ((Transport)freight.SelectedItem).Id, //DepartTime = DateTime.Now, Delivered = "Not yet", // ArriveTime = null, Comment = comment.Text }; freights Freight = Functions.FindFreights(Shipping.FreightId); cars Car = Functions.FindCar(Shipping.CarId); drivers Driver = Functions.FindDriver(Shipping.DriverId); cargo Cargo = Functions.FindCargo(Freight.CargoId); if (Freight.Weight > Car.Carry) { MessageBox.Show("Ten pojazd ma za małą ładowność"); return; } if (Boolean.Parse(Cargo.ADR) && !Boolean.Parse(Driver.ADR_License)) { MessageBox.Show("Kierowca nie może wieźć ładunku niebezpiecznego"); return; } //Freight.Weight projektEntities context = new projektEntities(); context.shipping.Add(Shipping); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Shipping.Id.ToString(); updateResources(); }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from car in context.cars where car.Id == Id select new { Car = car }).First(); if (query.Car == null) { MessageBox.Show("Nie znaleziono auta o takim Id"); return; } if (!Functions.AllowedPlate(plate.Text) && plate.Text != query.Car.Number_plate) { MessageBox.Show("Taki numer rejestracji już występuje"); return; } query.Car.Make = make.Text; query.Car.Model = model.Text; query.Car.Comment = comment.Text; query.Car.Number_plate = plate.Text; query.Car.Carry = (int)carry.Value; query.Car.Sold = sold.Checked.ToString(); context.Entry(query.Car).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from company in context.companies where company.Id == Id select new { company }).First(); try { getOrAddCity(cities.SelectedIndex); getOrAddCompany(companies.SelectedIndex); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } query.company.Address = address.Text; query.company.Comment = comment.Text; query.company.CityId = ((Transport)cities.SelectedItem).Id; query.company.CompanyId = ((Transport)companies.SelectedItem).Id; context.Entry(query.company).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { drivers Driver = new drivers { Name = name.Text, Surname = surname.Text, Wage = (int)wage.Value, ADR_License = adr.Checked.ToString(), Employed = true.ToString(), Busy = false.ToString(), Comment = comment.Text }; projektEntities context = new projektEntities(); context.drivers.Add(Driver); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Driver.Id.ToString(); }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from driver in context.drivers where driver.Id == Id select new { Driver = driver }).First(); if (query.Driver == null) { MessageBox.Show("Nie znaleziono kierowcy o takim Id"); return; } query.Driver.Name = name.Text; query.Driver.Surname = surname.Text; query.Driver.Comment = comment.Text; query.Driver.Wage = (int)wage.Value; query.Driver.Employed = employed.Checked.ToString(); query.Driver.ADR_License = adr.Checked.ToString(); context.Entry(query.Driver).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") { return; } int Id = int.Parse(id.Text); if (cargo.SelectedIndex < 0 || start.SelectedIndex < 0 || destination.SelectedIndex < 0) { MessageBox.Show("Towar, miejsce startowe i miejsce docelowe nie mogą być puste"); return; } projektEntities context = new projektEntities(); var query = (from f in context.freights where f.Id == Id select new { Freight = f }).First(); query.Freight.Amount = (byte)amount.Value; query.Freight.CargoId = ((Transport)cargo.SelectedItem).Id; query.Freight.Comment = comment.Text; query.Freight.From = ((Transport)start.SelectedItem).Id; query.Freight.ScheduledArrive = date.Value; query.Freight.To = ((Transport)destination.SelectedItem).Id; query.Freight.Weight = (int)weight.Value; context.Entry(query.Freight).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from f in context.shipping where f.Id == Id select new { Shipping = f }).First(); query.Shipping.Comment = comment.Text; context.Entry(query.Shipping).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { //////FreightsList.Types a = FreightsList.Types.Container; //////string b = "Flatbed"; //////a = (FreightsList.Types)2; //////Console.WriteLine("Types a = " + a + (int)a); //////Console.WriteLine(b + " == " + a + " asasd "); //////Console.WriteLine((string)a.ToString() == b); //////Console.WriteLine(""); //////MessageBox.Show(dataGridView1.Rows[1].Cells[4].Value.ToString()); string adrClass = ""; foreach (var item in CheckBoxList) { if (item.Checked) { adrClass += Functions.classes[(int)item.Tag]; } adrClass += ","; //Cargo.AdrClass[(int)item.Tag] = item.Checked; } adrClass = adrClass.Remove(adrClass.LastIndexOf(',')); cargo Cargo = new cargo() { Name = name.Text, ADR = adr.Checked.ToString(), Type = Types[Functions.FindStringIndex(TypesPL, type.Text)], Comment = comment.Text, ADR_Class = adrClass }; projektEntities context = new projektEntities(); context.cargo.Add(Cargo); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Cargo.Id.ToString(); ////string adrClass = ""; ////foreach (var item in CheckBoxList) ////{ //// if (item.Checked) //// { //// adrClass += Functions.classes[(int)item.Tag] + ","; //// } ////} ////if (adrClass.Length > 0) //// adrClass.Remove(adrClass.Length - 1, 1); ////else //// adr.Checked = false; ////DataBase.AddFreightsList(name.Text, Types[Functions.FindStringIndex(TypesPL, type.Text)], adrClass, adr.Checked, comment.Text); ////LoadData(DataBase); //////if (Functions.AllowedPlate(plate.Text, DataBase.CarsList)) //////{ ////// //DataBase.AddCar(plate.Text, make.Text, model.Text, (uint)carry.Value, false, false, comment.Text); ////// //DataBase.CarsList.Add(new Cars()); ////// //LoadData(DataBase); //////} //////else //////{ ////// MessageBox.Show("Istnieje już auto o takiej rejestracji"); //////} }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from car in context.cars where car.Id == Id select new { Car = car }).First(); if (query.Car == null) { MessageBox.Show("Nie znaleziono auta o takim Id"); return; } if (!Functions.AllowedPlate(plate.Text) && plate.Text != query.Car.Number_plate) { MessageBox.Show("Taki numer rejestracji już występuje"); return; } query.Car.Make = make.Text; query.Car.Model = model.Text; query.Car.Comment = comment.Text; query.Car.Number_plate = plate.Text; query.Car.Carry = (int)carry.Value; query.Car.Sold = sold.Checked.ToString(); context.Entry(query.Car).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { if (cargo.SelectedIndex < 0 || start.SelectedIndex < 0 || destination.SelectedIndex < 0) { MessageBox.Show("Towar, miejsce startowe i miejsce docelowe nie mogą być puste"); return; } freights Freight = new freights { Amount = (byte)amount.Value, CargoId = ((Transport)cargo.SelectedItem).Id, Comment = comment.Text, From = ((Transport)start.SelectedItem).Id, ScheduledArrive = date.Value, To = ((Transport)destination.SelectedItem).Id, Weight = (int)weight.Value }; projektEntities context = new projektEntities(); context.freights.Add(Freight); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Freight.Id.ToString(); }
private void button3_Click(object sender, EventArgs e) { if (Functions.AllowedPlate(plate.Text)) { cars Car = new cars { Make = make.Text, Model = model.Text, Comment = comment.Text, Number_plate = plate.Text, Carry = (int)carry.Value, IsUsed=false.ToString(), Sold = false.ToString() }; projektEntities context = new projektEntities(); context.cars.Add(Car); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount-2]; id.Text = Car.Id.ToString(); } else { MessageBox.Show("Istnieje już auto o takiej rejestracji"); } }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from driver in context.drivers where driver.Id == Id select new { Driver = driver }).First(); if (query.Driver == null) { MessageBox.Show("Nie znaleziono kierowcy o takim Id"); return; } query.Driver.Name = name.Text; query.Driver.Surname = surname.Text; query.Driver.Comment = comment.Text; query.Driver.Wage = (int)wage.Value; query.Driver.Employed = employed.Checked.ToString(); query.Driver.ADR_License = adr.Checked.ToString(); context.Entry(query.Driver).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void ShowShipping(int Id) { shipping Shipping = Functions.FindShipping(Id); projektEntities ctx = new projektEntities(); var result = (from fr in ctx.freights join ca in ctx.cargo on fr.CargoId equals ca.Id join st in ctx.companies on fr.From equals st.Id join stci in ctx.cities_list on st.CityId equals stci.Id join stco in ctx.company_name_list on st.CompanyId equals stco.Id join de in ctx.companies on fr.To equals de.Id join deci in ctx.cities_list on de.CityId equals deci.Id join deco in ctx.company_name_list on de.CompanyId equals deco.Id where fr.Id == Shipping.FreightId select new { Freight = fr, Cargo = ca, Start = st, StartCity = stci, StartCompany = stco, Destination = de, DestinationCity = deci, DestinationCompany = deco }).First(); drivers Driver = Functions.FindDriver(Shipping.DriverId); cars Car = Functions.FindCar(Shipping.CarId); driver.Text = Driver.Surname + " " + Driver.Name; if (Boolean.Parse(Driver.Busy) || !Boolean.Parse(Driver.Employed)) { driver.SelectedIndex = -1; driver.DropDownStyle = ComboBoxStyle.DropDown; driver.Enabled = false; driver.Text = Driver.Surname + " " + Driver.Name; } else { driver.DropDownStyle = ComboBoxStyle.DropDownList; driver.Enabled = true; } car.Text = Car.Make + " " + Car.Model + ", " + Car.Number_plate; if (Boolean.Parse(Car.IsUsed) || Boolean.Parse(Car.Sold)) { car.SelectedIndex = -1; car.DropDownStyle = ComboBoxStyle.DropDown; car.Enabled = false; car.Text = Car.Make + " " + Car.Model + ", " + Car.Number_plate; } else { car.DropDownStyle = ComboBoxStyle.DropDownList; car.Enabled = true; } freight.Text = result.Cargo.Name + ": " + result.StartCompany.Company + ", " + result.StartCity.City + '\u279C' + result.DestinationCompany.Company + ", " + result.DestinationCity.City; if (result.Freight.Amount < 1) { freight.SelectedIndex = -1; freight.DropDownStyle = ComboBoxStyle.DropDown; freight.Enabled = false; freight.Text = result.Cargo.Name + ": " + result.StartCompany.Company + ", " + result.StartCity.City + '\u279C' + result.DestinationCompany.Company + ", " + result.DestinationCity.City; } else { freight.DropDownStyle = ComboBoxStyle.DropDownList; freight.Enabled = true; } context.Dispose(); comment.Text = Shipping.Comment; context.SaveChanges(); }
private void button3_Click(object sender, EventArgs e) { try { getOrAddCity(cities.SelectedIndex); getOrAddCompany(companies.SelectedIndex); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } companies Company = new companies { Address = address.Text, Comment = comment.Text, CityId = ((Transport)cities.SelectedItem).Id, CompanyId = ((Transport)companies.SelectedItem).Id }; projektEntities context = new projektEntities(); try { context.companies.Add(Company); context.SaveChanges(); LoadData(); int currentRow = dataGridView.RowCount - 2; for (int i = 0; i < dataGridView.RowCount; i++) { System.Console.WriteLine(dataGridView[0, i].Value.ToString()); if (int.Parse(dataGridView[0, i].Value.ToString()) == Company.Id) { currentRow = i; break; } } dataGridView.CurrentCell = dataGridView[0, currentRow]; id.Text = Company.Id.ToString(); } catch(Exception){ MessageBox.Show("Taka firma już istnieje"); } }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from c in context.cargo where c.Id == Id select new { Cargo = c }).First(); if (query.Cargo == null) { MessageBox.Show("Nie znaleziono auta o takim Id"); return; } query.Cargo.Name = name.Text; query.Cargo.ADR = adr.Checked.ToString(); query.Cargo.Type = Types[Functions.FindStringIndex(TypesPL, type.Text)]; query.Cargo.Comment = comment.Text; string adrClass = ""; foreach (var item in CheckBoxList) { if (item.Checked) { adrClass += Functions.classes[(int)item.Tag]; } adrClass += ","; //Cargo.AdrClass[(int)item.Tag] = item.Checked; } adrClass = adrClass.Remove(adrClass.LastIndexOf(',')); query.Cargo.ADR_Class = adrClass; context.Entry(query.Cargo).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { //////FreightsList.Types a = FreightsList.Types.Container; //////string b = "Flatbed"; //////a = (FreightsList.Types)2; //////Console.WriteLine("Types a = " + a + (int)a); //////Console.WriteLine(b + " == " + a + " asasd "); //////Console.WriteLine((string)a.ToString() == b); //////Console.WriteLine(""); //////MessageBox.Show(dataGridView1.Rows[1].Cells[4].Value.ToString()); string adrClass = ""; foreach (var item in CheckBoxList) { if (item.Checked) { adrClass += Functions.classes[(int)item.Tag]; } adrClass += ","; //Cargo.AdrClass[(int)item.Tag] = item.Checked; } adrClass = adrClass.Remove(adrClass.LastIndexOf(',')); cargo Cargo = new cargo() { Name = name.Text, ADR = adr.Checked.ToString(), Type = Types[Functions.FindStringIndex(TypesPL, type.Text)], Comment = comment.Text, ADR_Class = adrClass }; projektEntities context = new projektEntities(); context.cargo.Add(Cargo); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Cargo.Id.ToString(); ////string adrClass = ""; ////foreach (var item in CheckBoxList) ////{ //// if (item.Checked) //// { //// adrClass += Functions.classes[(int)item.Tag] + ","; //// } ////} ////if (adrClass.Length > 0) //// adrClass.Remove(adrClass.Length - 1, 1); ////else //// adr.Checked = false; ////DataBase.AddFreightsList(name.Text, Types[Functions.FindStringIndex(TypesPL, type.Text)], adrClass, adr.Checked, comment.Text); ////LoadData(DataBase); //////if (Functions.AllowedPlate(plate.Text, DataBase.CarsList)) //////{ ////// //DataBase.AddCar(plate.Text, make.Text, model.Text, (uint)carry.Value, false, false, comment.Text); ////// //DataBase.CarsList.Add(new Cars()); ////// //LoadData(DataBase); //////} //////else //////{ ////// MessageBox.Show("Istnieje już auto o takiej rejestracji"); //////} }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); if (cargo.SelectedIndex < 0 || start.SelectedIndex < 0 || destination.SelectedIndex < 0) { MessageBox.Show("Towar, miejsce startowe i miejsce docelowe nie mogą być puste"); return; } projektEntities context = new projektEntities(); var query = (from f in context.freights where f.Id == Id select new { Freight = f }).First(); query.Freight.Amount = (byte)amount.Value; query.Freight.CargoId = ((Transport)cargo.SelectedItem).Id; query.Freight.Comment = comment.Text; query.Freight.From = ((Transport)start.SelectedItem).Id; query.Freight.ScheduledArrive = date.Value; query.Freight.To = ((Transport)destination.SelectedItem).Id; query.Freight.Weight = (int)weight.Value; context.Entry(query.Freight).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button4_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from f in context.shipping where f.Id == Id select new { Shipping = f }).First(); if (query.Shipping.ArriveTime.HasValue) { MessageBox.Show("To zlecenie zostało już ukończone"); return; } query.Shipping.Comment = comment.Text; query.Shipping.ArriveTime = DateTime.Now; context.Entry(query.Shipping).State = EntityState.Modified; context.SaveChanges(); updateResources(); ClearForm(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button1_Click(object sender, EventArgs e) { int currentRow = dataGridView1.CurrentRow.Index; int currentCol = dataGridView1.CurrentCell.ColumnIndex; if (id.Text == "") return; int Id = int.Parse(id.Text); projektEntities context = new projektEntities(); var query = (from company in context.companies where company.Id == Id select new { company }).First(); try { getOrAddCity(cities.SelectedIndex); getOrAddCompany(companies.SelectedIndex); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } query.company.Address = address.Text; query.company.Comment = comment.Text; query.company.CityId = ((Transport)cities.SelectedItem).Id; query.company.CompanyId = ((Transport)companies.SelectedItem).Id; context.Entry(query.company).State = EntityState.Modified; context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[currentCol, currentRow]; }
private void button3_Click(object sender, EventArgs e) { if (driver.SelectedIndex < 0 || car.SelectedIndex < 0 || freight.SelectedIndex < 0) { MessageBox.Show("Musi być określony kierowca, pojazd i zlecenie"); return; } shipping Shipping = new shipping { CarId = ((Transport)car.SelectedItem).Id, DriverId = ((Transport)driver.SelectedItem).Id, FreightId = ((Transport)freight.SelectedItem).Id, //DepartTime = DateTime.Now, Delivered = "Not yet", // ArriveTime = null, Comment = comment.Text }; freights Freight = Functions.FindFreights(Shipping.FreightId); cars Car = Functions.FindCar(Shipping.CarId); drivers Driver = Functions.FindDriver(Shipping.DriverId); cargo Cargo = Functions.FindCargo(Freight.CargoId); if (Freight.Weight > Car.Carry) { MessageBox.Show("Ten pojazd ma za małą ładowność"); return; } if(Boolean.Parse(Cargo.ADR) && !Boolean.Parse(Driver.ADR_License)) { MessageBox.Show("Kierowca nie może wieźć ładunku niebezpiecznego"); return; } //Freight.Weight projektEntities context = new projektEntities(); context.shipping.Add(Shipping); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Shipping.Id.ToString(); updateResources(); }
private void button3_Click(object sender, EventArgs e) { drivers Driver = new drivers { Name = name.Text, Surname = surname.Text, Wage = (int)wage.Value, ADR_License = adr.Checked.ToString(), Employed = true.ToString(), Busy = false.ToString(), Comment = comment.Text }; projektEntities context = new projektEntities(); context.drivers.Add(Driver); context.SaveChanges(); LoadData(); dataGridView.CurrentCell = dataGridView[0, dataGridView.RowCount - 2]; id.Text = Driver.Id.ToString(); }