示例#1
0
        private void frmSelReceipeDefinitions_Load(object sender, EventArgs e)
        {
            formloaded = false;
            parms      = new DyeQueryParameters();

            using (var context = new TTI2Entities())
            {
                var ExistingGreige = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
                foreach (var record in ExistingGreige)
                {
                    cmboQualities.Items.Add(new DyeHouse.CheckComboBoxItem(record.TLGreige_Id, record.TLGreige_Description, false));
                }

                var ExistDefinitions = context.TLDYE_RecipeDefinition.ToList();
                foreach (var record in ExistDefinitions)
                {
                    cmboReceipeDefintions.Items.Add(new DyeHouse.CheckComboBoxItem(record.TLDYE_DefinePk, record.TLDYE_DefineDescription, false));
                }

                var ExistWeight = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
                foreach (var Record in ExistWeight)
                {
                    cmboColours.Items.Add(new DyeHouse.CheckComboBoxItem(Record.Col_Id, Record.Col_Display, false));
                }

                //--------------------------------------------------------
                // wire up the check state changed event
                //--------------------------------------------------------------------------------------------------------
                this.cmboColours.CheckStateChanged           += new System.EventHandler(this.cmboColours_CheckStateChanged);
                this.cmboQualities.CheckStateChanged         += new System.EventHandler(this.cmboQualities_CheckStateChanged);
                this.cmboReceipeDefintions.CheckStateChanged += new System.EventHandler(this.cmboReceipeDefintions_CheckStateChanged);
            }
            formloaded = true;
        }
示例#2
0
        private void frmViewDyeOrder_Load(object sender, EventArgs e)
        {
            FormLoaded    = false;
            DyeParameters = new DyeQueryParameters();

            using (var context = new TTI2Entities())
            {
                var Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
                foreach (var Customer in Customers)
                {
                    comboCustomers.Items.Add(new DyeHouse.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
                }

                var Qualitys = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
                foreach (var Quality in Qualitys)
                {
                    comboQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.TLGreige_Id, Quality.TLGreige_Description, false));
                }

                var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
                foreach (var Colour in Colours)
                {
                    comboColour.Items.Add(new DyeHouse.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
                }

                var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
                foreach (var Style in Styles)
                {
                    comboStyles.Items.Add(new DyeHouse.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
                }
            }
            FormLoaded = true;
        }
示例#3
0
        public IQueryable <TLKNI_GreigeCommissionTransctions> CommissionTransactions(DyeQueryParameters parameters)
        {
            var Transactions = _context.TLKNI_GreigeCommissionTransctions.Where(x => x.GreigeCom_Transdate >= parameters.FromDate && x.GreigeCom_Transdate <= parameters.ToDate).OrderBy(x => x.GreigeCom_GrnNo).AsQueryable();

            if (parameters.Customers.Count > 0)
            {
                var CustomerPredicate = PredicateBuilder.False <TLKNI_GreigeCommissionTransctions>();
                foreach (var Customer in parameters.Customers)
                {
                    var temp = Customer;
                    CustomerPredicate = CustomerPredicate.Or(s => s.GreigeCom_Customer_FK == temp.Cust_Pk);
                }

                Transactions = Transactions.AsExpandable().Where(CustomerPredicate);
            }

            if (parameters.FabricQualities.Count > 0)
            {
                var QualityPredicate = PredicateBuilder.False <TLKNI_GreigeCommissionTransctions>();
                foreach (var Quality in parameters.FabricQualities)
                {
                    var temp = Quality;
                    QualityPredicate = QualityPredicate.Or(s => s.GreigeCom_ProductType_FK == Quality.GQ_Pk);
                }

                Transactions = Transactions.AsExpandable().Where(QualityPredicate);
            }

            return(Transactions);
        }
示例#4
0
        private void cmboProductCodes_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBox oCmbo = sender as ComboBox;

            if (oCmbo != null && formloaded)
            {
                var selected = (TLDYE_RecipeDefinition)cmboProductCodes.SelectedItem;
                if (selected != null)
                {
                    dataGridView1.Rows.Clear();
                    txtProductCode.Text = selected.TLDYE_DefineCode;
                    //cmboGreigeQuality.SelectedValue = selected.TLDYE_DefineGreigeQual_Fk;
                    if (selected.TLDYE_ColorChart_FK != null)
                    {
                        cmboColours.SelectedValue = selected.TLDYE_ColorChart_FK;
                    }
                    txtProgramLoad.Text   = selected.TLDYE_ProgramLoad.ToString();
                    txtProgramVolume.Text = selected.TLDYE_LiquidLoad.ToString();
                    lNew = false;

                    using (var context = new TTI2Entities())
                    {
                        var ExistingData = context.TLDYE_DefinitionDetails.Where(x => x.TLDYED_Receipe_FK == selected.TLDYE_DefinePk).ToList();
                        foreach (var row in ExistingData)
                        {
                            var index = dataGridView1.Rows.Add();
                            dataGridView1.Rows[index].Cells[0].Value = row.TLDYED_PK;
                            dataGridView1.Rows[index].Cells[1].Value = row.TLDYED_Cosumables_FK;
                            dataGridView1.Rows[index].Cells[2].Value = row.TLDYED_LiqCalc;
                            dataGridView1.Rows[index].Cells[3].Value = row.TLDYED_MELFC;
                            dataGridView1.Rows[index].Cells[4].Value = row.TLDYED_LiqRatio;

                            MandRows = core.PopulateArray(MandatoryRows.Length, true);
                            fieldEntered.Add(new DATA(index, MandRows));
                        }

                        this.cmboGreigeQuality.Items.Clear();
                        QueryParms = new DyeQueryParameters();

                        var GreigeQualities = context.TLADM_GreigeQuality.OrderBy(x => x.GQ_Description).ToList();
                        foreach (var Quality in GreigeQualities)
                        {
                            var Existing = context.TLDYE_ReceipeGreigeQual.Where(x => x.TLGQ_GreigeQuality_FK == Quality.GQ_Pk && x.TLGQ_ReceipeDef_FK == selected.TLDYE_DefinePk).FirstOrDefault();
                            if (Existing != null)
                            {
                                cmboGreigeQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.GQ_Pk, Quality.GQ_Description, true));
                                QueryParms.FabricQualities.Add(repo.LoadFabricQuality(Quality.GQ_Pk));
                            }
                            else
                            {
                                cmboGreigeQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.GQ_Pk, Quality.GQ_Description, false));
                            }
                        }
                    }
                }
            }
        }
