cguldogan

var myObjectAsJsonStringInCSharp = Newtonsoft.Json.JsonConvert.SerializeObject(myObj);

cguldogan

function downloadBase64BlobFile(response) {
    var blob = b64toBlob(response.data, 'application/vnd.ms-excel');

      if (blob != null && navigator.msSaveBlob) {
          return navigator.msSaveBlob(blob, response.fileName);
      }

      var a = $('<a style=\'display: none;\'/>');
    var url = window.URL.createObjectURL(new Blob([blob], {
      type: 'application/vnd.ms-excel',

cguldogan

function b64toBlob(b64Data, contentType, sliceSize) {
    contentType = contentType || '';
    sliceSize = sliceSize || 512;
  
    var byteCharacters = atob(b64Data);
    var byteArrays = [];
  
    for (var offset = 0; offset < byteCharacters.length; offset += sliceSize) {
      var slice = byteCharacters.slice(offset, offset + sliceSize);
  

cguldogan

//Use : http://angular-ui.github.io/bootstrap/
HTML PART
---
....
</table>
     <pagination 
            ng-click="ctrl.showPageUkOnly()"
            ng-model="ctrl.currentPageUkOnly"
            total-items="ctrl.ukOnlyResults.length"
            max-size="ctrl.maxSize"  

cguldogan

 public class SwaggerConfig
    {
        public static void Register()
        {

            if (System.Configuration.ConfigurationManager.AppSettings["DisableSwagger"].Equals("True"))
            {
                return;
            }
      ......

cguldogan

using System;
using System.Configuration;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http.Controllers;
using ActionFilterAttribute = System.Web.Http.Filters.ActionFilterAttribute;

namespace Api.Filters

cguldogan

var jsonFormatter = config.Formatters.OfType<JsonMediaTypeFormatter>().First();
jsonFormatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();

cguldogan

 public static class PrintAllProperties
    {
        public static string PropertyList(this object obj)
        {
            var props = obj.GetType().GetProperties();
            var sb = new System.Text.StringBuilder();
            foreach (var p in props)
            {
                sb.AppendLine(p.Name + ": " + p.GetValue(obj, null));
            }

cguldogan

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Threading.Tasks;

namespace BUSINESS
{
    //http://www.itworld.com/article/2700950/development/a-generic-repository-for--net-entity-framework-6-with-async-operations.html

cguldogan

public class ExcelOperations
    {

        public List<List<string>> Read(string filePath)
        {

            OleDbConnection conn = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + filePath + "; Extended Properties = 'Excel 8.0; HDR=NO'");
            OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]", conn);
            conn.Open();
            OleDbDataReader dr = cmd.ExecuteReader();