public Result GetLast()
        {
            var result = new Result();

            try
            {
                var baseBL = new BaseBL <Ref>();

                result.Data    = baseBL.GetLastID("[dbo].[Proc_GetNewCode]", "Ref", "RefNo", "NK");
                result.Success = true;
            }
            catch (Exception)
            {
                result.Success = false;
                throw;
            }
            return(result);
        }