Anwar Minarso

See also: Other Geeks@INDC
Multilingual ResourceManager dgn Auto Translate (Part II)

Sebelumnya saya telah membuat contoh Custom ResourceManger dengan implementasi API Bing Translator pada post Multilingual ResourceManager dgn Auto Translate (Part I).  

Kali ini, saya akan tune up agar performance lebih baik dan juga lebih mudah dimaintain. Adapun yg di Tune Up adalah sbb :

  1. Menggunakan database
    ResourceManager akan menarik resource data cache terlebih dahulu, jika tidak ada menarik ke database, jika resource tidak ditemukan, maka secara automatis mentranslate dgn service Translator dan menyimpannya kedalam database dan di cache
  2. Memudahkan Maintain
    Dengan menggunakan database akan memudahkan kita memaintain data output translatenya, jika translatornya salah.

source code dapat didownload di sini

Ok, kita lanjut ...

Pertama2 membuat class untuk store database (dengan LinqToSql)

Code Snippet
  1. [Table(Name = "ResourceData")]
  2.     public class ResourceData
  3.     {
  4.         [Column(Name = "ResourceID", CanBeNull = false, IsDbGenerated = true, IsPrimaryKey = true, AutoSync = AutoSync.OnInsert)]
  5.         public long ResourceID { get; set; }
  7.         [Column(Name = "ResourceType", DbType = "NVARCHAR(1000) NOT NULL", CanBeNull = false)]
  8.         public string ResourceType { get; set; }
  11.         [Column(Name = "ResourceKey", DbType = "NVARCHAR(MAX) NOT NULL", CanBeNull = false)]
  12.         public string ResourceKey { get; set; }
  14.         [Column(Name = "FromLanguageCode", DbType = "VARCHAR(20) NOT NULL", CanBeNull = false)]
  15.         public string FromLanguageCode { get; set; }
  17.         [Column(Name = "ToLanguageCode", DbType = "VARCHAR(20) NOT NULL", CanBeNull = false)]
  18.         public string ToLanguageCode { get; set; }
  20.         [Column(Name = "ResourceValue", DbType = "NVARCHAR(MAX) NOT NULL", CanBeNull = false)]
  21.         public string ResourceValue { get; set; }
  22.     }

Kemudian membuat DataContextnya (dengan default connectionStringName nya adalah "MyResourceManager")

Code Snippet
  1. public class ResourceDataContext : DataContext
  2.     {
  3.         private static string ConnectionString = ConfigurationManager.ConnectionStrings["MyResourceManager"].ConnectionString;
  4.         private static AttributeMappingSource mappingSource = new AttributeMappingSource();
  6.         public Table<ResourceData> Resources
  7.         {
  8.             get
  9.             {
  10.                 return GetTable<ResourceData>();
  11.             }
  12.         }
  14.         public ResourceDataContext()
  15.             : base(ConnectionString, mappingSource)
  16.         {
  18.         }
  20.         /// <summary>
  21.         /// attribute [MethodImpl(MethodImplOptions.Synchronized)] memaksa agar fungsi ini menjadi thread-safe
  22.         /// </summary>
  23.         [MethodImpl(MethodImplOptions.Synchronized)]
  24.         public ResourceData GetByResourceKey(string ResourceType, string ResourceKey, string FromLanguageCode, string ToLanguageCode)
  25.         {
  26.             var query = from r in Resources
  27.                         where r.ResourceType.Equals(ResourceType) && r.ResourceKey.Equals(ResourceKey) && r.FromLanguageCode.Equals(FromLanguageCode) && r.ToLanguageCode.Equals(ToLanguageCode)
  28.                        select r;
  29.             var data = query.ToArray(); // pada sql 2005 query equal operator tidak case sensitive
  31.             return data.FirstOrDefault(t => t.ResourceKey.Equals(ResourceKey)); // memaksa agar case sensitive
  32.         }
  34.         [MethodImpl(MethodImplOptions.Synchronized)]
  35.         public ListDictionary GetByFromLanguageCodeToLanguageCode(string ResourceType, string FromLanguageCode, string ToLanguageCode)
  36.         {
  37.             var query = from r in Resources
  38.                         where r.ResourceType.Equals(ResourceType) && r.FromLanguageCode.Equals(FromLanguageCode) && r.ToLanguageCode.Equals(ToLanguageCode)
  39.                         select new { r.ResourceKey, r.ResourceValue };
  40.             ListDictionary dic = new ListDictionary();
  41.             foreach (var result in query)
  42.                 dic.Add(result.ResourceKey, result.ResourceValue);
  43.             return dic;
  44.         }
  45.     }


 Kemudian update coding dibawah ini pada class MyResourceProvider method GetObject

