Amir Hoshang Kioumars

Monday, 6 August 2018

C# REST Server POST and Get Response

async Task Main()
{
   string outputfile = "output.csv";

   File.Delete (outputfile);

   var httpWebRequest = (HttpWebRequest)WebRequest.Create(URL);
   httpWebRequest.ContentType = "application/json";
   httpWebRequest.Method = "POST";

   using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
   {
       string json = new JavaScriptSerializer().Serialize(new
       {
           startDate = "7/1/2018",
           endDate = "6/30/2019",
           codes = new string[] { "value1", "value2" },
           skus= "",
           returnCSV = 1
       });
       streamWriter.Write(json);
   }

   var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
   using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
   {
       using (StreamWriter sw = new StreamWriter(outputfile))
           sw.Write(await streamReader.ReadToEndAsync());
   }
}

Sunday, 5 August 2018

VueJS Get and Post Data

Use it in App.vue

Wednesday, 1 August 2018

Powershell: Quick Search

Measure-Command
{
    Get-AdUser -Filter {
        ExtensionAttribute11 -eq 'NON'
    }
    -SearchBase 'Desired OU,DC=xxxx,DC=xxxx,DC=xxxx,DC=xxxx' # OU and DC parts
    -Properties ExtensionAttribute11 |
        Select name, ExtensionAttribute11, ExtensionAttribute13, Department, ...
}

Friday, 20 July 2018

SQL Update target tables from 2 different databases

begin transaction;

update [destination database].[dbo].[destination table]
set [destination database].[dbo].[destination table].'destination column' = source.'desired column'
from [source database].[dbo].[source table] source
inner join [destination database].[dbo].[destination table] destnation
on destination.'column to join' = source.'column to join'

--rollback;
--commit;

Wednesday, 4 July 2018

Vue.js Get Json Data and Display

Index.html
<html>
<title></title>
    <head>
        
        <script src="https://cdn.jsdelivr.net/npm/vue"></script>
    </head>
    <body>
        <div id="app">
            <li v-for="msg in json">
                {{msg}}
            </li>
            <input v-model="text"/>
            <button @click="DisplayData">Query</button>
        </div>
    <script src="index.js"></script>
    </body>
</html>

Index.js
var app = new Vue({
    el: "#app",
    data: {
        text: "",
        json: null
    },
    methods: {
        DisplayData: function () {
            if (this.text)
            {
                fetch("https://api.github.com/users/" + this.text)
                    .then(r => r.json())
                    .then(json => { this.json = json; });
            }
        }
    }
});

Friday, 6 April 2018

Button feature not working within update panel in ASP.NET

To resolve this, initiate a full page postback trigger on update panel:

<asp:UpdatePanel runat="server">
<Triggers>
<asp:PostBackTrigger ControlID="YourControlID" />
</Triggers>
<ContentTemplate>
.....

Wednesday, 14 February 2018

Call button on hit enter key in a text box