示例#5
0
        public IQueryable <TLDYE_DyeOrder> SelectActiveDyeOrders(DyeQueryParameters parameters)
        {
            var DO = _context.TLDYE_DyeOrder.Where(x => !x.TLDYO_Closed).AsQueryable();

            if (parameters.Customers.Count > 0)
            {
                var CustomerPredicate = PredicateBuilder.False <TLDYE_DyeOrder>();
                foreach (var Customer in parameters.Customers)
                {
                    var temp = Customer;
                    CustomerPredicate = CustomerPredicate.Or(s => s.TLDYO_Customer_FK == temp.Cust_Pk);
                }

                DO = DO.AsExpandable().Where(CustomerPredicate);
            }
            if (parameters.Colours.Count > 0)
            {
                var ColourPredicate = PredicateBuilder.False <TLDYE_DyeOrder>();

                foreach (var colour in parameters.Colours)
                {
                    var temp = colour;
                    ColourPredicate = ColourPredicate.Or(s => s.TLDYO_Colour_FK == temp.Col_Id);
                }

                DO = DO.AsExpandable().Where(ColourPredicate);
            }
            if (parameters.Styles.Count > 0)
            {
                var StylePredicate = PredicateBuilder.False <TLDYE_DyeOrder>();

                foreach (var Style in parameters.Styles)
                {
                    var temp = Style;
                    StylePredicate = StylePredicate.Or(s => s.TLDYO_Style_FK == temp.Sty_Id);
                }

                DO = DO.AsExpandable().Where(StylePredicate);
            }
            if (parameters.Qualities.Count > 0)
            {
                var QualityPredicate = PredicateBuilder.False <TLDYE_DyeOrder>();

                foreach (var Quality in parameters.Qualities)
                {
                    var temp = Quality;
                    QualityPredicate = QualityPredicate.Or(s => s.TLDYO_Greige_FK == temp.TLGreige_Id);
                }

                DO = DO.AsExpandable().Where(QualityPredicate);
            }
            return(DO);
        }
