CSVDgv.cs

using System;
using System.Data;
using System.IO;
using System.Text;
using System.Windows.Forms;
using be.gaudry.model.enums;
using be.gaudry.view.dialogs;
 
namespace be.gaudry.view.utils.dgvFactory
{
    public class CSVDgv : AbstractDgv
    {
        #region declarations and constructors
        private SaveFileDialog saveFileDialog;
        //private Export export;
        private string separator;
        public CSVDgv()
        {
            //export = new Export();
 
            saveFileDialog = new SaveFileDialog();
            saveFileDialog.CheckPathExists = true;
            saveFileDialog.CheckFileExists = false;
            saveFileDialog.AddExtension = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.DefaultExt = ".csv";
            saveFileDialog.Filter = "CSV (*.csv)|*.csv|Tous les fichiers (*.*)|*.*";
            saveFileDialog.FilterIndex = 1;
        }
        #endregion
 
        #region Attributes
        public string Separator
        {
            get { return this.separator; }
            set { this.separator = value; }
        }
        #endregion
 
        public override void print(DataGridView dgv)
        {
            this.dgv = dgv;
            //setLayoutOptions(outputTitle);
 
            DialogResult dr;
            if (dialogOwner != null)
            {
                dr = saveFileDialog.ShowDialog(dialogOwner);
            }
            else
            {
                dr = saveFileDialog.ShowDialog();
            }
            if (dr == DialogResult.OK)
            {
                print(saveFileDialog.FileName);
            }
        }
 
        private void print(string destinationFile)
        {
            bool writed = false;
            StreamWriter writer = new StreamWriter(destinationFile, false);
            try
            {
                //export.ExportDetails(getDGVDataTable(), EXPORT_FORMAT.CSV, destinationFile);
                writer.Write(getDGVString());
                writed = true;
            }
            catch (Exception e)
            {
                ExceptionDialog.ShowDialog(e, this.dialogOwner);
            }
            finally
            {
                writer.Close();
            }
            if (writed)
            {
                CustomOpenResultFileDialog.Show(
                    this.dialogOwner,
                    destinationFile,
                    "Le fichier est sauvé.\nVous pouvez sélectionner une action à effectuer.",
                    "Sauvegarde",
                    MessageBoxIcon.Information
                    );
            }
        }
 
        private string getDGVString()
        {
            StringBuilder str = new StringBuilder();
            string dateStr = "";
            if (DisplayDate)
            {
                dateStr = string.Format(
                    "\nLe {0} à {1}\n",
                    DateTime.Now.ToLongDateString(),
                    DateTime.Now.ToShortTimeString()
                );
            }
            if (DisplayDate && textPlacement == TEXT_POSITION.Header)
            {
                str.AppendLine(dateStr);
            }
            foreach (DataGridViewColumn dgvCol in SelectedColumns)
            {
                str.Append('"');
                str.Append(dgvCol.HeaderText);
                str.Append('"');
                str.Append(separator);
            }
            str.AppendLine();
            foreach (DataGridViewRow dgvRow in dgv.Rows)
            {
                str.AppendLine();
                foreach (DataGridViewCell dgvCell in dgvRow.Cells)
                {
                    if (!SelectedColumns.Contains(dgvCell.OwningColumn))
                        continue;
                    str.Append('"');
                    str.Append(dgvCell.EditedFormattedValue);
                    str.Append('"');
                    str.Append(separator);
                }
            }
            if (DisplayDate && textPlacement == TEXT_POSITION.Footer)
            {
                str.AppendLine();
                str.AppendLine(dateStr);
            }
            return str.ToString();
        }
 
        private System.Data.DataTable getDGVDataTable()
        {
            DataTable dataTable = new DataTable();
            foreach (DataGridViewColumn dgvCol in SelectedColumns)
            {
                dataTable.Columns.Add(dgvCol.HeaderText);
            }
            foreach (DataGridViewRow dgvRow in dgv.Rows)
            {
                dataTable.Rows.Add();
                int rowIndex = dataTable.Rows.Count -1;
                int colIndex = 0;
                foreach (DataGridViewCell dgvCell in dgvRow.Cells)
                {
                    if (!SelectedColumns.Contains(dgvCell.OwningColumn))
                                continue;
                    dataTable.Rows[rowIndex][colIndex++] = dgvCell.EditedFormattedValue;
                }
            }
            return dataTable;
        }
    }
}