public static void sendEmailDateProjectEnd(object sender, ElapsedEventArgs e)
        {
            Func <MySqlDataReader, List <SendEmailEndProject> > func = (reader) =>
            {
                List <SendEmailEndProject> workerSendEmail = new List <SendEmailEndProject>();
                while (reader.Read())
                {
                    workerSendEmail.Add(ConvertSendEmail.convertDBtoProjects(reader));
                }
                return(workerSendEmail);
            };
            List <SendEmailEndProject> workerNotFinish = DBAccess.RunReader(func, "SendEmailEndProject", new List <string>(), new List <string>());

            foreach (var item in workerNotFinish)
            {
                string message = $"Hi {item.UserName}<br/> the project {item.nameProject} the deadline tommorow You did {item.HourDo} from {item.hoursForProject}, You stay to do {item.stayToDo} hours ";
                LogicManager.SendEmail(item.EmailManager, item.EmailUser, "end dead line", message);
            }
            var d = workerNotFinish.GroupBy(p => p.EmailManager);

            foreach (var item in d)
            {
                string message = "";
                item.ToList().ForEach(user =>
                {
                    message += user.UserName + " ";
                });
                LogicManager.SendEmail("*****@*****.**", item.Key, "end dead line", message);
            }
        }
        /// <summary>
        ///Send email day before dead line
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public static List <SendEmailEndProject> SendEmailDateProjectEnd()
        {
            Func <MySqlDataReader, List <SendEmailEndProject> > func = (reader) =>
            {
                List <SendEmailEndProject> workerSendEmail = new List <SendEmailEndProject>();
                while (reader.Read())
                {
                    workerSendEmail.Add(ConvertSendEmail.convertDBtoProjects(reader));
                }
                return(workerSendEmail);
            };

            return(DBAccess.RunReader(func, "SendEmailEndProject", new List <string>(), new List <string>()));
        }