Code Snippet
  1. public object GetObject(string resourceKey, CultureInfo culture)
  2.         {
  3.             if (Disposed)
  4.                 throw new ObjectDisposedException("MyResourceProvider object is already disposed.");
  6.             if (string.IsNullOrEmpty(resourceKey))
  7.                 throw new ArgumentNullException("resourceKey");
  9.             if (culture == null)
  10.                 culture = CultureInfo.CurrentUICulture;
  11.             if (string.IsNullOrEmpty(culture.Name))
  12.                 culture = System.Globalization.CultureInfo.CurrentUICulture;
  13.             string resourceValue = null;
  14.             Dictionary<string, string> resCacheByCulture = null;
  15.             if (resourceCache.ContainsKey(culture.Name))
  16.             {
  17.                 resCacheByCulture = resourceCache[culture.Name];
  18.                 if (resCacheByCulture.ContainsKey(resourceKey))
  19.                     resourceValue = resCacheByCulture[resourceKey];
  20.             }
  21.             if (resourceValue == null)
  22.             {
  23.                 using (ResourceDataContext ctxt = new ResourceDataContext())
  24.                 {
  25.                     // Create Database jika tidak ada
  26.                     if (!ctxt.DatabaseExists())
  27.                         ctxt.CreateDatabase();
  29.                     string fromLanguageCode = resourceKeyLanguage.GetLanguageType().GetLanguageCode();
  30.                     string toLanguageCode = culture.GetLanguageType().GetLanguageCode();
  32.                     // Tarik data Resource
  33.                     ResourceData data = ctxt.GetByResourceKey(classKey, resourceKey, fromLanguageCode, toLanguageCode);
  34.                     if (data == null)
  35.                     {
  36.                         // jika data tidak ada, menarik service API
  37.                         resourceValue = Utils.Translate(resourceKey, resourceKeyLanguage.GetLanguageType(), culture.GetLanguageType());
  38.                         data = new ResourceData();
  39.                         data.ResourceType = classKey;
  40.                         data.ResourceKey = resourceKey;
  41.                         data.FromLanguageCode = fromLanguageCode;
  42.                         data.ToLanguageCode = toLanguageCode;
  43.                         data.ResourceValue = resourceValue;
  45.                         // Insert data
  46.                         ctxt.Resources.InsertOnSubmit(data);
  47.                         ctxt.SubmitChanges();
  48.                     }
  49.                     else
  50.                         resourceValue = data.ResourceValue;
  51.                 }
  53.                 // add this result to the cache
  54.                 // find the dictionary for this culture
  55.                 // add this key/value pair to the inner dictionary
  56.                 lock (this)
  57.                 {
  58.                     if (resCacheByCulture == null)
  59.                     {
  60.                         resCacheByCulture = new Dictionary<string, string>();
  61.                         resourceCache.Add(culture.Name, resCacheByCulture);
  62.                     }
  63.                     resCacheByCulture.Add(resourceKey, resourceValue);
  64.                 }
  65.             }
  66.             return resourceValue;
  68.         }

 Dan yang terakhir tambahakn ConnectionString pada web.config

Code Snippet
  1. <connectionStrings>
  2.     <add name="MyResourceManager" connectionString="Data Source=.\SQL2005;Initial Catalog=MyResourceManagerDB;User ID=sa;Password=12345" providerName="System.Data.SqlCLient"/>
  3.   </connectionStrings>

Rename DataSource, User dan password, sesuai environment kalian...

Semoga bermanfaat Big Smile 

Share this post: | | | |
Posted: Aug 22 2011, 09:22 PM by Anwar Minarso | with no comments
Filed under: ,
Multilingual ResourceManager dgn Auto Translate (Part I)

Dalam pengembangan aplikasi, multi language merupakan point plus dalam aplikasi. Dalam .NET sendiri fitur tersebut sudah ada yaitu menggunakan ResourceManager, namun dalam prakteknya setiap bahasa kita membutuhkan tenaga kerja yg menguasai bahasa terkait, dan juga harus mencompile dan mendeploy kembali. Tentunya ujung2nya adalah waktu dan cost.

Source code dapat didownload di sini

Dalam postingan kali ini saya akan memberikan contoh membuat Custom ResourceManager dgn implementasi service Translator Microsoft. Contoh screennya adalah sbb :

English

Indonesian

Japanese

Korean

Cukup menarik bukan ?

Sebelum menyentuh lebih dalam, sebaiknya lihat dahulu link dibawah ini :

  1. ResourceManager, detail penggunanaannya dapat dilihat pada http://msdn.microsoft.com/en-us/library/aa905797.aspx.
  2. Contoh Implementasi Translator telah posting oleh teman kita Yugie, linknya adalah http://students.netindonesia.net/blogs/yugie/archive/2011/03/02/mudah-translator-dengan-bing-web-service.aspx
  3. Dan juga untuk detail API Translator dapat dilihat pada http://api.microsofttranslator.com/

Jika sudah membaca link diatas, oke kita lanjut....

Saya membuat enum LanguageType dan Extensionnya, tujuannya untuk mapping dengan API Translator dan juga mapping CultureInfonya