示例#6
0
        public IQueryable <TLDYE_DyeBatch> SelectDyeBatches(DyeQueryParameters parameters)
        {
            var DB = _context.TLDYE_DyeBatch.Where(x => !x.DYEB_Transfered).AsQueryable();

            if (parameters.DyeBatches.Count > 0)
            {
                var BatchesPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();
                foreach (var DyeBatch in parameters.DyeBatches)
                {
                    var temp = DyeBatch;
                    BatchesPredicate = BatchesPredicate.Or(s => s.DYEB_Pk == temp.DYEB_Pk);
                }
                DB = DB.AsExpandable().Where(BatchesPredicate);
            }
            if (parameters.Customers.Count > 0)
            {
                var CustomerPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();
                foreach (var Customer in parameters.Customers)
                {
                    var temp = Customer;
                    CustomerPredicate = CustomerPredicate.Or(s => s.DYEB_Customer_FK == temp.Cust_Pk);
                }
                DB = DB.AsExpandable().Where(CustomerPredicate);
            }
            if (parameters.Qualities.Count != 0)
            {
                var QualitiesPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();

                foreach (var Qual in parameters.Qualities)
                {
                    QualitiesPredicate = QualitiesPredicate.Or(s => s.DYEB_Greige_FK == Qual.TLGreige_Id);
                }

                DB.AsExpandable().Where(QualitiesPredicate);
            }
            if (parameters.Colours.Count > 0)
            {
                var ColourPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();

                foreach (var colour in parameters.Colours)
                {
                    var temp = colour;
                    ColourPredicate = ColourPredicate.Or(s => s.DYEB_Colour_FK == temp.Col_Id);
                }

                DB = DB.AsExpandable().Where(ColourPredicate);
            }
            return(DB);
        }
示例#7
0
        public IQueryable <TLDYE_DyeBatchDetails> SelectDyeBatchDetails(DyeQueryParameters parameters)
        {
            var DBDetails = _context.TLDYE_DyeBatchDetails.AsQueryable();

            if (parameters.DyeBatchDetails.Count > 0)
            {
                var DyeBatchDetPredicate = PredicateBuilder.False <TLDYE_DyeBatchDetails>();
                foreach (var BatchDetail in parameters.DyeBatchDetails)
                {
                    var Temp = BatchDetail;
                    DyeBatchDetPredicate = DyeBatchDetPredicate.Or(s => s.DYEBD_DyeBatch_FK == Temp.DYEBD_DyeBatch_FK);
                }
            }
            return(DBDetails);
        }
示例#8
0
        void SetUp()
        {
            formloaded          = false;
            txtProductCode.Text = string.Empty;

            QueryParms = new DyeQueryParameters();

            rbStandard.Checked = true;

            lNew = true;

            using (var context = new TTI2Entities())
            {
                cmboColours.DataSource    = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
                cmboColours.DisplayMember = "Col_Display";
                cmboColours.ValueMember   = "Col_Id";
                cmboColours.SelectedValue = -1;

                cmboProductCodes.DataSource    = context.TLDYE_RecipeDefinition.Where(x => x.TLDYE_StandardReceipe).OrderBy(x => x.TLDYE_DefineCode).ToList();
                cmboProductCodes.DisplayMember = "TLDYE_DefineDescription";
                cmboProductCodes.ValueMember   = "TLDYE_DefinePK";
                cmboProductCodes.SelectedValue = -1;

                var GreigeQualitys = context.TLADM_GreigeQuality.OrderBy(x => x.GQ_Description).ToList();
                foreach (var Quality in GreigeQualitys)
                {
                    cmboGreigeQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.GQ_Pk, Quality.GQ_Description, false));
                }

                oCmboA.DataSource    = context.TLADM_ConsumablesDC.OrderBy(x => x.ConsDC_Description).ToList();
                oCmboA.DisplayMember = "ConsDC_Description";
                oCmboA.ValueMember   = "ConsDC_Pk";
            }

            txtProgramLoad.KeyPress += core.txtWin_KeyPress;
            txtProgramLoad.KeyDown  += core.txtWin_KeyDownJI;
            txtProgramLoad.Text      = "0";

            txtProgramVolume.KeyPress += core.txtWin_KeyPress;
            txtProgramVolume.KeyDown  += core.txtWin_KeyDownJI;
            txtProgramVolume.Text      = "0";

            MandSelected = core.PopulateArray(MandatoryFields.Length, false);
            formloaded   = true;
        }
示例#9
0
        public IQueryable <TLADM_Colours> PPSColour(DyeQueryParameters parameters)
        {
            var SOH = _context.TLADM_Colours.AsQueryable();

            if (parameters.Colours.Count > 0)
            {
                var ReceipePredicate = PredicateBuilder.False <TLADM_Colours>();
                foreach (var Quality in parameters.Colours)
                {
                    var temp = Quality;
                    ReceipePredicate = ReceipePredicate.Or(s => s.Col_Id == temp.Col_Id);
                }

                SOH = SOH.AsExpandable().Where(ReceipePredicate);
            }

            return(SOH);
        }
示例#10
0
        public IQueryable <TLADM_ConsumablesDC> SelectConsumables(DyeQueryParameters parameters)
        {
            var Consumables = _context.TLADM_ConsumablesDC.Where(x => !(bool)x.ConsDC_Discontinued).AsQueryable();

            if (parameters.Consummables.Count > 0)
            {
                var ConsumablesPredicate = PredicateBuilder.False <TLADM_ConsumablesDC>();
                foreach (var Consumable in parameters.Consummables)
                {
                    var temp = Consumable;
                    ConsumablesPredicate = ConsumablesPredicate.Or(s => s.ConsDC_Pk == temp.ConsDC_Pk);
                }

                Consumables = Consumables.AsExpandable().Where(ConsumablesPredicate);
            }

            return(Consumables);
        }
示例#11
0
        public IQueryable <TLDYE_DyeBatch> SelectViewDyeBatches(DyeQueryParameters parameters)
        {
            var DB = _context.TLDYE_DyeBatch.Where(x => x.DYEB_BatchDate >= parameters.FromDate && x.DYEB_BatchDate <= parameters.ToDate && !x.DYEB_Closed && !x.DYEB_CommissinCust).AsQueryable();

            if (parameters.FabricQualities.Count > 0)
            {
                var QualityPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();

                foreach (var Quality in parameters.FabricQualities)
                {
                    var temp = Quality;
                    QualityPredicate = QualityPredicate.Or(s => s.DYEB_Pk == temp.GQ_Pk);
                }

                DB = DB.AsExpandable().Where(QualityPredicate);
            }

            if (parameters.Customers.Count > 0)
            {
                var CustomerPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();
                foreach (var Customer in parameters.Customers)
                {
                    var temp = Customer;
                    CustomerPredicate = CustomerPredicate.Or(s => s.DYEB_Customer_FK == temp.Cust_Pk);
                }

                DB = DB.AsExpandable().Where(CustomerPredicate);
            }

            if (parameters.Colours.Count > 0)
            {
                var ColourPredicate = PredicateBuilder.False <TLDYE_DyeBatch>();

                foreach (var colour in parameters.Colours)
                {
                    var temp = colour;
                    ColourPredicate = ColourPredicate.Or(s => s.DYEB_Colour_FK == temp.Col_Id);
                }

                DB = DB.AsExpandable().Where(ColourPredicate);
            }
            return(DB);
        }
