private void UpdateCode()
        {
            seriesName = dropdownJobCatagory.SelectedValue;
            string    companyName   = "";
            DataTable seriesDT      = NumberSeriesManager.GetDataBySeriesName(seriesName, companyName);
            int       lastGenNumber = int.Parse(seriesDT.Rows[0]["LastGeneratedNo"].ToString());

            currentNo = lastGenNumber + 1;
            NumberSeriesManager.UpdateSerialNo(seriesName, currentNo, companyName);
        }
        private void GenerateCode()
        {
            preFix   = "";
            prefixHF = SKprefixHF.Value;
            curNoHF  = SKcurNoHF.Value;
            string companyName = "";

            DataTable seriesDT = NumberSeriesManager.GetDataBySeriesName(seriesName, companyName);

            for (int i = 0; i < seriesDT.Rows.Count; i++)
            {
                preFix = seriesDT.Rows[i]["PreFix"].ToString();
            }

            lblJobCode.Text = NumberSeriesManager.GenerateNumberSeries(companyName, seriesName, preFix, prefixHF, curNoHF);
        }