private void DoSale(object sender, EventArgs e) { DB_Element city = new DB_Element(); Client client = new Client(); Sale sale; if (City_Changed) { city.Value = comBoxCities.Text; city.Id = DB_Sale_Query.AddCity(city.Value); } else { city.Id = ((DB_Element)comBoxCities.SelectedItem).Id; Console.WriteLine("ID::" + city.Id); } if (comBoxClients.SelectedIndex < 0) { client = new Client(comBoxClients.Text, clientPhone.Text, city); client.Id = DB_Sale_Query.AddClient(client); } else { client.Id = ((Client)comBoxClients.SelectedItem).Id; } sale = new Sale(client, new DB_Element(boxVINsale.Text), (DB_Element)comboxPayType.SelectedItem); DB_Sale_Query.AddSale(sale); Update(); }
private new void Update() { DB_Storage = new DB_Storage(); comboxEngineCapacity.DataSource = DB_Storage.GetCapacity(); comboxDoors.DataSource = DB_Storage.GetDoors(); comboxSeats.DataSource = DB_Storage.GetSeats(); comboxModel.DataSource = DB_Storage.Models; comboxCarcase.DataSource = DB_Storage.Carcases; comboxCountry.DataSource = DB_Storage.Countries; comboxBrand.DataSource = DB_Storage.Brands; comboxTypeEngine.DataSource = DB_Storage.Engine_types; comBoxPlace.DataSource = DB_Storage.Engine_places; addModelBrand.DataSource = DB_Storage.Brands; comboxPayType.DataSource = DB_Storage.Payment_types; comBoxCities.DataSource = DB_Storage.Cities; comBoxClients.DataSource = DB_Storage.Clients; //BrandSaleSelect.DataSource = DB_Storage.Brands; TotalSumGridView.DataSource = DB_Sale_Query.GetTotalSum(""); productsView.DataSource = DB_Product_Query.GetAllProducts(); }
private void SalesSearch_TextChanged(object sender, EventArgs e) { brandSaleGridView.DataSource = DB_Sale_Query.GetSales(SalesSearch.Text); }
private void BrandSumSearch_TextChanged(object sender, EventArgs e) { TotalSumGridView.DataSource = DB_Sale_Query.GetTotalSum(BrandSumSearch.Text); }
private void tabTotalSum_Click(object sender, EventArgs e) { TotalSumGridView.DataSource = DB_Sale_Query.GetTotalSum(""); GridAutoSize(TotalSumGridView); }