Ricardo Soria's questions

I need to download a file located in the App_Data folder of my project, all permissions are granted, I have the following code to download an .xlsx file by calling a WebService in C#, the result of the process does not throw an error, but it does not download the file in the explorer and in the preview when inspecting the process shows unknown characters.

AJAX Jquery code:

function DOWNLOAD_EXCEL_SERVICES() {

    $.ajax({
        type: 'POST',
        url: '../WebServices/getJSON.asmx/DOWNLOAD_EXCEL_SERVICES',
        contentType: 'application/x-msexcel',
        success: OnSuccess,
        error: function (xhr, status, error) {
            var err = eval("(" + xhr.responseText + ")");
            alert(err.Message);
        }
    });

    function OnSuccess() {
        console.log("donloading-services");
    }

}

WebService C# code:

    [WebMethod]
    public void DOWNLOAD_EXCEL_SERVICES()
    {
        var path = Server.MapPath("~/App_Data//");
        string filename = "SERVICES.xlsx";
        System.Web.HttpResponse Response = System.Web.HttpContext.Current.Response;
        byte[] Content = File.ReadAllBytes(path + "SERVICES.xlsx");
        Response.ContentType = "application/x-msexcel";
        Response.AddHeader("content-disposition", "attachment; filename=\"" + filename + "\"");
        Response.BufferOutput = true;
        Response.OutputStream.Write(Content, 0, Content.Length);
        Response.Flush();
}

Output of Process inspecting in Chrome:

Additionally if I use Response.End()instead of Response.flush()just check "Proces was being aborted", even though I use a try-catch structure I get the same result, it doesn't drop the file.

I have a String that represents a time in Epoch and I need the correct format to be able to enter it in a SQL Server database, from PowerShell. So far I can change the Epoch format to a very long date format, EXAMPLE:

Date in Epoch to convert: 746181000

Function I use:

[timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds('746181000')) 

The output is the following:

Tuesday, August 24, 1993 3:30:00 AM

What I really need is the date in this format:yyyy-MM-dd HH:MM:ss

So my desired output would be1993-08-24 03:30:00

Normally this is the structure of a WebService that I use in a project, but now I need to get all the columns of a table that can have N number of columns, in the example I only receive 4 columns that I know exist, but what happens when I have 12 , 15 or 20 columns whose names are not known and I want them to receive the same treatment through the WebService (convert to json).

The table that returns N number of columns is generated with a dynamic SQL query and changes the number of columns constantly.

[WebMethod]
        public string getInformacion()
        {
            List<condDet> p = new List<condDet>();

            string ConnectString = ConfigurationManager.ConnectionStrings["CTS"].ToString();

            using (SqlConnection cn = new SqlConnection(ConnectString))
            {
                string qry = "SELECT * FROM TABLAEJEMPLO";

                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = qry;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = cn;

                cn.Open();

                SqlDataReader dr = cmd.ExecuteReader();

                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        condDet cpData = new condDet();
                        cpData.NOMBRE = dr["NOMBRE"].ToString();
                        cpData.EXC = dr["EXC"].ToString();
                        cpData.PAIS = dr["PAIS"].ToString();
                        cpData.NOMBRE_PAIS = dr["NOMBRE_PAIS"].ToString();
                        p.Add(cpData);
                    }
                }
                string json = JsonConvert.SerializeObject(p);
                return json;
            }
        }

public class condDet
    {
        public string NOMBRE { get; set; }
        public string EXC { get; set; }
        public string PAIS { get; set; }
        public string NOMBRE_PAIS { get; set; }
    }

I need this table:

Becomes this: (edit it as an image using paint to show as an example)

The data will always have the same 'serverName', DATE and TIME in common