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;
}
