public AddSKU(SKU s) { //конструктор в параметрах приходит товар для изменения InitializeComponent(); ADD.Visibility = Visibility.Hidden; Save.Visibility = Visibility.Visible; sk = s; MContext mc = new MContext(); sa = mc.SAs.First(x => x.ID == sk.ID); BitmapImage bi = new BitmapImage(new Uri("D:\\logo.ico")); this.Icon = bi; this.Title = "Изменить товар"; SetSKU(s, sa); List <Category> lc = mc.Categories.ToList(); CBCategory.ItemsSource = lc; int i = 0; foreach (Category c in CBCategory.ItemsSource) { Subcategory sub = mc.Subcategories.First(x => x.ID == s.ID_Subcategory); if (c.Name == sub.Category.Name) { break; } i++; } CBCategory.SelectedIndex = i; i = 0; foreach (Subcategory sc in CBSubcategory.ItemsSource) { if (sc.ID == s.ID_Subcategory) { break; } i++; } CBSubcategory.SelectedIndex = i; i = 0; foreach (Brend b in CBBrend.ItemsSource) { if (b.ID == s.ID_Brend) { break; } i++; } CBBrend.SelectedIndex = i; }
private void ADD_Click(object sender, RoutedEventArgs e) { try { //по нажатию кнопки добавляеися товар MContext mc = new MContext(); Brend b = CBBrend.SelectedItem as Brend; Subcategory s = CBSubcategory.SelectedItem as Subcategory; SKU sku = new SKU() { ID_Brend = b.ID, ID_Subcategory = s.ID, Enable = true, idAllo = Allo.Text, idComfy = Comfy.Text, idEldorado = Eldorado.Text, idRozetka = Rozetka.Text, InputPrice = double.Parse(TBInputPrice.Text), Name = TBTitle.Text, Price = int.Parse(TBPrice.Text), UrlHotline = Hotline.Text }; mc.SKUs.Add(sku); mc.SaveChanges(); SkuAnot sa = new SkuAnot() { ID = sku.ID, Val1 = Value1.Text, Val2 = Value2.Text, Val3 = Value3.Text, Val4 = Value4.Text, Val5 = Value5.Text, Val6 = Value6.Text, Val7 = Value7.Text, Val8 = Value8.Text, Val9 = Value9.Text, Val10 = Value10.Text, Val11 = Value11.Text, Val12 = Value12.Text }; mc.SAs.Add(sa); mc.SaveChanges(); MessageBox.Show("Товар успешно добавлен"); this.Close(); } catch { MessageBox.Show("Неверно заполнено поле"); } }
public AddSKU(SKU s, SkuAnot sa) { //конструктор в параметрах приходит товар и аннотация InitializeComponent(); MContext mc = new MContext(); //инициализируем комобобокс категориями List <Category> lc = mc.Categories.ToList(); CBCategory.ItemsSource = lc; BitmapImage bi = new BitmapImage(new Uri("D:\\logo.ico")); this.Icon = bi; //вызываем метод устонавливающий товары SetSKU(s, sa); }
private void DGS_MouseDoubleClick(object sender, MouseButtonEventArgs e) { try { MyGridMainMenu s = DGS.SelectedItem as MyGridMainMenu; MContext mc = new MContext(); InfoSKU isku = new InfoSKU(mc.SKUs.First(x => x.ID == s.ID)); isku.ShowDialog(); } catch { SkuAnot s = DGS.SelectedItem as SkuAnot; MContext mc = new MContext(); EnterID isku = new EnterID(mc.SAs.First(x => x.ID == s.ID).ID); } }
private void Save_Click(object sender, RoutedEventArgs e) { try { MContext mc = new MContext(); Brend b = CBBrend.SelectedItem as Brend; Subcategory s = CBSubcategory.SelectedItem as Subcategory; SKU savesku = mc.SKUs.First(x => x.ID == sk.ID); savesku.ID_Brend = b.ID; savesku.ID_Subcategory = s.ID; savesku.Enable = true; savesku.idAllo = Allo.Text; savesku.idComfy = Comfy.Text; savesku.idEldorado = Eldorado.Text; savesku.idRozetka = Rozetka.Text; savesku.InputPrice = double.Parse(TBInputPrice.Text); savesku.Name = TBTitle.Text; savesku.Price = int.Parse(TBPrice.Text); savesku.UrlHotline = Hotline.Text; mc.SaveChanges(); SkuAnot sa = mc.SAs.First(x => x.ID == savesku.ID); sa.Val1 = Value1.Text; sa.Val2 = Value2.Text; sa.Val3 = Value3.Text; sa.Val4 = Value4.Text; sa.Val5 = Value5.Text; sa.Val6 = Value6.Text; sa.Val7 = Value7.Text; sa.Val8 = Value8.Text; sa.Val9 = Value9.Text; sa.Val10 = Value10.Text; sa.Val11 = Value11.Text; sa.Val12 = Value12.Text; mc.SaveChanges(); MessageBox.Show("Товар успешно изменен"); this.Close(); } catch { MessageBox.Show("Неверно заполнено поле"); } }
void SetSKU(SKU s, SkuAnot sa) { //установка данных из файла Allo.Text = s.idAllo; Comfy.Text = s.idComfy; Eldorado.Text = s.idEldorado; Rozetka.Text = s.idRozetka; TBInputPrice.Text = string.Format("{0}", s.InputPrice); TBTitle.Text = s.Name; TBPrice.Text = string.Format("{0}", s.Price); Hotline.Text = s.UrlHotline; Value1.Text = sa.Val1; Value2.Text = sa.Val2; Value3.Text = sa.Val3; Value4.Text = sa.Val4; Value5.Text = sa.Val5; Value6.Text = sa.Val6; Value7.Text = sa.Val7; Value8.Text = sa.Val8; Value9.Text = sa.Val9; Value10.Text = sa.Val10; Value11.Text = sa.Val11; Value12.Text = sa.Val12; }
private void MI15_Click(object sender, RoutedEventArgs e) { System.Windows.Forms.OpenFileDialog ofd = new System.Windows.Forms.OpenFileDialog(); ofd.Filter = "CSV files (*.csv)|*.csv"; if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { List <SKU> ls = new List <SKU>(); List <SkuAnot> lskuan = new List <SkuAnot>(); string content; using (StreamReader sr = new StreamReader(ofd.FileName)) { while ((content = sr.ReadLine()) != null) { string[] mas = content.Split(';'); SKU s = new SKU(); SkuAnot sa = new SkuAnot(); for (int i = 0; i < mas.Length; i++) { switch (i) { case 0: s.Name = mas[i]; break; case 1: s.InputPrice = double.Parse(mas[i]); break; case 2: if (mas[i] != string.Empty) { s.Price = int.Parse(mas[i]); } else { s.Price = 0; } break; case 3: s.idComfy = mas[i]; break; case 4: s.idRozetka = mas[i]; break; case 5: s.idAllo = mas[i]; break; case 6: s.idEldorado = mas[i]; break; case 7: s.UrlHotline = mas[i]; break; case 8: sa.Val1 = mas[i]; break; case 9: sa.Val2 = mas[i]; break; case 10: sa.Val3 = mas[i]; break; case 11: sa.Val4 = mas[i]; break; case 12: sa.Val5 = mas[i]; break; case 13: sa.Val6 = mas[i]; break; case 14: sa.Val7 = mas[i]; break; case 15: sa.Val8 = mas[i]; break; case 16: sa.Val9 = mas[i]; break; case 17: sa.Val10 = mas[i]; break; case 18: sa.Val11 = mas[i]; break; case 19: sa.Val12 = mas[i]; break; } } ls.Add(s); lskuan.Add(sa); } } int j = 0; foreach (SKU s in ls) { AddSKU asku = new AddSKU(s, lskuan[j]); this.Visibility = Visibility.Hidden; asku.ShowDialog(); this.Visibility = Visibility.Visible; j++; } } }