private void ButtonDelete_OnClick(object sender, RoutedEventArgs e) { int x = ListViewData.SelectedIndex; int id = tablesManufacturers[x].intManufacturerID; SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("delete from TablesManufacturer where intManufacturerID=" + id, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); var query = db.TablesManufacturers .Select(s => new { s.intManufacturerID, s.strManufacturerChecklistId, s.strName }).ToList(); foreach (var item in query.ToList()) { TablesManufacturer tb = new TablesManufacturer(); tb.intManufacturerID = item.intManufacturerID; tb.strManufacturerChecklistId = item.strManufacturerChecklistId; tb.strName = item.strName; tablesManufacturers.Add(tb); } ListViewData.ItemsSource = tablesManufacturers; ListViewData.ItemsSource = tablesManufacturers; }
private void DeleteBtn_OnClick(object sender, RoutedEventArgs e) { //var data = db.TablesManufacturer // .Where(w => w.intManufacturerID == int.Parse(intManufacturerIDBox.Text)).ToList(); //TablesManufacturer tm = new TablesManufacturer(); //foreach (var it in data) //{ // tm.intManufacturerID = it.intManufacturerID; // tm.strManufacturerChecklistId = it.strManufacturerChecklistId; // tm.strName = it.strName; //} if (intManufacturerIDBox.Text == "" || strNameBox.Text == "") { MessageBox.Show("Чтобы удалить данные, выберите их из списка!"); } else { TablesManufacturer tt = db.TablesManufacturer.Find(int.Parse(intManufacturerIDBox.Text)); db.TablesManufacturer.Remove(tt); db.SaveChanges(); Clear(); MessageBox.Show("Объекты удалены"); } }
private void lvManuf_SelectionChanged(object sender, SelectionChangedEventArgs e) { TablesManufacturer manuf = (TablesManufacturer)lvManuf.SelectedItem; if (manuf != null) { strManufacturerChecklistId.Text = manuf.strManufacturerChecklistId; strName.Text = manuf.strName; intManufacturerID.Text = manuf.intManufacturerID.ToString(); } }
private void AddBtn_OnClick(object sender, RoutedEventArgs e) { TablesManufacturer tm = new TablesManufacturer(); tm.intManufacturerID = int.Parse(intManufacturerIDBox.Text); tm.strManufacturerChecklistId = strManufacturerChecklistIdBox.Text; tm.strName = strNameBox.Text; db.TablesManufacturer.Add(tm); db.SaveChanges(); Clear(); MessageBox.Show("Объекты добавлены"); }
private void AcceptChangesButtonClick(object sender, RoutedEventArgs e) { try { TablesManufacturer a = (TablesManufacturer)ManufacturesToChangeList.SelectedItem; db.Entry(a).State = EntityState.Modified; db.SaveChanges(); ErrorOrSuccesTextBlockChange.Text = null; ErrorOrSuccesTextBlockChange.Text = "Запись была успешно изменена под именем : " + a.strName + "!"; } catch (Exception ex) { ErrorOrSuccesTextBlockChange.Text = ex.Message; } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { TablesManufacturer manuf = (TablesManufacturer)lvManuf.SelectedItem; if (manuf != null) { db.TablesManufacturer.Remove(manuf); db.SaveChanges(); lvManuf.ItemsSource = db.TablesManufacturer.ToList(); } else { MessageBox.Show("Please select the item you want to delete"); } }
private void btnCreate_Click(object sender, RoutedEventArgs e) { if (strName.Text != "") { TablesManufacturer manuf = new TablesManufacturer(); manuf.strManufacturerChecklistId = strManufacturerChecklistId.Text; //50 chisel manuf.strName = strName.Text; //50 chisel db.TablesManufacturer.Add(manuf); db.SaveChanges(); lvManuf.ItemsSource = db.TablesManufacturer.ToList(); } else { MessageBox.Show("FIll strName"); } }
private void Insert_Click(object sender, RoutedEventArgs e) { try { TablesManufacturer rec = new TablesManufacturer(); rec.strManufacturerChecklistId = strManufacturerChecklistIdTextBox.Text; rec.strName = strNameTextBox.Text; db.TablesManufacturers.Add(rec); db.SaveChanges(); MessageBox.Show("Запись добавлена"); DataListView.ItemsSource = db.TablesManufacturers.ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Update_Click(object sender, RoutedEventArgs e) { TablesManufacturer t = (TablesManufacturer)DataWrapPanel.DataContext; try { db.Entry(t).State = EntityState.Modified; db.SaveChanges(); MessageBox.Show("Изменения сохранены"); DataListView.ItemsSource = db.TablesManufacturers.ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnAddManuf_Click(object sender, RoutedEventArgs e) { TablesManufacturer manuf = new TablesManufacturer(); manuf.strName = tbName.Text; try { db.TablesManufacturer.Add(manuf); db.SaveChanges(); MainWindow.mf.Source = new Uri("View/Page_Manufactures.xaml", UriKind.RelativeOrAbsolute); } catch (Exception ex) { ErrMessage.Content = ex.Message; ErrMessage.Foreground = new SolidColorBrush(Colors.Red); } }
private void EditBtn_OnClick(object sender, RoutedEventArgs e) { if (intManufacturerIDBox.Text == "" || strNameBox.Text == "") { MessageBox.Show("Чтобы изменить данные, выберите их из списка!"); } else { TablesManufacturer tm = new TablesManufacturer(); tm.intManufacturerID = int.Parse(intManufacturerIDBox.Text); tm.strManufacturerChecklistId = strManufacturerChecklistIdBox.Text; tm.strName = strNameBox.Text; db.TablesManufacturer.Add(tm); db.SaveChanges(); Clear(); MessageBox.Show("Объекты изменены"); } }
public MainWindow() { InitializeComponent(); var query = db.TablesManufacturers .Select(s => new { s.intManufacturerID, s.strManufacturerChecklistId, s.strName }).ToList(); foreach (var item in query.ToList()) { TablesManufacturer tb = new TablesManufacturer(); tb.intManufacturerID = item.intManufacturerID; tb.strManufacturerChecklistId = item.strManufacturerChecklistId; tb.strName = item.strName; tablesManufacturers.Add(tb); } ListViewData.ItemsSource = tablesManufacturers; ListViewData2.ItemsSource = tablesManufacturers; }
private void btnUpdate_Click(object sender, RoutedEventArgs e) { if (lvManuf.SelectedIndex >= 0) { TablesManufacturer manuf = (TablesManufacturer)lvManuf.SelectedItem; foreach (var item in db.TablesManufacturer) { if (item.intManufacturerID == manuf.intManufacturerID) { item.strManufacturerChecklistId = strManufacturerChecklistId.Text; item.strName = strName.Text; break; } } db.SaveChanges(); lvManuf.ItemsSource = db.TablesManufacturer.ToList(); } else { MessageBox.Show("Please select the item you want to update"); } }
private void AddButtonClick(object sender, RoutedEventArgs e) { ErrorOrSuccesTextBlockAdd.Text = null; TablesManufacturer a = new TablesManufacturer() { strName = StrNameTextBox.Text, strManufacturerChecklistId = StrManufacturerChecklistIdTextBox.Text }; try { db.TablesManufacturers.Add(a); db.SaveChanges(); ErrorOrSuccesTextBlockAdd.Text = "Был добавлен елемент под именем - " + a.strName; ManufacturesToaddList.ItemsSource = null; ManufacturesToaddList.ItemsSource = db.TablesManufacturers.ToList(); } catch (Exception ex) { ErrorOrSuccesTextBlockAdd.Text = ex.Message; } }