Code Snippet
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Globalization;
  7. namespace MyResourceManager
  8. {
  9.     public enum LanguageType
  10.     {
  11.         AutoDetect,
  12.         Arabic,
  13.         Bulgarian,
  14.         Catalan,
  15.         Chinese_Simplified,
  16.         Chinese_Traditional,
  17.         Czech,
  18.         Danish,
  19.         Dutch,
  20.         English,
  21.         Estonian,
  22.         Finnish,
  23.         French,
  24.         German,
  25.         Greek,
  26.         Haitian_Creole,
  27.         Hebrew,
  28.         Hungarian,
  29.         Indonesian,
  30.         Italian,
  31.         Japanese,
  32.         Korean,
  33.         Latvian,
  34.         Lithuanian,
  35.         Norwegian,
  36.         Polish,
  37.         Portuguese,
  38.         Romanian,
  39.         Russian,
  40.         Slovak,
  41.         Slovenian,
  42.         Spanish,
  43.         Swedish,
  44.         Thai,
  45.         Turkish,
  46.         Ukrainian,
  47.         Vietnamese
  48.     }
  50.     public static class LanguageTypeExtension
  51.     {
  52.         public static string GetLanguageCode(this LanguageType value)
  53.         {
  54.             switch (value)
  55.             {
  56.                 case LanguageType.AutoDetect:
  57.                     return "";
  58.                 case LanguageType.Arabic:
  59.                     return "ar";
  60.                 case LanguageType.Bulgarian:
  61.                     return "bg";
  62.                 case LanguageType.Catalan:
  63.                     return "ca";
  64.                 case LanguageType.Chinese_Simplified:
  65.                     return "zh-CHS";
  66.                 case LanguageType.Chinese_Traditional:
  67.                     return "zh-CHT";
  68.                 case LanguageType.Czech:
  69.                     return "cs";
  70.                 case LanguageType.Danish:
  71.                     return "da";
  72.                 case LanguageType.Dutch:
  73.                     return "nl";
  74.                 case LanguageType.English:
  75.                     return "en";
  76.                 case LanguageType.Estonian:
  77.                     return "et";
  78.                 case LanguageType.Finnish:
  79.                     return "fi";
  80.                 case LanguageType.French:
  81.                     return "fr";
  82.                 case LanguageType.German:
  83.                     return "de";
  84.                 case LanguageType.Greek:
  85.                     return "el";
  86.                 case LanguageType.Haitian_Creole:
  87.                     return "ht";
  88.                 case LanguageType.Hebrew:
  89.                     return "he";
  90.                 case LanguageType.Hungarian:
  91.                     return "hu";
  92.                 case LanguageType.Indonesian:
  93.                     return "id";
  94.                 case LanguageType.Italian:
  95.                     return "it";
  96.                 case LanguageType.Japanese:
  97.                     return "ja";
  98.                 case LanguageType.Korean:
  99.                     return "ko";
  100.                 case LanguageType.Latvian:
  101.                     return "lv";
  102.                 case LanguageType.Lithuanian:
  103.                     return "lt";
  104.                 case LanguageType.Norwegian:
  105.                     return "no";
  106.                 case LanguageType.Polish:
  107.                     return "pl";
  108.                 case LanguageType.Portuguese:
  109.                     return "pt";
  110.                 case LanguageType.Romanian:
  111.                     return "ro";
  112.                 case LanguageType.Russian:
  113.                     return "ru";
  114.                 case LanguageType.Slovak:
  115.                     return "sk";
  116.                 case LanguageType.Slovenian:
  117.                     return "sl";
  118.                 case LanguageType.Spanish:
  119.                     return "es";
  120.                 case LanguageType.Swedish:
  121.                     return "sv";
  122.                 case LanguageType.Thai:
  123.                     return "th";
  124.                 case LanguageType.Turkish:
  125.                     return "tr";
  126.                 case LanguageType.Ukrainian:
  127.                     return "uk";
  128.                 case LanguageType.Vietnamese:
  129.                     return "vi";
  130.                 default:
  131.                     return "";
  132.             }
  133.         }
  134.     }
  137.     public static class CultureInfoExtension
  138.     {
  139.         public static LanguageType GetLanguageType(this CultureInfo value)
  140.         {
  141.             string name = value.Name.ToLower();
  142.             LanguageType result = LanguageType.English;
  144.             switch (name)
  145.             {
  146.                 case "af":
  147.                 case "af-za":
  148.                     result = LanguageType.English;
  149.                     break;
  150.                 case "sq":
  151.                 case "sq-al":
  152.                     break;
  153.                 case "ar":
  154.                 case "ar-dz":
  155.                 case "ar-bh":
  156.                 case "ar-eg":
  157.                 case "ar-iq":
  158.                 case "ar-jo":
  159.                 case "ar-kw":
  160.                 case "ar-lb":
  161.                 case "ar-ly":
  162.                 case "ar-ma":
  163.                 case "ar-om":
  164.                 case "ar-qa":
  165.                 case "ar-sa":
  166.                 case "ar-sy":
  167.                 case "ar-tn":
  168.                 case "ar-ae":
  169.                 case "ar-ye":
  170.                     result = LanguageType.Arabic;
  171.                     break;
  172.                 case "hy":
  173.                 case "hy-am":
  174.                     break;
  175.                 case "az":
  176.                 case "az-az-cyrl":
  177.                 case "az-az-latn":
  178.                     break;
  179.                 case "eu":
  180.                 case "eu-es":
  181.                     break;
  182.                 case "be":
  183.                 case "be-by":
  184.                     break;
  185.                 case "bg":
  186.                 case "bg-bg":
  187.                     result = LanguageType.Bulgarian;
  188.                     break;
  189.                 case "ca":
  190.                 case "ca-es":
  191.                     result = LanguageType.Catalan;
  192.                     break;
  193.                 case "zh-hk":
  194.                 case "zh-mo":
  195.                 case "zh-cn":
  196.                 case "zh-sg":
  197.                 case "zh-tw":
  198.                 case "zh-chs":
  199.                     result = LanguageType.Chinese_Simplified;
  200.                     break;
  201.                 case "zh-cht":
  202.                     result = LanguageType.Chinese_Traditional;
  203.                     break;
  204.                 case "hr":
  205.                 case "hr-hr":
  206.                     break;
  207.                 case "cs":
  208.                 case "cs-cz":
  209.                     result = LanguageType.Czech;
  210.                     break;
  211.                 case "da":
  212.                 case "da-dk":
  213.                     result = LanguageType.Danish;
  214.                     break;
  215.                 case "div":
  216.                 case "div-mv":
  217.                     break;
  218.                 case "nl":
  219.                 case "nl-be":
  220.                 case "nl-nl":
  221.                     result = LanguageType.Dutch;
  222.                     break;
  223.                 case "en":
  224.                 case "en-au":
  225.                 case "en-bz":
  226.                 case "en-ca":
  227.                 case "en-cb":
  228.                 case "en-ie":
  229.                 case "en-jm":
  230.                 case "en-nz":
  231.                 case "en-ph":
  232.                 case "en-za":
  233.                 case "en-tt":
  234.                 case "en-gb":
  235.                 case "en-us":
  236.                 case "en-zw":
  237.                     result = LanguageType.English;
  238.                     break;
  239.                 case "et":
  240.                 case "et-ee":
  241.                     result = LanguageType.Estonian;
  242.                     break;
  243.                 case "fo":
  244.                 case "fo-fo":
  245.                     break;
  246.                 case "fa":
  247.                 case "fa-ir":
  248.                     break;
  249.                 case "fi":
  250.                 case "fi-fi":
  251.                     result = LanguageType.Finnish;
  252.                     break;
  253.                 case "fr":
  254.                 case "fr-be":
  255.                 case "fr-ca":
  256.                 case "fr-fr":
  257.                 case "fr-lu":
  258.                 case "fr-mc":
  259.                 case "fr-ch":
  260.                     result = LanguageType.French;
  261.                     break;
  262.                 case "gl":
  263.                 case "gl-es":
  264.                     break;
  265.                 case "ka":
  266.                 case "ka-ge":
  267.                     break;
  268.                 case "de":
  269.                 case "de-at":
  270.                 case "de-de":
  271.                 case "de-li":
  272.                 case "de-lu":
  273.                 case "de-ch":
  274.                     result = LanguageType.German;
  275.                     break;
  276.                 case "el":
  277.                 case "el-gr":
  278.                     result = LanguageType.Greek;
  279.                     break;
  280.                 case "gu":
  281.                 case "gu-in":
  282.                     break;
  283.                 case "he":
  284.                 case "he-il":
  285.                     result = LanguageType.Hebrew;
  286.                     break;
  287.                 case "hi":
  288.                 case "hi-in":
  289.                     break;
  290.                 case "hu":
  291.                 case "hu-hu":
  292.                     result = LanguageType.Hungarian;
  293.                     break;
  294.                 case "is":
  295.                 case "is-is":
  296.                     break;
  297.                 case "id":
  298.                 case "id-id":
  299.                     result = LanguageType.Indonesian;
  300.                     break;
  301.                 case "it":
  302.                 case "it-it":
  303.                 case "it-ch":
  304.                     result = LanguageType.Italian;
  305.                     break;
  306.                 case "ja":
  307.                 case "ja-jp":
  308.                     result = LanguageType.Japanese;
  309.                     break;
  310.                 case "kn":
  311.                 case "kn-in":
  312.                     break;
  313.                 case "kk":
  314.                 case "kk-kz":
  315.                     break;
  316.                 case "kok":
  317.                 case "kok-in":
  318.                     break;
  319.                 case "ko":
  320.                 case "ko-kr":
  321.                     result = LanguageType.Korean;
  322.                     break;
  323.                 case "ky":
  324.                 case "ky-kz":
  325.                     break;
  326.                 case "lv":
  327.                 case "lv-lv":
  328.                     result = LanguageType.Latvian;
  329.                     break;
  330.                 case "lt":
  331.                 case "lt-lt":
  332.                     result = LanguageType.Lithuanian;
  333.                     break;
  334.                 case "mk":
  335.                 case "mk-mk":
  336.                     break;
  337.                 case "ms":
  338.                 case "ms-bn":
  339.                 case "ms-my":
  340.                     break;
  341.                 case "mr":
  342.                 case "mr-in":
  343.                     break;
  344.                 case "mn":
  345.                 case "mn-mn":
  346.                     break;
  347.                 case "no":
  348.                     result = LanguageType.Norwegian;
  349.                     break;
  350.                     
  351.                 case "nb-no":
  352.                     break;
  353.                 case "nn-no":
  354.                     break;
  355.                 case "pl": break;
  356.                 case "pl-pl":
  357.                     result = LanguageType.Polish;
  358.                     break;
  359.                 case "pt":
  360.                 case "pt-br":
  361.                 case "pt-pt":
  362.                     result = LanguageType.Portuguese;
  363.                     break;
  364.                 case "pa":
  365.                 case "pa-in":
  366.                     break;
  367.                 case "ro":
  368.                 case "ro-ro":
  369.                     result = LanguageType.Romanian;
  370.                     break;
  371.                 case "ru":
  372.                 case "ru-ru":
  373.                     result = LanguageType.Russian;
  374.                     break;
  375.                 case "sa":
  376.                 case "sa-in":
  377.                     break;
  378.                 case "sr-sp-cyrl":
  379.                 case "sr-sp-latn":
  380.                     break;
  381.                 case "sk":
  382.                 case "sk-sk":
  383.                     result = LanguageType.Slovak;
  384.                     break;
  385.                 case "sl":
  386.                 case "sl-si":
  387.                     result = LanguageType.Slovenian;
  388.                     break;
  389.                 case "es":
  390.                 case "es-ar":
  391.                 case "es-bo":
  392.                 case "es-cl":
  393.                 case "es-co":
  394.                 case "es-cr":
  395.                 case "es-do":
  396.                 case "es-ec":
  397.                 case "es-sv":
  398.                 case "es-gt":
  399.                 case "es-hn":
  400.                 case "es-mx":
  401.                 case "es-ni":
  402.                 case "es-pa":
  403.                 case "es-py":
  404.                 case "es-pe":
  405.                 case "es-pr":
  406.                 case "es-es":
  407.                 case "es-uy":
  408.                 case "es-ve":
  409.                     result = LanguageType.Spanish;
  410.                     break;
  411.                 case "sw":
  412.                 case "sw-ke":
  413.                     break;
  414.                 case "sv":
  415.                 case "sv-fi":
  416.                 case "sv-se":
  417.                     result = LanguageType.Swedish;
  418.                     break;
  419.                 case "syr":
  420.                 case "syr-sy":
  421.                     break;
  422.                 case "ta":
  423.                 case "ta-in":
  424.                     break;
  425.                 case "tt":
  426.                 case "tt-ru":
  427.                     break;
  428.                 case "te":
  429.                 case "te-in":
  430.                     break;
  431.                 case "th":
  432.                 case "th-th":
  433.                     result = LanguageType.Thai;
  434.                     break;
  435.                 case "tr":
  436.                 case "tr-tr":
  437.                     result = LanguageType.Turkish;
  438.                     break;
  439.                 case "uk":
  440.                 case "uk-ua":
  441.                     result = LanguageType.Ukrainian;
  442.                     break;
  443.                 case "ur":
  444.                 case "ur-pk":
  445.                     break;
  446.                 case "uz":
  447.                 case "uz-uz-cyrl":
  448.                 case "uz-uz-latn":
  449.                     break;
  450.                 case "vi":
  451.                 case "vi-vn":
  452.                     result = LanguageType.Vietnamese;
  453.                     break;
  454.                 default:
  455.                     result = LanguageType.AutoDetect;
  456.                     break;
  457.             }
  459.             return result;
  460.         }
  461.     }
  462.     
  463. }

 Kemudian saya membuat class Utility untuk memudahkan memanggil fungsi API Translatornya

