private void Form1_Load(object sender, EventArgs e) { CboFiles.DisplayMember = nameof(ItemData.Name); CboFiles.ValueMember = nameof(ItemData.Id); CboWorkSheets.DisplayMember = nameof(ItemData.Name); CboWorkSheets.ValueMember = nameof(ItemData.Id); List <ItemData> workbooks = Workbook_BLL.Workbooks().Select(kvp => new ItemData { Id = kvp.Key, Name = kvp.Value }).ToList(); CboFiles.DataSource = workbooks; }
private void Delete(bool confirm) { WaitingMessage.WaitingMessage waitingMessage = null; try { if (confirm && MessageBox.Show("Are you sure you want to DEFINITIVELY delete the opened workbook?", "Delete a workbook", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } waitingMessage = new WaitingMessage.WaitingMessage("Please wait while data are being erased from the database." + Environment.NewLine + "This may take few seconds...", "Delete a workbook", 0); if (!Workbook_BLL.Delete(OpenedFile.Id)) { return; } CboFiles.DataSource = GetWorkbooks(); UnloadWorkBook(); } catch (Exception ex) { ErrorManagement.Log(ex); } finally { if (waitingMessage != null) { waitingMessage.CloseMessage(); } } }
public bool Save() { if (WorkbookRow == null) { Id = Workbook_BLL.Create(Name, Created, Modified); WorkbookRow = WorkBook_DAL.GetDataRow(Id); Imported = WorkbookRow.Imported; } foreach (string wsName in WorkSheets.Keys) { WorkSheet worksheet = WorkSheets[wsName]; worksheet.Save(Id); // Delete all worksheets those are empty if (worksheet.Cells.Count == 0) { WorkSheets.Remove(wsName); } } return(Id != Constants.Constants.UNDEFINED_ID); }