REST Servis Cagırma

REST GET/POST/PUT/DELETE yapmak için uyguladığım adımlar şu şekilde:

• Visual Studio’da Visual C#/Windows Desktop/Console Application projesi oluşturdum. Adını RestClientSample koydum.
• NuGet üzerinden Microsoft.AspNet.WebApi.Client paketini yükledim.
• Rest servise gönderilecek ve servisten dönecek nesnelere karşılık gelen sınıfları oluşturdum.
• Program.cs’yi aşağıdaki gibi değiştirdim.

using System;

using System.Net.Http;

using System.Net.Http.Headers;

using System.Text;

using System.Threading.Tasks;

 

namespace RestClientSample

{

    class Program

    {

        static void Main(string[] args)

        {

            try

            {

                RunAsync().Wait();

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.StackTrace);

            }

 

            Console.ReadKey();

        }

 

        static async Task RunAsync()

        {

            using (var client = new HttpClient())

            {

                // Servis adresi

                client.BaseAddress = new Uri("http://webadresi.com/");

                client.DefaultRequestHeaders.Accept.Clear();

                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

 

                // Servis Basic Http Authentication istiyorsa eklenir.

                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", Convert.ToBase64String(new UTF8Encoding().GetBytes(string.Format("{0}:{1}", "TestUser", "Pass"))));

 

                // HTTP GET

                HttpResponseMessage response = await client.GetAsync("api/IotDatas/1");

                if (response.IsSuccessStatusCode)

                {

                    IotData product = await response.Content.ReadAsAsync<IotData>();

                    Console.WriteLine("{0}\t${1}\t{2}", product.Name, product.Value, product.CreateDate);

                }

 

                // HTTP POST

                var iotData = new IotData { Name = "Test", Value = null, CreateDate = DateTime.Now };

                response = await client.PostAsJsonAsync("api/IotDatas", iotData);

                if (response.IsSuccessStatusCode)

                {

                    Uri gizmoUrl = response.Headers.Location;

 

                    // HTTP PUT

                    iotData.Value = null;

                    response = await client.PutAsJsonAsync(gizmoUrl, iotData);

 

                    // HTTP DELETE

                    response = await client.DeleteAsync(gizmoUrl);

                }

            }

        }

    }

}

VS 2015 : ?. ve ?[ Operatörleri

int? length = customers?.Length; // customers null ise null değilse customers.Length

Customer first = customers?[0];  // customers null ise null değilse customers[0]

int? count = customers?[0]?.Orders?.Count();  // customers, customers[0], customers[0].Orders null ise null değilse customers[0].Orders.Count()

WPF Ekran Resmi alma

public static void MultipleScreenCapture(string filename)

{

    var ss = new Bitmap(SystemInformation.VirtualScreen.Width,

                        SystemInformation.VirtualScreen.Height,

                        PixelFormat.Format32bppArgb);

  

    Graphics.FromImage(ss).CopyFromScreen(SystemInformation.VirtualScreen.X,

                                          SystemInformation.VirtualScreen.Y,

                                          0,

                                          0,

                                          SystemInformation.VirtualScreen.Size,

                                          CopyPixelOperation.SourceCopy);

  

    ss.Save(filename, ImageFormat.Png);

}

PL-SQL Table Create

CREATE TABLE OD_TABLE
( SEQ_NO NUMBER(12) not null,
  colum2 varchar2(50) not null,
 colum3 varchar2(50),
 colum4 varchar2(50),
 colum5 varchar2(50),
 colum6 varchar2(50),
  colum7 varchar2(50),
  colum8 varchar2(4000),
  CRE_USER varchar2(50),
  CONSTRAINT OD_TABLE_pk PRIMARY KEY (SEQ_NO)
);


CREATE TABLE OD_TABLE (select * from table_name)