private void DeleteFitment_Button_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Do you want to delete selected fitments?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { using (var db = new ProductDBEntitie()) { DataGridRow row = (DataGridRow)(DataTable.ItemContainerGenerator.ContainerFromItem(DataTable.SelectedItem)); DataGridDetailsPresenter presenter = FindVisualChild <DataGridDetailsPresenter>(row); DataTemplate template = presenter.ContentTemplate; DataGrid dg = (DataGrid)template.FindName("datagridf", presenter); DataGridCheckBoxColumn cb = (DataGridCheckBoxColumn)template.FindName("NOf", presenter); List <int> deleteFitment = new List <int>(); foreach (Fitment f in dg.ItemsSource) { try { if (((CheckBox)cb.GetCellContent(f)).IsChecked == true) { deleteFitment.Add(f.id); Fitment fitment = (from c in db.Fitment where c.id == f.id select c).FirstOrDefault(); if (fitment != null) { db.Fitment.Remove(fitment); db.SaveChanges(); } } } catch { } } new ReadFitmentsDB(dg, statusBar); } } }
private void readFirments_DoWork(object sender, DoWorkEventArgs e) { using (var db = new ProductDBEntitie()) { fitment = (from c in db.Fitment where c.sku == str orderby c.sku select c).Skip(i * j++).Take(i).FirstOrDefault(); if (fitment != null) { fitment.Make = (from c in db.Make where c.id == fitment.id_make select c).FirstOrDefault(); fitment.BrandName = (from c in db.BrandName where c.id == fitment.id_brand_name select c).FirstOrDefault(); } } }
private void init_fitment() { fitment = new Fitment(); Make make = new Make(); string[] values = lines[i].Split('|'); for (int j = 0; j < values.Count(); j++) { if (headers[j] == "Make") { make.make1 = values[j]; } else if (headers[j] == "Model") { make.model = values[j]; } else if (headers[j] == "ourMake") { make.our_make = values[j]; } else if (headers[j] == "ourMake") { make.our_make = values[j]; } else if (headers[j] == "ourModel") { make.our_model = values[j]; } else if (headers[j] == "_BodyTypeName_") { make.body_type_name = values[j]; } else if (headers[j] == "_MfrBodyCodeName_") { make.mf_body_code_name = values[j]; } else if (headers[j] == "ourBodyTypeName") { make.our_body_type_name = values[j]; } else { try { fitment.init_fitment(headers[j], values[j]); } catch { } } } using (var db = new ProductDBEntitie()) { try { var make_ = (from c in db.Make where c.make1 == make.make1 && c.model == make.model && c.our_make == make.our_make && c.body_type_name == make.body_type_name select c).ToList(); if (make_.Count() == 0) { db.Make.Add(make); db.SaveChanges(); fitment.id_make = make.id; fitment.Make = make; } else { fitment.id_make = make_.First().id; fitment.Make = make_.First(); } } catch { } fitment.Product = (from c in db.Product where c.sku == fitment.sku select c).FirstOrDefault(); try { BrandName brand = fitment.BrandName; fitment.BrandName = null; Make m = fitment.Make; fitment.Make = null; db.Fitment.Add(fitment); db.SaveChanges(); fitment.Make = m; fitment.BrandName = brand; } catch (Exception e) { } } }
private void datagridf_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { DataGridRow row = (DataGridRow)(DataTable.ItemContainerGenerator.ContainerFromItem(DataTable.SelectedItem)); DataGridDetailsPresenter presenter = FindVisualChild <DataGridDetailsPresenter>(row); DataTemplate template = presenter.ContentTemplate; DataGrid dg = (DataGrid)template.FindName("datagridf", presenter); ObservableCollection <Fitment> fitments = new ObservableCollection <Fitment>(); foreach (Fitment c in dg.ItemsSource) { fitments.Add(c); } TextBox t = e.EditingElement as TextBox; String value = t.Text.ToString(); String header = e.Column.Header.ToString().ToUpper().Replace(" ", ""); var id = (e.Row.DataContext as Fitment).id; if (id == 0) { using (var db = new ProductDBEntitie()) { Fitment f = new Fitment(); f.sku = (DataTable.SelectedItem as Product).sku; db.Fitment.Add(f); db.SaveChanges(); fitments.Add(f); id = f.id; } } //mAKE using (var db = new ProductDBEntitie()) { var fitment = (from c in db.Fitment where c.id == id select c).FirstOrDefault(); var make = (from c in db.Make where fitment.id_make == c.id select c).FirstOrDefault(); if (make == null) { make = new Make(); db.Make.Add(make); db.SaveChanges(); fitment.id_make = make.id; db.SaveChanges(); } if (header == "MAKE") { make.make1 = value; } else if (header == "MODEL") { make.model = value; } else if (header == "OURMAKE") { make.our_make = value; } else if (header == "OURMODEL") { make.our_model = value; } else if (header == "BODYTYPENAME") { make.body_type_name = value; } else if (header == "_MFRBODYCODENAME_") { make.mf_body_code_name = value; } else if (header == "OURBODYTYPENAME") { make.our_body_type_name = value; } else { try { fitment.init_fitment(header, t.Text.ToString()); } catch (Exception ee) { MessageBox.Show(ee.Message); } } db.SaveChanges(); } }