private void frmDyeOrdersSelection_Load(object sender, EventArgs e) { using (var context = new TTI2Entities()) { FormLoaded = false; QueryParms = new DyeQueryParameters(); FormLoaded = true; var Grieges = context.TLADM_Griege.Where(x => !(bool)x.TLGriege_Discontinued).OrderBy(x => x.TLGreige_Description).ToList(); foreach (var Greige in Grieges) { cmboGreige.Items.Add(new DyeHouse.CheckComboBoxItem(Greige.TLGreige_Id, Greige.TLGreige_Description, false)); } var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList(); foreach (var Style in Styles) { cmboStyle.Items.Add(new DyeHouse.CheckComboBoxItem(Style.Sty_Id, Style.Sty_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 Customers = context.TLADM_CustomerFile.Where(x => !x.Cust_Blocked).OrderBy(x => x.Cust_Description).ToList(); foreach (var Customer in Customers) { cmboCustomers.Items.Add(new DyeHouse.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false)); } } }
private void frmCommissionDeliveries_Load(object sender, EventArgs e) { formloaded = false; IList <TLADM_CustomerFile> Customers = null; cmboBatchesReprint.Visible = false; using (var context = new TTI2Entities()) { var LNU = context.TLADM_LastNumberUsed.Find(3); if (LNU != null) { if (_Commission) { TxtTransNumber.Text = "CD" + LNU.col9.ToString().PadLeft(6, '0'); Customers = context.TLADM_CustomerFile.Where(x => x.Cust_CommissionCust).ToList(); } else { TxtTransNumber.Text = "FS" + LNU.col10.ToString().PadLeft(6, '0'); Customers = context.TLADM_CustomerFile.Where(x => !x.Cust_CommissionCust).ToList(); } } cmboCustomer.DataSource = Customers; cmboCustomer.ValueMember = "Cust_Pk"; cmboCustomer.DisplayMember = "Cust_Description"; cmboCustomer.SelectedValue = -1; QueryParms = new DyeQueryParameters(); cmboCurrentBatches.Items.Clear(); cmboBatchesReprint.Items.Clear(); } formloaded = true; }
private void btnSubmit_Click(object sender, EventArgs e) { Button oBtn = (Button)sender; if (oBtn != null) { QueryParms = new DyeQueryParameters(); QueryParms.FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()); QueryParms.ToDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()); QueryParms.ToDate = QueryParms.ToDate.AddHours(23); if (chkProductionResults.Checked) { QueryParms.CalculateProdResults = true; } frmDyeViewReport vRep = new frmDyeViewReport(43, QueryParms); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } }