using System.Linq;

using sharpknife.Engines;

namespace sharpknife.Commands
{
    public class UpdateBalanceCommand : Command
    {
        public UpdateBalanceCommand()
        {
        }

        public override void Execute()
        {
            base.Execute();

            using (databaseEntities context = new databaseEntities())
            {
                var query = (from s in context.PTCSource where !string.IsNullOrEmpty(s.BalanceUrl) && s.Enabled == true select s);

                foreach (PTCSource source in query)
                {
                    BalanceCommand command = new BalanceCommand(source.Name);
                    CommandEngine commandEngine = CommandEngine.GetEngine();
                    commandEngine.Commands.Add(command);
                }
            }

            Status = StatusCode.Completed;
        }
    }
}