//#region Web Service Getters

        //    public static List<Proxy.SubCategory> GetAll()
        //    {
        //        BLL.SubCategory v = new BLL.SubCategory();
        //        v.LoadAll();
        //        return ToList(v);
        //    }

        //    public static List<Proxy.SubCategory> GetUpdatesAfter(int LastVersion)
        //    {
        //        BLL.SubCategory v = new BLL.SubCategory();
        //        v.LoadUpdatesAfter( LastVersion );
        //        return ToList(v);
        //    }

        //#endregion



        #region Utilities

        public static List <Proxy.DrugSubCategory> ToList(BLL.SubCategory v)
        {
            List <Proxy.DrugSubCategory> list = new List <Proxy.DrugSubCategory>();

            while (!v.EOF)
            {
                Proxy.DrugSubCategory t = new Proxy.DrugSubCategory();
                if (!v.IsColumnNull("ID"))
                {
                    t.ID = v.ID;
                }
                if (!v.IsColumnNull("CategoryId"))
                {
                    t.CategoryId = v.CategoryId;
                }
                if (!v.IsColumnNull("SubCategoryName"))
                {
                    t.SubCategoryName = v.SubCategoryName;
                }
                if (!v.IsColumnNull("SubCategoryCode"))
                {
                    t.SubCategoryCode = v.SubCategoryCode;
                }
                if (!v.IsColumnNull("Description"))
                {
                    t.Description = v.Description;
                }
                if (!v.IsColumnNull("ParentID"))
                {
                    t.ParentID = v.ParentID;
                }

                list.Add(t);
                v.MoveNext();
            }
            return(list);
        }
        public static List<Proxy.DrugSubCategory> ToList(BLL.SubCategory v)
        {
            List<Proxy.DrugSubCategory> list = new List<Proxy.DrugSubCategory>();
            while (!v.EOF)
            {
                Proxy.DrugSubCategory t = new Proxy.DrugSubCategory();
              if(!v.IsColumnNull("ID"))
                     t.ID = v.ID;
              if(!v.IsColumnNull("CategoryId"))
                     t.CategoryId = v.CategoryId;
              if(!v.IsColumnNull("SubCategoryName"))
                     t.SubCategoryName = v.SubCategoryName;
              if(!v.IsColumnNull("SubCategoryCode"))
                     t.SubCategoryCode = v.SubCategoryCode;
              if(!v.IsColumnNull("Description"))
                     t.Description = v.Description;
              if(!v.IsColumnNull("ParentID"))
                     t.ParentID = v.ParentID;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }