private void updateDGVDataSource() { string query = "SELECT Purchases.ID,Purchases.Efficiency, Purchases.Provider, Purchases.DeliveryDate,Purchases.GuaranteePeriod,Purchases.PurchaseAmount " + "FROM(Accessories INNER JOIN Purchases ON Accessories.Purchase_ID = Purchases.ID) " + "WHERE(Purchases.ID = " + PurchasesModel.id.ToString() + ")"; purchaseDataGridView.DataSource = DGVDataSourceChanger.getNewDGVDataSource(query); purchaseDataGridView.Update(); }
public void updateInputs() { NameTextBox.Text = ProvidersModel.name; telephoneTextBox.Text = ProvidersModel.telephone; adressComboBox.SelectedIndex = adressComboBox.FindString(Convert.ToString(locationTableAdapter.GetData().FirstOrDefault(u => u.ID == ProvidersModel.adress).ID)); string query = "SELECT Purchases.ID,Purchases.Provider, Purchases.DeliveryDate,Purchases.GuaranteePeriod,Purchases.PurchaseAmount " + "FROM(Provider INNER JOIN Purchases ON Provider.ID = Purchases.Provider) " + "WHERE(Provider.ID = " + ProvidersModel.id.ToString() + ")"; purchasesDataGridView.DataSource = DGVDataSourceChanger.getNewDGVDataSource(query); }
public void updateInputs() { startDateTimePicker.Value = RepairModel.startDate; endDateTimePicker.Value = RepairModel.endDate; NeedToWriteOff.Checked = RepairModel.needToWriteOff; costNumericUpDown.Value = RepairModel.cost; string query = "SELECT Computer.ID, Computer.OperatingSystem, Computer.Cost, Computer.LifeTime, Computer.MaxLifeTime " + "FROM(Computer INNER JOIN Repair ON Computer.Repair_ID = Repair.ID) " + "WHERE(Repair.ID = " + RepairModel.id.ToString() + ")"; computerDataGridView.DataSource = DGVDataSourceChanger.getNewDGVDataSource(query); }
public void updateInputs() { ViewTextBox.Text = AccessoriesModel.view; costNumericUpDown.Value = AccessoriesModel.cost; purchaseComboBox.SelectedIndex = purchaseComboBox.FindString(Convert.ToString(purchasesTableAdapter3.GetData().FirstOrDefault(u => u.ID == AccessoriesModel.purchase).ID)); string query = "SELECT Purchases.ID,Purchases.Provider, Purchases.DeliveryDate,Purchases.GuaranteePeriod,Purchases.PurchaseAmount " + "FROM(Accessories INNER JOIN Purchases ON Accessories.Purchase_ID = Purchases.ID) " + "WHERE(Accessories.ID = " + AccessoriesModel.id.ToString() + ")"; PurchaseDataGridView.DataSource = DGVDataSourceChanger.getNewDGVDataSource(query); changePurchaseButton.Enabled = true; }