示例#12
0
        public IQueryable <TLDYE_RecipeDefinition> SOHQuery(DyeQueryParameters parameters)
        {
            var SOH = _context.TLDYE_RecipeDefinition.Where(x => x.TLDYE_ColorChart_FK != null).AsQueryable();

            if (parameters.Colours.Count > 0)
            {
                var ReceipePredicate = PredicateBuilder.False <TLDYE_RecipeDefinition>();
                foreach (var Colour in parameters.Colours)
                {
                    var temp = Colour;
                    ReceipePredicate = ReceipePredicate.Or(s => s.TLDYE_ColorChart_FK == temp.Col_Id);
                }

                SOH = SOH.AsExpandable().Where(ReceipePredicate);
            }

            if (parameters.RecDefinitions.Count > 0)
            {
                var RecDefPredicate = PredicateBuilder.False <TLDYE_RecipeDefinition>();
                foreach (var Definition in parameters.RecDefinitions)
                {
                    var temp = Definition;
                    RecDefPredicate = RecDefPredicate.Or(s => s.TLDYE_DefinePk == temp.TLDYE_DefinePk);
                }

                SOH = SOH.AsExpandable().Where(RecDefPredicate);
            }

            if (parameters.Qualities.Count > 0)
            {
                var QualPredicate = PredicateBuilder.False <TLDYE_RecipeDefinition>();
                foreach (var Quality in parameters.Qualities)
                {
                    var temp = Quality;
                    // QualPredicate = QualPredicate.Or(s => s.TLDYE_DefineGreigeQual_Fk == temp.TLGreige_Id);
                }

                SOH = SOH.AsExpandable().Where(QualPredicate);
            }

            return(SOH);
        }
示例#13
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null)
            {
                DyeHouse.DyeRepository      repo       = new DyeRepository();
                DyeHouse.DyeQueryParameters QueryParms = new DyeQueryParameters();

                QueryParms.FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                QueryParms.ToDate   = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                QueryParms.ToDate   = QueryParms.ToDate.AddHours(23);

                frmDyeViewReport vRep = new frmDyeViewReport(44, QueryParms);
                int h = Screen.PrimaryScreen.WorkingArea.Height;
                int w = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);
            }
        }
        private void frmViewCommissionReceipts_Load(object sender, EventArgs e)
        {
            FormLoaded    = false;
            DyeParameters = new DyeQueryParameters();

            using (var context = new TTI2Entities())
            {
                var Customers = context.TLADM_CustomerFile.Where(x => x.Cust_CommissionCust).OrderBy(x => x.Cust_Description).ToList();
                foreach (var Customer in Customers)
                {
                    comboCustomers.Items.Add(new DyeHouse.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
                }

                var Qualitys = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
                foreach (var Quality in Qualitys)
                {
                    comboQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.TLGreige_Id, Quality.TLGreige_Description, false));
                }
            }
            FormLoaded = true;
        }
示例#15
0
        private void frmProductionPlanDC_Load(object sender, EventArgs e)
        {
            formloaded = false;

            repo       = new DyeRepository();
            QueryParms = new DyeQueryParameters();

            using (var context = new TTI2Entities())
            {
                var Entries = context.TLDYE_DyeBatch.Where(x => !x.DYEB_Allocated && !x.DYEB_Closed).OrderBy(x => x.DYEB_BatchNo).ToList();
                foreach (var Entry in Entries)
                {
                    cmboDyeBatches.Items.Add(new DyeHouse.CheckComboBoxItem(Entry.DYEB_Pk, Entry.DYEB_BatchNo, false));
                }

                cmboDyeBatches.ValueMember   = "DYEB_PK";
                cmboDyeBatches.DisplayMember = "DYEB_BatchNo";
            }

            formloaded = true;
        }
