MainWindow.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using GUI.IO_Modules;
using GUI.Datatypes;
using System.IO;
using Mosel;

namespace GUI
{
    public partial class MainWindow : Form
    {
        String[] locationNames;
        LocationCB[] locations;
        Dictionary<String, int> locationDictionary = new Dictionary<String, int>();
        List<MachineCB>[] machinesAtLocation;
        List<ProductCB>[] productsAtMachine;
        FlowLayoutPanel[] LocationFlowLayouts;
        FlowLayoutPanel[] MachineFlowLayouts;
        FlowLayoutPanel[] ProductFlowLayouts;

        
        // 86bit
        //string resourcesFolder = Directory.GetParent(Directory.GetParent(Directory.GetCurrentDirectory()).ToString()) + "\\Resources";
        // 64bit
        string resourcesFolder = Directory.GetParent(Directory.GetParent(Directory.GetParent(Directory.GetCurrentDirectory()).ToString()).ToString()) + "\\Resources";


        //86bit
        //string excelFileFolder = Directory.GetParent(Directory.GetParent(Directory.GetCurrentDirectory()).ToString()) + "\\Resources";
        //64bit
        string excelFilePath = Directory.GetParent(Directory.GetParent(Directory.GetParent(Directory.GetCurrentDirectory()).ToString()).ToString()) + "\\Resources\\Dataset.xlsx";

