private async void btnDone_Click(object sender, RoutedEventArgs e) { var messageDialog = new MessageDialog("Add new produt", "Confirm"); messageDialog.Commands.Add(new UICommand("Yes") { Id = 0 }); messageDialog.Commands.Add(new UICommand("No") { Id = 1 }); messageDialog.DefaultCommandIndex = 0; messageDialog.CancelCommandIndex = 1; var result = await messageDialog.ShowAsync(); if ((int)result.Id == 0) { Product.Price = Decimal.Parse(addGia.Text); Product.Quantity = int.Parse(addSoLuong.Text); var productid = QueryForSQLServer.InsertProduct(Product); int id = 1; foreach (var item in Product.Product_Images) { item.id = id; item.ProductId = productid; QueryForSQLServer.InsertProduct_Image(item); id++; } Frame.GoBack(); } else { Frame.GoBack(); } }
private async void ImportButton_Click(object sender, RoutedEventArgs e) { try { ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; //Instantiates the File Picker. FileOpenPicker openPicker = new FileOpenPicker(); openPicker.SuggestedStartLocation = PickerLocationId.Desktop; openPicker.FileTypeFilter.Add(".xlsx"); openPicker.FileTypeFilter.Add(".xls"); StorageFile openFile = await openPicker.PickSingleFileAsync(); //Opens the workbook. IWorkbook workbook = await application.Workbooks.OpenAsync(openFile); //Access first worksheet from the workbook. var tabs = workbook.Worksheets; //Set Text in cell A3. //Sets workbook version. workbook.Version = ExcelVersion.Excel2016; //Initializes FileSavePicker. FileSavePicker savePicker = new FileSavePicker(); List <Category> list = new List <Category>(); foreach (var tab in tabs) { Debug.WriteLine(tab.Name); var row = 3; var category = new Category() { Name = tab.Name }; category.Id = QueryForSQLServer.InsertCategory(category); tab.UsedRangeIncludesFormatting = false; var cell = tab.Range[$"C3"]; while (cell.Value != null && !cell.IsBlank) { var author = tab.Range[$"J{row}"].Text; var name = tab.Range[$"C{row}"].Text; var price = Convert.ToDecimal(tab.Range[$"D{row}"].Number); var quantity = (int)(tab.Range[$"E{row}"].Number); var description = tab.Range[$"F{row}"].Text; var image = tab.Range[$"I{row}"].Text; var product = new Product() { Author = author, Name = name, CatId = category.Id, Price = price, Quantity = quantity, Description = description, Image = image }; category.Products.Add(product); Debug.WriteLine($"{author}{name}{price}{quantity}{description}"); // Đi qua dòng kế row++; cell = tab.Range[$"C{row}"]; } list.Add(category); } var tes = list; workbook.Close(); excelEngine.Dispose(); var messageDialog = new MessageDialog("Import", "Confirm"); messageDialog.Commands.Add(new UICommand("Yes") { Id = 0 }); messageDialog.Commands.Add(new UICommand("No") { Id = 1 }); messageDialog.DefaultCommandIndex = 0; messageDialog.CancelCommandIndex = 1; var result = await messageDialog.ShowAsync(); if ((int)result.Id == 0) { foreach (var cat in list) { cat.Id = QueryForSQLServer.InsertCategory(cat); foreach (var product in cat.Products) { var index = QueryForSQLServer.InsertProduct(product); } } var messageDialog2 = await new MessageDialog("Success", "Confirm").ShowAsync(); } else { } } catch (Exception ex) { Debug.WriteLine("Exception: " + ex.Message); } }