public static long ValidateHSCode(string HSCode)
        {
            if (HSCode.ToString().Trim().Length == 10)
            {
                HSCodes AssessedHSCode;

                AssessedHSCode = new HSCodes(HSCode);

                if (!(AssessedHSCode.HSCodeID == null || AssessedHSCode.HSCodeID == 0))
                {
                    return (long)AssessedHSCode.HSCodeID;
                }
                else
                {
                    //mskHScode.Focus();
                    //MessageBox.Show("Invalid HS Code", "Generation II", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return -1;
                }
            }
            else
            {
                //mskHScode.Focus();
                //MessageBox.Show("Invalid HS Code", "Generation II", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return -1;
            }
        }
        public static string SetHSPer(string HSCode)
        {
            if (HSCode.ToString().Trim().Length == 10)
            {
                HSCodes AssessedHSCode;
                AssessedHSCode = new HSCodes(HSCode);

                if (!(AssessedHSCode.HSCodeID == null || AssessedHSCode.HSCodeID == 0))
                {

                    string[] per = { AssessedHSCode.Duty.ToString(), AssessedHSCode.VAT.ToString(), AssessedHSCode.NHIL.ToString() };

                    //return (long)AssessedHSCode.HSCodeID;
                    string result = string.Join(",", per);
                    return result;

                }
                else
                {
                    //MessageBox.Show("Invalid HS Code", "Generation II", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return "failed";
                }
            }
            else
            {
                //MessageBox.Show("Invalid HS Code", "Generation II", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return "failed";
            }
        }