/// <summary>
        /// Changes the item ID.
        /// </summary>
        /// <param name="fromItemId">From item id.</param>
        /// <param name="fromUnitId">From unit id.</param>
        /// <param name="toItemId">To item id.</param>
        /// <param name="toUnitId">To unit id.</param>
        /// <returns></returns>
        public static String ChangeItemID(int fromItemId, int fromUnitId, int toItemId, int toUnitId)
        {
            System.Collections.Specialized.ListDictionary Parms = new System.Collections.Specialized.ListDictionary();
            Parms.Add("@toItemID", toItemId);
            Parms.Add("@fromitemID",fromItemId);
            Parms.Add("@fromUnitID",fromUnitId);
            Parms.Add("@toUnitID" ,toUnitId);

            try
            {
                Item items = new Item();
                items.LoadFromSql("procChangeItemID", Parms);
                //return items.DataRow.ItemArray[0].ToString();
                return "Successful";
            }
            catch (Exception ex)
            {
                return ex.Message;
            }
        }