private void NewShow_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'pineSpringsPotteryDataSet.CUSTOMER' table. You can move, or remove it, as needed. this.cUSTOMERTableAdapter.Fill(this.pineSpringsPotteryDataSet.CUSTOMER); // TODO: This line of code loads data into the 'pineSpringsPotteryDataSet.SHOW' table. You can move, or remove it, as needed. this.sHOWTableAdapter.Fill(this.pineSpringsPotteryDataSet.SHOW); getCustomers(); //collection.AddRange(customerNames); //addGuestTextBox.AutoCompleteCustomSource = collection; patterns = DatabaseAccess.GetPatterns(); pieces = DatabaseAccess.GetPieces(); showTypes = DatabaseAccess.GetShowTypes(); cboShowType.DataSource = showTypes; hostNoTextBox.DataBindings[0].Parse += new ConvertEventHandler(ParseNumeric); showDateDateTimePicker.DataBindings[0].Parse += new ConvertEventHandler(ShortDate); //new show if (show.showNo == 0) { bindingNavigatorAddNewItem.PerformClick(); } else //(show != 0) view show number { int index = sHOWBindingNavigator.BindingSource.Find("ShowNo", show.showNo); sHOWBindingNavigator.BindingSource.Position = index; uneditable(); getShowInfo(); } }
private void cboPatternPreference_SelectedIndexChanged(object sender, EventArgs e) { patternPreferenecTextBox.Text = DatabaseAccess.GetPatterns().Find(pattern => pattern.patternName == cboPatternPreference.SelectedItem.ToString()).patternNo.ToString(); if (patternPreferenecTextBox.Text == "0") { patternPreferenecTextBox.Text = ""; } }
//make sorted list of patterns public SortedList <int, Pattern> GetPatternSortedList() { patterns = DatabaseAccess.GetPatterns(); SortedList <int, Pattern> tempPatterns = new SortedList <int, Pattern>(); foreach (Pattern pattern in patterns) { tempPatterns.Add(pattern.patternNo, pattern); } return(tempPatterns); }
public CustomerInformation(int pCustomer) { connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\PineSpringsPottery.accdb"; connection = new OleDbConnection(connectionString); customers = new List <Customer>(); customer = new Customer(); customer.customerNo = pCustomer; if (customer.customerNo == 0) { newCustomer = true; } else { newCustomer = false; //getCustomer(); } patterns = DatabaseAccess.GetPatterns(); InitializeComponent(); }
//onload private void Catalog_Load(object sender, EventArgs e) { //only show extra options and add to list button if called by show, wishlist, order if (parent.GetType() != typeof(NewOrder) && parent.GetType() != typeof(ViewWishList) && parent.GetType() != typeof(NewShow)) { pnlLineItem.Visible = false; } //wishlist options if (parent.GetType() == typeof(ViewWishList)) { txtCardMessage.Visible = false; lblCardMessage.Visible = false; cbxGift.Visible = false; nudCustomPrice.Visible = false; cbCustomPrice.Visible = false; btnAddItem.Text = "Add To Wishlist"; } //show options else if (parent.GetType() == typeof(NewShow)) { txtCardMessage.Visible = false; lblCardMessage.Visible = false; cbxGift.Visible = false; nudCustomPrice.Visible = false; cbCustomPrice.Visible = false; btnAddItem.Text = "Add To Show"; } //order options else { btnAddItem.Text = "Add To Order"; } //get and show pices and patterns patterns = DatabaseAccess.GetPatterns(); pieces = DatabaseAccess.GetPieces(); ShowPieces(); ShowPatterns(); }
//refresh patterns if one is added public void refreshPatterns() { patterns = DatabaseAccess.GetPatterns(); ShowPatterns(); }