private async void addCat_Click(object sender, RoutedEventArgs e) { TextBox input = new TextBox() { Height = (double)App.Current.Resources["TextControlThemeMinHeight"], PlaceholderText = "Display Text" }; ContentDialog dialog = new ContentDialog() { Title = "Change Category's Name", MaxWidth = this.ActualWidth, PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", Content = input }; ContentDialogResult result = await dialog.ShowAsync(); if (result == ContentDialogResult.Primary) { input = (TextBox)dialog.Content; if (input.Text != "") { var cat = new Category() { Name = input.Text }; QueryForSQLServer.InsertCategory(cat); await new Windows.UI.Popups.MessageDialog("Success!").ShowAsync(); Refresh(); } else { await new Windows.UI.Popups.MessageDialog("Noting change!").ShowAsync(); } } }
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); } }