Code Snippet
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Configuration;
  6. using System.Globalization;
  8. namespace MyResourceManager
  9. {
  10.     public static class Utils
  11.     {
  12.         /// <summary>
  13.         /// Application ID untuk kebutuhan Service API Translator, APP ID dapat dibuat dari link http://www.bing.com/developers/appids.aspx
  14.         /// </summary>
  15.         private static string _AppId = ConfigurationManager.AppSettings["MSTranslatorAppId"].ToString();
  17.         /// <summary>
  18.         /// default kode bahasa ResourceKey valuenya dapat didapat dari LanguageTypeExtension.GetLanguageCode()
  19.         /// </summary>
  20.         private static string _ResourceKeyLanguage = ConfigurationManager.AppSettings["ResourceKeyLanguage"].ToString();
  22.         public static string ResourceKeyLanguage
  23.         {
  24.             get
  25.             {
  26.                 return _ResourceKeyLanguage;
  27.             }
  28.         }
  29.         public static string AppId
  30.         {
  31.             get
  32.             {
  33.                 return _AppId;
  34.             }
  35.         }
  37.         public static string Translate(string resourceKey, LanguageType from, LanguageType to)
  38.         {
  39.             if (from.Equals(to)) // Skip jika translate ke bahasa yg sama;
  40.                 return resourceKey;
  42.             string result = string.Empty;
  43.             using (MSTranslator.LanguageServiceClient client = new MSTranslator.LanguageServiceClient())
  44.             {
  45.                 result = client.Translate(_AppId, resourceKey, from.GetLanguageCode(), to.GetLanguageCode(), "text/plain", "general");
  46.             }
  47.             return result;
  48.         }
  50.         public static string Translate(string resourceKey, CultureInfo from, CultureInfo to)
  51.         {
  52.             LanguageType fromLang = from.GetLanguageType();
  53.             LanguageType toLang = to.GetLanguageType();
  54.             return Translate(resourceKey, fromLang, toLang);
  55.         }
  56.     }
  57. }

