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