public Boolean IsJobAccountAvaialbleInACMaster(String strJob, String strSubCode, String strAcCode)
        {
            Boolean boolIsJobAvail = false;
            DataSet ds             = new DataSet();

            ds = SQLHelperGL.FillDataSet("SELECT     AccountCode FROM  dbo.AccountMaster WHERE (JobCode = '" + strJob + "') AND (SubCategoryCode = '" + strSubCode + "') AND (AccountCode = '" + strAcCode + "')", CommandType.Text);
            if (ds.Tables[0].Rows.Count > 0)
            {
                boolIsJobAvail = true;
            }
            return(boolIsJobAvail);
        }
        public Boolean IsAvailableSubCategory(String strACCode)
        {
            Boolean boolIsACAvail = false;
            DataSet ds            = new DataSet();

            ds = SQLHelperGL.FillDataSet("SELECT SubCategoryCode, SubCategoryName FROM dbo.AccountSubCategory WHERE (SubCategoryCode = '" + strACCode + "')", CommandType.Text);
            if (ds.Tables[0].Rows.Count > 0)
            {
                boolIsACAvail = true;
            }
            return(boolIsACAvail);
        }
        public String GETSubCategoryNameByCode(String strACCode)
        {
            String  strName = "";
            DataSet ds      = new DataSet();

            ds = SQLHelperGL.FillDataSet("SELECT SubCategoryCode, SubCategoryName FROM dbo.AccountSubCategory WHERE (SubCategoryCode = '" + strACCode + "')", CommandType.Text);
            if (ds.Tables[0].Rows.Count > 0)
            {
                strName = ds.Tables[0].Rows[0][1].ToString();
            }
            else
            {
                strName = "NA";
            }
            return(strName);
        }