/// <summary>
        /// Generates the subject for the Transportation team
        /// </summary>
        /// <param name="license"></param>
        /// <param name="states"></param>
        /// <returns></returns>
        public string GenerateEmailSubjectTransportationTeam(CS_EquipmentPermit license)
        {
            CS_State state = new CS_State();
            using (_locationModel = new LocationModel())
            {
                state = _locationModel.ListAllStatesByAcronym(license.Code).FirstOrDefault();
            }

            if (null != license)
                return string.Format("Expired permit(s) identified for {0}, from {1}, in {2}, for {3}", license.LicenseNumber, license.CS_Equipment.DivisionName, ((null != state) ? state.AcronymName : string.Empty), license.Type);

            return string.Empty;
        }
        /// <summary>
        /// Generates body for the email for the Transportation team
        /// </summary>
        /// <param name="license"></param>
        /// <param name="expiredPermits"></param>
        /// <param name="states"></param>
        /// <returns></returns>
        private string GenerateEmailBodyForTransportationTeam(CS_EquipmentPermit permit)
        {
            StringBuilder _permitEmail = new StringBuilder();

            CS_State state = new CS_State();
            using (_locationModel = new LocationModel())
            {
                state = _locationModel.ListAllStatesByAcronym(permit.Code).FirstOrDefault();
            }

            _permitEmail.AppendFormat("{0} was issued a permit on {1} which expired on {2} in {3} for the {4} permit. Please update the permit information in Dossier.", permit.CS_Equipment.Name, permit.IssueDate.ToString("MM/dd/yyyy HH:mm"), permit.ExpirationDate.ToString("MM/dd/yyyy HH:mm"), ((null != state) ? state.AcronymName : string.Empty), permit.Type);

            return StringManipulation.TabulateString(_permitEmail.ToString());
        }
        /// <summary>
        /// Generates the subject for the permit team
        /// </summary>
        /// <param name="license"></param>
        /// <param name="states"></param>
        /// <returns></returns>
        public string GenerateEmailSubjectEstimationTeam(CS_EquipmentPermit license, IList<CS_State> states)
        {
            CS_State state = states.FirstOrDefault(e => e.Acronym == license.Code);

            if (null != license)
                return string.Format("Expired Permit Number {0}, {1}", license.LicenseNumber, ((null != state) ? state.AcronymName : string.Empty));

            return string.Empty;
        }
        /// <summary>
        /// Generates body for the email for the permit team
        /// </summary>
        /// <param name="license"></param>
        /// <param name="expiredPermits"></param>
        /// <param name="states"></param>
        /// <returns></returns>
        private string GenerateEmailBodyForPermitTeam(CS_EquipmentPermit license, IList<CS_EquipmentPermit> expiredPermits, IList<CS_State> states)
        {
            StringBuilder _permitEmail = new StringBuilder();
            CS_State state = states.FirstOrDefault(e => e.Acronym == license.Code);
            expiredPermits.OrderBy(e => e.ExpirationDate);

            _permitEmail.Append("Permit#:<Text> " + license.LicenseNumber);

            if (null == state)
                _permitEmail.Append("<BL>" + "Permit State:<Text> " + license.Code);
            else
                _permitEmail.Append("<BL>" + "Permit State:<Text> " + state.AcronymName);

            _permitEmail.Append("<BL>" + "Permit Type:<Text> " + license.Type);

            _permitEmail.Append("<BL>" + "Permit Equipments<Text> ");

            if (expiredPermits.Count > 0)
            {
                for (int i = 0; i < expiredPermits.Count; i++)
                {
                    CS_EquipmentPermit permit = expiredPermits[i];

                    _permitEmail.Append("<BL>" + "  Unit#:<Text> " + permit.CS_Equipment.Name);
                    _permitEmail.Append("<BL>" + "  Descriptor:<Text> " + permit.CS_Equipment.Description);
                    _permitEmail.Append("<BL>" + "  Division#:<Text> " + permit.CS_Equipment.CS_Division.Name);
                    _permitEmail.Append("<BL>" + "  Expiration Date:<Text> " + permit.ExpirationDate + "<BL>");
                }
            }

            return StringManipulation.TabulateString(_permitEmail.ToString());
        }