        DateTime startTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, 0, 0);
        DateTime endTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, 0, 0).AddHours(1);
        bool ExcelFileReadIn = false;

        private ModelData md;

        private int width = 145;

        public MainWindow()
        {
            InitializeComponent();  // needed
            setup();                // create all the elements that the GUI needs
        }

        public void setup()
        {
            numericUpDown2.Value = DateTime.Now.Hour;
            numericUpDown1.Value = DateTime.Now.Hour;

            CheckboxCreator creator = new CheckboxCreator(excelFilePath);
            try
            {
                // Try to extract Location/Machine/Product Data from Excel file
                creator.Create();
            }
            catch (Exception e)
            {
                // if that fails, show the Exception thrown
                ThreadExceptionDialog ted = new ThreadExceptionDialog(e);
                ted.ShowDialog();
            }
            
            // get all the Data from the CheckboxCreator
            locationDictionary = creator.GetLocationDict();
            locations = creator.GetAllLocations();
            locationNames = creator.GetLocationNames();
            machinesAtLocation = creator.GetAllMachines();
            productsAtMachine = creator.GetAllProducts();

            // Have a FlowLayoutPanel for each Location, which then will be added to a wrapping FlowLayoutPanel (flowLayoutPanelLocations)
            LocationFlowLayouts = new FlowLayoutPanel[locations.Length];
            for (int i = 0; i < locations.Length; i++)
            {
                // adjust design of the location checkboxes
                locations[i].MinimumSize = new Size(width, 0);      //adjust width
                locations[i].CheckStateChanged += new EventHandler(LocationCheckBoxChanged);    // add custom EventHandler to each Checkbox
                locations[i].Click += new EventHandler(LocationCheckBoxClicked);                // if Checkbox is clicked, show TimeslotDialog
                LocationFlowLayouts[i] = new FlowLayoutPanel();
                LocationFlowLayouts[i].Padding = new Padding(0, 3, 0, 3);
                LocationFlowLayouts[i].Size = new Size(width, flowLayoutPanelLocations.Size.Height - flowLayoutPanelLocations.Padding.Top - flowLayoutPanelLocations.Padding.Bottom - 6);
                LocationFlowLayouts[i].Controls.Add(locations[i]);              //add Checkbox to FlowLayoutPanel
                flowLayoutPanelLocations.Controls.Add(LocationFlowLayouts[i]);
            }

            // Mostly the same as for the Locations
            MachineFlowLayouts = new FlowLayoutPanel[locations.Length];
            for (int i = 0; i < locations.Length; i++)
            {
                MachineFlowLayouts[i] = new FlowLayoutPanel();
                MachineFlowLayouts[i].Padding = new Padding(0, 3, 0, 3);
                MachineFlowLayouts[i].Size = new Size(width, flowLayoutPanelMachines.Size.Height - flowLayoutPanelMachines.Padding.Top - flowLayoutPanelMachines.Padding.Bottom - 6);
                MachineFlowLayouts[i].FlowDirection = FlowDirection.TopDown;    
                MachineFlowLayouts[i].AutoScroll = true;        // if too much Machines are in one Panel, add scrollbar
                MachineFlowLayouts[i].WrapContents = false;
                MachineFlowLayouts[i].MaximumSize = new Size(width, 10000);
                flowLayoutPanelMachines.Controls.Add(MachineFlowLayouts[i]);
                foreach (MachineCB mac in machinesAtLocation[i])
                {
                    mac.CheckStateChanged += new EventHandler(MachineCheckBoxChanged);
                    mac.Click += new EventHandler(MachineCheckBoxClicked);
                    MachineFlowLayouts[i].Controls.Add(mac);
                }
            }

            // Mostly the same as for the Locations
            ProductFlowLayouts = new FlowLayoutPanel[locations.Length];
            for (int i = 0; i < locations.Length; i++)
            {
                ProductFlowLayouts[i] = new FlowLayoutPanel();
                ProductFlowLayouts[i].Padding = new Padding(0, 3, 0, 3);
                ProductFlowLayouts[i].Size = new Size(width, flowLayoutPanelProducts.Size.Height - flowLayoutPanelProducts.Padding.Top - flowLayoutPanelProducts.Padding.Bottom - 6);
                ProductFlowLayouts[i].FlowDirection = FlowDirection.TopDown;
                ProductFlowLayouts[i].AutoScroll = true;
                ProductFlowLayouts[i].WrapContents = false;
                ProductFlowLayouts[i].MaximumSize = new Size(width, 10000);
                flowLayoutPanelProducts.Controls.Add(ProductFlowLayouts[i]);
                foreach (MachineCB mac in machinesAtLocation[i])
                {
                    ProductFlowLayouts[i].Controls.Add(new Label() { Text = mac.Name });
                    foreach (ProductCB prod in mac.getProducts())
                    {
                        prod.CheckStateChanged += new EventHandler(ProductCheckBoxChanged);
                        ProductFlowLayouts[i].Controls.Add(prod);
                    }
                }
            }

            // make the folder Textbox readonly and display that excelFileFoler String
            textBox1.ReadOnly = true;           
            textBox1.Text = excelFilePath;
        }


        private void LocationCheckBoxChanged(object sender, EventArgs e)
        {
            // logic for LocationCheckboxes (mark all of the machines if location is checked, etc.)
            LocationCB loc = (LocationCB)sender;
            if (loc.CheckState.Equals(CheckState.Checked))
            {
                loc.checkAllMachines();
            }

            if (loc.CheckState.Equals(CheckState.Unchecked))
            {
                loc.uncheckAllMachines();
            }

            if (loc.CheckState.Equals(CheckState.Indeterminate))
            {
                if (loc.allChildrenChecked() == 2.00000)
                {
                    loc.CheckState = CheckState.Unchecked;
                }
                else
                {
                    if (loc.allChildrenChecked() == 0.00000)
                    {
                        loc.CheckState = CheckState.Checked;
                    }
                }
            }

        }


        private void MachineCheckBoxChanged(object sender, EventArgs e)
        {
            // logic for MachineCheckboxes (mark all of the products if machine is checked, etc.)
            MachineCB mac = (MachineCB)sender;
            if (mac.CheckState.Equals(CheckState.Checked))
            {
                mac.checkAllProducts();
                if (mac.getLocation().allChildrenChecked()== 2.00000)
                {
                    mac.getLocation().CheckState = CheckState.Checked;
                }
                else
                {
                    mac.getLocation().CheckState = CheckState.Indeterminate;
                }
            }

            if (mac.CheckState.Equals(CheckState.Unchecked))
            {
                mac.uncheckAllProducts();
                if (mac.getLocation().allChildrenChecked() == 0.00000)
                {
                    mac.getLocation().CheckState = CheckState.Unchecked;
                }
                else
                {
                    mac.getLocation().CheckState = CheckState.Indeterminate;
                }
            }

            if (mac.CheckState.Equals(CheckState.Indeterminate))
            {
                if (mac.allChildrenChecked() == 2.00000)
                {
                    mac.CheckState = CheckState.Unchecked;
                }
                else
                {
                    if (mac.allChildrenChecked() == 0.00000)
                    {
                        mac.CheckState = CheckState.Checked;
                    }
                    else
                    {
                        mac.getLocation().CheckState = CheckState.Indeterminate;
                    }
                }
            }
        }


        private void MachineCheckBoxClicked(object sender, EventArgs e)
        {
            // if clicked, show the TimeSlotDialog for the corresponding Machine
            MachineCB mac = (MachineCB)sender;
            if (mac.CheckState.Equals(CheckState.Checked))
            {
                var form2 = new TimeslotDialog(mac, startTime, endTime);
                form2.ShowDialog();
            }
        }


        private void LocationCheckBoxClicked(object sender, EventArgs e)
        {
            // if clicked, show the TimeSlotDialog for the corresponding Location
            LocationCB c = (LocationCB)sender;
            if (c.CheckState.Equals(CheckState.Checked))
            {
                var form2 = new TimeslotDialog(c, startTime, endTime);
                form2.ShowDialog();
            }
        }


        private void ProductCheckBoxChanged(object sender, EventArgs e)
        {
            // logic for LocationCheckboxes
            ProductCB p = (ProductCB)sender;
            if (p.CheckState == CheckState.Checked)
            {
                if (p.getMachine().allChildrenChecked() == 2.00000)
                {
                    p.getMachine().CheckState = CheckState.Checked;
                }
                else
                {
                    p.getMachine().CheckState = CheckState.Indeterminate;
                }
            }

            if (p.CheckState == CheckState.Unchecked)
            {
                if (p.getMachine().allChildrenChecked() == 0.00000)
                {
                    p.getMachine().CheckState = CheckState.Unchecked;
                }
                else
                {
                    p.getMachine().CheckState = CheckState.Indeterminate;
                }
            }
        }


        private void button1_Click(object sender, EventArgs e)
        {
            // if "Durchsuchen" is clicked, let the user browse for a folder that contains "Dataset.xlsx"
            while (true) {
                OpenFileDialog ofd = new OpenFileDialog();
                ofd.Filter = "Exceldateien | *.xlsx";
                DialogResult result = ofd.ShowDialog();
                string s = "";

                if (result == DialogResult.Cancel)
                {
                    // abort
                    break;
                }

                if (result == DialogResult.OK)
                {
                    s = ofd.FileName;
                }

                if (s.EndsWith("TestDatei.xlsx"))
                {
                    // if so, make the selected folder the one we operate on
                    excelFilePath = s;
                    textBox1.Text = s;
                    // clear Layout and create new Checkboxes etc.
                    clear();
                    setup();
                    break;
                }
                else
                {
                    // if not, let user know and make them select another folder (or abort)
                    MessageBox.Show("Datei muss auf *Dataset.xlsx enden.");
                }
            }
        }

        public void clear()
        {
            // clear all elements
            locationDictionary.Clear();
            locationNames = null;
            locations = null;
            machinesAtLocation = null;
            productsAtMachine = null;
            ExcelFileReadIn = false;
            

            foreach (FlowLayoutPanel f in LocationFlowLayouts)
            {
                f.Dispose();
            }

            foreach (FlowLayoutPanel f in MachineFlowLayouts)
            {
                f.Dispose();
            }

            foreach (FlowLayoutPanel f in ProductFlowLayouts)
            {
                f.Dispose();
            }

            // activate Garbage Collector
            GC.Collect();
        }

        private void UpdateStartTime()
        {
            DateTime sd = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day, (int)numericUpDown1.Value, 0, 0);
            startTime = sd;
            // if the start time is at the same time or after the end time, we update the endtime and the display of end time
            //We update it so that the endTime is the startTime + 1 hour
            if (sd.CompareTo(endTime) >= 0)
            {
                endTime = startTime.AddHours(1);
                numericUpDown2.Value = endTime.Hour;
                dateTimePicker2.Value = new DateTime(endTime.Year, endTime.Month, endTime.Day);
            }

            //update number of timeslots for each machine and Location
            this.UpdateNumberOfTimeslots();
        }

        private void numericUpDown1_ValueChanged(object sender, EventArgs e)
        {
            UpdateStartTime();
        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            UpdateStartTime();
        }

        private void UpdateEndtime()
        {
            DateTime et = new DateTime(dateTimePicker2.Value.Year, dateTimePicker2.Value.Month, dateTimePicker2.Value.Day, (int)numericUpDown2.Value, 0, 0);
            //If the end time asked in the GUI is valid, we update the attribute endTime
            if (et.CompareTo(startTime)>0)
            {
                endTime = et;
            }
            //Else, we set the end time and the display to the start time + 1 hour
            else
            {
                endTime = startTime.AddHours(1);
                numericUpDown2.Value = endTime.Hour;
                dateTimePicker2.Value = new DateTime(endTime.Year, endTime.Month, endTime.Day);
            }

            //update number of timeslots for each machine and Location
            this.UpdateNumberOfTimeslots();
        }

        private void numericUpDown2_ValueChanged(object sender, EventArgs e)
        {
            UpdateEndtime();
        }

        private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
        {
            UpdateEndtime();
        }

        private void UpdateNumberOfTimeslots()
        {
            int num = (int)Math.Ceiling(endTime.Subtract(startTime).TotalHours);
            if (machinesAtLocation != null)
            {
                foreach (List<MachineCB> l in machinesAtLocation)
                {
                    foreach (MachineCB m in l)
                    {
                        m.setNumberOfTimeslots(num);
                    }
                }
            }

            if (locations != null)
            {
                for (int i = 0; i < locations.Length; i++)
                {
                    locations[i].setNumberOfTimeslots(num);
                }
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //read in ModelData from Excel file (once!)
            if (!ExcelFileReadIn)
            {
                md = new ModelData(excelFilePath, locationNames, locations, locationDictionary);
                ExcelFileReadIn = true;
            }

            // reformulate data so that it matches the .dat format we need for the model
            DatFileCreator dfc = new DatFileCreator(md, startTime, endTime);
            double d = 1;
            if (dfc.createDatFile(d))
            {
                // if there was no problem writing the Datafile, i.e. maxN>0

                // Initialize Mosel
                XPRM mosel = XPRM.Init();

                // Compile and load the Mosel model
                XPRMModel model = mosel.CompileAndLoad(resourcesFolder + "\\Test.mos");

                // Bind a stream based on the BurglarDat data to the name 'BurglarIni' 
                // where the model will expect to find its initialization data
                model.Bind("ModelIni", new StringReader(dfc.Data));
                model.Bind("ModelIniSecond", new StringReader(dfc.Data));

                // Redirect the model’s output to a custom TextWriter
                MoselTextWriter modelOut = new MoselTextWriter();
                model.SetDefaultStream(XPRMStreamType.F_OUTPUT, modelOut);
                // Redirect the error output to a custom TextWriter
                MoselTextWriter errorOut = new MoselTextWriter();
                model.SetDefaultStream(XPRMStreamType.F_ERROR, errorOut);


                // Pass data location as a parameter to the model 
                // Initializations block in .mos is separated into two blocks, therefore we have to hand two StreamReader to it.
                model.SetExecParam("DATAFILE", "dotnet:ModelIni");
                model.SetExecParam("SECONDDATAFILE", "dotnet:ModelIniSecond");
                model.Run();

                if (errorOut.sb.Length > 0)
                {
                    MessageBox.Show(errorOut.sb.ToString(), "ERROR in Mosel");
                }
                else
                {
                    MessageBox.Show(modelOut.sb.ToString(), "Mosel Output");
                }
#if DEBUG
                dfc.export();
#endif
            }
            else
            {
                // if not show user what went wrong
                MessageBox.Show("Es muss mindestens eine Bestellung im Planungshorizont liegen.");
            }
        }
    }
}