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