private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { if (cmboReportOptions.SelectedValue != null) { repOps.DO_OptionSelected = Int32.Parse(cmboReportOptions.SelectedValue.ToString()); } else { repOps.DO_OptionSelected = 0; } if (chkException.Checked) { repOps.ExceptionOnly = true; repOps.Percentage_Exception = Convert.ToInt32(txtPercentage.Text); } repOps.fromDate = DateTime.Parse(dtpFromDate.Value.ToShortDateString()); repOps.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); frmDyeViewReport vRep = new frmDyeViewReport(24, repOps); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); repOps = new DyeReportOptions(); chkException.Checked = false; } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = (Button)sender; if (oBtn != null) { DateTime FDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); DateTime TDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); TDate = TDate.AddHours(23); DyeReportOptions repOps = new DyeReportOptions(); repOps.fromDate = FDate; repOps.toDate = TDate; if (chkProdResults.Checked) { repOps.ProductionResults = true; } frmDyeViewReport vRep = new frmDyeViewReport(43, repOps); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } }
private void frmStockTake_Load(object sender, EventArgs e) { formloaded = false; repOps = new DyeReportOptions(); using (var context = new TTI2Entities()) { var Deptment = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Deptment != null) { cmboStore.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_DepartmentFK == Deptment.Dep_Id).ToList(); cmboStore.ValueMember = "WhStore_Id"; cmboStore.DisplayMember = "WhStore_Description"; cmboStore.SelectedValue = -1; } cmboStockType.DataSource = context.TLADM_StockTypes.Where(x => x.ST_ShortCode.Contains("DC")).ToList(); cmboStockType.ValueMember = "ST_Id"; cmboStockType.DisplayMember = "ST_Description"; cmboStockType.SelectedValue = -1; cmboStockTake.DataSource = context.TLADM_StockTakeFreq.ToList(); cmboStockTake.ValueMember = "STF_Pk"; cmboStockTake.DisplayMember = "STF_Description"; cmboStockTake.SelectedValue = -1; } formloaded = true; }
private void frmReportOpts4_Load(object sender, EventArgs e) { repOps = new DyeReportOptions(); formloaded = false; using (var context = new TTI2Entities()) { try { cmboBatches.DataSource = context.TLDYE_DyeTransactions.Where(x => x.TLDYET_SequenceNo != 0).ToList(); cmboBatches.DisplayMember = "TLDYET_BatchNo"; cmboBatches.ValueMember = "TLDYET_Pk"; cmboBatches.SelectedValue = -1; } catch (Exception ex) { MessageBox.Show(ex.Message); } var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Dept != null) { cmboDyeMachine.DataSource = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).ToList(); cmboDyeMachine.ValueMember = "MD_Pk"; cmboDyeMachine.DisplayMember = "MD_Description"; cmboDyeMachine.SelectedValue = -1; } cmboFaultCode.DataSource = context.TLADM_DyeQDCodes.OrderBy(x => x.QDF_Description).ToList(); cmboFaultCode.ValueMember = "QDF_Pk"; cmboFaultCode.DisplayMember = "QDF_Description"; cmboFaultCode.SelectedValue = -1; cmboRemedy.DataSource = context.TLADM_DyeRemendyCodes.OrderBy(x => x.QRC_Description).ToList(); cmboRemedy.ValueMember = "QRC_Pk"; cmboRemedy.DisplayMember = "QRC_Description"; cmboRemedy.SelectedValue = -1; cmboQuality.DataSource = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList(); cmboQuality.ValueMember = "TLGreige_Id"; cmboQuality.DisplayMember = "TLGreige_Description"; cmboQuality.SelectedValue = -1; cmboColour.DataSource = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList(); cmboColour.DisplayMember = "Col_Display"; cmboColour.ValueMember = "Col_Id"; cmboColour.SelectedValue = -1; var reportOptions = new BindingList <KeyValuePair <string, string> >(); reportOptions.Add(new KeyValuePair <string, string>("0", "Batch Number")); reportOptions.Add(new KeyValuePair <string, string>("1", "Dye Machines")); reportOptions.Add(new KeyValuePair <string, string>("2", "Fault Code")); reportOptions.Add(new KeyValuePair <string, string>("3", "Remedy Code")); reportOptions.Add(new KeyValuePair <string, string>("4", "Quality")); reportOptions.Add(new KeyValuePair <string, string>("5", "Colour")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; } formloaded = true; }
private void frmNCRDetails_Load(object sender, EventArgs e) { repOps = new DyeReportOptions(); formloaded = false; using (var context = new TTI2Entities()) { cmboCause.DataSource = context.TLADM_DyeQDCodes.OrderBy(x => x.QDF_Code).ToList(); cmboCause.DisplayMember = "QDF_Description"; cmboCause.ValueMember = "QDF_Pk"; cmboCause.SelectedValue = -1; cmboRemedy.DataSource = context.TLADM_DyeRemendyCodes.OrderBy(x => x.QRC_Code).ToList(); cmboRemedy.DisplayMember = "QRC_Description"; cmboRemedy.ValueMember = "QRC_Pk"; cmboRemedy.SelectedValue = -1; cmboColour.DataSource = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList(); cmboColour.ValueMember = "Col_Id"; cmboColour.DisplayMember = "Col_Display"; cmboColour.SelectedValue = -1; var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Dept != null) { cmboDyeMachine.DataSource = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).OrderBy(x => x.MD_Description).ToList(); cmboDyeMachine.ValueMember = "MD_Pk"; cmboDyeMachine.DisplayMember = "MD_Description"; cmboDyeMachine.SelectedValue = -1; cmboDyeOperator.DataSource = context.TLADM_MachineOperators.Where(x => x.MachOp_Department_FK == Dept.Dep_Id).ToList(); cmboDyeOperator.ValueMember = "MachOp_Pk"; cmboDyeOperator.DisplayMember = "MachOp_Description"; cmboDyeOperator.SelectedValue = -1; } cmboQuality.DataSource = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList(); cmboQuality.ValueMember = "TLGreige_Id"; cmboQuality.DisplayMember = "TLGreige_Description"; cmboQuality.SelectedValue = -1; } var reportOptions = new BindingList <KeyValuePair <string, string> >(); reportOptions.Add(new KeyValuePair <string, string>("0", "NCR number")); reportOptions.Add(new KeyValuePair <string, string>("1", "Batch Number")); reportOptions.Add(new KeyValuePair <string, string>("2", "Quality")); reportOptions.Add(new KeyValuePair <string, string>("3", "Colour")); reportOptions.Add(new KeyValuePair <string, string>("4", "Dye machine")); reportOptions.Add(new KeyValuePair <string, string>("5", "Dye operator")); reportOptions.Add(new KeyValuePair <string, string>("6", "Cause when not complying")); reportOptions.Add(new KeyValuePair <string, string>("7", "Remedy when not compliant")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; formloaded = true; }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { DyeReportOptions repOptions = new DyeReportOptions(); repOptions.fromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); repOptions.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); repOptions.toDate = repOptions.toDate.AddHours(23); var selected = (TLADM_MachineDefinitions)cmboMachines.SelectedItem; if (selected != null) { repOptions.DYEMPMachineSelected = selected.MD_Pk; } if (rbFirstTime.Checked) { repOptions.DYEMPProdType = 1; } else if (rbOwnReprocessing.Checked) { repOptions.DYEMPProdType = 2; } else { repOptions.DYEMPProdType = 3; } if (rbModeSummary.Checked) { repOptions.DYEMPReportType = 1; } else { repOptions.DYEMPReportType = 2; } if (cmboReportOptions.SelectedValue != null) { repOptions.DYEMPSortOptions = int.Parse(cmboReportOptions.SelectedValue.ToString()); } else { repOptions.DYEMPSortOptions = 1; }; frmDyeViewReport vRep = new frmDyeViewReport(34, repOptions); vRep.ShowDialog(this); cmboMachines.SelectedIndex = -1; cmboReportOptions.SelectedIndex = -1; } }
private void btnSubmit_Click(object sender, EventArgs e) { Util core = new Util(); DyeReportOptions dro = new DyeReportOptions(); //------------------------------------------------------------ // if (rbGarmentsOnly.Checked) { dro.SelGarments = true; } else if (rbFabricOnly.Checked) { dro.SelFabric = true; } else if (rbBoth.Checked) { dro.SelBoth = true; } if (rbAdditionalBoth.Checked) { dro.DO_Both = true; } else if (rbOrderOpen.Checked) { dro.DO_Open = true; } else if (rbOrderClosed.Checked) { dro.DO_Closed = true; } if (cmboReportOptions.SelectedValue != null) { dro.DO_OptionSelected = int.Parse(cmboReportOptions.SelectedValue.ToString()); if (dro.DO_OptionSelected == 0) { dro.DO_ByOrderNo = true; } } else { dro.DO_ByOrderNo = true; } frmDyeViewReport vRep = new frmDyeViewReport(14, dro); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { DyeReportOptions repOpts = new DyeReportOptions(); repOpts.fromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); repOpts.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); repOpts.toDate = repOpts.toDate.AddHours(23); frmDyeViewReport vRep = new frmDyeViewReport(36, repOpts); vRep.ShowDialog(this); } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { if (groupBox2.Visible) { repOps.FabricToQ = true; if (radFirstTime.Checked) { repOps.FirstTime = true; } else { repOps.FirstTime = false; } } else { repOps.FirstTime = false; repOps.FabricToStore = true; if (_RepNumber == 3) { repOps.FabricToStore = false; repOps.FabricNotFinished = true; } } if (chkQASummary.Checked) { repOps.QASummary = true; } repOps.fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); repOps.toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); repOps.toDate = repOps.toDate.AddHours(23.00); frmDyeViewReport vRep = new frmDyeViewReport(31, repOps); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); repOps = new DyeReportOptions(); } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { DyeReportOptions DOpts = new DyeReportOptions(); DOpts.fromDate = DateTime.Parse(dtpFromDate.Value.ToShortDateString()); DOpts.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); frmDyeViewReport vRep = new frmDyeViewReport(23, DOpts); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { if (repOps.stkWhseSelected == false && repOps.stkTakeCategorySelected == false && repOps.stkTypeSelected == false) { MessageBox.Show("Please select one option from the drop down box"); return; } frmDyeViewReport vRep = new frmDyeViewReport(25, repOps); vRep.ShowDialog(this); repOps = new DyeReportOptions(); } }
private void frmDyeProductionSel_Load(object sender, EventArgs e) { core = new Util(); repOps = new DyeReportOptions(); using (var context = new TTI2Entities()) { formloaded = false; if (_RepNumber == 1) { this.Text = "Fabric Production to Quarantine Store"; } else if (_RepNumber == 2) { this.Text = "Fabric Production to Fabric Store"; groupBox2.Visible = false; } else { this.Text = "Fabric Dyed Not Finished"; groupBox2.Visible = false; } radFirstTime.Checked = true; cmboCustomers.DataSource = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList(); cmboCustomers.ValueMember = "Cust_Pk"; cmboCustomers.DisplayMember = "Cust_Description"; cmboCustomers.SelectedValue = -1; var reportOptions = new BindingList <KeyValuePair <int, string> >(); reportOptions.Add(new KeyValuePair <int, string>(0, "Machine , Shade, Dye Machine ")); reportOptions.Add(new KeyValuePair <int, string>(1, "Dye Machines, Shade, Colour")); reportOptions.Add(new KeyValuePair <int, string>(2, "Dye Machines, Quality , Colour")); reportOptions.Add(new KeyValuePair <int, string>(3, "Quality, Colour, Shade")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; formloaded = true; } }
private void ReprocessDetails_Load(object sender, EventArgs e) { repOps = new DyeReportOptions(); formloaded = false; using (var context = new TTI2Entities()) { cmboCause.DataSource = context.TLADM_DyeQDCodes.OrderBy(x => x.QDF_Code).ToList(); cmboCause.DisplayMember = "QDF_Description"; cmboCause.ValueMember = "QDF_Pk"; cmboCause.SelectedValue = -1; cmboRemedy.DataSource = context.TLADM_DyeRemendyCodes.OrderBy(x => x.QRC_Code).ToList(); cmboRemedy.DisplayMember = "QRC_Description"; cmboRemedy.ValueMember = "QRC_Pk"; cmboRemedy.SelectedValue = -1; cmboColour.DataSource = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList(); cmboColour.ValueMember = "Col_Id"; cmboColour.DisplayMember = "Col_Display"; cmboColour.SelectedValue = -1; var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Dept != null) { cmboDyeMachine.DataSource = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).OrderBy(x => x.MD_Description).ToList(); cmboDyeMachine.ValueMember = "MD_Pk"; cmboDyeMachine.DisplayMember = "MD_Description"; cmboDyeMachine.SelectedValue = -1; cmboDyeOperator.DataSource = context.TLADM_MachineOperators.Where(x => x.MachOp_Department_FK == Dept.Dep_Id).ToList(); cmboDyeOperator.ValueMember = "MachOp_Pk"; cmboDyeOperator.DisplayMember = "MachOp_Description"; cmboDyeOperator.SelectedValue = -1; } cmboQuality.DataSource = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList(); cmboQuality.ValueMember = "TLGreige_Id"; cmboQuality.DisplayMember = "TLGreige_Description"; cmboQuality.SelectedValue = -1; } }
private void frmDyeingProcessLoss_Load(object sender, EventArgs e) { repOps = new DyeReportOptions(); formloaded = false; using (var context = new TTI2Entities()) { cmboBatchNo.DataSource = context.TLDYE_DyeBatch.OrderBy(x => x.DYEB_BatchNo).ToList(); cmboBatchNo.DisplayMember = "DYEB_BatchNo"; cmboBatchNo.ValueMember = "DYEB_Pk"; cmboBatchNo.SelectedValue = -1; cmboShade.DataSource = context.TLADM_FabricProduct.OrderBy(x => x.FP_Description).ToList(); cmboShade.DisplayMember = "FP_Description"; cmboShade.ValueMember = "FP_Id"; cmboShade.SelectedValue = -1; cmboColour.DataSource = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList(); cmboColour.ValueMember = "Col_Id"; cmboColour.DisplayMember = "Col_Display"; cmboColour.SelectedValue = -1; var Department = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Department != null) { cmboMachines.DataSource = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Department.Dep_Id).OrderBy(x => x.MD_Description).ToList(); cmboMachines.ValueMember = "MD_Pk"; cmboMachines.DisplayMember = "MD_Description"; cmboMachines.SelectedValue = -1; } var reportOptions = new BindingList <KeyValuePair <string, string> >(); reportOptions.Add(new KeyValuePair <string, string>("0", "Machine , Shade, Dye Machine ")); reportOptions.Add(new KeyValuePair <string, string>("1", "Dye Machines, Shade, Colour")); reportOptions.Add(new KeyValuePair <string, string>("2", "Dye Machines, Quality , Colour")); reportOptions.Add(new KeyValuePair <string, string>("3", "Quality, Colour, Shade")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; } formloaded = true; }
private void frmFabricSOHSel_Load(object sender, EventArgs e) { FormLoad = false; repOps = new DyeReportOptions(); var reportOptions = new BindingList <KeyValuePair <string, string> >(); reportOptions.Add(new KeyValuePair <string, string>("0", "Customer , Quality , Batch Number")); reportOptions.Add(new KeyValuePair <string, string>("1", "Store, Customer, Quality")); reportOptions.Add(new KeyValuePair <string, string>("2", "Store, Colour, Quality")); reportOptions.Add(new KeyValuePair <string, string>("3", "Quality, Colour, Customer")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; rbFabFS.Checked = true; rbStandard.Checked = true; FormLoad = true; }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && FormLoad) { if (cmboReportOptions.SelectedValue != null) { repOps.DO_OptionSelected = Int32.Parse(cmboReportOptions.SelectedValue.ToString()); } else { repOps.DO_OptionSelected = 0; } if (rbFabFS.Checked) { repOps.FabricStore = true; } if (rbFabQS.Checked) { repOps.FabricQSStore = true; } if (rbFabRS.Checked) { repOps.FabricRejectStore = true; } if (rbStandard.Checked) { repOps.FabricType = true; } repOps.ShowIndvidualNo = false; frmDyeViewReport vRep = new frmDyeViewReport(22, repOps); vRep.ShowDialog(this); repOps = new DyeReportOptions(); } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { DyeReportOptions RepOptions = new DyeReportOptions(); RepOptions.fromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); RepOptions.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); RepOptions.toDate = RepOptions.toDate.AddHours(23); var selected = (TLADM_MachineDefinitions)cmboMachines.SelectedItem; if (selected != null) { RepOptions.ResEficMachine = selected.MD_Pk; } if (rbDyeFirstTime.Checked) { RepOptions.ResEfficTrans = true; } var FTSelected = (TLADM_FabricProduct)cmboFabricType.SelectedItem; if (FTSelected != null) { RepOptions.ResFabType = FTSelected.FP_Id; } frmDyeViewReport ViewRep = new frmDyeViewReport(35, RepOptions); ViewRep.ShowDialog(this); formloaded = false; cmboFabricType.SelectedIndex = -1; cmboMachines.SelectedIndex = -1; formloaded = true; } }
private void frmDyeProdSel_Load(object sender, EventArgs e) { formloaded = false; repOpts = new DyeReportOptions(); using (var context = new TTI2Entities()) { cmboCustomers.DataSource = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList(); cmboCustomers.DisplayMember = "Cust_Description"; cmboCustomers.ValueMember = "Cust_Pk"; cmboCustomers.SelectedValue = -1; } var reportOptions = new BindingList <KeyValuePair <string, string> >(); reportOptions.Add(new KeyValuePair <string, string>("0", "Machines , Shade, Quality ")); reportOptions.Add(new KeyValuePair <string, string>("1", "Machines, Shade, Colour")); reportOptions.Add(new KeyValuePair <string, string>("2", "Machines, Quality , Colour")); reportOptions.Add(new KeyValuePair <string, string>("3", "Quality, Colour, Shade")); cmboReportOptions.DataSource = reportOptions; cmboReportOptions.ValueMember = "Key"; cmboReportOptions.DisplayMember = "Value"; cmboReportOptions.SelectedIndex = -1; formloaded = true; }
private void button1_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { var WhseIssue = (TLADM_WhseStore)cmboIssueDepartment.SelectedItem; if (WhseIssue == null) { MessageBox.Show("Please select a Chemical Store from the list provided"); return; } var WhseReceiving = (TLADM_WhseStore)cmboReceivingDepartment.SelectedItem; if (WhseReceiving == null) { MessageBox.Show("Please select a Dye Kitchen from the list provided"); return; } using (var context = new TTI2Entities()) { var LNU = context.TLADM_LastNumberUsed.Find(3); LNU.col12 += 1; foreach (DataGridViewRow row in dataGridView1.Rows) { if (!(bool)row.Cells[1].Value) { continue; } var index = (int)row.Cells[0].Value; //--------------------------------------- // 1st decision //------------------------------------------------------- TLDYE_ConsumableSOH newSOH = new TLDYE_ConsumableSOH(); newSOH = context.TLDYE_ConsumableSOH.Where(x => x.DYCSH_WhseStore_FK == WhseReceiving.WhStore_Id && x.DYCSH_Consumable_FK == index).FirstOrDefault(); if (newSOH == null) { newSOH = new TLDYE_ConsumableSOH(); newSOH.DYCSH_StockOnHand = (decimal)row.Cells[4].Value; newSOH.DYCSH_TransNumber = -1 + LNU.col12; newSOH.DYCSH_Consumable_FK = (int)row.Cells[5].Value; newSOH.DYCSH_WhseStore_FK = WhseReceiving.WhStore_Id; newSOH.DYCSH_DyeKitchen = WhseReceiving.WhStore_DyeKitchen; context.TLDYE_ConsumableSOH.Add(newSOH); } else { newSOH.DYCSH_StockOnHand += (decimal)row.Cells[4].Value; } TLDYE_ConsumableSOH oldSOH = new TLDYE_ConsumableSOH(); oldSOH = context.TLDYE_ConsumableSOH.Find(index); if (oldSOH != null) { oldSOH.DYCSH_StockOnHand -= (Decimal)row.Cells[4].Value; } } try { context.SaveChanges(); MessageBox.Show("Data successfully saved to database"); DyeReportOptions opts = new DyeReportOptions(); opts.fromDate = DateTime.Now; opts.LNU = -1 + LNU.col12; opts.toStore = WhseReceiving.WhStore_Id; TLADM_WhseStore FromWhse = context.TLADM_WhseStore.Where(x => x.WhStore_Code.Contains("CS")).FirstOrDefault(); opts.fromStore = FromWhse.WhStore_Id; frmDyeViewReport vRep = new frmDyeViewReport(30, opts); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
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; }
private void button1_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { if (!rbAllCustomers.Checked) { var selected = (TLADM_CustomerFile)cmboCustomer.SelectedItem; if (selected == null) { MessageBox.Show("Please select a customer record"); return; } } DyeReportOptions opts = new DyeReportOptions(); opts.fromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); opts.toDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); opts.toDate = opts.toDate.AddHours(23.00); if (rbAllCustomers.Checked) { opts.AllCustomersSelected = true; } else { var select = (TLADM_CustomerFile)cmboCustomer.SelectedItem; opts.CustomerNumberSelected = select.Cust_Pk; opts.CustomerSelected = true; } if (rbDyeBatchPending.Checked) { opts.DBPending = true; } else { opts.DBWIP = true; } if (rbBatchNumber.Checked) { opts.SortByBatchNumber = true; } if (rbByQuality.Checked) { opts.SortByQuality = true; } if (rbSortByDate.Checked) { opts.SortByDate = true; } frmDyeViewReport vRep = new frmDyeViewReport(12, opts); vRep.ShowDialog(this); rbAllCustomers.Checked = false; } }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { DyeReportOptions repOps = new DyeReportOptions(); if (!rbAllCustomers.Checked) { var selected = (TLADM_CustomerFile)cmboCustomers.SelectedItem; if (selected == null) { MessageBox.Show("Please select a customer from the drop down box"); return; } else { repOps.CustomerSelected = true; repOps.CustomerNumberSelected = ((TLADM_CustomerFile)cmboCustomers.SelectedItem).Cust_Pk; } } else { repOps.AllCustomersSelected = true; } //--------------------------------------------------------- if (rbWIPDBPending.Checked) { repOps.DBPending = true; } if (rbWIPDyeing.Checked) { repOps.DBWIP = true; } if (rbAll.Checked) { repOps.DBAll = true; } if (rbReprocess.Checked) { repOps.DBReprocess = true; } //------------------------------------------------------------ if (cmboReportOptions.SelectedValue != null) { repOps.DO_OptionSelected = Int32.Parse(cmboReportOptions.SelectedValue.ToString()); } else { repOps.DO_OptionSelected = 0; } frmDyeViewReport vRep = new frmDyeViewReport(19, repOps); vRep.ShowDialog(this); rbAllCustomers.Checked = false; cmboCustomers.SelectedIndex = -1; } }