internal static void DeleteSelectedRows(CsvEditor form, List <int> selectedRows)
{
DataGridView csvGridView = form.csvGridView;
AddUndo(form);
if (csvGridView.SelectedRows.Count > 0)
{
foreach (DataGridViewRow selectedRow in csvGridView.SelectedRows)
{
if (!selectedRow.IsNewRow)
{
csvGridView.Rows.RemoveAt(selectedRow.Index);
}
}
}
else if (selectedRows.Count > 0)
{
selectedRows.Sort();
int[] selectedRowsCopy = new int[selectedRows.Count];
selectedRows.CopyTo(selectedRowsCopy);
for (int i = selectedRowsCopy.Length - 1; i >= 0; i--)
{
csvGridView.Rows.RemoveAt(selectedRowsCopy[i]);
}
}
}
internal static void AddNewColumn(CsvEditor form)
{
DataGridView csvGridView = form.csvGridView;
ToolStripTextBox addNewColumnToolStripTextBox = form.addNewColumnToolStripTextBox;
AddUndo(form);
form.addingNewColumn = true;
if (addNewColumnToolStripTextBox.Enabled)
{
((DataTable)csvGridView.DataSource).Columns.Add(addNewColumnToolStripTextBox.Text, typeof(String));
//csvGridView.Columns.Add(addNewColumnToolStripTextBox.Text, addNewColumnToolStripTextBox.Text);
}
else
{
String columnName = String.Format(LanguageUtil.GetCurrentLanguageString("StandardColumnLabel", className), csvGridView.Columns.Count + 1);
((DataTable)csvGridView.DataSource).Columns.Add(columnName, typeof(String));
//csvGridView.Columns.Add(columnName, columnName);
}
csvGridView.CurrentCell = csvGridView.Rows[0].Cells[csvGridView.Columns.Count - 1];
SelectColumns(form, csvGridView.CurrentCell);
form.addingNewColumn = false;
}
internal static void ClearUndo(CsvEditor form)
{
Button applyButton = form.applyButton;
ToolStripSplitButton undoToolStripSplitButton = form.undoToolStripSplitButton;
ToolStripMenuItem undoToolStripMenuItem = form.undoToolStripMenuItem;
form.undoHistory.Clear();
undoToolStripSplitButton.Enabled = false;
undoToolStripMenuItem.Enabled = false;
applyButton.Enabled = false;
}
internal static void ReadCsv(CsvEditor form, bool withHeader, char delimiter, char quote)
{
Form1 form1 = (Form1)form.Owner;
XtraTabControl pagesTabControl = form1.pagesTabControl;
DataGridView csvGridView = form.csvGridView;
//ContextMenuStrip contentContextMenuStrip = form.contentContextMenuStrip;
Encoding textEncoding = EncodingUtil.GetDefaultEncoding();
String text = String.Empty;
if (pagesTabControl != null)
{
textEncoding = TabUtil.GetTabTextEncoding(pagesTabControl.SelectedTabPage);
text = ProgramUtil.GetPageTextBox(pagesTabControl.SelectedTabPage).Text;
}
byte[] byteArray = textEncoding.GetBytes(text);
using (MemoryStream stream = new MemoryStream(byteArray))
{
try
{
using (CachedCsvReader csv = new CachedCsvReader(new StreamReader(stream), withHeader, delimiter, quote, '\\', '#', ValueTrimmingOptions.UnquotedOnly))
{
csv.DefaultParseErrorAction = ParseErrorAction.AdvanceToNextLine;
csv.SkipEmptyLines = true;
if (String.IsNullOrEmpty(csv[0, 0]))
{
WindowManager.ShowAlertBox(form, LanguageUtil.GetCurrentLanguageString("NoResults", className));
}
//PutCsvReaderIntoDataGrid(csv, csvGridView);
csvGridView.Columns.Clear();
csvGridView.DataSource = ConvertCsvReaderToDataTable(csv);
}
//for (int i = 0; i < csvGridView.Rows.Count; i++)
//{
// for (int j = 0; j < csvGridView.Rows[i].Cells.Count; j++)
// {
// csvGridView.Rows[i].Cells[j].ContextMenuStrip = contentContextMenuStrip;
// }
//}
}
catch (Exception exception)
{
WindowManager.ShowErrorBox(form, LanguageUtil.GetCurrentLanguageString("ContentError", className), exception);
}
}
csvGridView.Refresh();
}
private static void SelectColumns(CsvEditor form, DataGridViewCell cell)
{
DataGridView csvGridView = form.csvGridView;
ToolStripButton deleteSelectedColumnsToolStripButton = form.deleteSelectedColumnsToolStripButton;
csvGridView.ClearSelection();
for (int i = 0; i < csvGridView.RowCount; i++)
{
csvGridView[cell.ColumnIndex, i].Selected = true;
}
deleteSelectedColumnsToolStripButton.Enabled = true;
}
internal static void DeleteSelectedColumns(CsvEditor form, List <int> selectedColumns)
{
DataGridView csvGridView = form.csvGridView;
AddUndo(form);
selectedColumns.Sort();
int[] selectedColumnsCopy = new int[selectedColumns.Count];
selectedColumns.CopyTo(selectedColumnsCopy);
for (int i = selectedColumnsCopy.Length - 1; i >= 0; i--)
{
csvGridView.Columns.RemoveAt(selectedColumnsCopy[i]);
}
}
internal static void ClearLastUndo(CsvEditor form)
{
Button applyButton = form.applyButton;
ToolStripSplitButton undoToolStripSplitButton = form.undoToolStripSplitButton;
ToolStripMenuItem undoToolStripMenuItem = form.undoToolStripMenuItem;
if (form.undoHistory.Count == 0)
{
return;
}
form.undoHistory.RemoveAt(form.undoHistory.Count - 1);
undoToolStripSplitButton.Enabled = (form.undoHistory.Count > 0);
undoToolStripMenuItem.Enabled = (form.undoHistory.Count > 0);
applyButton.Enabled = (form.undoHistory.Count > 0);
}
internal static void ShowCsvEditor(Form1 form)
{
CustomRichTextBox pageTextBox = ProgramUtil.GetPageTextBox(form.pagesTabControl.SelectedTabPage);
if (String.IsNullOrEmpty(pageTextBox.Text))
{
ShowInfoBox(form, LanguageUtil.GetCurrentLanguageString("TextEmpty", className));
return;
}
CsvEditor csvEditor = new CsvEditor {
Owner = form
};
csvEditor.InitializeForm();
csvEditor.ShowDialog(form);
}
//private static void PutCsvReaderIntoDataGrid(CsvReader csv, DataGridView csvGridView)
//{
// String[] csvHeaders = csv.GetFieldHeaders();
// if (csvHeaders.Length > 0)
// {
// foreach (String csvHeader in csvHeaders)
// {
// csvGridView.Columns.Add(csvHeader, csvHeader);
// }
// }
// else
// {
// for (int i = 0; i < csv.FieldCount; i++)
// {
// csvGridView.Columns.Add(String.Format(LanguageUtil.GetCurrentLanguageString("StandardColumnLabel", className), i), String.Format(LanguageUtil.GetCurrentLanguageString("StandardColumnLabel", className), i));
// }
// }
// do
// {
// object[] csvRow = new object[csvGridView.Columns.Count];
// for (int i = 0; i < csv.FieldCount; i++)
// {
// csvRow[i] = csv[i];
// }
// csvGridView.Rows.Add(csvRow);
// } while (csv.ReadNextRecord());
//}
#endregion Read Methods
#region Write Methods
internal static void WriteCsv(CsvEditor form, char quote, char delimiter)
{
Form1 form1 = (Form1)form.Owner;
XtraTabControl pagesTabControl = form1.pagesTabControl;
CustomRichTextBox pageTextBox = ProgramUtil.GetPageTextBox(pagesTabControl.SelectedTabPage);
DataGridView csvGridView = form.csvGridView;
CheckBox headerCheckBox = form.headerCheckBox;
String finalText = String.Empty;
String quoteStr = (quote == '\0') ? String.Empty : quote.ToString();
if (headerCheckBox.Checked)
{
for (int i = 0; i < csvGridView.Columns.Count; i++)
{
finalText += quoteStr + csvGridView.Columns[i].HeaderText + quoteStr + delimiter;
}
finalText = finalText.Substring(0, finalText.Length - 1) + ConstantUtil.newLine;
}
for (int i = 0; i < csvGridView.Rows.Count - 1; i++)
{
for (int j = 0; j < csvGridView.Rows[i].Cells.Count; j++)
{
if (csvGridView.Rows[i].Cells[j].Value == null)
{
finalText += quoteStr + String.Empty + quoteStr + delimiter;
}
else
{
finalText += quoteStr + csvGridView.Rows[i].Cells[j].Value + quoteStr + delimiter;
}
}
finalText = finalText.Substring(0, finalText.Length - 1) + ConstantUtil.newLine;
}
finalText = finalText.Substring(0, finalText.Length - 1);
pageTextBox.SelectAll();
pageTextBox.SelectedText = finalText;
TextManager.RefreshUndoRedoExternal(form1);
}
private static void ManageApplyButton(CsvEditor form)
{
Button applyButton = form.applyButton;
ToolStripSplitButton undoToolStripSplitButton = form.undoToolStripSplitButton;
ToolStripMenuItem undoToolStripMenuItem = form.undoToolStripMenuItem;
if (form.undoHistory.Count > 0)
{
applyButton.Enabled = true;
undoToolStripSplitButton.Enabled = true;
undoToolStripMenuItem.Enabled = true;
}
else
{
applyButton.Enabled = false;
undoToolStripSplitButton.Enabled = false;
undoToolStripMenuItem.Enabled = false;
}
}
internal static void PerformUndo(CsvEditor form)
{
DataGridView csvGridView = form.csvGridView;
ComboBox delimiterComboBox = form.delimiterComboBox;
ComboBox quoteComboBox = form.quoteComboBox;
CheckBox headerCheckBox = form.headerCheckBox;
form.noAutomaticalActionForControls = true;
csvGridView.Columns.Clear();
csvGridView.DataSource = form.undoHistory[form.undoHistory.Count - 1].CsvGridView.Copy();
delimiterComboBox.SelectedIndex = form.undoHistory[form.undoHistory.Count - 1].DelimiterComboBox;
quoteComboBox.SelectedIndex = form.undoHistory[form.undoHistory.Count - 1].QuoteComboBox;
headerCheckBox.Checked = form.undoHistory[form.undoHistory.Count - 1].HeaderCheckBox;
form.undoHistory.RemoveAt(form.undoHistory.Count - 1);
form.noAutomaticalActionForControls = false;
ManageApplyButton(form);
}
internal static List <int> SelectRows(CsvEditor form, DataGridViewSelectedCellCollection selectedCells)
{
DataGridView csvGridView = form.csvGridView;
ToolStripButton deleteSelectedRowsToolStripButton = form.deleteSelectedRowsToolStripButton;
csvGridView.ClearSelection();
List <int> rowsIndexes = new List <int>();
foreach (DataGridViewCell cell in selectedCells)
{
for (int i = 0; i < csvGridView.ColumnCount; i++)
{
csvGridView[i, cell.RowIndex].Selected = true;
}
rowsIndexes.Add(cell.RowIndex);
}
deleteSelectedRowsToolStripButton.Enabled = true;
return(rowsIndexes);
}
internal static void TakeDataGridViewScreenshot(CsvEditor form)
{
DataGridView csvGridView = form.csvGridView;
CheckBox headerCheckBox = form.headerCheckBox;
csvGridView.ClearSelection();
csvGridView.Refresh();
int x = csvGridView.ClientRectangle.Location.X + csvGridView.RowHeadersWidth;
int y = csvGridView.ClientRectangle.Location.Y;
int width = csvGridView.Columns.Cast <DataGridViewColumn>().Sum(column => column.Width);
//int columnsSize = 0;
//foreach (DataGridViewColumn column in csvGridView.Columns)
//{
// columnsSize += column.Width;
//}
int height = csvGridView.Height;
if (!headerCheckBox.Checked)
{
height -= csvGridView.ColumnHeadersHeight;
y += csvGridView.ColumnHeadersHeight;
}
Rectangle screenshotArea = new Rectangle(csvGridView.PointToScreen(new Point(x, y)), new Size(width, height));
using (Bitmap screenshot = new Bitmap(screenshotArea.Width, screenshotArea.Height))
{
using (Graphics graphic = Graphics.FromImage(screenshot))
{
graphic.CopyFromScreen(new Point(screenshotArea.Left, screenshotArea.Top), Point.Empty, screenshotArea.Size);
}
Clipboard.SetImage(screenshot);
}
ShowInfoBox(form, LanguageUtil.GetCurrentLanguageString("ScreenshotInClipboard", className));
}
internal static void AddUndo(CsvEditor form, DataTable dataSource = null)
{
DataGridView csvGridView = form.csvGridView;
ComboBox delimiterComboBox = form.delimiterComboBox;
ComboBox quoteComboBox = form.quoteComboBox;
CheckBox headerCheckBox = form.headerCheckBox;
if (form.noAutomaticalActionForControls) // || csvGridView.IsCurrentCellInEditMode)
{
return;
}
if (dataSource == null)
{
dataSource = ((DataTable)csvGridView.DataSource).Copy();
}
if ((form.undoHistory.Count == 0 && !form.startingData.Equals(csvGridView.DataSource)) ||
!(form.undoHistory[form.undoHistory.Count - 1].CsvGridView.Equals(csvGridView.DataSource)))
{
form.undoHistory.Add(new CsvUndoHistory(dataSource, delimiterComboBox.SelectedIndex, quoteComboBox.SelectedIndex, headerCheckBox.Checked));
ManageApplyButton(form);
}
}
static void Init()
{
CsvEditor window = EditorWindow.GetWindow <CsvEditor>();
window.Show();
}
internal static bool IsNewColumnNameValorized(CsvEditor form)
{
ToolStripTextBox addNewColumnToolStripTextBox = form.addNewColumnToolStripTextBox;
return(addNewColumnToolStripTextBox.ForeColor != SystemColors.ControlDark);
}