using SteamWare;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.Web;
using System.Web.UI;

namespace GIM_site
{
    public partial class ExcelExportAllData : System.Web.UI.Page
    {
        /// <summary>
        /// wrapper traduzione
        /// </summary>
        /// <param name="lemma"></param>
        /// <returns></returns>
        public string traduci(object lemma)
        {
            return user_std.UtSn.Traduci(lemma.ToString());
        }
        /// <summary>
        /// fix rendering tabelle standard in webform
        /// </summary>
        /// <param name="control"></param>
        public override void VerifyRenderingInServerForm(Control control)
        {
            // Confirms that an HtmlForm control is rendered for the  specified ASP.NET server control at run time.
        }
        /// <summary>
        /// Si occupa di rendere l'out HTML come excel file (mimetype)
        /// </summary>
        private void doExportCsv()
        {
            var dataTable = TA_app.obj.taAllData.GetData();
            StringBuilder builder = new StringBuilder();
            List<string> columnNames = new List<string>();
            List<string> rows = new List<string>();

            foreach (DataColumn column in dataTable.Columns)
            {
                columnNames.Add(column.ColumnName);
            }

            builder.Append(string.Join(memLayer.ML.confReadString("separatoreCsv"), columnNames.ToArray())).Append("\n");

            foreach (DataRow row in dataTable.Rows)
            {
                List<string> currentRow = new List<string>();

                foreach (DataColumn column in dataTable.Columns)
                {
                    object item = row[column];

                    currentRow.Add(item.ToString().Replace("\n", " ").Replace("\r", ""));
                }

                rows.Add(string.Join(memLayer.ML.confReadString("separatoreCsv"), currentRow.ToArray()));
            }

            builder.Append(string.Join("\n", rows.ToArray()));

            Response.Clear();
            Response.AddHeader("content-disposition", "attachment; filename=WebGIM_AllData.csv");
            Response.ContentType = "text/csv";
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.Write(builder.ToString());
            Response.End();
        }

        #region area protected

        /// <summary>
        /// caricamento pagina
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                doExportCsv();
            }
        }

        #endregion


    }
}