private bool ValidateSchedule(UploadedFile attachment, FlightScheduleEngine scheduleEngine, User user, string[] emails)
        {
            bool valid = true;
            //validate before upload
            var missingEquipmentCode = scheduleEngine.ValidateSchedulePlan(attachment.InputStream);

            if (missingEquipmentCode.Count > 0)
            {
                //Loop with comma separated value
                var missingCode = string.Empty;
                for (int j = 0; j < missingEquipmentCode.Count; j++)
                {
                    missingCode += missingEquipmentCode[j] + ",";
                }

                //send email
                var misingEquipmentMessage = EmailHelper.MissingEquipmentEmailTemplate;
                misingEquipmentMessage = EmailHelper.ConvertMail2(misingEquipmentMessage, missingCode, "\\[EQUIPMENTS\\]");

                EmailHelper.SendMail(user.Username, "*****@*****.**", "EMMA- Flight Schedule Validation - " + attachment.FileName, misingEquipmentMessage);

                foreach (var email in emails)
                {
                    if (!string.IsNullOrEmpty(email))
                    {
                        EmailHelper.SendMail(email, "*****@*****.**", "EMMA- Flight Schedule Validation - " + attachment.FileName, misingEquipmentMessage);
                    }
                }

                valid = false;
            }
            return(valid);
        }
        private bool ValidateSchedule()
        {
            bool valid = true;
            FlightScheduleEngine scheduleEngine = new FlightScheduleEngine();

            //validate before upload
            Stream stream = System.IO.File.OpenRead(txtBoxFileName.Text);

            var missingEquipmentCode = scheduleEngine.ValidateSchedulePlan(stream);

            if (missingEquipmentCode.Count > 0)
            {
                //Loop with comma separated value
                var missingCode = string.Empty;
                for (int j = 0; j < missingEquipmentCode.Count; j++)
                {
                    missingCode += missingEquipmentCode[j] + ",";
                }


                MessageBox.Show("Invalid schedule - Missing Equipments: " + missingCode);

                valid = false;
            }
            return(valid);
        }