/// <summary>
        /// Get by ID
        /// </summary>
        /// <param name="_id"></param>
        /// <returns></returns>
        public CoreData.Article GetByID(long _id)
        {
            try
               {
               DictionaryDefine df = new DictionaryDefine();

               var data = entity.GetById(_id, Table.Article.ToString());

               foreach (var item in df.DicArticleCategory)
               {
                   if (data.CateID == item.Key)
                    {
                        data.CateID = item.Key;
                        data.CategoryNameExt = item.Value;
                        data.View = data.View + 1;
                        Save(data);
                    }
               }
               return data;
               }
               catch { return null; }
        }
        /// <summary>
        /// Get List
        /// </summary>
        /// <returns></returns>
        public IList<CoreData.Article> GetList()
        {
            try
               {
               DictionaryDefine df = new DictionaryDefine();

               var list = entity.GetByCusTomSQL(SQLCommand.GetArticleList).ToList();
               foreach (var item in df.DicArticleCategory)
               {
                   for (int i = 0; i < list.Count; i++)
                   {
                       if (list[i].CateID == item.Key)
                       {
                           list[i].CateID = item.Key;
                           list[i].CategoryNameExt = item.Value;
                       }
                   }
               }
               //return entity.GetByCusTomSQL(SQLCommand.GetArticleList).ToList();
               return list;
               }
               catch { return null; }
        }
 /// <summary>
 /// Get Article by Category ID
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public IList<Article> GetListByRelationsID(long catid, string username)
 {
     try
     {
         string tempstring = "";
         string getuserid = "";
         if (username == "" && catid == 0)
         {
             tempstring = "";
         }
         else
         {
             if (username != "" && catid == 0)
             {
                 tempstring = " and u.UserName LIKE '" + username + "'";
                 getuserid = ", u.Name AS UserName";
             }
             if (catid != 0) {
                 if (username == "")
                 {
                     tempstring = " and a.CateID = '" + catid + "'";
                 }
                 else
                 {
                     tempstring = " and u.UserName LIKE '" + username + "'" + " and CateID = '" + catid + "'";
                     getuserid = ", u.Name AS UserName";
                 }
             }
         }
         var list = entity.GetByCusTomSQL(String.Format(SQLCommand.GetListByRelationsID,getuserid, tempstring)).ToList();
         DictionaryDefine df = new DictionaryDefine();
         if (catid != 0)
         {
             foreach (var item in df.DicArticleCategory)
             {
                 for (int i = 0; i < list.Count; i++)
                 {
                     if (list[i].CateID == item.Key)
                     {
                         list[i].CateID = item.Key;
                         list[i].CategoryNameExt = item.Value;
                     }
                 }
             }
         }
         return list;
     }
     catch { return null; }
 }
 public List<SelectListItem> GetListCategory(int id)
 {
     var lst = new List<SelectListItem>();
     DictionaryDefine listcate = new DictionaryDefine();
     foreach (var item in listcate.DicArticleCategory) {
         var sitem = new SelectListItem();
         sitem.Value = item.Key.ToString();
         sitem.Text = item.Value;
         lst.Add(sitem);
     }
     return lst;
 }
        /// <summary>
        /// Get List with search string
        /// </summary>
        /// <returns></returns>
        public IList<CoreData.Article> GetList(string _searchstring)
        {
            //search theo tieu chi nao do
               try
               {
               DictionaryDefine df = new DictionaryDefine();

               var list = entity.GetBySearchString(_searchstring, Table.Article.ToString()).ToList();
               foreach (var item in df.DicArticleCategory)
               {
                   for (int i = 0; i < list.Count; i++)
                   {
                       if (list[i].CateID == item.Key)
                       {
                           list[i].CateID = item.Key;
                           list[i].CategoryNameExt = item.Value;
                       }
                   }
               }
               //return entity.GetBySearchString(_searchstring, Table.Article.ToString()).ToList();
               return list;
               }
               catch { return null; }
        }