using System;
using System.IO;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;

namespace JIS_0212
{
  class Class1
  {
    [STAThread]
    static void Main(string[] args)
    {
      try
      {
        string dataIN = "\u4F3B\u56E6\u8835(JIS_0212)\u96E3\u8AAD\u6F22\u5B57(JIS_0208)";
        string dataOUT = "";
        string dbUser = "$USER_NAME_TO_CONNECT_TO_DB$";
        string dbPassword = "$PASSWORD_TO_CONNECT_TO_DB$";
        string dbName = "master";

        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = 
          "Data Source=127.0.0.1,1433;Network Library=DBMSSOCN;Initial catalog=" + 
          dbName + ";user id=" + dbUser + ";password=" + dbPassword + ";pooling=false";
        conn.Open();
        SqlCommand command = new SqlCommand();
        command.Connection = conn;
        command.CommandType = CommandType.Text;
        command.CommandText = 
          "if not exists (select * from sys.objects " +
          "                  where object_id = object_id(N'[dbo].[JIS_0212]') and " +
          "                        type in (N'U')) " +
          "begin " + 
          "  create table JIS_0212 (data varchar(64) collate Japanese_90_CI_AS) " +
          "end " +
          "insert into JIS_0212 values (N'"+ dataIN +"') " + 
          "select * from JIS_0212";
        SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
        while (reader.Read())
          dataOUT = reader.GetString(0);


        string s = "JIS_0212";
        string dataIN_0212 = dataIN.Substring(0, dataIN.IndexOf(s) + s.Length + 1);
        string dataOUT_0212 = dataOUT.Substring(0, dataOUT.IndexOf(s) + s.Length + 1);
        if (dataIN_0212 == dataOUT_0212)
          Trace.WriteLine("JIS 0212:1990 stored successfully :)");
        else
          Trace.WriteLine("JIS 0212:1990 data mismatch in DB :(");

        string dataIN_0208 = dataIN.Substring(dataIN.IndexOf("JIS_0212") + s.Length + 1);
        string dataOUT_0208 = dataOUT.Substring(dataOUT.IndexOf("JIS_0212") + s.Length + 1);
        if (dataIN_0208 == dataOUT_0208)
          Trace.WriteLine("JIS 0208 stored successfully :)");
        else
          Trace.WriteLine("JIS 0208 data mismatch in DB :(");
      }
      catch (Exception e)
      {
        Trace.WriteLine(e.ToString());
      }
    }
  }
}