Kemudian implementasi ResourceManagernya (disini saya tidak menjelaskan lebih detail, beberapa code saya ambil dari contoh http://msdn.microsoft.com/en-us/library/aa905797.aspx.  

Code Snippet
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Resources;
  6. using System.Globalization;
  7. using System.Web.Compilation;
  8. using System.Collections.Specialized;
  10. namespace MyResourceManager
  11. {
  13.     public class DisposableBaseType : IDisposable
  14.     {
  15.         private bool m_Disposed;
  16.         protected bool Disposed
  17.         {
  18.             get
  19.             {
  20.                 lock (this)
  21.                 {
  22.                     return m_Disposed;
  23.                 }
  24.             }
  25.         }
  27.         #region IDisposable Members
  29.         public void Dispose()
  30.         {
  31.             lock (this)
  32.             {
  33.                 if (m_Disposed == false)
  34.                 {
  35.                     Cleanup();
  36.                     m_Disposed = true;
  38.                     GC.SuppressFinalize(this);
  39.                 }
  40.             }
  41.         }
  43.         #endregion
  45.         protected virtual void Cleanup()
  46.         {
  47.             // override to provide cleanup
  48.         }
  50.         ~DisposableBaseType()
  51.         {
  52.             Cleanup();
  53.         }
  55.     }
  57.     public class MyResourceReader : DisposableBaseType, IResourceReader, IEnumerable<KeyValuePair<string, object>>
  58.     {
  59.         private ListDictionary _listDic;
  61.         public MyResourceReader(ListDictionary dic)
  62.         {
  63.             this._listDic = dic;
  64.         }
  65.         #region IResourceReader Members
  67.         public void Close()
  68.         {
  69.             this.Dispose();
  70.         }
  72.         public System.Collections.IDictionaryEnumerator GetEnumerator()
  73.         {
  74.             if (Disposed)
  75.                 throw new ObjectDisposedException("MyResourceReader object is already disposed.");
  77.             return this._listDic.GetEnumerator();
  78.         }
  80.         #endregion
  82.         #region IEnumerable Members
  84.         System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
  85.         {
  86.             if (Disposed)
  87.                 throw new ObjectDisposedException("MyResourceReader object is already disposed.");
  89.             return this._listDic.GetEnumerator();
  90.         }
  92.         #endregion
  95.         protected override void Cleanup()
  96.         {
  97.             try
  98.             {
  99.                 this._listDic = null;
  100.             }
  101.             finally
  102.             {
  103.                 base.Cleanup();
  104.             }
  105.         }
  107.         #region IEnumerable<KeyValuePair<string,object>> Members
  109.         IEnumerator<KeyValuePair<string, object>> IEnumerable<KeyValuePair<string, object>>.GetEnumerator()
  110.         {
  111.             if (Disposed)
  112.                 throw new ObjectDisposedException("MyResourceReader object is already disposed.");
  114.            return this._listDic.GetEnumerator() as IEnumerator<KeyValuePair<string, object>>;
  115.         }
  117.         #endregion
  118.     }
  119.     public class MyResourceProvider : DisposableBaseType, IResourceProvider
  120.     {
  121.         private string classKey;
  122.         private Dictionary<string, Dictionary<string, string>> resourceCache = new Dictionary<string, Dictionary<string, string>>();
  124.         private CultureInfo resourceKeyLanguage = new CultureInfo(Utils.ResourceKeyLanguage);
  126.         public MyResourceProvider(string classKey)
  127.         {
  128.             this.classKey = classKey;
  129.         }
  131.         #region IResourceProvider Members
  133.         public object GetObject(string resourceKey, CultureInfo culture)
  134.         {
  135.             if (Disposed)
  136.                 throw new ObjectDisposedException("MyResourceProvider object is already disposed.");
  138.             if (string.IsNullOrEmpty(resourceKey))
  139.                 throw new ArgumentNullException("resourceKey");
  141.             if (culture == null)
  142.                 culture = CultureInfo.CurrentUICulture;
  143.             if (string.IsNullOrEmpty(culture.Name))
  144.                 culture = System.Globalization.CultureInfo.CurrentUICulture;
  145.             string resourceValue = null;
  146.             Dictionary<string, string> resCacheByCulture = null;
  147.             if (resourceCache.ContainsKey(culture.Name))
  148.             {
  149.                 resCacheByCulture = resourceCache[culture.Name];
  150.                 if (resCacheByCulture.ContainsKey(resourceKey))
  151.                     resourceValue = resCacheByCulture[resourceKey];
  152.             }
  153.             if (resourceValue == null)
  154.             {
  155.                 resourceValue = Utils.Translate(resourceKey, resourceKeyLanguage, culture);
  157.                 // add this result to the cache
  158.                 // find the dictionary for this culture
  159.                 // add this key/value pair to the inner dictionary
  160.                 lock (this)
  161.                 {
  162.                     if (resCacheByCulture == null)
  163.                     {
  164.                         resCacheByCulture = new Dictionary<string, string>();
  165.                         resourceCache.Add(culture.Name, resCacheByCulture);
  166.                     }
  167.                     resCacheByCulture.Add(resourceKey, resourceValue);
  168.                 }
  169.             }
  170.             return resourceValue;
  172.         }
  174.         public IResourceReader ResourceReader
  175.         {
  176.             get
  177.             {
  178.                 if (Disposed)
  179.                     throw new ObjectDisposedException("MyResourceProvider object is already disposed.");
  181.                 // this is required for implicit resources
  182.                 // this is also used for the expression editor sheet
  184.                 ListDictionary resourceDictionary = new ListDictionary();
  186.                 return new MyResourceReader(resourceDictionary);
  187.             }
  188.         }
  190.         #endregion
  192.         protected override void Cleanup()
  193.         {
  194.             try
  195.             {
  196.                 this.resourceCache.Clear();
  197.             }
  198.             finally
  199.             {
  200.                 base.Cleanup();
  201.             }
  202.         }
  204.     }
  206.     public class MyResourceProviderFactory : ResourceProviderFactory
  207.     {
  208.         public override IResourceProvider CreateGlobalResourceProvider(string classKey)
  209.         {
  210.             return new MyResourceProvider(classKey);
  211.         }
  213.         public override IResourceProvider CreateLocalResourceProvider(string virtualPath)
  214.         {
  215.             string classKey = virtualPath;
  216.             if (!string.IsNullOrEmpty(virtualPath))
  217.             {
  218.                 virtualPath = virtualPath.Remove(0, 1);
  219.                 classKey = virtualPath.Remove(0, virtualPath.IndexOf('/') + 1);
  220.             }
  221.             return new MyResourceProvider(classKey);
  223.         }
  225.     }
  228. }


Kemudian tambahan web.config nya

Code Snippet
  1. .
  2. .
  3. .
  4. . 
  5. <appSettings>
  7.     <!-- default kode bahasa ResourceKey valuenya dapat didapat dari LanguageTypeExtension.GetLanguageCode() -->
  8.     <add key="ResourceKeyLanguage" value="en" />
  11.     <!-- Application ID untuk kebutuhan Service API Translator, APP ID dapat dibuat dari link http://www.bing.com/developers/appids.aspx -->
  12.     <add key="MSTranslatorAppId" value="2FF28BD209C6653904A8307F0BA50E1D97E862B0"/>
  13.   </appSettings>
  14.   <system.web>
  15.     <!-- uiCulture untuk default tampilan bahsa di UInya -->
  16.     <globalization culture="en-US" uiCulture="en-US" resourceProviderFactoryType="MyResourceManager.MyResourceProviderFactory, MyResourceManager" />
  17.    .
  18.    .
  19.    .
  20.    .

Pada contoh ini ada beberapa configurasi yg perlu kita ketahui

  1. Pada AppSetting ResourceKeyLanguage ini digunakan untuk default bahasa ResourceKey nya. Setiap kita membuat resourceKey, musti dalam bahasa yg diset pada ResourceKeyLanguage.
  2. Pada AppSetting MSTranslatorAppId, Application ID harus diset untuk mendapatkannya harus register terlebih dahulu pada link http://www.bing.com/developers/appids.aspx

Berhubung waktu terbatas, sepertinya cukup untuk sekian dulu... Big Smile


 

Share this post: | | | |
Posted: Aug 22 2011, 08:44 AM by Anwar Minarso | with 1 comment(s)
Filed under: ,
Recursive Calculation

Dengar nama Recursive, sering menjadi bottle neck dalam aplikasi. Banyak cara untuk meningkatkan performance agar metode recursive tidak menjadi berat.

Source code dapat di download di sini

Contoh Struktur Table Part

Contoh Isi Data Part

Result

Class Part

Code Snippet
  1. [Table(Name = "Part")]
  2. public partial class Part
  3. {
  4.     [Column(DbType = "INT NOT NULL IDENTITY", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.OnInsert, Name = "PartID")]
  5.     public int PartID { get; set; }
  8.     [Column(DbType="INT NULL",  CanBeNull=true, Name="ParentPartID")]
  9.     public int? ParentPartID { get; set; }
  13.     [Column(DbType = "VARCHAR(255) NOT NULL", CanBeNull = false, Name = "PartName")]
  14.     public string PartName { get; set; }
  16.     [Column(DbType = "DECIMAL NOT NULL", CanBeNull = false, Name = "Price")]
  17.     public Decimal Price { get; set; }
  20.     [Column(DbType = "INT NOT NULL", CanBeNull = false, Name = "Qty")]
  21.     public int Qty { get; set; }
  23. }

Addional Property class Part (untuk memudahkan perhitungan Recursive)

Code Snippet
  1. public partial class Part
  2. {
  3.     public Part Parent { get; set; }
  4.     private List<Part> _childs = new List<Part>();
  5.     public List<Part> Childs
  6.     {
  7.         get { return _childs; }
  8.         set { _childs = value; }
  9.     }
  11.     public Decimal Total
  12.     {
  13.         get
  14.         {
  15.             return (Price * Qty);
  16.         }
  17.     }
  18.     public Decimal SubTotal
  19.     {
  20.         get
  21.         {
  22.             return _childs.Sum(t => t.SubTotal) + Total;
  23.         }
  24.     }
  26.     public int TotalPart
  27.     {
  28.         get
  29.         {
  30.             return _childs.Sum(t => t.TotalPart) + Qty;
  31.         }
  32.     }
  36.     public override string ToString()
  37.     {
  38.         string LabelPrice = string.Empty;
  39.         if (Parent == null)
  40.             LabelPrice = "Grand Total";
  41.         else if (_childs.Count > 0)
  42.             LabelPrice = "Sub Total";
  43.         else
  44.             LabelPrice = "Total";
  46.         return string.Format("Part Name : {0}, Price: Rp {1}, Qty: {2}, Total Part: {3}, {4}: Rp {5}", PartName, Price.ToString("n0"), Qty, TotalPart, LabelPrice, SubTotal.ToString("n0"));
  47.     }
  48. }

Part Context (untuk caching data, dan membuat struktur Tree)

Code Snippet
  1. public class PartContext
  2. {
  3.     private static string ConnectionString = ConfigurationManager.ConnectionStrings["MyPartDB"].ConnectionString;
  4.     private static Dictionary<int, Part> dicParts = new Dictionary<int, Part>();
  6.     public static Part[] GetAllParts()
  7.     {
  8.         if (dicParts.Count == 0)
  9.             PopulatePart();
  11.         return dicParts.Values.ToArray();
  12.     }
  14.     public static Part[] GetAllParent()
  15.     {
  16.         if (dicParts.Count == 0)
  17.             PopulatePart();
  19.         return dicParts.Values.Where(t => !t.ParentPartID.HasValue).ToArray();
  20.     }
  22.     public static Part GetByPartID(int PartID)
  23.     {
  24.         if (dicParts.Count == 0)
  25.             PopulatePart();
  26.         if (dicParts.ContainsKey(PartID))
  27.             return dicParts[PartID];
  28.         else
  29.             return null;
  30.     }
  33.     public static void ClearCache()
  34.     {
  35.         dicParts.Clear();
  36.     }
  40.     private static void PopulatePart()
  41.     {
  43.         using (DBContext ctxt = new DBContext(ConnectionString))
  44.         {
  45.             #region Create Database
  46.             if (!ctxt.DatabaseExists())
  47.             {
  48.                 // Create Database
  49.                 ctxt.CreateDatabase();
  51.                 // Create Dummy Record;
  52.                 Part PC = new Part()
  53.                 {
  54.                     ParentPartID = null,
  55.                     PartName = "PC",
  56.                     Price = 0,
  57.                     Qty = 1
  58.                 };
  59.                 ctxt.Parts.InsertOnSubmit(PC);
  60.                 ctxt.SubmitChanges();
  62.                 Part Casing = new Part()
  63.                 {
  64.                     ParentPartID = PC.PartID,
  65.                     PartName = "Casing",
  66.                     Price = 500000,
  67.                     Qty = 1
  68.                 };
  69.                 ctxt.Parts.InsertOnSubmit(Casing);
  70.                 ctxt.SubmitChanges();
  73.                 Part PowerSupply = new Part()
  74.                 {
  75.                     ParentPartID = Casing.PartID,
  76.                     PartName = "Power Supply",
  77.                     Price = 400000,
  78.                     Qty = 1
  79.                 };
  80.                 ctxt.Parts.InsertOnSubmit(PowerSupply);
  81.                 ctxt.SubmitChanges();
  84.                 Part ExtraFan = new Part()
  85.                 {
  86.                     ParentPartID = Casing.PartID,
  87.                     PartName = "Extra Fan",
  88.                     Price = 120000,
  89.                     Qty = 1
  90.                 };
  91.                 ctxt.Parts.InsertOnSubmit(ExtraFan);
  92.                 ctxt.SubmitChanges();
  94.                 Part DVD = new Part()
  95.                 {
  96.                     ParentPartID = Casing.PartID,
  97.                     PartName = "DVD ROM RW",
  98.                     Price = 400000,
  99.                     Qty = 1
  100.                 };
  101.                 ctxt.Parts.InsertOnSubmit(DVD);
  102.                 ctxt.SubmitChanges();
  105.                 Part Motherboard = new Part()
  106.                 {
  107.                     ParentPartID = Casing.PartID,
  108.                     PartName = "Motherboard",
  109.                     Price = 1200000,
  110.                     Qty = 1
  111.                 };
  112.                 ctxt.Parts.InsertOnSubmit(Motherboard);
  113.                 ctxt.SubmitChanges();
  115.                 Part Processor = new Part()
  116.                 {
  117.                     ParentPartID = Motherboard.PartID,
  118.                     PartName = "Processor",
  119.                     Price = 2500000,
  120.                     Qty = 1
  121.                 };
  122.                 ctxt.Parts.InsertOnSubmit(Processor);
  123.                 ctxt.SubmitChanges();
  126.                 Part Memory = new Part()
  127.                 {
  128.                     ParentPartID = Motherboard.PartID,
  129.                     PartName = "Memory 4GB",
  130.                     Price = 600000,
  131.                     Qty = 4
  132.                 };
  133.                 ctxt.Parts.InsertOnSubmit(Memory);
  134.                 ctxt.SubmitChanges();
  137.                 Part VGACARD = new Part()
  138.                 {
  139.                     ParentPartID = Motherboard.PartID,
  140.                     PartName = "VGA CARD",
  141.                     Price = 1200000,
  142.                     Qty = 1
  143.                 };
  144.                 ctxt.Parts.InsertOnSubmit(VGACARD);
  145.                 ctxt.SubmitChanges();
  148.                 Part SOUNDCARD = new Part()
  149.                 {
  150.                     ParentPartID = Motherboard.PartID,
  151.                     PartName = "SOUND CARD",
  152.                     Price = 600000,
  153.                     Qty = 1
  154.                 };
  155.                 ctxt.Parts.InsertOnSubmit(SOUNDCARD);
  156.                 ctxt.SubmitChanges();
  159.                 Part HardDisk = new Part()
  160.                 {
  161.                     ParentPartID = Motherboard.PartID,
  162.                     PartName = "Hard Disk 1 TB",
  163.                     Price = 1300000,
  164.                     Qty = 2
  165.                 };
  166.                 ctxt.Parts.InsertOnSubmit(HardDisk);
  167.                 ctxt.SubmitChanges();
  169.                 Part CoolingFan = new Part()
  170.                 {
  171.                     ParentPartID = Processor.PartID,
  172.                     PartName = "Super Cooler",
  173.                     Price = 350000,
  174.                     Qty = 1
  175.                 };
  176.                 ctxt.Parts.InsertOnSubmit(CoolingFan);
  177.                 ctxt.SubmitChanges();
  178.             }
  179.             #endregion
  181.             #region Populate Dic
  183.             Part[] parts = ctxt.Parts.ToArray();
  185.             // Populate Dic
  186.             foreach (Part part in parts)
  187.                 dicParts.Add(part.PartID, part);
  189.             // Populate Parent & Child
  190.             foreach (Part part in parts)
  191.             {
  192.                 if (part.ParentPartID.HasValue)
  193.                 {
  194.                     Part parentPart = dicParts[part.ParentPartID.GetValueOrDefault()];
  195.                     part.Parent = parentPart;
  196.                     parentPart.Childs.Add(part);
  197.                 }
  198.             }
  199.             #endregion
  200.         }
  201.     }
  203. }

Kesimpulan :

Metode ini sangat berguna untuk menaikan kinerja aplikasi. Akan tetapi jgn lupa Clear Cache atau Partial Update pada PartContextnya jika terjadi perubahan data..

Apakah ada cara yg lebih cepat dari ini ?

Share this post: | | | |
Posted: Aug 20 2011, 12:58 AM by Anwar Minarso | with no comments |
Filed under:
Bermain dengan Extension (fitur .NET 3.0)

Salah satu fitur yg saya suka pada .NET adalah fitur Extension. Fitur ini digunakan untuk membuat tambahan method/function pada class tanpa harus mencompile ulang..

Source Code dapat didownload di sini


Syntax :

Code Snippet
  2. public static <ReturnType> MyFunction(this <ObjectExtension> value)
  3. {
  4.     //Do Something
  5.     return <ReturnType>;
  6. }

Contoh Extension

Berikut ini contoh Extension untuk class IEnumerable<T> agar menambah method konversi ke DataTable

Code Snippet
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. using System.Reflection;
  8. namespace MyNamespace
  9. {
  10.     /// <summary>
  11.     /// Untuk membuat Extension harus dibuatkan static Member
  12.     /// </summary>
  13.     public static class MyExtension
  14.     {
  15.         /// <summary>
  16.         /// untuk membuat Extension method harus dibuatkan method/function static Member
  17.         /// </summary>
  18.         /// <typeparam name="T"></typeparam>
  19.         /// <param name="values"></param>
  20.         /// <returns></returns>
  21.         public static DataTable ToDataTable<T>(this IEnumerable<T> values)
  22.             where T: class
  23.         {
  24.             if (values == null)
  25.                 throw new ArgumentNullException("values", "value tidak boleh null");
  27.             Type _type = typeof(T);
  28.             DataTable dt = new DataTable(_type.Name);
  30.             // ambil informasi property pada class
  31.             PropertyInfo[] _propertyInfoArr = _type.GetProperties();
  34.             // membuat column
  35.             foreach (PropertyInfo pi in _propertyInfoArr)
  36.             {
  37.                 DataColumn col = new DataColumn(pi.Name, pi.PropertyType);
  38.                 dt.Columns.Add(col);
  39.             }
  41.             
  42.             // mengisi data
  43.             foreach (T value in values)
  44.             {
  45.                 DataRow row = dt.NewRow();
  46.                 foreach (PropertyInfo pi in _propertyInfoArr)
  47.                 {
  48.                     object propertyValue = pi.GetValue(value, null);
  49.                     row[pi.Name] = propertyValue;
  50.                 }
  51.                 dt.Rows.Add(row);
  52.             }
  54.             return dt;
  55.         }
  56.     }
  57. }

Contoh penggunaannya :

Code Snippet
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  6. using MyNamespace;
  7. using System.Data;
  9. namespace TestExtension
  10. {
  11.     class Program
  12.     {
  13.         static void Main(string[] args)
  14.         {
  15.             List<MyClass> myClassCol = new List<MyClass>();
  16.             for (int i = 1; i <= 100; i++)
  17.             {
  18.                 myClassCol.Add(new MyClass()
  19.                 {
  20.                     ID = i,
  21.                     Name = string.Format("Name {0}", i)
  22.                 });
  23.             }
  25.             DataTable dt = myClassCol.ToDataTable(); // Ini adalah Extension
  26.             int totalColumn = dt.Columns.Count;
  28.             foreach (DataRow row in dt.Rows)
  29.             {
  30.                 for (int i = 0; i < totalColumn; i++)
  31.                 {
  32.                     Console.WriteLine("{0} : {1}", dt.ColumnsIdea.ColumnName, rowIdea.ToString());
  33.                 }
  35.                 Console.WriteLine("---------------------------");
  36.             }
  37.             Console.ReadLine();
  38.         }
  39.     }
  42.     public class MyClass
  43.     {
  44.         public int ID { get; set; }
  45.         public string Name { get; set; }
  46.     }
  48. }

Semoga bermanfaat.....

Share this post: | | | |
Posted: Aug 19 2011, 07:30 PM by Anwar Minarso | with 1 comment(s)
Filed under:
Blog Test

Hari ini adalah hari account geeks.netindonesia saya dibuat.

Share this post: | | | |
Posted: Jan 11 2008, 02:51 PM by Anwar Minarso | with no comments