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 = "";
     }
 }
Exemple #3
0
        //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();
 }
Exemple #5
0
        //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();
        }
Exemple #6
0
 //refresh patterns if one is added
 public void refreshPatterns()
 {
     patterns = DatabaseAccess.GetPatterns();
     ShowPatterns();
 }