private void comboBoxStorages_SelectedIndexChanged(object sender, EventArgs e) { ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem; List <StoreCellTable> list = query.querySelectStoreCells(obj.Id); addGridView(list); }
private void buttonSearch_Click(object sender, EventArgs e) { string name = searchNameBox.Text; string description = searchDescriptionBox.Text; ObjectComboBox obj = (ObjectComboBox)comboBoxColors.SelectedItem; int article = 0; string color = ""; try { if (obj.Id != 0) { color = obj.Name; } bool ifNumber = Int32.TryParse(searchArticleBox.Text.ToString(), out article); if (!ifNumber) { addGridView(query.querySelectProductsBySearch(name, description, color)); } else { addGridView(query.querySelectProductsBySearch(name, article, description, color)); } } catch (Exception) { } }
private void buttonOK_Click(object sender, EventArgs e) { ContractShipment c = new ContractShipment(); ObjectComboBox obj2 = (ObjectComboBox)comboBoxCells.SelectedItem; c.StoreCellFromId = obj2.Id; ObjectComboBox objPr = (ObjectComboBox)comboBoxProducts.SelectedItem; c.ProductId = objPr.Id; int amount = 0; Int32.TryParse(textBox1.Text, out amount); c.Amount = amount; c.Date = dateTimePicker1.Value.Date; if (Id == -1) { query.queryAddContractShipment(c); } else { c.Id = Id; query.queryUpdateContractShipment(c); } instance.refreshGrid(); this.Dispose(); }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { ObjectComboBox obj = (ObjectComboBox)comboBoxStorehouses.SelectedItem; int storehouseIdSelected = obj.Id; addStorageCells(storehouseIdSelected, comboBoxCells); }
private void buttonOK_Click(object sender, EventArgs e) { ContractMove c = new ContractMove(); ObjectComboBox obj2 = (ObjectComboBox)comboBoxCellFrom.SelectedItem; c.StoreCellFromId = obj2.Id; ObjectComboBox obj4 = (ObjectComboBox)comboBoxCellTo.SelectedItem; c.StoreCellToId = obj4.Id; ObjectComboBox objPr = (ObjectComboBox)comboBoxProducts.SelectedItem; c.ProductId = objPr.Id; c.Amount = Int32.Parse(textBoxAmount.Text); c.Date = dateTimePicker1.Value.Date; if (Id == -1) { query.queryAddContractMove(c); } else { c.Id = Id; query.queryUpdateContractMove(c); } instance.refreshGrid(); this.Dispose(); }
private void comboBoxGroups_SelectedIndexChanged(object sender, EventArgs e) { ObjectComboBox obj = (ObjectComboBox)comboBoxGroups.SelectedItem; List <EmployeeTable> list = queryEmpl.querySelectEmployees(obj.Id); addGridView(list); }
private void comboBoxContractorType_SelectedIndexChanged(object sender, EventArgs e) { ObjectComboBox obj = (ObjectComboBox)comboBoxContractorType.SelectedItem; List <Contractor> list = query.querySelectContractors(obj.Id); addGridView(list); // MessageBox.Show(comboBoxContractorType.SelectedIndex+""); }
private void comboBoxColors_SelectedIndexChanged(object sender, EventArgs e) { ObjectComboBox obj = (ObjectComboBox)comboBoxColors.SelectedItem; if (obj.Id != 0) { addGridView(query.querySelectProducts(obj.Name)); } else { addGridView(query.querySelectProducts()); } }
private void search_Click(object sender, EventArgs e) { string name = searchNameBox.Text; ObjectComboBox obj = (ObjectComboBox)comboBoxContractorType.SelectedItem; if (obj.Id != 0) { addGridView(query.querySelectContractorsBySearch(name, obj.Id)); } else { addGridView(query.querySelectContractorsBySearch(name)); } }
private void addDataForUpdate() { StoreCell c = query.queryFindStoreCellById(Id); if (c == null) { return; } textBox2.Text = c.Description; ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem; comboBoxStorages.SelectedValue = c.StorehouseId; }
private void buttonSearch_Click(object sender, EventArgs e) { string description = searchDescriptionBox.Text; int id = 0; bool isNumber = Int32.TryParse(searchCellIdBox.Text, out id); ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem; if (obj.Id != 0) { addGridView(query.querySelectStoreCellsBySearch(description, id, obj.Id)); } else { addGridView(query.querySelectStoreCellsBySearch(description, id)); } }
private void buttonOK_Click(object sender, EventArgs e) { StoreCell c = new StoreCell(); ObjectComboBox obj = (ObjectComboBox)comboBoxStorages.SelectedItem; c.StorehouseId = obj.Id; c.Description = textBox2.Text; if (Id == -1) { query.queryAddStoreCell(c); } else { c.Id = Id; query.queryUpdateStoreCell(c); } instance.refreshGrid(); this.Dispose(); }
private void buttonOK_Click(object sender, EventArgs e) { TechnologicalCard techCard = new TechnologicalCard(); techCard.Title = textBox1.Text; techCard.Date = dateTimePicker1.Value.Date; List <ProductTechCard> productTechCardList = new List <ProductTechCard>(); ObjectComboBox objPr1 = (ObjectComboBox)comboBoxProductsImport.SelectedItem; ProductTechCard product = new ProductTechCard(); product.ProductId = objPr1.Id; int amount = 0; Int32.TryParse(textBoxAmountImport.Text, out amount); product.Amount = amount; product.Type = 1; productTechCardList.Add(product); product = new ProductTechCard(); objPr1 = (ObjectComboBox)comboBoxProductsExport.SelectedItem; product.ProductId = objPr1.Id; amount = 0; Int32.TryParse(textBoxAmountExport.Text, out amount); product.Amount = amount; product.Type = 2; productTechCardList.Add(product); techCard.ProductTechCards = productTechCardList; if (Id == -1) { query.queryAddTechCard(techCard); } else { techCard.Id = Id; query.queryUpdateTechCard(techCard); } instance.refreshGrid(); this.Dispose(); }