示例#16
0
        private void frmTransferToDyeHouse_Load(object sender, EventArgs e)
        {
            formloaded = false;
            QueryParms = new DyeQueryParameters();

            using (var context = new TTI2Entities())
            {
                var Batches = context.TLDYE_DyeBatch.Where(x => !x.DYEB_Transfered).ToList();
                foreach (var Batch in Batches)
                {
                    cmboBatches.Items.Add(new DyeHouse.CheckComboBoxItem(Batch.DYEB_Pk, Batch.DYEB_BatchNo, false));
                }

                var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
                foreach (var Colour in Colours)
                {
                    cmboColour.Items.Add(new DyeHouse.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
                }

                var FabricWeights = context.TLADM_FabricWeight.OrderBy(x => x.FWW_Id).ToList();
                foreach (var FabricWeight in FabricWeights)
                {
                    cmboFabricWeight.Items.Add(new DyeHouse.CheckComboBoxItem(FabricWeight.FWW_Id, FabricWeight.FWW_Description, false));
                }

                var FabricWidths = context.TLADM_FabWidth.OrderBy(x => x.FW_Id).ToList();
                foreach (var FabricWidth in FabricWidths)
                {
                    cmboFabricWidth.Items.Add(new DyeHouse.CheckComboBoxItem(FabricWidth.FW_Id, FabricWidth.FW_Description, false));
                }

                var FabricQualities = context.TLADM_GreigeQuality.OrderBy(x => x.GQ_Description).ToList();
                foreach (var FabricQuality in FabricQualities)
                {
                    cmboFabricQuality.Items.Add(new DyeHouse.CheckComboBoxItem(FabricQuality.GQ_Pk, FabricQuality.GQ_Description, false));
                }
            }

            formloaded = true;
        }
示例#17
0
        private void frmShadeAfterDyeing_Load(object sender, EventArgs e)
        {
            repOps     = new DyeReportOptions();
            QueryParms = new DyeQueryParameters();

            formloaded = false;
            using (var context = new TTI2Entities())
            {
                var DyeQDCodes = context.TLADM_DyeQDCodes.OrderBy(x => x.QDF_Code).ToList();
                foreach (var DyeCode in DyeQDCodes)
                {
                    cmboCause.Items.Add(new DyeHouse.CheckComboBoxItem(DyeCode.QDF_Pk, DyeCode.QDF_Description, false));
                }

                var Remedies = context.TLADM_DyeRemendyCodes.OrderBy(x => x.QRC_Code).ToList();
                foreach (var Remedy in Remedies)
                {
                    cmboRemedy.Items.Add(new DyeHouse.CheckComboBoxItem(Remedy.QRC_Pk, Remedy.QRC_Description, false));
                }

                var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
                foreach (var Colour in Colours)
                {
                    cmboColour.Items.Add(new DyeHouse.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
                }

                var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault();
                if (Dept != null)
                {
                    var MachineDefinitions = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).OrderBy(x => x.MD_Description).ToList();
                    foreach (var MachineDefinition in MachineDefinitions)
                    {
                        cmboDyeMachine.Items.Add(new DyeHouse.CheckComboBoxItem(MachineDefinition.MD_Pk, MachineDefinition.MD_AlternateDesc, false));
                    }


                    var Operators = context.TLADM_MachineOperators.Where(x => x.MachOp_Department_FK == Dept.Dep_Id && !x.MachOp_Discontinued).ToList();
                    foreach (var Operator in Operators)
                    {
                        cmboDyeOperator.Items.Add(new DyeHouse.CheckComboBoxItem(Operator.MachOp_Pk, Operator.MachOp_Description, false));
                    }
                }

                var Qualities = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
                foreach (var Quality in Qualities)
                {
                    cmboQuality.Items.Add(new DyeHouse.CheckComboBoxItem(Quality.TLGreige_Id, Quality.TLGreige_Description, false));
                }
            }

            var reportOptions = new BindingList <KeyValuePair <string, string> >();

            reportOptions.Add(new KeyValuePair <string, string>("1", "Quality"));
            reportOptions.Add(new KeyValuePair <string, string>("2", "Dye Machine"));
            reportOptions.Add(new KeyValuePair <string, string>("3", "Dye Operator"));
            reportOptions.Add(new KeyValuePair <string, string>("4", "Colour"));
            if (_Stage == 3)
            {
                reportOptions.Add(new KeyValuePair <string, string>("5", "Remedy"));
                reportOptions.Add(new KeyValuePair <string, string>("6", "Fault"));
                reportOptions.Add(new KeyValuePair <string, string>("7", "Result"));
            }
            cmboReportOptions.DataSource    = reportOptions;
            cmboReportOptions.ValueMember   = "Key";
            cmboReportOptions.DisplayMember = "Value";
            cmboReportOptions.SelectedIndex = -1;

            formloaded = true;
        }