private void Update_button_Click_1(object sender, RoutedEventArgs e) { dataAdapter.Update(dataSet.Tables[0]); switch (Singleton.getInstance().Filtr) { case 1: { dataAdapter = new SqlDataAdapter("Select * from ViewAll", connect); break; } case 2: { dataAdapter = new SqlDataAdapter("Select * from ViewMain", connect); break; } case 3: { dataAdapter = new SqlDataAdapter("Select * from ViewNoAcc", connect); break; } default: { dataAdapter = new SqlDataAdapter("Select * from ViewMain", connect); break; } } dataSet = new DataSet(); dataAdapter.Fill(dataSet); dataGridAccount.ItemsSource = dataSet.Tables[0].DefaultView; }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { if (ButtonAdd.Content.ToString() == "Добавить" && DateOff.Visibility == Visibility.Hidden) { //dataAd.Update(DSet.Tables[0]); string Query = String.Format("INSERT INTO Accounts (Service_Id, Instrument_Id, Srvicemn_Id, " + "AccountingDate, DecisionOprtn, " + "SerialNumber,InventoryNumber,Condition,AddirionalInf) " + "values ({0},{1},{2},'{3}',N'{4}',N'{5}',N'{6}',N'{7}',N'{8}')", this.servicesRepository.GetServiceId(Services.Text), this.InstrumentRepository.GetInstrumentId(Instrument.Text), Singleton.getInstance().IdServicemen, DateOn.DisplayDate, decisionOprtn.Text, serialN.Text, inventoryN.Text, condition.Text, AddInf.Text); dataAd = new SqlDataAdapter(Query, con); DSet = new DataSet(); dataAd.Fill(DSet); /* instruments.Description = Descript.ToString(); * instruments.YearIssue = yearissue.ToString(); * account.AccountingDate = DateOn.DisplayDate; * account.Date_ofderegistration = DateOff.DisplayDate; * account.DecisionOprtn = decisionOprtn.Text; * account.SerialNumber = serialN.Text; * account.InventoryNumber = inventoryN.Text; * account.Condition = condition.Text; * account.AddirionalInf = AddInf.Text;*/ } else { string Query = String.Format("INSERT INTO Accounts (Service_Id, Instrument_Id, Srvicemn_Id, " + "AccountingDate, Date_ofderegistration, DecisionOprtn, " + "SerialNumber,InventoryNumber,Condition,AddirionalInf) " + "values ({0},{1},{2},'{3}','{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}')", this.servicesRepository.GetServiceId(Services.Text), this.InstrumentRepository.GetInstrumentId(Instrument.Text), Singleton.getInstance().IdServicemen, DateOn.DisplayDate, DateOff.DisplayDate, decisionOprtn.Text, serialN.Text, inventoryN.Text, condition.Text, AddInf.Text); dataAd = new SqlDataAdapter(Query, con); DSet = new DataSet(); dataAd.Fill(DSet); // var a=mainWindow.dataGridAccount.Cells } //accountsRepository.SaveAccount(account); Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { Singleton.getInstance().Filtr = N; Close(); }
private void SaveButton_Click_1(object sender, RoutedEventArgs e) { temp = srvicemnRepository.GetServicemen(comboBoxServicemen.Text); Singleton.getInstance().IdServicemen = temp; Close(); }