private void updateButton_Click(object sender, RoutedEventArgs e)
{
var customer = db.Customers.Find(_data.Tel);
customer.Customer_Name = customerNameTextBox.Text;
customer.Email = customerEmailTextBox.Text;
customer.Address = customerAddressTextBox.Text;
db.SaveChanges();
dynamic item = purchaseStatusComboBox.SelectedItem;
var purchase = db.Purchases.Find(_data.Purchase_ID);
purchase.Status = item.Value;
db.SaveChanges();
DialogResult = true;
}
private void deleteProduct(object sender, RoutedEventArgs e)
{
if (getId != -1)
{
var db = new MyShopEntities();
var products = db.Products.ToList();
var photos = db.Photos.ToList();
var qProduct = products.FirstOrDefault(i => i.Product_ID == getId);
var qPhoto = photos.FirstOrDefault(i => i.Product_id == getId);
db.Photos.Remove(qPhoto);
db.SaveChanges();
db.Products.Remove(qProduct);
db.SaveChanges();
CalculatePagingInfo();
UpdateProductView();
}
}
private void addProductButton_Click(object sender, RoutedEventArgs e)
{
if (_filename == "")
{
MessageBox.Show("Không được để trống hình ảnh");
return;
}
try
{
var db = new MyShopEntities();
NewProductInfo = new Product()
{
Product_Name = productNameTextbox.Text.ToString(),
Price = int.Parse(productPriceTextbox.Text.ToString().Replace(",", "")),
Quantity = int.Parse(productQuantityTextbox.Text.ToString())
};
var _selectedCategoryIndex = productCategoryComboBox.SelectedIndex;
db.Categories.ToList()[_selectedCategoryIndex].Products.Add(NewProductInfo);
db.SaveChanges();
var image = new BitmapImage(new Uri(_filename, UriKind.Absolute));
var encoder = new JpegBitmapEncoder();
encoder.Frames.Add(BitmapFrame.Create(image));
using (var stream = new MemoryStream())
{
encoder.Save(stream);
var photo = new Photo()
{
Product_id = NewProductInfo.Product_ID,
Data = stream.ToArray()
};
db.Photos.Add(photo);
db.SaveChanges();
}
DialogResult = true;
}
catch
{
MessageBox.Show("Không được để trống thông tin");
return;
}
}
private void editButton_Click(object sender, RoutedEventArgs e)
{
var db = new MyShopEntities();
var product = db.Products.Find(_data.Product_ID);
try
{
if (!string.IsNullOrEmpty(_filename))
{
product.Product_Name = productNameTextbox.Text.ToString();
product.Price = int.Parse(productPriceTextbox.Text.ToString().Replace(",", ""));
product.Quantity = int.Parse(productQuantityTextbox.Text.ToString());
db.SaveChanges();
var image = new BitmapImage(new Uri(_filename, UriKind.Absolute));
var encoder = new JpegBitmapEncoder();
encoder.Frames.Add(BitmapFrame.Create(image));
var photo = db.Photos.Find(_photo.Photo_id);
using (var stream = new MemoryStream())
{
encoder.Save(stream);
photo.Data = stream.ToArray();
db.SaveChanges();
}
DialogResult = true;
}
else
{
product.Product_Name = productNameTextbox.Text.ToString();
product.Price = int.Parse(productPriceTextbox.Text.ToString().Replace(",", ""));
product.Quantity = int.Parse(productQuantityTextbox.Text.ToString());
db.SaveChanges();
DialogResult = true;
}
}
catch
{
MessageBox.Show("Không được để trống thông tin");
return;
}
}
private void editCategoryButton_Click(object sender, RoutedEventArgs e)
{
var db = new MyShopEntities();
var category = db.Categories.Find(_data.Category_ID);
if (!string.IsNullOrEmpty(categoryTextbox.Text.ToString()))
{
category.Category_Name = categoryTextbox.Text.ToString().ToUpper();
db.SaveChanges();
}
DialogResult = true;
}
private void addCategoryButton_Click(object sender, RoutedEventArgs e)
{
var db = new MyShopEntities();
var NewCategoryInfo = new Category()
{
Category_Name = categoryTextbox.Text.ToString().ToUpper(),
};
db.Categories.Add(NewCategoryInfo);
db.SaveChanges();
DialogResult = true;
}
private void deletePurchase_MenuItem_Click(object sender, RoutedEventArgs e)
{
dynamic item = purchaseDataGrid.SelectedItem;
var oderDetail = db.PurchaseDetails.ToList().FindAll(i => i.Purchase_ID == item.Purchase_ID);
var purchase = db.Purchases.Find(item.Purchase_ID);
var customer = db.Customers.Find(item.Tel);
foreach (var o in oderDetail)
{
db.PurchaseDetails.Remove(o);
db.SaveChanges();
}
db.Purchases.Remove(purchase);
db.Customers.Remove(customer);
db.SaveChanges();
// Reload giao dien
loadAllPurchases();
// Thong bao phan hoi
MessageBox.Show("Đơn hàng đã được xóa thành công!");
purchaseStackPanel.Visibility = Visibility.Collapsed;
}
private void deleteCategory(object sender, RoutedEventArgs e)
{
var db = new MyShopEntities();
var _selectedCategoryIndex = categoriesComboBox.SelectedIndex;
var c = _categories[_selectedCategoryIndex];
var categories = db.Categories.ToList();
var qCategory = categories.FirstOrDefault(i => i.Category_ID == c.Category_ID);
var products = db.Products.ToList();
var qProduct = products.FindAll(i => i.Catgory_ID == c.Category_ID);
var photos = db.Photos.ToList();
foreach (var p in qProduct)
{
var qPhoto = photos.FirstOrDefault(i => i.Product_id == p.Product_ID);
db.Photos.Remove(qPhoto);
db.SaveChanges();
db.Products.Remove(p);
db.SaveChanges();
}
db.Categories.Remove(qCategory);
db.SaveChanges();
Refresh();
}
private void confirmButton_Click(object sender, RoutedEventArgs e)
{
try {
var purchase = new Purchase()
{
Created_At = DateTime.Now,
Total = list.Sum((dynamic p) => Convert.ToInt32(p.SubTotal)),
Customer_Tel = customerTelTextBox.Text,
Status = 1,
};
var customer = new Customer()
{
Tel = customerTelTextBox.Text,
Customer_Name = customerNameTextBox.Text,
Address = customerAddressTextBox.Text,
Email = customerEmailTextBox.Text
};
foreach (dynamic item in list)
{
var orderDetail = new PurchaseDetail()
{
Product_ID = item.Product_ID,
Price = item.Unit_Price,
Quantity = item.Quantity,
Total = item.SubTotal
};
purchase.PurchaseDetails.Add(orderDetail);
db.PurchaseDetails.Add(orderDetail);
}
db.Customers.Add(customer);
db.Purchases.Add(purchase);
db.SaveChanges();
MessageBox.Show("Thêm đơn hàng mới thành công!");
DialogResult = true;
}
catch
{
MessageBox.Show("Không Được Để Trống Thông Tin!");
return;
}
}
private void importExecl_Click(object sender, RoutedEventArgs e)
{
var screen = new OpenFileDialog();
if (screen.ShowDialog() == true)
{
var filename = screen.FileName;
var fileinfo = new FileInfo(filename);
var excelFile = new Workbook(filename);
var tabs = excelFile.Worksheets;
var db = new MyShopEntities();
foreach (var tab in tabs)
{
var category = new Category()
{
Category_Name = tab.Name
};
db.Categories.Add(category);
db.SaveChanges();
var row = 3;
var cell = tab.Cells[$"C3"];
while (cell.Value != null)
{
var product = new Product()
{
//SKU = tab.Cells[$"C{row}"].StringValue,
Product_Name = tab.Cells[$"D{row}"].StringValue,
Price = tab.Cells[$"E{row}"].IntValue,
Quantity = tab.Cells[$"F{row}"].IntValue
};
category.Products.Add(product);
db.SaveChanges();
var imageName = tab.Cells[$"H{row}"].StringValue;
var imageFull = $"{fileinfo.Directory}\\images\\{imageName}";
var image = new BitmapImage(new Uri(imageFull, UriKind.Absolute));
var encoder = new JpegBitmapEncoder();
encoder.Frames.Add(BitmapFrame.Create(image));
using (var stream = new MemoryStream())
{
encoder.Save(stream);
var photo = new Photo()
{
Product_id = product.Product_ID,
Data = stream.ToArray()
};
db.Photos.Add(photo);
db.SaveChanges();
}
row++;
cell = tab.Cells[$"C{row}"];
}
}
MessageBox.Show("Data Imported");
UserControl_Initialized(sender, e);
}
}
